http://qs321.pair.com?node_id=1124471


in reply to Semicolon delimited to Comma delimited

Add a line with sep=; at the top of the csv file. Excel will read this as an instruction and override the end user's default separator. This should still be readable on your end as well but it's quite possibly specific to Excel.

Minor point but the semicolon variant isn't used everywhere in Europe but I did see it when working with a German company.