I have been running into issues with Excel shenanigans whenever I go to edit my CSV exports from Tulip tables - things like losing trailing zeroes, specifically, which are important for test specifications where you need to do things like round your results to match the # of siginficant digits in your spec. Also for product numbers that end in zero. Stuff like that.
I found the following article which looked promising:
I got the plugin installed and was able to transform my data:
Notepad++ finally upversioned for me (something IT-wise was preventing it for a while) and I now have access to the CSVLint plugin - it automatically color codes column content by delimiter placement (rather than attempting to fix the column width). Combined with CTRL+F to find the record ID or other content of interest, this makes it very easy to export, update, and re-import table data without Excel fouling up my trailing zeros, etc.
A suggestion;
If you don’t open the CSV import directly in excel, but instead use the CSV data importer/power query editor in excel. Here you can change all column data types to text which makes excel retain all data as it exist in the CSV file.
If you save again as a CSV the output file should look fine.
Would this work for you?
rgds
asger
