How to Map Two Columns in CSV file to One Field in HubSpot?

Published 26 November 2018


When importing data from CSV file, you may wish to merge columns together before adding the data into your HubSpot account. Using a simple formula, you can merge the data before you upload your CSV file to import.

1. Open your CSV file, and locate the columns to be merged

2. Use the "concatenate" formula to merge the column data

3. Upload your updated CSV file to Import2 Wizard

4. Perform the import into HubSpot

Automate your data import tasks
Use Auto-import to perform regular data uploads into your business apps. Learn more
Your familiar CSV import, but better
Import2 Wizard helps you bring the data you want into the tools you use - whether it be contacts, accounts, deals, tickets, customers, emails, tasks, notes and more. Learn more
Business Data Glossary
We know that talking about data could be confusing. Here is a list of terms for you to get up to speed. Learn more