Hi Everyone!
We wanted to send out a helpful guide regarding some recent confusion around Assessor Parcel Number (APN) formatting. Our hope is that this post can assist anyone that runs into the extremely common issue of APNs showing up looking incorrect, missing digits, or showing up in scientific notation.
For background, all property data, including the APNs, comes directly from DataTree. DataTree gets their data either directly from the County Assessor's Office, or from an upstream data source (i.e CoreLogic, Black Knight, etc). When we pull the data from them, we do not modify or manipulate the APNs in any way. We take all of this data, price it, organize it, and deliver it to you in a group of CSV files.
Where things become tricky is when these CSV files are opened in Microsoft Excel. Excel is designed to auto-format certain cells to create ease of use. In the case of these APNs, however, this can cause a bit of a headache for land investors. There are two primary cases we have seen that should be noted:
APN being formatted into scientific notation. Excel has a limit of 15 numbers for any cell, so any APN that extends beyond this will be formatted into scientific notation. We have put together a video on how to fix this HERE.
APNs with decimals being rounded or truncated. This one is a bit trickier, as there is not a perfect answer. The best solution we have found can be followed HERE.
We want to mention that the APNs in the original CSV file are always the correct number, regardless of how Excel formats them for viewing. You can confirm this by either opening the file in another program (Numbers for Mac, Google Sheets, Text Editor, etc), or if you are in Excel, when you select a cell, view the formula bar. The full and correct number will always be present there.
Finally, we also want to shed some light on what happens when you save the CSV file in Excel. Excel will take all of the displayed values within each cell (i.e the ones that are being formatted) and save those back to the CSV file. What this means is that your original APN will be lost and replaced with an invalid number if you do not manage the formatting correctly. Once this happens, you will need to refer back to the original CSV file we sent you to obtain the correct APN. This is why it's extremely important that the auto-formatting rules are understood and managed correctly!
We hope that by informing our community of this happening we can all be more diligent about managing our data and help ease any stress around incorrect information. As always, please reach out if you have any questions!