Provides menu options and functions to convert between latitude and longitude and plus codes.
Plus codes make location information easier to use. Instead of two long numbers (atitude and longitude) there's a single, shorter code.
Most people in the world live on an unnamed street. Plus codes were created so that these people can have an address, so that they can receive deliveries, access emergency services, register to vote – and more. Plus codes are open source and free to use, for any purpose, forever.
Plus codes are based on latitude and longitude, so they already exist everywhere. The location 47°21'56.0"N 8°31'29.3"E has the plus code "8FVC9G8F+6W".
Plus codes can be converted to plus code addresses. These use place names and a short version of the code: "9G8F+6W, Zürich, Switzerland". This form is easier to recognise, and the shorter code means people have less digits to remember.
This add-on for Google Sheets allows you to convert between location coordinates and plus codes, using a menu function and additional sheet functions:
You can also convert between plus codes and addresses using the menu and additional functions:
Plus codes use the Open Location Code algorithm, an open source Google project. See https://opensource.google.com/projects/open-location-code for links to the open source projects.