Error "...invalid rows in the file" Importing Custom Geocoding
Published: 03 May 2013 Last Modified Date: 17 Oct 2022
Issue
When you try to import a .csv file with custom geocoding, the following error might occur:
Ignored <number> invalid rows in the file <filename>.csv
Environment
Tableau Desktop
Resolution
Correct the format of the custom geocoding .csv file. For example:
When importing latitude and longitude values in Tableau Desktop, the entire value must be in one cell instead of split into two cells. For example, instead of -11 and 929 in separate cells, include one cell with the value -11.929.
Verify that the geocoding columns do not contain blank cells.