Hacker News new | ask | show | jobs
by zozbot234 2143 days ago
Great, how do you set a custom column format in a CSV file?
2 comments
ryukafalz 2142 days ago
I'm only familiar with LibreOffice and not Excel myself, but: if you want to be sure a column is treated as text in a CSV file, you have LO quote text fields on save, and have it treat quoted fields as text on import. I assume Excel must have similar options.
link
rini17 2142 days ago
LibreOffice, on opening of CSV file, always pops an import dialog where you can do this. To keep the column format permanently, save as ods.
link