Easily split addresses into separate columns by street, city, state, zipcode and more.
정보 업데이트:2024년 6월 27일
호환 기기:
1만+
개요
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.
추가정보
가격무료 체험
개발자
개인정보처리방침
Parserator: Parse and Split Addresses에서 아래에 표시된 권한을 요청합니다. 자세히 알아보기
Parserator: Parse and Split Addresses에서 Google 계정에 액세스해야 함
이렇게 하면 Parserator: Parse and Split Addresses에서 다음 작업을 할 수 있습니다.
애플리케이션 설치 시 사용한 스프레드시트 조회 및 관리
Google 애플리케이션 내 메시지 및 사이드바에 외부 웹 콘텐츠를 표시하고 실행합니다.
외부 서비스에 연결
기본 Google 계정의 이메일 주소 확인
개인정보(공개로 설정한 개인정보 포함) 보기
리뷰
언어:
정렬 기준:
Google에서는 리뷰나 평점을 확인하지 않습니다. 리뷰에 대해 자세히 알아보기
댓글 없음
검색
검색어 지우기
검색 닫기
Google 앱
기본 메뉴