This article shows you how to add counties to addresses using Geocodio. This can be useful for many purposes, such as clustering addresses by county using a pivot table, or mapping addresses by county. With Geocodio, you can choose to get the raw data back (via spreadsheet or API), or view the addresses on a map with county outlines.
The first step will be to organize the addresses into a spreadsheet. 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.
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.
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 Congressional districts or Census tracts). Counties are included by default with geocoding.
You will receive an email when your spreadsheet is done processing -- no need to stay on the page. You can download an example completed spreadsheet with counties added here.
You can also use Geocodio Maps to show a map with county outlines.
If you've already uploaded the file above, you would click "Edit in Geocodio Maps" from the dashboard.
Upon opening the map, you would then click the plus button next to the file name and select "add layer."
Next you would select Counties or County Subdivisions (the latter being the Census Bureau's terminology and definition).
Now you should see the county outlines on the map, as below:
You can also use the Geocodio API to add counties. You can do single requests for real-time geocoding, or use our batch geocoding endpoint to do batches of up to 10,000 at a time. Multiple batches can be run in parallel. See more in our documentation here.
Any questions? Please feel free to reach out to us.