Parse addresses, names or any unstructured text into useful components






123 Main St. Suite 100 Chicago, IL





Address part Tag
123 AddressNumber
Main StreetName
St. StreetNamePostType
Suite OccupancyType
100 OccupancyIdentifier
Chicago PlaceName
IL StateName

Split addresses into separate columns by street, city, state, zipcode and more right in Google Sheets™

Try the API for free

Try the Parserator API with 2,500 free API calls
Paid plans start at $10 / month

Sign up for an API key > Read the documentation >


Split addresses into separate columns by street, city, state, zipcode and more right in Google Sheets™

Google Sheets App

Parse addresses right in your Google Sheet™
API key required

Get started for free > Read more >

U.S. address parser

Dealing with some messy or unstructured addresses? We can parse them for you. Learn more »

Try it out! Parse an address in the United States into fields like AddressNumber, StreetName and ZipCode.

API Documentation Parse large volumes or integrate parserator with your service or application
Bulk address parsing Parse up to 500 addresses at a time with a simple copy & paste

Name parser

We've got names covered too. Parse names, households or companies. Learn more »

Try it out! Parse a western name into separate fields like GivenName, MiddleInitial, Surname, or Corporation

API Documentation Parse large volumes or integrate parserator with your service or application
Bulk name parsing Parse up to 500 names at a time with a simple copy & paste