Easily split addresses into separate columns by street, city, state, zipcode and more.
Ultimo aggiornamento scheda:27 giugno 2024
Compatibile con:
13.339+
Panoramica
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.
Informazioni aggiuntive
PrezziProva senza costi
Sviluppatore
Norme sulla privacy
Termini di servizio
Parserator: Parse and Split Addresses richiederà le autorizzazioni mostrate di seguito. Scopri di più
Parserator: Parse and Split Addresses dovrà poter accedere al tuo Account Google
Ciò consente all'app Parserator: Parse and Split Addresses di
Visualizzare e gestire i fogli di lavoro in cui è stata installata questa applicazione
Visualizza e pubblica contenuti web di terze parti in messaggi e barre laterali all'interno delle applicazioni Google
Connettersi a un servizio esterno
Visualizzare l'indirizzo email principale del tuo Account Google
Visualizzare le tue informazioni personali, incluse quelle che hai reso pubblicamente disponibili
Recensioni
Lingua:
Ordina per:
Google non verifica le recensioni né le valutazioni. Scopri di più sulle recensioni
Nessun commento
Ricerca
Cancella ricerca
Chiudi ricerca
App Google
Menu principale