KNOWLEDGE BASE

Error "...invalid rows in the file" Importing Custom Geocoding


Published: 03 May 2013
Last Modified Date: 25 Sep 2017

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.
  • Eliminate duplicate geocoding values.
For examples of custom geocoding formatting, see Creating an Import File in Tableau Help.

Incorrect Formatting:

Incorrectly formatted custom geocoding file

Correct Formatting:

Correctly formatted custom geocoding file

 

Cause

The custom geocoding .csv file is not formatted correctly.
Did this article resolve the issue?