Digipin Lookup

Digipin Lookup brings fast, accurate DIGIPIN encoding and decoding directly into Google Sheets. Built for teams working with geographic data, logistics, field operations, mapping workflows, and address normalization, this add-on transforms coordinates into standardized DIGIPIN location codes—and converts DIGIPINs back into precise latitude/longitude pairs.

Key Features

✓ Encode Latitude/Longitude → DIGIPIN

Generate precise, 10-character DIGIPIN location codes using a custom formula or the interactive sidebar tool.

Single location:

=DIGIPIN_ENCODE(19.0760, 72.8777)

Entire columns of coordinates:

=DIGIPIN_ENCODE(A2:A100, B2:B100)

✓ Decode DIGIPIN → Latitude/Longitude

Instantly convert any valid DIGIPIN back to a coordinate pair.

Single:
=DIGIPIN_DECODE("4FK-595-8823")

Multi-row batch decode:

=DIGIPIN_DECODE(E2:E50)

Returns clean 2-column output for easy mapping or distance calculations.

Smart Range Handling

The add-on is designed for real spreadsheet workflows:

• Automatically handles large ranges

• Skips blank rows safely

• Prevents formula expansion errors

• Works with vertical, horizontal, or block ranges

Perfect for processing thousands of DIGIPINs at once.

Intuitive Sidebar Tool

The built-in sidebar allows non-technical users to:

• Encode coordinates without writing formulas

• Decode any DIGIPIN instantly

• Copy results with one click

• Access quick examples and usage instructions

Ideal for onboarding teams or quick one-off conversions.

Reliable, Accurate, Built for Scale

This add-on uses a precise grid-based algorithm to compute or decode DIGIPIN location codes with high accuracy. Designed for operational workflows such as:

• Delivery planning

• GIS validation

• Field workforce tools

• Asset tracking

• Survey datasets

• Location-based analytics

Easy to Use, Secure by Design

No external servers.
All calculations happen inside Google Sheets and Apps Script.
Your data never leaves your spreadsheet.

Make location processing effortless.

Whether you're preparing datasets, validating coordinates, or standardizing location formats, Digipin Lookup gives you fast, accurate, spreadsheet-native tools to get the job done.

* Google services impose daily quotas and hard limitations on some features - https://developers.google.com/apps-script/guides/services/quotas

Digipin Lookup use and transfer of information received from Google APIs to any other app will adhere to Workspace API User Data and Developer Policy, including the Limited use of user data.