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:
42,098
Overview
Ready to match addresses? Quick start video guide: https://www.youtube.com/watch?v=kMAHCQXfliw

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:
https://docs.placekey.io/#b02e2799-21ea-43af-b5ee-922dc4bdd164
Additional information
PricingNot available
Developer
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
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Nicole Berger
November 11, 2020
Such a great and easy way to add Placekeys to my addresses! Love it.
Is this review helpful?
Yes
No
Profile Picture
Ross Epstein
November 9, 2020
By far the easiest way to add Placekeys to my addresses
Is this review helpful?
Yes
No
Profile Picture
Roshan George
November 16, 2020
Quick and easy to use.
Is this review helpful?
Yes
No
Profile Picture
Eugene Chong
March 15, 2021
Really helpful for joining location data!
Is this review helpful?
Yes
No
Profile Picture
Ravi Patel
January 14, 2021
super easy to match and join location data...life changer!
Is this review helpful?
Yes
No
Profile Picture
Jason Richman
November 12, 2020
I can't code (I am in sales). This is very helpful and intuitive.
Is this review helpful?
Yes
No
Profile Picture
Ryan Squire
November 11, 2020
works great
Is this review helpful?
Yes
No
Profile Picture
Jason Cook
March 23, 2021
Incredibly easy to use with any addressable data, makes joining datasets SUPER easy. Even better is the underlying Placekey data has awesome usage rights and can be stored/used freely forever
Is this review helpful?
Yes
No
Profile Picture
Jaime Unger
March 16, 2021
Very intuitive + helpful with address normalization
Is this review helpful?
Yes
No
Profile Picture
John Votta
November 9, 2020
Intuitive and easy to use.
Is this review helpful?
Yes
No
1-10 of 15
Search
Clear search
Close search
Google apps
Main menu