CSV/MS Excel: Trick for separators

PHOTO EMBED

Mon Aug 29 2022 19:20:27 GMT+0000 (UTC)

Saved by @marcopinero #csv

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
content_copyCOPY

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)