Skip to content

Latest commit

 

History

History
16 lines (8 loc) · 950 Bytes

Using-plus-codes-in-spreadsheets.md

File metadata and controls

16 lines (8 loc) · 950 Bytes

Being able to work with plus codes in spreadsheets is, for most people, probably the easiest method to work with them in bulk.

This page explains how you can access the Open Location Code functions from Excel, LibreOffice or Google Spreadsheets.

Google Sheets

There is an add-on for Google Sheets that allows you to create plus codes from latitude and longitude coordinates, and to decode them as well.

The plus codes youtube channel has some videos showing how to install and use the add-on.

Excel/LibreOffice

VBA script and instructions are checked into github here.

LibreOffice does sometimes have problems. This may be due to slightly unreliable VBA support in some versions.