"I know Excel"

How to change the delimiter when exporting CSV from Excel?

Recently, I needed to find a way to import data from an old Excel-file to a custom-coded system that could import CSV files. However, the data was fairly non-sanitized – containing commas, semicolons and other weird characters. I could define the delimiter used in the imported data – however, that would be useless if I wasn’t also able to define it in the export. With Excel, it’s not that simple, though. Excel, just like other Microsoft Office applications loves trying its best to respect the…Continue reading How to change the delimiter when exporting CSV from Excel?