Prestashop: Open the Sample CSV Import Files in Excel

April 3, 2018 Tags Programming, Fixes, Prestashop

I was having trouble opening the sample CSV files that Prestashop provides for doing mass object importing, turns out it was simply because the sample files are separated by semicolon instead of by comma. The very easy fix is to open the CSV file in a text-editor and adding the following line to the beginning of the file:


Doing this tells Excel that you want to use the semicolon caharacter as seperator.