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 formulas or the interactive sidebar.

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 into a coordinate pair.

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

Multi-row batch decode:
=DIGIPIN_DECODE(E2:E50)

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

--------------------------------------------------
SMART RANGE HANDLING
--------------------------------------------------

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 DIGIPINs 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
--------------------------------------------------

Uses a precise grid-based algorithm to compute and 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 run inside Google Sheets™ and Apps Script
- Your data never leaves your spreadsheet

--------------------------------------------------
MAKE LOCATION PROCESSING EFFORTLESS
--------------------------------------------------

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