gridcode for Excel

DIGIPIN, Plus Codes & GeoHash custom functions — local dev sideload.

manifest.xml functions.json functions.html (runtime) functions.js (bundle)

Sideload — Excel desktop (Mac)

1. Copy manifest.xml into the Wef folder: 
cp manifest.xml ~/Library/Containers/com.microsoft.Excel/Data/Documents/wef/
(Create the wef directory first if it doesn't exist.)
2. Restart Excel completely (Cmd+Q, then re-open).
3. Open any workbook. Insert → My Add-ins → Developer Add-ins → gridcode.

Sideload — Excel desktop (Windows)

1. Create a network share (or local folder) — e.g. \\localhost\addins — and place manifest.xml there.
2. In Excel: File → Options → Trust Center → Trust Center Settings → Trusted Add-in Catalogs → add the share.
3. Restart Excel. Insert → My Add-ins → Shared Folder → gridcode.

Sideload — Excel for the Web

1. In a workbook on office.com, go to Home → Add-ins → More Add-ins → Upload My Add-in.
2. Select your local manifest.xml file.
3. Refresh the workbook. Functions become available.

Try these formulas

=G.DIGIPIN(28.622788, 77.213033) → "39J-49L-L8T4" (Dak Bhawan)
=G.DIGIPIN(12.9716, 77.5946, 6) → "4P3-JK8" (1 km cell, Bangalore)
=G.PLUSCODE(12.9716, 77.5946) → "7J4VXHCV+JR"
=G.GEOHASH(12.9716, 77.5946, 8) → "tdr1v9qt"
=G.RECODE("39J-49L-L8T4", "digipin", "pluscode") → cross-conversion
=G.CHECKSUM("39J-49L-L8T4") → "39J-49L-L8T4-T" (Luhn-mod-16)
=G.VERIFY("39J-49L-L8T4-T") → TRUE
=G.DISTANCE(A1, A2, "digipin", "digipin") → metres

Test in a real workflow

Put 1000 lat/lng pairs in columns A and B, then drop =G.DIGIPIN(A1, B1) in C1 and fill down. Bulk-tag in seconds.

Trust the dev cert (one-time)

If your browser shows a security warning visiting this page, run:

cd excel-addin && npx office-addin-dev-certs install --machine

Then restart Excel and your browser.