If you recently acquired an MLS dataset, you probably quickly noticed that many of the locations are missing longitude/latitude location coordinates. With so many MLSes per state and across the country, there is a wide variety in the depth and quality of information they provide. As a result, many MLS datasets are missing the location coordinates that let you put the addresses on a map.
This is vital if you want to be able to display the MLS data on a map with accuracy using tools like Tableau, since Tableau's built-in geocoding is only at the city level.
This guide walks you through how to add coordinates to MLS data using Geocodio. With Geocodio, you can add coordinates from spreadsheets or use our API to integrate geolocation into your tools and add coordinates automatically whenever you get new address data.
The first step will be to organize the addresses into a spreadsheet with the address information consistently formatted. Your spreadsheet will need to have headers (street, city, state or street + zip). The addresses can all be in one column or in multiple columns, as shown below, as long as it is consistent for the entire spreadsheet.
|660 Pennsylvania Ave SE||Washington||DC||20003|
|660 Pennsylvania Ave SE, Washington, DC 20003|
You can also download an example spreadsheet here. The addresses can be missing information as long as they are all consistently formatted. For example, you can have street + zip for some addresses and street + city + state for others.
You can also download an example completed spreadsheet with counties added here.
Once your spreadsheet is organized, you can upload it directly to Geocodio. You will select the columns where your data is, see an example of the results, and be able to optionally add on other data (such as school districts districts or Census tracts).
When we add the coordinates, we'll just add columns to your spreadsheet. We won't delete any information from the spreadsheet. So you can leave columns with other data such as property IDs and feel confident that it'll come back to you in the same order.
You will receive an email when your spreadsheet is done processing -- no need to stay on the page. You will also be able to download it from the dashboard.
You can also use the Geocodio API to add missing location coordinates to your MLS address data. You can do single requests for real-time geocoding, or use our batch geocoding endpoint to do batches of up to 10,000 lookups at a time. Multiple batches can be run in parallel. See more in our documentation here.