Address Formatting Guide

Before uploading your CSV file for geocoding, please ensure your addresses are properly formatted. This guide will help you prepare your data for successful geocoding.

Address Format Example

STREET: 5801 S Ellis Ave
CITY: Chicago
STATE: IL
POSTAL: 60637
COUNTRY: US

Address Format Requirements

• Required Fields: STREET, CITY, STATE, POSTAL, COUNTRY
• Optional Fields: NEIGHBORHOOD, SUBREGION

Common Formatting Issues

Tips for Better Results

• Use standard abbreviations (St, Ave, Blvd, etc.)
• Avoid special characters when possible
• Ensure city names match official postal records
• Verify postal codes are correct for the given city/state
• For international addresses, include the correct country code

Example CSV Format

ID,STREET,CITY,STATE,POSTAL,COUNTRY
1,5801 S Ellis Ave,Chicago,IL,60637,US
2,1200 E California Blvd,Pasadena,CA,91125,US
3,1 Queen's Rd,London,,SW1A 1AA,GB

Need Help?

If you're having trouble formatting your addresses, please contact GIS Help for assistance.

Tips for Successful Validation

• Include as much address information as possible
• Use standard abbreviations (e.g., "St" instead of "Street")
• Verify postal codes match the city/state
• Check for typos in city and street names
• For US addresses, use the two-letter state code (e.g., "IL" for Illinois)

Common Issues

• Incomplete Addresses: Missing street numbers, city, or postal code
• Typos: Common in street names and city names
• Incorrect Formatting: Using full state names instead of codes, or vice versa
• Special Characters: Some special characters might cause validation issues

Interactive Address Validator

ID,ADDRESS,CITY,REGION,POSTAL,COUNTRYCODE
1,123 Main St,Chicago,IL,60601,US
2,456 Oak Ave,Portland,OR,97201,US

ADDRESS
"123 Main St, Chicago, IL 60601, US"
"456 Oak Ave, Portland, OR 97201, US"