4 ms·
I don't think excel will change the file if you dont save. But, weirdly excels CSV issues are a more mac-specific program. MSFT insists that mac has a differen
by spollo 10y ago
I don't think excel will change the file if you dont save.
But, weirdly excels CSV issues are a more mac-specific program. MSFT insists that mac has a different format for csvs and will constantly destroy csvs, change formatting, unquote fields, merge columns together, insert random unicode characters, screwed up line endings, etc if you save on mac and aren't careful.
I've actually noticed msft has changed the default csv output format in excel mac twice over the past month (including making the csv default format be TSV??) which is pretty ridiculous.
I just want them to comma seperate, quote fields if necessary, and properly escape characters. Don't insert random characters or fuck with encodings. How hard could it be?
- pjmlp 10y ago> MSFT insists that mac has a different format for csvs Mac had a different format for CSVs, and actually Excel started its life as a Mac product.