Re:Dangers of CSV Injection
by letlambda on Tuesday October 10, 2017 @02:40AM
(#15439849)
If you open a .csv file in excel and save it, you may find that it has converted any long numbers into scientific notation for you, and saved that as text. It will also get rid of any leading zeros for you.
[ Parent
| on HN ]
Also it will round those numbers silently to 15 digits.
It was a fun time explaining to accounting why their report showed duplicate billing events. Try telling an accountant "Don't use Excel". The solution of course was to prefix a "'" character, making the file useless outside of spreadsheet programs.