CSV Tips and Tricks

Saving a CSV correctly

  1. We regularly see CSV files that are saved with incorrect settings, for example they are not saved with comma separated values (CSV), but tab separated values, and then they look like this when opened:
  2. To make sure you save your CSV file correctly, choose Save a copy from the File menu:
  3. In the next dialog box, tick Edit filter settings and then Save:
  4. In the next dialog box, make sure you pick UTF-8 as character set and comma as field delimiter:
  5. Your file should now look like this when opened as a comma delimited file: