Skip to main content

​
Your file contains more than 100 columns

When generating or saving a CSV file, a problem can occur when the file contains many unnecessary blank cells that contain no data but still have to be processed. To prevent this, the number of columns in the file is limited to 100 (far more than should normally be required). If you see this message, your file is likely full of blank data. If you open it in a plain text editor, you will probably see thousands of commas and not much else.

​
How to fix it

  1. Open the file in Excel.
  2. Select all blank columns after your data.
  3. Delete the data in them.
  4. Save the file.
You should then see the file size reduce. If opened in a text editor, only the data columns should remain.