Easily split addresses into separate columns by street, city, state, zipcode and more.
Listing updated:2024 m. birželio 27 d.
Works with:
14 tūkst.+
Apžvalga
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
- USPSBoxID
- 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
Developer
Paslaugos teikimo sąlygos
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 :
Peržiūrėkite ir tvarkykite skaičiuokles, kuriose įdiegta ši programa
Rodykite trečiosios šalies žiniatinklio turinį „Google“ programų paraginimuose ir šoninėse juostose
Prisijungiama prie išorinės paslaugos
Peržiūrėti pirminį „Google“ paskyros el. pašto adresą
Peržiūrėkite savo asmens informaciją, įskaitant bet kokią viešai pasiekiamą asmens informaciją
Įvertinimai
Language:
Rūšiuoti pagal:
„Google“ nepatvirtina apžvalgų ar įvertinimų. Sužinokite daugiau apie apžvalgas
No comments
Paieška
Išvalyti paiešką
Uždaryti paiešką
Google Apps
Pagrindinis meniu