Import CSV files to create datasets (BETA)
Last updated: July 11, 2024
Available with any of the following subscriptions, except where noted:
|
Import CSV files to create a dataset. A dataset can be created with the CSV file as the data source or can be added to any HubSpot object or event data.
Before you import
- You must have Import permissions.
- Set up your import files and confirm you have all the required fields. Properly setting up your files helps you avoid import errors. You can refer to sample import files to help you get started.
Set up your import file
The import file must:
- Be a .csv file.
- Have one sheet only.
- Include a header row in which each column header represents a column in the dataset. The column headers can be organized in any order without affecting the import. To join your CSV data to a HubSpot object or event, one of the columns in the file must match a HubSpot property for the object or event you want to join your data with.
- Contain less than 100 columns.
- Be UTF-8 encoded if foreign language characters are included.
- Contain cells in number format when importing date-time properties.
- Ensure all cell values containing commas are enclosed in quotes.
- Only contain currency data formatted for USD using decimals (for example 123.45).
There are additional technical limits for the import tool depending on your HubSpot subscription. These limits include the size and row limits of an import file, as well as how many files and rows you can import per day.
- Import files up to 512 MB.
- Import up to 10,000,000 rows per day, with a limit of 1,048,576 rows per file.
- These limits apply to a rolling 24-hour period and don't reset at a specific time of day.
Import a CSV file as a data source
- In your HubSpot account, navigate to Reporting & Data > Datasets.
- Navigate to the CSV data sources tab.
- Click Upload CSV.
![upload-csv-dataset](https://knowledge.hubspot.com/hs-fs/hubfs/Knowledge_Base_2023_2024/upload-csv-dataset.png?width=1004&height=470&name=upload-csv-dataset.png)
- Select a CSV file. Then, click the dropdown menu and select a language.
- Click Next.
- Click the Data type dropdown menu and select the data type for each of the column headers. Data types include: boolean, text, date, datetime, number.
- If you don't want to import a column, click the Import as dropdown menu and select Don't import column.
- Click Next.
- Enter an Import name.
- Click Finish import.
Please note: uploaded CSV files will be available to all dataset users in the account.
Use the imported CSV file in the dataset builder
- In your HubSpot account, navigate to Reporting & Data > Datasets.
- Navigate to the CSV data sources tab.
- Hover over the name of the dataset upload and click Use in dataset builder.
![use-in-dataset-builder](https://knowledge.hubspot.com/hs-fs/hubfs/Knowledge_Base_2023_2024/use-in-dataset-builder.png?width=591&height=247&name=use-in-dataset-builder.png)
- Select CSV in the Primary data sources dropdown menu. Or, to use the CSV file as a secondary data source, under Other select CSV. The CSV data source can be used by itself to create a dataset or can be joined with other data sources.
- In the right panel, select your CSV file. Only one CSV file can be selected as a data source.
- If you are using more than one data source, select how to join your CSV data source to your HubSpot data. A column in your CSV file should map to a property on your selected HubSpot object. For example, select a unique identifier to link both data sources. A unique identifier could be a contact's email address because it is unique to them.
![select-key-join](https://knowledge.hubspot.com/hs-fs/hubfs/Knowledge_Base_2023_2024/select-key-join.png?width=508&height=432&name=select-key-join.png)
Please note: it isn't possible to join multiple CSV data sources.
Data Management
Thank you for your feedback, it means a lot to us.
This form is used for documentation feedback only. Learn how to get help with HubSpot.