Easily split addresses into separate columns by street, city, state, zipcode and more.
Listing updated:June 27, 2024
Works with:
Parserator parses and splits addresses into separate components like street, city, state or zipcode. This tool is powered by DataMade’s open source usaddress library (https://github.com/datamade/usaddress), the most accurate and reliable parser for addresses in the United States.

How to use Parserator:
- Sign up to get a free Parserator API key emailed to you: https://parserator.datamade.us/sign-up/. Your first 1,000 address parses are free.
- In your Google Sheets™ spreadsheet, go to Parserator => Set API key and paste in your API key.
- Select a column of addresses and go to Parserator => Parse addresses.
- Parserator will parse each address into structured, labeled address components, like street number, street name, city, and zipcode.
- For more than 1,000 parses, sign up for a paid account starting at $10/month: https://parserator.datamade.us/pricing/

How does Parserator work?
Using a probabilistic model, it makes (very educated) guesses in identifying address components, even in tricky cases where rule-based parsers typically break down. You can read more about it at our blog post: https://datamade.us/blog/parsing-addresses-with-usaddress/

Parserator is a great tool to assist with:
- Creating standardized address labels
- Matching and merging addresses
- Importing address data into a database
- Geocoding

Parserator can identify and tag up to 27 distinct address parts:
- AddressNumber
- AddressNumberPrefix
- AddressNumberSuffix
- BuildingName
- CornerOf
- IntersectionSeparator
- LandmarkName
- NotAddress
- OccupancyIdentifier
- OccupancyType
- PlaceName
- Recipient
- StateName
- StreetName
- StreetNamePostDirectional
- StreetNamePostModifier
- StreetNamePostType
- StreetNamePreDirectional
- StreetNamePreModifier
- StreetNamePreType
- SubaddressIdentifier
- SubaddressType
- USPSBoxGroupID
- USPSBoxGroupType
- USPSBoxType
- ZipCode

This is a tool by DataMade. For any further queries visit our website at https://parserator.datamade.us/ or email us at parserator@datamade.us.
Additional information
PricingFree of charge trial
Privacy policy
Terms of service
Parserator: Parse and Split Addresses will ask for the permissions shown below. Learn more
Parserator: Parse and Split Addresses will need access to your Google account
This will allow Parserator: Parse and Split Addresses to :
View and manage spreadsheets that this application has been installed in
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Joey Gribble
February 18, 2023
Worked great. I had to a hard refresh of my sheet to get the option to put the API key, but was able to easily get one emailed to me from the website. Great extension!
Is this review helpful?
Profile Picture
Sam McAlilly
March 23, 2022
very helpful for working with address data
Is this review helpful?
Profile Picture
Derek Eder
February 18, 2022
Super fast and convenient tool for structuring my address data
Is this review helpful?
1-3 of 3
Clear search
Close search
Google apps
Main menu