Alfreido's Blog

Just a quick tip for those working with scripts that generate CSV files…

If the first 2 letters of the CSV file are ID and are capitalized (ie. your first column is an ID column), Microsoft Excel will try to read the file as an SYLK file instead of a CSV - and will sprout a couple of error messages saying the format is not what was expected and some asinine crap like that.

Quick fix: Make the ID lowercase so that it’s `id` instead, Excel will read it as a CSV once again.

Longer, more tedious fix: Petition Microsoft to get its arse into gear.

Through a freak series of circumstances, we ended up with veggie patties instead of hamburgers for dinner last night. And veggies patties taste fucking horrible!