Can you help me sort my data to identify all zips/ZCTAs in a city, county or state?

These instructions are optimized for Excel but function much the same in other spreadsheet programs like LibreOffice Calc and Google Sheets.

Sorting the list by Value

Click on the arrow next to the field you want to sort, and click on "Sort Smallest to Largest" or Sort Largest to Smallest".

Finding all Zip/ZCTAs in a state

Click on the arrow next to state

Either select/deselect the checkboxes next to the states…

…or type a state in the search box

Finding all Zip/ZCTAs in a city or county

You can first narrow down the results by filtering first if you know which state your city or county is in.

Then, click on the arrow next to the City or County and type the name of the geography you want to search for.

In some cases, you may get geographies with the same name, but are located in different parts of a state. You can further refine your search results using the County field.

Other Filtering Options

Please see the video below for additional help on:

  1. Filtering by city/county
  2. Filtering for high income zips
  3. Excluding high margin of errors
  4. Only displaying data for a subset of zip's/ZCTA's using a VLOOKUP
Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.