Guides
for everything Geocodio
Guides
Geocoded results
Guides
for everything Geocodio
Geocoded results
When you upload a spreadsheet for geocoding, we'll leave your columns in place and append additional columns to the existing spreadsheet.
We'll leave the rest of your columns untouched. If you have information that's important to you in the spreadsheet, like a user ID number, you can leave that in there and it'll still be there when you download the completed file.
In addition to the latitude & longitude, we also append a few helpful pieces of data, like accuracy score, accuracy type, and the parsed addresses.
You can download a sample geocoded spreadsheet here.
The columns we'll add will be:
Latitude/longitude coordinates, or approximate addresses if you're reverse geocoding
Parsed and standardized addresses: We'll return the parsed address data as individual, standardized values. You'll find that street suffixes and directions are always abbreviated, and the capitalization of words are also standardized. For Australian and New Zealand addresses, street types use the Australia Post and NZ Post abbreviations (St, Rd, Tce, Cct), and New Zealand place names keep their macrons.
Completed address:
For US locations: Street, City, State, 5-digit ZIP Code, County
For Canadian locations: Street, City, Province, partial postal code or user-submitted postal code (see note below)
For Mexican locations: Street, Locality, Postal Code, City, Province (abbreviation)
Example: Calzada Independencia Sur 991, 44100 Guadalajara, JAL Mexico
For UK locations: Street, City (post town), County, Postcode, Country
Example: 10 Downing Street, London, Greater London, SW1A 2AA, GB
For Australian locations: Street (with any unit written before a slash, as in 1/201), Suburb, State (abbreviation), Postcode, Country
Example: 1/165-203 George St, The Rocks, NSW, 2000, AU
For New Zealand locations: Street, Suburb, Town or city, Postcode, Country. The suburb goes in its own Geocodio Sublocality column, just before Geocodio City, and is left blank when the suburb is the city centre (such as Auckland Central). New Zealand addresses don’t include a region.
Example: 174 Vivian St, Te Aro, Wellington, 6011, NZ
Accuracy scores and types for each result: Accuracy types are the type of result (such as rooftop) and accuracy scores are a function of differences between input and output. See more about what this means here.
A note on Mexico address data: In Mexico, Geocodio only provides rooftop coordinates. We have full rooftop coverage for every single province in Mexico, as well as a countrywide dataset.
A note on UK address data: Geocodio only provides Northern Ireland data at postcode-level accuracy. However, all districts in Northern Ireland follow postcode boundaries, so this level of accuracy is sufficient for district matching.
A note on Australian and New Zealand address data: Geocodio doesn’t use range interpolation in Australia or New Zealand. Results are rooftop, nearest rooftop match, intersection, street centre, or place level. See more about accuracy types here.
A note on New Zealand postcodes: New Zealand postcodes are licensed from NZ Post. You can show the postcode as part of an address in your own product. You can’t supply the postcodes separately as a dataset, or pass them to your own customers to store with their addresses. See our Terms of Use for details.
Any additional data you've requested. Read more about data appends.
UK data appends
For UK addresses, you can also append Census geographies ((Output Areas, LSOAs, MSOAs, local authorities), political constituency and district data including Westminster, devolved parliaments (Scotland, Wales, Northern Ireland), and local wards. Select them during upload or add them via the API.
Australian data appends
For Australian addresses, you can also append Census geographies, demographics, housing, and income, and federal and state electorates. Select them during upload or add them via the API.
2. A map of the results
You'll also be able to create a map with markers and labels.
You can share the map (publicly or privately)
To create or edit, open the map on the dashboard. (Note: you must be logged in in order to see this page.)
Note on Canadian postal codes
Full postal codes in Canada are proprietary to Canada Post. Therefore, for licensing reasons, if you do not provide a postal code for a Canadian location, Geocodio will return only the first three characters (FSA), which is open-source.
If you supply a full Canadian postal code with your input, Geocodio will check that the FSA matches our internal data and, for your convenience, return the user-inputted full postal code in the results. Such full postal codes have not been verified or corrected by Geocodio, and Geocodio makes no claims about their accuracy.