There are several formatting issues with .csv files that can cause errors in the way our system populates your list with the validation results, and Empty Trailing Columns is one such issue. We are going to explain how to quickly fix it in order to avoid errors in the DataValidation analysis report.
Empty Trailing Columns and Rows have to do with the fact that spreadsheet software (Microsoft Excel and others) don’t tell the difference between an empty column and a non-existent one. So the issue appears when the user removes the content from a column, but does not delete the column itself, leaving it empty. The spreadsheet software treats the column as non-existent, but when the file is saved in .csv format, the empty fields are perceived as such and separators (commas) are placed between each blank field.
When you upload your file into our interface, the software scans your file for empty trailing columns and will give you a warning message if it detects any. You can still choose to upload your file, but then you might have a hard time finding the validation results. The reason is that we place our validation grades after the last column that our system detects. But if you have empty trailing columns, the grade column will be placed after these. So here’s how to avoid this inconvenience.
If you still encounter issues, please contact our LiveChat agents or write us at firstname.lastname@example.org.