Parserator: Parse and Split Addresses allows you to easily split addresses into separate columns by street, city, state, zipcode and more right in Google Sheets™
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, the most accurate and reliable parser for addresses in the United States.
Fit your addresses to the required format for address label services
Easily match addresses in different formats by standardizing them
Align your address data to the fields in your database
Properly identify all the correct address parts to send to your Geocoding service
Sign up to get a free Parserator API key emailed to you. Your first 10,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 10,000 parses, email email@example.com for a paid account starting at $10/month.