CSV Files Not Created Equal

All CSV files are not the same. I just had a issue when working with a CSV export from another Requirements Management Tool was not importing correctly into PACE. It looked fine when we opened it in Excel to make sure the data was clean but we were having a problem with the column counts. Finally I watched them export the data and found that they were export to “Spreadsheet”. There was another option to export to MS Office > Excel. When we did the export that way and then opened it an saved as “MS Dos” .csv everything worked as it should.
So just remember that not all CSV files are created Equal.