Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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?

share|improve this question
add comment

2 Answers 2

I found that solution for Windows version of Excel:

  • Click the Windows Start menu.
  • Click Control Panel.
  • Open the Regional and Language Options dialog box.
  • Click the Regional Options Tab.
  • Click Customize.
  • Type a new separator in the List separator box.
  • Click OK twice.

I didn't find anything for Excel for Mac.

share|improve this answer
2  
Not particularly helpful if it's not for the Mac version. –  slhck Jul 18 '12 at 14:51
add comment

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.

share|improve this answer
    
There are many legitimate reasons for exporting CSV from Excel that are nothing to do with databases. Other than that I think you are spot on. –  Lunatik Dec 21 '11 at 16:37
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.