# Emails from excel importation **URL:** \ **Category:** Tips, Tricks & Best Practices\ **Created:** [February 19, 2022, 2:37pm UTC](https://community.hubspot.com/t/emails-from-excel-importation/51865 "2022-02-19T14:37:37Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![IGeogiadis](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/igeogiadis/32/193573_2.png) [@IGeogiadis](https://community.hubspot.com/u/IGeogiadis)\ **Post date:** [February 19, 2022, 2:37pm UTC](https://community.hubspot.com/t/emails-from-excel-importation/51865/1 "2022-02-19T14:37:37Z")
Good evening to the community! We are new HubSpot users. As far I understand, upon importation, HubSpot cannot import multiple emails from1 excel cell. How should we manage this matter? In addition, is it possible to store multiple emails for a company record? Looking forward to your valuable feedback. Kind regards, Ioannis G. ---
**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\ **Post date:** [February 19, 2022, 2:57pm UTC](https://community.hubspot.com/t/emails-from-excel-importation/51865/2 "2022-02-19T14:57:19Z")
Hi @IGeogiadis, That is correct. The email column must include one email only. One row = one email address = one row. One way to update your Excel file accordingly is by using the [text to columns feature](https://support.microsoft.com/en-us/office/split-text-into-different-columns-with-the-convert-text-to-columns-wizard-30b14928-5550-41f5-97ca-7a3e9c363ed7). You’ll have to then copy those new rows in the correct place and clean up your file a bit. And yes, company records can be associated with multiple contact records ( = emails). However, company records themselves do not have a default field for email address. This would be only via association. If you want to import a file and create both contacts and companies, you can find instructions here: [Import and associate multiple objects](https://knowledge.hubspot.com/crm-setup/import-and-associate-multiple-objects) This page also has some [sample / example files](https://knowledge.hubspot.com/crm-setup/set-up-your-import-file#sample-import-files). If you’re unsure what you’re doing, I’d recommend testing the import in a [developer account](https://developers.hubspot.com/get-started) first (choose “An app” on the page). Imports with incorrect associations cannot be reversedf. Let me know if you have any follow-up questions! ---
**Author:** ![IGeogiadis](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/igeogiadis/32/193573_2.png) [@IGeogiadis](https://community.hubspot.com/u/IGeogiadis)\ **Post date:** [February 20, 2022, 6:22pm UTC](https://community.hubspot.com/t/emails-from-excel-importation/51865/3 "2022-02-20T18:22:26Z")
Good evening from Greece, Many thanks for this kind and prompt correspondence. Your guidance indeed is a useful solution. Though our problem is a little bit more complicated or at least we believe so. So in our excel sheet, the column with emails (especially for company records) might have multiple emails (1-30 emails, separated with spaces or commas). Then there are more information columns on the left/right side as well as above/below. So how could we use the \*Convert Text to Columns Wizard\* without overriding the information around the email column? Looking forward to your valuable feedback and insights. Kind regards, ---
**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\ **Post date:** [February 21, 2022, 5:03am UTC](https://community.hubspot.com/t/emails-from-excel-importation/51865/4 "2022-02-21T05:03:13Z")
Hi @IGeogiadis, To make sure you’re not overwriting information, you would simply add empty columns to the right (as many as needed) before using the text to columns option. Best regards!