DataMatch Enterprise Documents: DataMatch Enterprise + Address Verification: Resolve “The Column Heading Cannot be Empty.” When Importing CSV


How to resolve “Source Table File Missing” (Column heading cannot be empty) when importing CSV to DataMatch Enterprise + AV.  You are importing a CSV content to your DataMatch Enterprise software and receive the following error, “Source table file is missing” (Column heading cannot be empty).



Here’s how to resolve this issue:

    1. Open the source CSV file with Notepad, and check for a comma at the end of each row, which indicates an “invisible” column, normally as a result of manipulating the spreadsheet in Excel and exporting as CSV later on.
Empty Column

2. Now, open the CSV with Microsoft Excel. Remove the blank column by selecting the furthest right empty columns and deleting them, and then re-save the CSV. Check with Notepad again to make sure the comma at the end of each row has now gone.

3. Retry the import with the updated CSV file.

Please see a list of strict CSV specifications below

Common Format and MIME Type for Comma-Separated Values (CSV) Files

How can we help?