Creating Plus Codes Using the Spreadsheet Add-on

[irene_NLS27]

The Plus Codes Spreadsheet add-on makes it easy to work with plus codes in Google Spreadsheets.

INTRODUCTION

The Plus Codes Spreadsheet add-on combines plus codes with the power of data manipulation in Google Spreadsheets. It allows you to:

• Convert latitude and longitude coordinates to plus codes;
• Get the center coordinates, bounds and length from plus codes;
• Create plus code based addresses;
• Recover the original codes from plus code based addresses.

GETTING HELP

To ask a question about the add-on or to report a bug, post a message to the plus-codes-spreadsheet-add-on Google group. Search the group before posting as your question may have already been answered.

INSTALLING THE ADD-ON

To use the Plus Codes add-on, you must add it to your spreadsheet. Here's how:

1. Create a new Google Spreadsheet (or open an existing one);
2. From the menu bar, choose "Add-ons" > "Get Add-ons";
3. In the add-ons gallery, find the Plus Codes add-on and select it;
4. From the add-on description page, click the "+" in the top right corner to add this to your spreadsheet;
5. A dialog will pop up requesting your permission for the add-on to access your spreadsheets and external services. Click "Accept";
6. The add-on is now installed. You should now see a "Plus Codes" submenu in the Add-ons menu.

The add-on requires three permissions:

• "View and manage your spreadsheets in Google Drive" - this allows the add-on to read data from your sheets and update it;
• "Display and run third-party web content in prompts and sidebars inside Google applications" - this enables the add-on to display the panels for the menu options;
• "Connect to an external service" - this is used to report what functions are used and if there are problems

[River Mersey]

Also,

Please have a look at my VBA code for MSAccess databases: https://github.com/google/open-location-code/issues/364

While it does work very quickly, TBH, I had some problems understanding the pluscode specs for generating the codes beyond 10 character accuracy.

Any help in making this work better would be much appreciated.