Change line endings and delimiter format (permanently) when saving to CSV from Excel

Question

I'm using Excel on Mac and it's always painful to have to reopen all exported CSVs in another text editor just to change the line endings from "CR" to "LF" and the delimiter from ";" to ","

Is there a way to set the preferred CSV save format permanently?

Thanks :)

Answer 1

I'm not sure how to change the line endings, but the delimiter is a semicolon due to regional settings.

But I hesitate to recommend changing your regional settings.

A better recommendation would be to not use Excel. Excel is a spreadsheet program, not a database.