Is there a way to force Excel to open a .csv without formatting? I don't want it to remove the commas and create several columns. I understand I could just open it in notepad but I'd prefer to use excel.
5
-
Open it with Data, Get External Data, From Text and turn off all delimiting factors in the Import Wizard.user4039065– user40390652017-05-17 16:09:48 +00:00Commented May 17, 2017 at 16:09
-
Im sorry but I do not follow. From My Documents how should I open it?Jeremy Thomas– Jeremy Thomas2017-05-17 16:11:33 +00:00Commented May 17, 2017 at 16:11
-
ahhh from in Excel, nice! You should make it an answer and I'll acceptJeremy Thomas– Jeremy Thomas2017-05-17 16:12:57 +00:00Commented May 17, 2017 at 16:12
-
You should not open it from My Documents; you open Excel, possibly to a blank worksheet then use Data, Get External Data, From Text.user4039065– user40390652017-05-17 16:12:59 +00:00Commented May 17, 2017 at 16:12
-
I've posted an answer on same problem here.evilReiko– evilReiko2018-08-12 08:02:10 +00:00Commented Aug 12, 2018 at 8:02
Add a comment
|
2 Answers
You should not open it from My Documents; you open Excel, possibly to a blank worksheet then use Data, Get External Data, From Text.
Turn off all delimiting factors in the Import Wizard and it should come into the worksheet without separating the delimited values outside of a single cell per row.
3 Comments
Sadiq Khoja
how one would make changes and save it in csv?
posfan12
Outdated. Excel no longer has commands/menus with these exact names, nor does it have the same options. It keeps trying to use "Queries & Connections". Why can't Excel just load a file as plain text?
amihai
@posfan12 In modern (2023) Excel just go to File then Open, and if you select a csv file the import wizard will open and you can set there the options on how to import the data (by column, you can set every column to text, so then there will be no automatic conversions of any kind)
open the excel option you can find on the start menu of excel.
excel option -> advanced -> Use system separator (disable this then excel will not convert anything from text).
IMO, such misleading option though, eg if I have "5.123.444,24" and we want get number format from it, by enabling "use system separator" with the option to convert "." as thousand separator and "," as decimal separator, seems that we are doing right.In fact, if it is enabled, we'll have 5.123.444,24 and with the option disabled , we'll have 512344,24 which means the text "5.123.444,24" has been converted to number.
