CSV/MS Excel: Trick for separators

1
2
rep=,
number,name,date
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
In order to separate correctly values when a csv file is opened with MS Excel, add a first line with rep=<separator>.

For "," / comma:
rep=,

For ";" / semicolon:
rep=;

I don't know if it is a stupid trick but it works like a charm when downloading/opening csv files with MS Excel (I don't know if others)

Be the first to comment

You can use [html][/html], [css][/css], [php][/php] and more to embed the code. Urls are automatically hyperlinked. Line breaks and paragraphs are automatically generated.