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