ZeroSharp

Robert Anderson's ones and zeros

Top Tip for Viewing CSV Files in Excel

| Comments

Here’s a quick hack when your CSV file has a different separator than Excel is expecting.

Add this on the first line of the CSV file:

sep=;

or

sep=,

This will override system setting for list separator character and Excel will open the file correctly.

Note: Excel expects the separator to match the one defined in the Control Panel/Region/Formats/Additional settings/List Separator. On a French system, it expects a semi-colon.

Comments