Reputation: 16743
I have a colleague using Excel 2007 on XP, and every time she saves her workbook as a .csv file, she is getting tabs for delimiters. Any idea what is happening, and how we can get commas instead?
Upvotes: 8
Views: 4702
Reputation: 450
http://mavericksquest.blogspot.com/2011/06/excel-to-custom-character-delimited.html
if your default delimeter changed you can set it back there (in windows: Control Panel > Regional and Language Settings > Customize > Set List Separator field to ,) now you can save as csv through excel (saveas > other formats > csv)
Upvotes: 2