Tutorial · CRM Import Formatter

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.

13.1 million+ verified businesses

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.

In CRM Import Formatter

Step by step

  1. 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. 2

    Pick your CRM

    Under Supported CRMs, choose HubSpot, Salesforce or Pipedrive. The file is written with that CRM's own import headers.

  3. 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. 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. 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.

Format a list free

What happens in the video

  1. 0:00

    “My CRM import keeps FAILING”

  2. 0:03

    Drop in your contact list

  3. 0:07

    Pick your CRM

  4. 0:09

    Check the columns it matched

  5. 0:11

    Your list under Salesforce's headers

  6. 0:13

    Export the import file

  7. 0:15

    CRM-ready files free: leadquasar.com/tools/crm-import-formatter

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.

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.

Format a list free