---
title: "Free CRM Field Mapping Template (CSV) | FlitStack AI"
description: "Field-by-field mapping for 148 migration pairs, from Salesforce to HubSpot and more. View it, download the CSV, or start from a blank template."
url: "https://flitstack.ai/tools/field-mapping-template"
---

# Free CRM field mapping template

Pick the system you're leaving, then the one you're moving to. You get the researched field mapping for that pair, ready to download and adapt.

In short

A field mapping template lists each source field, where it lands in the new system and how the value changes. This tool has researched mappings for 148 migration pairs, downloadable as CSV, plus a blank template for any other pair. Free, no signup.

![](https://flitstack.ai/images/authors/aditya-kumar.webp)By [Aditya Kumar](https://flitstack.ai/about/aditya-kumar)

[Have us map it for you ](https://flitstack.ai/contact) [Open the template →](https://flitstack.ai/tools/field-mapping-template#mapping)

******What the template covers 5

- Source object and field
- Destination object and field
- Mapping type for each field
- Transformation rules
- Notes on picklists and owners

## Choose your migration

**Salesforce to HubSpot** · 48 fields mapped

| Source field                   | Destination field                        | Mapping               | Note                                                                                                                                      |
| ------------------------------ | ---------------------------------------- | --------------------- | ----------------------------------------------------------------------------------------------------------------------------------------- |
| `Lead.FirstName`               | `Contact.firstname`                      | direct                |                                                                                                                                           |
| `Lead.LastName`                | `Contact.lastname`                       | direct                |                                                                                                                                           |
| `Lead.Email`                   | `Contact.email`                          | direct                |                                                                                                                                           |
| `Lead.Phone`                   | `Contact.phone`                          | direct                |                                                                                                                                           |
| `Lead.MobilePhone`             | `Contact.mobilephone`                    | direct                |                                                                                                                                           |
| `Lead.Title`                   | `Contact.jobtitle`                       | direct                |                                                                                                                                           |
| `Lead.Company`                 | `Contact.associatedcompanyid`            | transformed           | Lead.Company creates or links to a HubSpot Company record; association is set on the Contact after the Company exists.                    |
| `Lead.Status`                  | `Contact.sf_lead_status__c`              | custom field required | HubSpot has no Status field on Contact; we create a custom property to preserve the original Salesforce Lead Status value.                |
| `Lead.LeadSource`              | `Contact.hs_analytics_source`            | value mapping         | Salesforce LeadSource pick-list maps to HubSpot's contact source property; unmapped values default to 'Other'.                            |
| `Lead.IsConverted`             | `Contact.sf_was_converted_lead__c`       | custom field required | HubSpot stores a boolean flag indicating the record was a converted Salesforce Lead.                                                      |
| `Lead.CreatedDate`             | `Contact.original_create_date__c`        | custom field required | HubSpot's createdate is set at import time; original Salesforce CreatedDate preserved as a custom datetime property.                      |
| `Lead.Id`                      | `Contact.source_system_id__c`            | custom field required | Salesforce Lead ID stored on the HubSpot contact for traceability and delta-run de-duplication.                                           |
| `Contact.FirstName`            | `Contact.firstname`                      | direct                |                                                                                                                                           |
| `Contact.LastName`             | `Contact.lastname`                       | direct                |                                                                                                                                           |
| `Contact.Email`                | `Contact.email`                          | direct                |                                                                                                                                           |
| `Contact.Phone`                | `Contact.phone`                          | direct                |                                                                                                                                           |
| `Contact.MobilePhone`          | `Contact.mobilephone`                    | direct                |                                                                                                                                           |
| `Contact.Title`                | `Contact.jobtitle`                       | direct                |                                                                                                                                           |
| `Contact.AccountId`            | `Contact.associatedcompanyid`            | transformed           | Salesforce AccountId resolves to a HubSpot Company ID; the Company must be migrated before the Contact.                                   |
| `Contact.Birthdate`            | `Contact.date_of_birth__c`               | custom field required | Birthdate is not a native HubSpot property; migrated as a custom date property.                                                           |
| `Contact.CreatedDate`          | `Contact.original_create_date__c`        | custom field required | Original Salesforce CreatedDate preserved as a custom datetime for reporting continuity.                                                  |
| `Contact.LastModifiedDate`     | `Contact.original_last_modified_date__c` | custom field required | Original Salesforce LastModifiedDate preserved as a custom datetime for delta-tracking.                                                   |
| `Contact.Id`                   | `Contact.source_system_id__c`            | custom field required | Salesforce Contact ID stored on the HubSpot contact for traceability and delta-run de-duplication.                                        |
| `Account.Name`                 | `Company.name`                           | direct                |                                                                                                                                           |
| `Account.Website`              | `Company.domain`                         | direct                |                                                                                                                                           |
| `Account.Industry`             | `Company.industry`                       | value mapping         | Salesforce Industry pick-list values mapped to HubSpot industry options; unmapped values mapped to 'Other'.                               |
| `Account.NumberOfEmployees`    | `Company.numberofemployees`              | direct                |                                                                                                                                           |
| `Account.AnnualRevenue`        | `Company.annualrevenue`                  | direct                |                                                                                                                                           |
| `Account.BillingStreet`        | `Company.address`                        | direct                |                                                                                                                                           |
| `Account.BillingCity`          | `Company.city`                           | direct                |                                                                                                                                           |
| `Account.BillingState`         | `Company.state`                          | direct                |                                                                                                                                           |
| `Account.BillingPostalCode`    | `Company.zip`                            | direct                |                                                                                                                                           |
| `Account.BillingCountry`       | `Company.country`                        | direct                |                                                                                                                                           |
| `Account.ParentId`             | `Company.parent_company_id__c`           | custom field required | HubSpot does not have a native parent-company lookup; we create a custom property linking to the parent Company record.                   |
| `Account.Type`                 | `Company.company_type__c`                | value mapping         | Salesforce Account Type values (Customer, Prospect, Partner) mapped to a HubSpot custom pick-list.                                        |
| `Account.Id`                   | `Company.source_system_id__c`            | custom field required | Salesforce Account ID stored on the HubSpot company for traceability and delta-run de-duplication.                                        |
| `Opportunity.Name`             | `Deal.dealname`                          | direct                |                                                                                                                                           |
| `Opportunity.Amount`           | `Deal.amount`                            | direct                |                                                                                                                                           |
| `Opportunity.StageName`        | `Deal.dealstage`                         | value mapping         | Salesforce StageName values map to HubSpot pipeline stage IDs; each pipeline has its own stage set derived from a Salesforce record type. |
| `Opportunity.CloseDate`        | `Deal.closedate`                         | direct                |                                                                                                                                           |
| `Opportunity.RecordTypeId`     | `Deal.pipeline`                          | transformed           | Salesforce RecordTypeId determines which HubSpot pipeline the deal enters; each record type maps to one HubSpot pipeline.                 |
| `Opportunity.Probability`      | `Deal.sf_probability__c`                 | custom field required | HubSpot does not have a probability field; the original Salesforce probability is stored as a custom number property on the deal.         |
| `Opportunity.ForecastCategory` | `Deal.forecast_category__c`              | custom field required | Salesforce forecast category (Commit, Best Case, Omitted) migrates as a custom pick-list on the HubSpot deal.                             |
| `Opportunity.OwnerId`          | `Deal.hubspot_owner_id`                  | transformed           | Owner resolved by email match to HubSpot users; unmatched owners flagged before migration runs.                                           |
| `Opportunity.AccountId`        | `Deal.associatedcompanyid`               | transformed           | Salesforce AccountId resolves to a HubSpot Company ID; the Company must be migrated before the Deal.                                      |
| `Opportunity.LeadSource`       | `Deal.hs_analytics_source`               | value mapping         | Salesforce LeadSource pick-list maps to HubSpot deal source property.                                                                     |
| `Opportunity.Type`             | `Deal.deal_type__c`                      | custom field required | Salesforce Opportunity Type (New Business, Upsell, Renewal) migrates as a custom pick-list on the HubSpot deal.                           |
| `Opportunity.Id`               | `Deal.source_system_id__c`               | custom field required | Salesforce Opportunity ID stored on the HubSpot deal for traceability and delta-run de-duplication.                                       |

Moving between systems that aren't listed? Start from the [blank field mapping template (CSV)](https://flitstack.ai/tools/field-mapping-template.csv): the same columns plus data type, owner and status for tracking review.

## How to use it

1. ### Start from your pair

   Download the mapping for your source and destination, or the blank template.

2. ### Add your custom fields

   Export your source schema and add every custom field and picklist the template doesn't list.

3. ### Decide every transform

   Picklist values, owners, dates and record IDs need a rule each. Write it in the note column.

4. ### Test on a sample

   Migrate a few hundred real records and check them in the new system before the full run.

## Mapping types

|                   |                                                               |
| ----------------- | ------------------------------------------------------------- |
| **Direct**        | Copied as is; same type on both sides.                        |
| **Transform**     | Changed on the way: split, joined, reformatted or converted.  |
| **Value mapping** | Picklist or stage values matched one by one.                  |
| **Lookup**        | A reference to another record, rebuilt as an association.     |
| **Custom field**  | No standard field exists; a custom property is created first. |

Questions, answered

## Field mapping questions

What is a field mapping template?

A spreadsheet that lists every field in the system you are leaving, the field it lands in on the new system, and how the value changes on the way: copied as is, transformed, looked up or dropped. It is the plan every CRM migration runs from.

Which columns should a CRM field mapping have?

Source object and field, destination object and field, mapping type (direct, transform, lookup, value mapping), the transformation rule, and a note for anything that needs a decision, such as picklist values, owners and record IDs.

Is this mapping complete for my account?

It covers the standard and most-used fields for each pair. Your custom fields and picklist values come from your own schema; we add those during scoping, or you can add them to the template yourself.

Is the template free?

Yes. No signup; the mapping and the CSV download are free to use for your own migration.

Get a quote

## Want the mapping done for you?

We map every field, custom objects included, run a sample you approve, then migrate with one-click rollback.

[Get a quote](https://flitstack.ai/contact)
