Question 1

How can I import data from a spreadsheet into HubSpot CRM?

Accepted Answer

To bring your records into HubSpot, first place the information in a spreadsheet where every column represents a HubSpot property. After the file is ready, go to the main navigation, choose CRM, and open Contacts. Click Add contacts, then Import, select "Import a file," and press Start import. Upload the file, specify whether you want to create new records, update existing ones, or do both, and follow the on-screen prompts to map columns and finalize. Once you click Finish import, HubSpot will show a summary confirming that your data is now inside the CRM.

Question 2

What summary information does HubSpot display right after an import is completed?

Accepted Answer

When you press Finish import, HubSpot generates a summary page that outlines how many records were created or updated and whether any errors occurred. You can download error files to investigate issues if needed. The new records appear instantly in their respective object views, ready for use. From there you can enrich missing details, format data consistently, or trigger workflows. The summary acts as both confirmation and a quick diagnostic report.

Question 3

How can I exclude a specific spreadsheet column from being imported into HubSpot CRM?

Accepted Answer

In the mapping interface, open the Import as dropdown for that column and select Do not import column. This tells HubSpot to ignore the data entirely. Skipping irrelevant columns keeps your database uncluttered and focused on useful information. It is especially handy for temporary notes or legacy fields you no longer need. Excluding them at import time saves cleanup effort later.

Question 4

How do I import a column that does not have a corresponding property in HubSpot CRM?

Accepted Answer

When you notice a column that has no matching HubSpot property, create that property in HubSpot before starting the import. Doing so allows the data to land in the right place without errors. You can create properties for any object—contacts, companies, deals, or tickets. Once the new property exists, include its exact name in your spreadsheet header. With that step complete, the import tool will map the column automatically.

Question 5

Where is the import function located in the HubSpot CRM interface?

Accepted Answer

Open the main navigation bar and choose CRM, then click Contacts. In the upper-right corner, press Add contacts and pick Import. This sequence opens HubSpot’s import wizard. From there you can choose to import from a file, sync an existing app, or request help from a specialist. Selecting Import a file lets you proceed with the step-by-step guide.

Question 6

How should I prepare my spreadsheet before importing contacts into HubSpot CRM?

Accepted Answer

Begin by organizing your data in a single spreadsheet. Each column must correspond to one HubSpot property such as first name, last name, or company. Place the exact property names in the first row so HubSpot can match them automatically during import. If a piece of information does not yet exist as a property in HubSpot, create that property before starting the import. This upfront structure makes the entire process faster and reduces post-import cleanup.

Question 7

What final settings must be configured before completing a HubSpot import?

Accepted Answer

Before clicking Finish import, name your import so you can recognize it later in the history list. Decide whether you want HubSpot to build a list from the imported contacts automatically. You also need to pick a lawful basis for processing the data to comply with privacy regulations. Finally, specify whether the new contacts should be marked as marketing contacts. These settings ensure transparency and proper segmentation right from the start.

Question 8

How do I specify which object types are in my file when importing into HubSpot?

Accepted Answer

After selecting your file, HubSpot prompts you to specify which objects are inside it. You can choose one object, such as contacts, or several objects at once—contacts, companies, deals, or tickets. This choice tells the system how to interpret each row in the spreadsheet. Selecting accurately ensures correct property mapping and record creation. Once the objects are set, click Next to move forward.

Question 9

Why does HubSpot ask me to choose a language for column headers during import?

Accepted Answer

HubSpot asks you to choose the language of your column headers so it can interpret special characters and map properties correctly. Selecting the right language avoids encoding issues, especially for accented letters or localized property names. It also helps HubSpot display the mapping screen in the same language, making confirmation easier. Incorrect language selection can lead to misread headers and errors. A quick choice here prevents downstream problems.

Question 10

Why should spreadsheet column headers exactly match HubSpot property names during an import?

Accepted Answer

Using the exact property names in the first row lets HubSpot automatically map each spreadsheet column to the correct place in the CRM. This automatic mapping saves time and minimizes human error during the import wizard. If HubSpot instantly recognizes a column, you do not have to manually search for the right property. It also reduces the risk of data ending up in the wrong field. Overall, precise headers streamline the import and keep your database clean.

Question 11

How can I use and manage the data after it has been imported into HubSpot CRM?

Accepted Answer

With the data now stored in HubSpot, you can fill in any missing information, correct formatting inconsistencies, and set up automation. This might include nurturing email sequences, deal pipelines, or ticket routing based on the imported properties. Clean, organized data enables accurate reporting and personalized outreach. The CRM’s segmentation tools let you build targeted lists or dashboards that drive strategic decisions. Ultimately, proper data management frees you to focus on business growth.

Question 12

Does HubSpot use the same import steps for companies, deals, or tickets as for contacts?

Accepted Answer

Yes, although the example walks through importing contacts, the overall steps apply to any standard object in HubSpot. Whether you are importing companies, deals, or tickets, you still prepare a spreadsheet, select the object type, map properties, and complete the wizard. The interface prompts you to choose which objects are in the file during the setup stage. This consistency allows you to reuse the same workflow for different data sets. It helps maintain uniformity across your CRM.

Question 13

How can I update existing HubSpot records during a data import instead of creating duplicates?

Accepted Answer

Yes, HubSpot lets you decide whether to create new records, update existing ones, or perform both actions in a single import. After uploading the file, you will see options to pick the desired behavior. Choosing update will compare the spreadsheet data to existing CRM records using unique identifiers like email. This flexibility allows you to refresh information without duplicating entries. It keeps your database accurate and eliminates manual edits.

Question 14

How does HubSpot automatically map spreadsheet columns to CRM properties during an import?

Accepted Answer

When you reach the mapping step, HubSpot scans the first row of your file and tries to match each column header to an existing property. If the header text is identical to a property name, the system maps it automatically. Any unmapped columns are flagged for manual selection, ensuring nothing is overlooked. Automatic mapping accelerates the process by handling most columns for you. It also highlights mismatches so you can correct them immediately.

Question 15

What source options are available when importing data into HubSpot?

Accepted Answer

HubSpot displays three choices when you begin the import: import from a file, synchronize an external application, or ask for assistance from a specialist. The file option is ideal for spreadsheets and CSVs you already have. Synchronizing an app connects HubSpot to another platform so data moves automatically. Requesting a specialist brings in expert help for custom or complex migrations. These options let you pick the workflow that best matches your resources and technical comfort level.

Oportunidades de aprendizaje de HubSpot Academy

Toda la formación

Certificaciones

Incorporación a HubSpot Academy

Centro de éxito de HubSpot

Cómo importar tus datos de CRM a HubSpot

Descripción del video

Profesores

Juanita Moreno

¿Por qué aprender con HubSpot Academy?

Es gratis

Es personalizado

Es internacional

Compartir este video