--- title: Understanding APN mapping when importing properties into Invelo description: Ensuring your APNs match Invelo’s database to maintain clean and accurate imports --- [Skip to content](https://helpdesk.inveloapp.com/understanding-apn-mapping-when-importing-properties-into-invelo#main-content) English Show submenu for translations ![Invelo square logo-1.png\]](https://helpdesk.inveloapp.com/hs-fs/hubfs/Invelo%20square%20logo-1.png?height=40&name=Invelo%20square%20logo-1.png) Open main navigation Close main navigation - English Show submenu for translations - [Visit inveloapp.com](https://inveloapp.com/) [Visit inveloapp.com](https://inveloapp.com/) Advice and answers from the Invelo Team - There are no suggestions because the search field is empty. 1. [Invelo's Help Desk](https://helpdesk.inveloapp.com/?hsLang=en) 2. [CRM](https://helpdesk.inveloapp.com/crm?hsLang=en) 3. [Importing & Exporting](https://helpdesk.inveloapp.com/crm?hsLang=en#importing-exporting) # Understanding APN mapping when importing properties into Invelo ## Ensuring your APNs match Invelo’s database to maintain clean and accurate imports When importing property records into Invelo, ensuring that the APN (Assessor’s Parcel Number) is correctly mapped and formatted is crucial for maintaining accurate and clean data within your account. ### What is APN Mapping? **APN** stands for **Assessor’s Parcel Number**, a unique identifier assigned to parcels of real estate by the local county assessor’s office. In Invelo, we use the APN (along with the state and county) as a key identifier to match imported properties with existing property records in our nationwide database. ### What Happens If the APN Doesn’t Match? If the APN in your imported file does not exactly match the APN format in Invelo’s property database (based on the state and county provided), Invelo will treat it as a brand-new property, even if it already exists in our system. This can lead to duplicate or separate property records being created. ### Common Causes of APN Mismatches: - Extra dashes, spaces, or formatting differences (e.g., `123-456-789` vs `123456789`) - Leading zeros being removed (e.g., `00123456` becomes `123456`) - Missing or incorrect county/state information - Use of local formatting that differs from official assessor formatting ### Best Practices for Accurate APN Matching: 1. **Map the APN Field Properly During Import** When uploading your file, make sure the column containing the APN is correctly mapped to the **“APN”** field in Invelo. 2. **Use Official APN Format** Ensure the APN in your file matches the official county format. You can usually verify this through the local assessor's website or by checking against known property records in Invelo. 3. **Include State and County** To improve matching accuracy, make sure your file includes the correct **State** and **County** columns mapped during import. 4. **Avoid Reformatting the APN** Try not to modify APNs by trimming leading zeros, adding dashes, or converting number formats (e.g., don’t let Excel auto-convert it into scientific notation). ### What to Do If a Property Was Imported with the Wrong APN If you suspect a property was duplicated or created separately due to an APN mismatch: 1. **Check the Property Details Page** Open the property record in Invelo and review theProperty Details section. - If this section is blank or missing key information, it likely means the APN did not match what’s in Invelo’s national property database. 2. **Use the Correct APN or Full Address for Re-import** You have two options: - Delete the incorrect property record and re-upload it with the correct APN. - Or, instead of relying on APN, you can import using the full property address (street, city, state, and zip code) to match against Invelo’s database. Unfortunately, Invelo does not currently support merging property records, so cleaning up mismatched imports manually is the best way to maintain a clean database. If you're unsure which record is correct, feel free to reach out to our support team — we're happy to help verify it with you! - [Getting Started](https://helpdesk.inveloapp.com/getting-started?hsLang=en#main-content) - [Welcome Series](https://helpdesk.inveloapp.com/getting-started?hsLang=en#welcome-series) - [Onboarding & White Glove Migration](https://helpdesk.inveloapp.com/getting-started?hsLang=en#onboarding-white-glove-migration) - [CRM Migration Guides to Invelo](https://helpdesk.inveloapp.com/getting-started?hsLang=en#crm-migration-guides-to-invelo) - [Autopilot](https://helpdesk.inveloapp.com/autopilot?hsLang=en) - [List Builder](https://helpdesk.inveloapp.com/list-builder?hsLang=en#main-content) - [List Builder Location Search](https://helpdesk.inveloapp.com/list-builder?hsLang=en#list-builder-location-search) - [List Builder Filters](https://helpdesk.inveloapp.com/list-builder?hsLang=en#list-builder-filters) - [List Builder Results](https://helpdesk.inveloapp.com/list-builder?hsLang=en#list-builder-results) - [List Builder Overview](https://helpdesk.inveloapp.com/list-builder?hsLang=en#list-builder-overview) - [List Builder Next Steps](https://helpdesk.inveloapp.com/list-builder?hsLang=en#list-builder-next-steps) - [Inbox](https://helpdesk.inveloapp.com/inbox?hsLang=en) - [CRM](https://helpdesk.inveloapp.com/crm?hsLang=en#main-content) - [Prospects](https://helpdesk.inveloapp.com/crm?hsLang=en#prospects) - [Leads](https://helpdesk.inveloapp.com/crm?hsLang=en#leads) - [Deals](https://helpdesk.inveloapp.com/crm?hsLang=en#deals) - [Contacts](https://helpdesk.inveloapp.com/crm?hsLang=en#contacts) - [Property & Contact Records](https://helpdesk.inveloapp.com/crm?hsLang=en#property-contact-records) - [Importing & Exporting](https://helpdesk.inveloapp.com/crm?hsLang=en#importing-exporting) - [Skip Tracing](https://helpdesk.inveloapp.com/crm?hsLang=en#skip-tracing) - [Calling](https://helpdesk.inveloapp.com/crm?hsLang=en#calling) - [AI Driving for Dollars](https://helpdesk.inveloapp.com/crm?hsLang=en#ai-driving-for-dollars) - [Filters](https://helpdesk.inveloapp.com/crm?hsLang=en#filters) - [Marketing](https://helpdesk.inveloapp.com/marketing?hsLang=en#main-content) - [Campaign Preparation](https://helpdesk.inveloapp.com/marketing?hsLang=en#campaign-preparation) - [Create a Campaign](https://helpdesk.inveloapp.com/marketing?hsLang=en#create-a-campaign) - [Marketing Templates](https://helpdesk.inveloapp.com/marketing?hsLang=en#marketing-templates) - [Create Campaign: Sequences](https://helpdesk.inveloapp.com/marketing?hsLang=en#create-campaign-sequences) - [Marketing campaign monitoring](https://helpdesk.inveloapp.com/marketing?hsLang=en#marketing-campaign-monitoring) - [Marketing Used Cases](https://helpdesk.inveloapp.com/marketing?hsLang=en#marketing-used-cases) - [Workflows & Automations](https://helpdesk.inveloapp.com/workflows-automations?hsLang=en#main-content) - [Actions: CRM](https://helpdesk.inveloapp.com/workflows-automations?hsLang=en#actions-crm) - [Actions: Outreach](https://helpdesk.inveloapp.com/workflows-automations?hsLang=en#actions-outreach) - [Analytics](https://helpdesk.inveloapp.com/analytics?hsLang=en#main-content) - [Prospecting Analytics](https://helpdesk.inveloapp.com/analytics?hsLang=en#prospecting-analytics) - [Marketing Analytics](https://helpdesk.inveloapp.com/analytics?hsLang=en#marketing-analytics) - [Lead Analytics](https://helpdesk.inveloapp.com/analytics?hsLang=en#lead-analytics) - [Deal Analytics](https://helpdesk.inveloapp.com/analytics?hsLang=en#deal-analytics) - [Integrations](https://helpdesk.inveloapp.com/integrations?hsLang=en#main-content) - [smrtPhone](https://helpdesk.inveloapp.com/integrations?hsLang=en#smrtphone) - [SMTP Email Service](https://helpdesk.inveloapp.com/integrations?hsLang=en#smtp-email-service) - [Webhooks](https://helpdesk.inveloapp.com/integrations?hsLang=en#webhooks) - [Mailchimp](https://helpdesk.inveloapp.com/integrations?hsLang=en#mailchimp) - [Constant Contact](https://helpdesk.inveloapp.com/integrations?hsLang=en#constant-contact) - [Gmail](https://helpdesk.inveloapp.com/integrations?hsLang=en#gmail) - [System & Settings](https://helpdesk.inveloapp.com/system-settings?hsLang=en#main-content) - [Account Settings](https://helpdesk.inveloapp.com/system-settings?hsLang=en#account-settings) - [Billing & Plan](https://helpdesk.inveloapp.com/system-settings?hsLang=en#billing-plan) - [Users, Roles & Permissions](https://helpdesk.inveloapp.com/system-settings?hsLang=en#users-roles-permissions) - [FAQs](https://helpdesk.inveloapp.com/faqs?hsLang=en#main-content) - [About Invelo](https://helpdesk.inveloapp.com/faqs?hsLang=en#about-invelo) - [List Builder](https://helpdesk.inveloapp.com/faqs?hsLang=en#list-builder) - [Lists](https://helpdesk.inveloapp.com/faqs?hsLang=en#lists) - [Filters](https://helpdesk.inveloapp.com/faqs?hsLang=en#filters) - [Records](https://helpdesk.inveloapp.com/faqs?hsLang=en#records) - [Skip Tracing](https://helpdesk.inveloapp.com/faqs?hsLang=en#skip-tracing) - [Marketing](https://helpdesk.inveloapp.com/faqs?hsLang=en#marketing) - [Account and Access](https://helpdesk.inveloapp.com/faqs?hsLang=en#account-and-access) - [Imports and Exports](https://helpdesk.inveloapp.com/faqs?hsLang=en#imports-and-exports) - [Education](https://helpdesk.inveloapp.com/education?hsLang=en#main-content) - [Masterclasses](https://helpdesk.inveloapp.com/education?hsLang=en#masterclasses) - [Webinars](https://helpdesk.inveloapp.com/education?hsLang=en#webinars) - [Overview](https://helpdesk.inveloapp.com/overview?hsLang=en) [![Chill listening crop-3](https://helpdesk.inveloapp.com/hs-fs/hubfs/invelo_logo-color-4.png?width=93&height=24&name=invelo_logo-color-4.png "Chill listening crop-3")](https://a.inveloapp.com) Your Guide to Smarter, Faster Real Estate Success. Copyright © 2026, Invelo