If your exported APN numbers look incomplete (for example, missing zeros at the beginning), donāt worry ā this isnāt a bug. Itās a formatting issue caused by Google Sheets automatically converting numbers when you open your export file.
Follow these simple steps to make sure your APN numbers appear correctly:
šŖ Step-by-Step Guide
Open a new blank spreadsheet in Google Sheets.
Click File ā Import ā Upload.
Choose the file you exported from Land Insights.
In the Import settings window:
Uncheck the box labeled āConvert text to numbers, dates, and formulas.ā
ā ļø This step is very important ā leaving it checked is what causes the missing or shortened APN numbers.
Click Import Data.
Once your file loads, your APN numbers will now appear complete and correctly formatted (including leading zeros).
š§ Why This Happens
Google Sheets automatically tries to āsimplifyā numbers by removing what it thinks are unnecessary zeros. APN numbers are identifiers, not mathematical values ā so when Sheets converts them, it ends up cutting off digits.
By unchecking that box, youāre telling Google Sheets to treat the APNs as text, preserving the full value exactly as exported from Land Insights.
ā Example
Setting | Result |
Box checked |
|
Box unchecked |
|
If youād like to see the full walkthrough, check out this quick video tutorial:
š„ Watch on Loom
You may also find this interesting ā
āStill need help?
Reach out to us at [email protected], and weāll make sure your export opens correctly.
ā
ā
