Excel's handling of CSV's pisses me off. It will modify the actual file when you open it, even if you don't save.

The entire office suite is horrible when it comes to preserving user data though. Access will change sql queries if you look at the code and close the query without saving or modifying anything. It's especially annoying when the query no longer works because Access 'helpfully' removed some parenthesis.

I've never had that happen and I open a lot of CSVs in Excel.

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?

> 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.

I just write a simple custom program to deal with my CSV's :-)

I don't doubt it, but the bit about excel was sarcasm, it doesn't exist in our workflow.

Do you know if LibreOffice modifies csv files in this manner, or is it 'safe' ?

I've never had it modify an opened file without me explicitly saving it.

What happens if you mark the file read-only?