CSV/MS Excel: Trick for separators

rep=, number,name,date 1,MARCO PINERO,06/25/2021 2,JHON DOE,06/24/2021 3,MICHEL GRUBER,06/27/2021 4,DELIA VAN THASTEN,06/28/2021 5,MILTON BRIGHT,06/29/2021
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.