How do I get Excel to put in enough “data elements” when the file is saved as comma-delimited (CSV)?
Excel files can be readed through the use of fix corrupt excel
Learn next item http://www.fixcorruptedexcelfile.excelfilefix.com
A. Because the last field is the final item in each record and has been left intentionally blank, there is a high likelihood of problems in converting your Excel file to the comma-delimited (CSV) file format. Excel often experiences difficulty knowing how many commas to put in each row when the cell at the end is empty. This can result in an incorrect number of data elements. (A “data element” is the same as an active cell in a spreadsheet.) The simplest solution to this problem is to put an apostrophe (‘) – also known as a single quotation mark – in any cell in the last column that is intentionally left blank. This will tell Excel to fill in the comma to indicate a blank item at the end.
