How to prepare a contact list for a CRM import
How do I import a contact list into HubSpot, Salesforce or Pipedrive?
Open the CRM Import Formatter, pick HubSpot, Salesforce or Pipedrive and drop your CSV or Excel list. It guesses which column fills each CRM field from your headers; change any guess with its dropdown, check the preview and click Export File, then import that CSV on your CRM's own import screen. Free, unlimited, no signup.
Real screen recording of CRM Import Formatter, signed out, 11 November 2026, with captions added. Waits sped up. With a voiceover; the captions show every step, so it works muted.
Step by step
- 1
Drop your list
Drag a CSV or Excel (.xlsx) file onto the drop zone, or tap Select File. It is read in your browser; nothing is uploaded.
- 2
Pick your CRM
Under Supported CRMs, choose HubSpot, Salesforce or Pipedrive. The file is written with that CRM's own import headers.
- 3
Check the column mapping
Map Your Columns shows each CRM field with the column guessed for it and an example value from your first row. Change any guess with its dropdown; Auto Map Fields puts the guesses back. A * marks a field the CRM requires.
- 4
Preview the rows
Data Preview shows the first rows under the CRM's headers. If rows are missing a field the CRM requires, such as Salesforce's Last Name and Company, it says how many before you download.
- 5
Export and import
Click Export File under Export Options, then import the CSV in your CRM: from Contacts in HubSpot, with the Data Import Wizard in Salesforce, or with Pipedrive's spreadsheet import.
Questions
Which CRMs does it format for?
HubSpot, Salesforce and Pipedrive. Each row becomes a HubSpot contact, a Salesforce lead or a Pipedrive person, under the headers that CRM's importer looks for.
Why does it split or join names?
HubSpot and Salesforce keep first and last names in separate fields, so a full-name column is split. Pipedrive takes one name per person, so separate first and last name columns are joined.
Does it remove duplicates or fix phone numbers?
No. It moves your data into the right columns as it is. Run the list through the free Contact List Cleaner first, then format the clean file here.
Is my file uploaded?
No. Your browser reads the file and writes the new one on your own device; nothing is sent to LeadQuasar or to the CRM. Free, unlimited, no signup.
Put it to work
- CRM Import FormatterAny contact list as a HubSpot, Salesforce or Pipedrive file.
- Contact List CleanerRemove duplicates and tidy emails and phones first.
- LeadQuasar CRMA free CRM on every plan, with the leads built in.
More tutorials: How to find leads · How to unlock and save a lead list · How to use LeadQuasar AI · How to do keyword research · How to use QuasarScout · How to check an email before sending · How to find a company's email format · How to audit a prospect's website · How to look up a company · How to calculate your market size · How to write a cold email sequence · How to define your ICP with AI · How to write a cold call script · How to extract email addresses · How to clean up a contact list · How to convert CSV contacts to vCard · How to make an invoice · How to write a quote · How to score a lead from its website · How to use the CRM · How to send a quote and invoice it · How to invoice a won deal · How to automate follow-ups · How to write an email sequence · How to set up a lead alert · How to audit a site in the app · How to track your rankings · How to save and export a lead list · How to find leads with the AI · How to research keywords in the app · How to plan with QuasarScout · How to create an API key · How to connect Gmail · How to connect HubSpot · How to connect Pipedrive · How to connect Zapier · How to connect Make · How to connect n8n · How to connect Slack
CRM Import Formatter
Try it on your own market
Free to search and count. 50 free unlocks a day with an account, no card needed.