App Icon
Solve difficult problems with address and POI matching, address normalization, validation, deduplication, and entity resolution with Placekey's free and open universal identifier for a physical place.
Works with:
Ready to match addresses? Quick start video guide:

Placekey is a free and open standard universal identifier for any physical place. For every address you have, our add-on generates a Placekey in a new column right inside of Google Sheets, without needing to wrie a single line of code. Placekey is smart: it can tell that differently-formatted addresses are the same (i.e. "Suite 261" vs. "Ste. 261" vs. "#261"), which lets you easily merge disparate data sets. This Add-on exposes the full functionality of the Placekey API in order to quickly add Placekeys to your address and geocoding data, right from Google Sheets.

How can I use Placekey? 

Placekeys solve a number of common problems for data scientists. As a unique identifier for any physical place, Placekey simplifies the process of joining both POI or non-POI datasets. Placekey also reveals relationships between POIs and addresses, providing details such as proximity, co-tenancy, and POI history. Even places without addresses can be appended with a Placekey.

Placekey Details:

Each Placekey is divided into two parts: What and Where, written as “What@Where”. The What part encodes information about the place and its address, while the Where part situates that place on Earth. The What part of a Placekey is optional, and a Whatless Placekey like “@5vg-7qg-tvz” refers to a region on the Earth while a What part plus a Where part specifies a particular place within a region on the Earth. The Where part of a Placekey encodes a hexagon of approximately 15,000 m2 on the surface of the Earth. These hexagons have an edge length of 66 m on average, and it can be helpful to think of them as roughly circles with a diameter of 132 m. The exact area and edge length of the hexagon varies by location. In particular, these hexagons are given by resolution 10 H3 indices.

Full instructions and documentation can be found here:
Additional information
PricingNot available
Trader status unspecified
Privacy policy
Terms of service
Address Matching by Placekey will ask for the permissions shown below. Learn more
Address Matching by Placekey will need access to your Google account
This will allow Address Matching by Placekey to :
View and manage spreadsheets that this application has been installed in
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Clear search
Close search
Google apps
Main menu