Forum Discussion

LucieH135's avatar
LucieH135
Copper Contributor
May 02, 2022

Importing csv file

1 - I need to import csv files into Excel. When I do so, I always need to navigate through the wizard to change the options from Tab delimited to comma. How can I change my settings so that excel wil...
excel
office 365
Martin_Weiss's avatar
Martin_Weiss
Bronze Contributor
May 03, 2022

Hi LucieH135 

 

according to your description a assume you have to do these imports on a frequent basis.

Therefore I strongly suggest to use Power Query instead of the old import wizard.

 

It's not really complicated, you just need to get used to it. You find this functionality in the Data menu:

 

Once you have imported it in Excel, you just need to replace the recent CSV-file with the new one (keep the same name) and do a refresh in Excel (right-click in the table, Refresh). And it will get the new data.

 

Regarding the CSV export:

If you save a CSV-file from Excel, the information from all the different cells are actually separated by a separator character. Which is a usually a comma or semikolon, depending on your regional local settings (CSV = comma separated values). And in case you use the comma (or semikolon) within your cells, Excel puts these values into quotes in order to be able to keep the proper cells.

 

From a distance it's hard to say why your third party application cannot deal with it. Maybe there is something special with your file. Could you provide an example?

Resources