The cells of the last column, shown with a red border, will cause the exported CSV file to contain a bug and the file will not import into logiforms. The last column of the exported spreadsheet must contain data in ever cell.

Workaround #1 Recommended
The first workaround is to move a column from the spreadsheet that DOES have data in each row/cell to the last position. The steps to do this are as follows:

• Click the column header of the column to move to the last position. The column is selected. In this example, we are moving 'plexcategory' to the last column position.
  
  
• Next, open the Edit Menu and select Cut
  
   
• Click the column header after the last column in the spreadsheet. This will highlight the column
• Open the Edit Menu, and Select Paste. This will move the 'plexcategory' column to the new position at the end of the spreadsheet.
  
  
• The final step, is to right click in the column header of the now empty Column and select Delete from the Edit Menu.
  
  

Workaround #2
To ensure that Microsoft Excel saves tab or comma delimiters for all empty columns, verify that the last column in the file contains some data in at least every 16 rows throughout the file. If the blocks of rows do not contain data, add spaces or other characters in every 16 rows to the cells in the last column or reorder the columns in the worksheet so that the last column on the worksheet always contains information.

Pressing shift+ctrl+8 while in Excel will select your entire data table. Use this tip to check for empty trailing columns.