# Importing an excel spreadsheet into contacts **URL:** \ **Category:** Tips, Tricks & Best Practices\ **Tags:** free\ **Created:** [August 21, 2023, 8:17pm UTC](https://community.hubspot.com/t/importing-an-excel-spreadsheet-into-contacts/87974 "2023-08-21T20:17:23Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![PFord6](https://avatars.discourse-cdn.com/v4/letter/p/43a26b/32.png) [@PFord6](https://community.hubspot.com/u/PFord6)\ **Post date:** [August 21, 2023, 8:17pm UTC](https://community.hubspot.com/t/importing-an-excel-spreadsheet-into-contacts/87974/1 "2023-08-21T20:17:23Z")
Hello! I am trying to upload an excel spreadsheet into Hubspot’s contacts and when I get to “MAP” I correct the columns and won’t let me move past the MAP category to Details. All columns are showing MAPPED. Any suggestions. ---
**Author:** ![franksteiner79](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/franksteiner79/32/34443_2.png) [@franksteiner79](https://community.hubspot.com/u/franksteiner79)\ **Post date:** [August 22, 2023, 4:19am UTC](https://community.hubspot.com/t/importing-an-excel-spreadsheet-into-contacts/87974/2 "2023-08-22T04:19:48Z")
Hi @PFord6 Could you share a screenshot of what you are seeing? If all columns are mappedmyou should be able to move to the next step, which is at the bottom right of the import screen. What object types are you importing? What does does it say above the mapping table - if for example you selected update and create records but don’t have the necessary unique identifier in your import file, this will keep you from continuing as HubSpot will be unable to deduplicate the import. I hope that helps. Frank ---
**Author:** ![PFord6](https://avatars.discourse-cdn.com/v4/letter/p/43a26b/32.png) [@PFord6](https://community.hubspot.com/u/PFord6)\ **Post date:** [August 22, 2023, 12:51pm UTC](https://community.hubspot.com/t/importing-an-excel-spreadsheet-into-contacts/87974/3 "2023-08-22T12:51:52Z")
Hi Frank! Thank you so much for the reply. I attached the screen shot (on the left-I have 2 screens) so everything is sayng “mapped” and the bottom right is a “next” button but it is not able to be selected. ![PFord6_0-1692708576390.jpg](https://d2qpr2jzcazej7.cloudfront.net/original/3X/3/d/3ded0d65b2d27be36cbe673bf2ba71838d73ecc5.jpeg) ---
**Author:** ![franksteiner79](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/franksteiner79/32/34443_2.png) [@franksteiner79](https://community.hubspot.com/u/franksteiner79)\ **Post date:** [August 22, 2023, 1:04pm UTC](https://community.hubspot.com/t/importing-an-excel-spreadsheet-into-contacts/87974/4 "2023-08-22T13:04:40Z")
Hi @PFord6 Thanks, can you answer the other questions: - What object types are you importing? - How are you importing - update and create record, create only, etc.? - What does it say above the mapping table? It usually tells you if necessary unique identifiers are missing. Thanks Frank ---
**Author:** ![PFord6](https://avatars.discourse-cdn.com/v4/letter/p/43a26b/32.png) [@PFord6](https://community.hubspot.com/u/PFord6)\ **Post date:** [August 22, 2023, 1:45pm UTC](https://community.hubspot.com/t/importing-an-excel-spreadsheet-into-contacts/87974/5 "2023-08-22T13:45:53Z")
Hi Frank, I am importing a very simple excel file that is a mailing list. Create and update contacts. Above the mapping table it says “Contacts can’t be imported. Required properties not mapped” but when I fix it, now “Mapped” is checked under every category and “Next” is still not illuminated to move to the next screen. ---
**Author:** ![franksteiner79](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/franksteiner79/32/34443_2.png) [@franksteiner79](https://community.hubspot.com/u/franksteiner79)\ **Post date:** [August 22, 2023, 1:51pm UTC](https://community.hubspot.com/t/importing-an-excel-spreadsheet-into-contacts/87974/6 "2023-08-22T13:51:12Z")
One thing I am not seeing in the screenshot is either an email or record-id. If you want to create and update records either of those is needed in order for HubSpot to deduplicate records. Sounds like to me like this might be the reason… ---
**Author:** ![PFord6](https://avatars.discourse-cdn.com/v4/letter/p/43a26b/32.png) [@PFord6](https://community.hubspot.com/u/PFord6)\ **Post date:** [August 22, 2023, 1:53pm UTC](https://community.hubspot.com/t/importing-an-excel-spreadsheet-into-contacts/87974/7 "2023-08-22T13:53:11Z")
That may be it. This is a new platform for me so perhaps I’ll enter my email to be able to load it and change it as I get it. Thank you for your time. ---
**Author:** ![PFord6](https://avatars.discourse-cdn.com/v4/letter/p/43a26b/32.png) [@PFord6](https://community.hubspot.com/u/PFord6)\ **Post date:** [August 22, 2023, 2:04pm UTC](https://community.hubspot.com/t/importing-an-excel-spreadsheet-into-contacts/87974/8 "2023-08-22T14:04:17Z")
Frank! That is exactly what it was! Thank you! ---
**Author:** ![victoriahcw](https://avatars.discourse-cdn.com/v4/letter/v/3ab097/32.png) [@victoriahcw](https://community.hubspot.com/u/victoriahcw)\ **Post date:** [April 3, 2025, 9:17pm UTC](https://community.hubspot.com/t/importing-an-excel-spreadsheet-into-contacts/87974/9 "2025-04-03T21:17:16Z")
For updating the contacts, you can also look into using other tools to export data from your Excel file. I’ve been using one called [Coefficient](https://app.hubspot.com/ecosystem/7039851/marketplace/apps/coefficient) and one of their features allows you to export live data from Excel directly into HubSpot. It’s been great because this tool is quite easy to use and allows you to manually select the mapping of your headers. So for instance, if your header names don’t match exactly in HubSpot, you can still perform a successful export. ---
**Author:** ![AlbertBer](https://avatars.discourse-cdn.com/v4/letter/a/a587f6/32.png) [@AlbertBer](https://community.hubspot.com/u/AlbertBer)\ **Post date:** [May 22, 2025, 1:22pm UTC](https://community.hubspot.com/t/importing-an-excel-spreadsheet-into-contacts/87974/10 "2025-05-22T13:22:13Z")
Sometimes that happens if there’s an issue with hidden characters or blank column headers in the Excel file. Try saving it as a clean CSV and re-uploading. If you’re doing this regularly, [Skyvia](https://skyvia.com/data-integration/integrate-hubspot-excel) can handle the import with more flexibility and fewer formatting hiccups.