Add Congressional Districts to a Spreadsheet of Addresses

Quickly add Congressional districts and legislator contact information to a spreadsheet of addresses

Need to add Congressional districts or Senator and Representative contact information to addresses in bulk? You're in the right place.

This article shows you how to add Congressional districts to addresses using Geocodio. The Congressional district data returned includes Congressional district number, Congress number, and Congress years, with the option to append legislator data. You can use our API to integrate it into a website, or upload Excel, CSV, and TSV files.

With Geocodio, you can choose to just get the raw data back (via spreadsheet or API), or view the addresses on a map with Congressional district outlines.

Find the Congressional district information for a single address

If you just need the Congressional districts and Senator/Representative contact information for one address, you can use the tool below. Just check the box next to ‘Congressional Districts’, then click ‘show results.’

Find the Congressional district for a single address

Please enter an address in the US or Canada

Do you want to append additional data?

Show results

How to Add Congressional Districts to a Spreadsheet of Addresses

1. Organize the addresses you want to add Congressional district info to in a spreadsheet

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.

Multiple column format:

Street City State ZIP
960 Orange Avenue Coronado CA
2050 N Stemmons Fwy Dallas TX
5020 E Sprague Ave 99212

Single-column format:

Address
960 Orange Avenue Coronado CA
2050 N Stemmons Fwy Dallas TX
5020 E Sprague Ave 99212

However, the formats cannot be mixed, as below:

Location
960 Orange Avenue Coronado CA
45.5045128,-73.621345
5020 E Sprague Ave 99212

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.

2. Upload the spreadsheet of addresses to Geocodio to add Congressional district data

Once your spreadsheet is organized, you can upload it directly to Geocodio. After confirming the columns and seeing a preview of the file on a map, you will be presented with options to append data. You will want to check the box that says “Congressional Districts”, with the option to include Senate and Representative info. Counties are included by default with geocoding.

Results are billed as geocode + Congressional district info (i.e., two lookups). For example, if you have 100 addresses that you want Congressional districts for, that would count as 200 lookups. You can calculate how much this will cost you and how long it will take here.

3. Download your completed spreadsheet with Congressional district information added

You will receive an email when your spreadsheet is done processing -- no need to stay on the page.

Congressional Districts

Congressional District Number

For example, Congressional District 8

Congress Number

For example, 117th

Congress Years

For example, 2021-2023

Vote.org
In elections, we can’t have even a 5% tolerance for error. Geocodio gives us the accuracy we need to give people the correct information about the election and remind them to vote.
Debra Cleaver, Founder
Vote.org

Address or Coordinates to Senator and Representative Info

Senator and Representative Names

Senator and Representative Emails

Senator and Representative DC Office Addresses

Senator and Representative Phone Numbers

Senator and Representative Websites

Senator and Representative Parties

Senator and Representative Social Media Links

Senator and Representative IDs

Upload a spreadsheet now. No credit card required.

Upload SpreadsheetGet an API Key

ZIP Codes to Congressional Districts

If you only have ZIP codes, we can return all of the possible Congressional districts ranked by likelihood in our API. (Most likely result is returned for spreadsheets.)
Learn more

Historical Congressional Districts

Use our API to get Congressional districts back to the 113th Congress.

Full Data Dictionary

Download an example result and see the full data dictionary.

Find Senator and Representative Phone Numbers in Bulk

Need to help people contact Congress? Geocodio can help.

Add Congressional Contact Information to MailChimp

Step-by-step guide on how to add Congressional contact information to addresses and upload to MailChimp.

Congressional Districts API

Use our API to programatically add Congressional districts and legislator contact information to addresses or coordinates.

Coordinates to Congressional Districts

Convert latitude/longitude coordinates to Congressional districts.

Canadian Ridings

You can also add Canadian electoral disricts at both the federal and provincial/territorial level.
Copyright © 2014-2024 Dotsquare LLC, Norfolk, Virginia. All rights reserved.