Re:Data Organization in Spreadsheets
by cm2187 on Monday August 20, 2018 @03:34PM
(#17803127)
Once you have are aware of it there are ways around that. The problem is that this will surprise I think pretty much anyone who hasn't been bitten yet. When you double click on a csv file, it just opens it. Then you have some weird behavior of things not matching when they should.
[ Parent
| on HN ]
Re:Data Organization in Spreadsheets
by smhenderson on Monday August 20, 2018 @04:29PM
(#17803652)
Yeah, it's a pain. Zip Codes that begin with zero, FedEx tracking numbers, as you mentioned any long numbers. All of these gotchas have a work-around but they can be very tedious to look for and address. The worst part is that when you think you've fixed whatever needed fixing, save the CSV file and then remember something you missed and reopen it all of your first round changes are lost.
I've gotten in the habit of saving a copy to Excel first, then to CSV again. If I realize I still have a bug in my CSV copy I reopen the Excel version so any earlier formatting edits I've made are still intact.