Issues importing CSV files into Excel

How can we help you?

Print

Issues importing CSV files into Excel

After exporting products or order data, opening your CSV file in MS Excel may cause the data to reformat incorrectly. This causes issues such as removing leading zeros in edition numbers or truncating long numbers like the ISBN. To avoid this it’s best to use the Excel import wizard to set all the fields to text fields.

For more information regarding common issues opening CSV files in Excel, please visit this page https://www.ablebits.com/office-addins-blog/converting-csv-excel-issues/