How to open a CSV file in Excel correctly

Last updated

Usually, when you open a CSV file exported from Ecwid in Excel, the file is parsed into columns correctly.

However, sometimes if some descriptions contain "new line" symbols, Excel cannot parse them properly and  decides to start a new product/record/row.

This instruction will help you to avoid this issue. Instruction was posted on our forums by Michelle:

Open File Method

Note that this method involves either double-clicking the file from Windows Explorer, or right-clicking the file and selecting Excel from a list. If the file extension is "csv", then Excel is presumed for my current file-associations. If the file extension is "txt", then Excel may not be the default application, so right-clicking and choosing Excel may be the way to go. Either way, the result is the same.

This method bypasses the "Text Import Wizard", and uses different defaults (perhaps a different engine, which gives no problems).

It is important however to ensure that the file extension and default delimiter for that file extension match with that selected during export from Ecwid. It is possible to rename the exported csv file to have a .txt extension if this makes things easier for your chosen delimiter during export.

.txt file
Excel presumes that such files are tab-delimited (ASCII character 009). If the delimiter of "tab" was chosen during export, it is simplest to simply rename the .csv file extension to .txt, then right-click and chose Excel to open the file.

.csv file
Such files are usually comma-delimited, but don't have to be. You can choose any of the options in Ecwid during export. However since we are simply double-clicking (or right-clicking where this doesn't work) the file to open using default settings, we must make sure that our default csv-file delimiter matches this. This is a Windows-wide setting, accessible through:

Start > Control Panel > Date,Time,Language,Regional Options > Regional,Language Options > Customise button > List separator field. 

eg. set this field to semicolon if that is what you have picked during Export (this will affect all Windows programs though).

You can even pick "tab" here if you like (and don't want to rename to be .txt file) - but you will have to copy and paste an existing tab from a Windows file to do it (alt-009 doesn't seem to work).

Also please refer to this thread: http://www.ecwid.com/forums/showthread.php?p=5913#5

Was this article helpful?
1 out of 3 found this helpful
Questions?
Get help
  • Presales Chat

    Need help choosing the right Ecwid plan? Our Sales team has the answer you’re looking for.

  • Forums

    Join the Ecwid community. Discuss support topics and store ideas with other Ecwid users.

  • Contact us

    Still have questions about Ecwid? Let us know! We will be glad to help you with your Ecwid store.

  • Status Monitor

    Get real time status updates on Ecwid services here, 24/7