Skip to content

Column Mapping

After uploading your file, you need to tell CSV2GEO which columns contain your address data.

Address Components

For forward geocoding (address → coordinates), map these fields:

FieldDescriptionExample
Street NumberHouse/building number123
StreetStreet nameMain Street
CityCity or townNew York
StateState/province/regionNY
ZipPostal code10001
CountryCountry name or codeUSA

INFO

You don't need to fill all fields. At minimum, provide enough information to identify the location (e.g., full street address + city).

How to Map Columns

  1. Look at the column headers in the preview table
  2. Click the dropdown for each address component
  3. Select the column that contains that data

Column Mapping

Auto-Detection

CSV2GEO automatically tries to detect your columns based on header names. Common headers like "address", "city", "state", "zip" are automatically recognized.

Single vs Multiple Columns

If your address is split across columns:

streetcitystatezip
123 Main StNew YorkNY10001

Map each column to its corresponding field.

Single Column

If your entire address is in one column:

full_address
123 Main St, New York, NY 10001

Select that column for the Street field and leave others empty.

Reverse Geocoding

For reverse geocoding (coordinates → address), map these fields:

FieldDescriptionExample
LatitudeLatitude coordinate40.7128
LongitudeLongitude coordinate-74.0060

Tips for Better Results

Improve Accuracy

  • Include country for international addresses
  • Use standardized abbreviations (NY, CA, TX)
  • Avoid typos in city and street names
  • Include zip/postal codes when available

Next Steps

Batch Geocoding Made Easy