3 ms·
I think you can do this in PowerQuery in excel and export as a clean CSV for the future fyi
by Closi 4y ago
I think you can do this in PowerQuery in excel and export as a clean CSV for the future fyi
- pbowyer 4y agoThanks, I'll look for that next time. The problem with Excel and these CSV files was it mangled the date column, which I only found out about after a bunch had been fully edited. I used modern CSV to rescue this and so have been suspicous of going back to Excel to do any further manipulations.
- Closi 4y agoThe good news is PowerQuery has data types! Although it is not as flexible in editing particular records if that is a requirement (just bulk edits, joins and merges)