How to Import Data into Salesforce

There might be situations, in which we need to import data to salesforce, and sometime also, we may need to upload bulk data into salesforce from CSV files. In this complete tutorial, we will discuss how to import data into salesforce with different examples.

  • How to import data into Salesforce
  • How to import data into Salesforce lightning
  • How to import data into salesforce classic
  • How to import data into salesforce from CSV
  • How to import bulk data into salesforce
  • How to mass import data into salesforce

How to import data into Salesforce

Import data is defined as that we are uploading data from any outside source and combine it with data we gather by analytics. It connects the offline data that we have passed with the default hit that is gathered by the analytics.

Import data in salesforce is defined as a tool that can import up to 50,000 records at a time. It gives a simple interface to identify the configuration parameters like data sources and field mapping. In Field mapping, we can map the field name in our import file.

We can also import data in standard objects such as Lead, Account, Contact, Accounts, etc, and we also import the data in custom objects.

Some important uses of Import Data:

  • Before importing the data we make sure that the objects we need to import are supported by the wizard.
  • The Data import wizard can upload fewer than 50,000 records at a time.
  • While importing the data we don’t need the import process to be computerized.

Now, we will see how to import data into salesforce using salesforce lightning and salesforce classic.

Read How to Create a related list in salesforce

How to import data into Salesforce lightning

Salesforce Lightning is a modern view of the salesforce platform that is fast, easy, and filled with a broad variety of options.

Here we are importing the data into the salesforce lightning, using a USA data CSV file.

Follow the below steps to import data into salesforce lightning:-

Step 1: Login to the salesforce account, Go to Setup and enter Data Import Wizard in Quick Find Box. Click on the Data Import Wizard.

How to import data into salesforce lightning
How to import data into salesforce lightning

Step 2: After clicking on Data Import Wizard, then import our data in three simple steps that mention in the below picture, and then click on the Launch button.

How to import data into salesforce
Import data into Salesforce and Launch Wizard

Step 3: After clicking on Launch wizard, then Import the data into Salesforce. Firstly select the data we want to import Like Standard Objects or Custom Objects.

Here we are choosing the Standard objects. There are lots of Standard objects and we are choosing Accounts and Contacts in between them.

How to import data into salesforce lightning experience
Import your Data into Salesforce

Step 4: After Choosing the objects, Next Add new records and then choose the CSV file. Here we want to upload the USA Data.csv file and remain all are same after that Click on Next.

Import data into salesforce lightning
Import data into salesforce lightning

Step 5: Edit Field Mapping of Accounts and Contacts, In the Edit section, click on the Map and Map the Salesforce object.

Import data in salesforce
Import data in salesforce

Step 6: After clicking on the Map, the Map your field Dialogue box is open in which we can find the field and click on the Map button.

Import data into salesforce lightning experience
Import data into the salesforce lightning

Step 7: After clicking on the Map option, you can see that the Field Mapping is completed, and then click on Next.

How to import data into salesforce lightning
Edit the Field Mapping

Step 8: After clicking on the Next, Review the information and click on the Start Import button.

Do you know how to import data into salesforce
Review and Start Import

Step 9: After clicking on the Start Import button, the dialogue box is open on which the text is written, Click on Ok to view your import status on the Bulk Data Load Job Page.

Do you know how to import data into salesforce lightning experience
Import data into the salesforce lightning

Step 10: After clicking on the Ok button you can see that the Bulk Data Load Jobs Page is open in which you can see that under the Batches the status is shown completed.

Do you know how to import data in salesforce
Import data in salesforce is completed

This is how to import data into salesforce lightning.

Read How to delete schema builder in salesforce

How to import data into salesforce classic

Salesforce classic is the traditional user experience of Salesforce and it has a simplified interface that is easy to use.

Here we are importing the data into the salesforce classic, using a USA Employee Data CSV file.

Follow these steps to import data into salesforce classic:-

Step 1: Login to the salesforce account, Go to Setup and enter Data Import Wizard in Quick Find Box. Click on the Data Import Wizard.

How to import data into salesforce classic
How to import data into salesforce classic

Step 2: After clicking on Data Import Wizard, then import our data in three simple steps that mention in the below picture, and then click on the Launch button.

How to import data into salesforce classic experience
How to import data into the salesforce classic

Step 3: After clicking on Launch wizard, then Import the data into Salesforce. Firstly select the data we want to import Like Standard Objects or Custom Objects.

Here we are choosing the Standard objects. There are lots of Standard objects and we are choosing Leads in between them.

After Choosing the objects, Next Add new records and then choose the CSV file. Here we want to upload the USA Employee Data.csv file and remain all are same after that Click on Next.

Import data into salesforce classic
Import data into salesforce classic

Step 4: Now Edit Field Mapping of Leads if needed, otherwise click on the Next.

Import data into salesforce classic experience
Edit Field Mapping

Step 5: After clicking on the Next, Review the information and click on the Start Import button.

Do you know how to import data into salesforce classic
Review and Start Import

Step 6: After clicking on the Start Import button, the dialogue box is open on which the text is written, Click on Ok to view your import status on the Bulk Data Load Job Page.

How to import data into salesforce classic experience
Import data has started and click OK

Step 7: After clicking on the Ok button you can see that the Bulk Data Load Jobs Page is open in which you can see that under the Batches the status is shown completed.

Do you know how to import data in salesforce classic
Import data in salesforce classic status completed

So, with this, we understand how to import data into salesforce classic.

Read How to Create Record Type in Salesforce

How to import data into salesforce from CSV

CSV stands for Comma Separated Values file which is a text file that has a specified format that permits the data to be saved in a table format. It uses commas to separate the values.

Here we are importing the data into the salesforce, using a Contacts USA CSV file.

Follow these steps to import data into salesforce from CSV:-

Step 1: Login to the salesforce account, Go to Setup and enter Data Import Wizard in Quick Find Box. Click on the Data Import Wizard.

How to import data into salesforce from CSV
How to import data into salesforce from CSV

Step 2: After clicking on Data Import Wizard, then import our data in three simple steps that mention in the below picture, and then click on the Launch button.

How to import data into salesforce lightning from CSV
How to import data into salesforce lightning from CSV

Step 3: After clicking on Launch wizard, then Import the data into Salesforce. Firstly select the data we want to import Like Standard Objects or Custom Objects.

Here we are choosing the Standard objects. There are lots of Standard objects and we are choosing Leads in between them.

After Choosing the objects, Next Add new records and then choose the CSV file. Here we want to upload the Contacts USA.csv file and remain all are same after that Click on Next.

How to import data into salesforce lightning experience from CSV
Import our Data into Salesforce

Step 4: Edit Field Mapping of Accounts and Contacts, In the Edit section, click on the Map and Map the Salesforce object.

Import Data into salesforce from CSV
Import Data into salesforce from CSV

Step 5: After clicking on the Map, the Map your field Dialogue box is open in which we can find the field and click on the Map button.

Import data into salesforce lightning from CSV
Import data into salesforce lightning from CSV

Step 6: After clicking on the Map option, you can see that the Field Mapping is completed, and then click on Next.

Import data into salesforce lightning experience from CSV
Edit Field Mapping of Accounts and Contacts

Step 7: After clicking on the Next, Review the information and click on the Start Import button.

Do you know how to import data into salesforce from CSV
Review and Start Import

Step 8: After clicking on the Start Import button, the dialogue box is open on which the text is written, Click on Ok to view your import status on the Bulk Data Load Job Page.

Do you know how to import data into salesforce lightning from CSV
Import Data has started

Step 9: After clicking on the Ok button you can see that the Bulk Data Load Jobs Page is open in which you can see that under the Batches the status is shown completed.

Do you know how to import data into salesforce lightning experience from CSV
Import data into salesforce is completed

Step 10: Go to the App Launcher, enter the contact in the search box and then click on the contacts.

Import data in salesforce from CSV
Import data in salesforce from CSV

Step 11: After clicking on the Contacts, the All Contacts Page is open and you can see all the contacts that are present in the Contacts USA.csv file is merged with these contacts.

Import data in salesforce lightning from CSV
Import data in salesforce lightning from CSV

So with this, we understand how to import data into salesforce from CSV.

Read How to a Create Custom Field in Salesforce

How to import bulk data into salesforce

The bulk stands for the mass or size of something large. The bulk of data refers to putting all the data into a file or set of files.

Here we are importing the data into the salesforce, using a Contacts USA Emp imp CSV file. Follow these steps to import bulk data into salesforce:-

Step 1: Login to the salesforce account, Go to Setup and enter Data Import Wizard in Quick Find Box. Click on the Data Import Wizard.

How to import bulk data into salesforce
How to import bulk data into salesforce

Step 2: After clicking on Data Import Wizard, then import our data in three simple steps that mention in the below picture, and then click on the Launch button.

How to import bulk data into salesforce lightning
How to import bulk data into salesforce lightning

Step 3: After clicking on Launch wizard, then Import the data into Salesforce. Firstly select the data we want to import Like Standard Objects or Custom Objects.

Here we are choosing the Standard objects. There are lots of Standard objects and we are choosing Accounts and contacts in between them.

After Choosing the objects, Next Add new records and then choose the CSV file. Here we want to upload the USA Emp imp.csv file and remain all are same after that Click on Next.

How to import bulk data into salesforce lightning experience
Import bulk data into salesforce lightning

Step 4: Edit Field Mapping of Accounts and Contacts, In the Edit section, click on the Map and Map the Salesforce object.

Import bulk data into salesforce
Import bulk data into salesforce

Step 5: After clicking on the Map, Map your field Dialogue box is open in which we can find the field and click on the Map button. After clicking on the Map option, you can see that the Field Mapping is completed, and then click on Next.

Import bulk data into salesforce lightning
Import bulk data into salesforce lightning

Step 6: After clicking on the Next, Review the information and click on the Start Import button.

Import bulk data into salesforce lightning experience
Review and start importing data

Step 7: After clicking on the Start Import button, the dialogue box is open on which the text is written, Click on Ok to view your import status on the Bulk Data Load Job Page.

Do you know how to import bulk data into salesforce
Import of bulk data has started

Step 8: After clicking on the Ok button you can see that the Bulk Data Load Jobs Page is open in which you can see that under the Batches the status is shown completed.

Do you know how to import bulk data into salesforce lightning
Import of bulk data is completed

This is how we understand how to import bulk data into salesforce.

Read How to Create a Campaign in Salesforce

How to mass import data into salesforce

The Import data connects the offline data that we have passed with the default hit that is gathered by the analytics.

Here we are importing the data into the salesforce, using a Contacts USA Lead CSV file. Follow these steps to import bulk data into salesforce:-

Step 1: Login to the salesforce account, Go to Setup and enter Data Import Wizard in Quick Find Box. Click on the Data Import Wizard.

How to mass import data into salesforce
How to mass import data into salesforce

Step 2: After clicking on Data Import Wizard, then import our data in three simple steps that mention in the below picture, and then click on the Launch button.

How to mass import data into salesforce lightning
How to mass import data into salesforce lightning

Step 3: After clicking on Launch wizard, then Import the data into Salesforce. Firstly select the data we want to import Like Standard Objects or Custom Objects.

Here we are choosing the Standard objects. There are lots of Standard objects and we are choosing Leads in between them.

After Choosing the objects, Next Add new records and then choose the CSV file. Here we want to upload the USA Lead.csv file and remain all are same after that Click on Next.

Import data into salesforce
Import data into salesforce

Step 4: Edit Field Mapping of Leads, In the Edit section, click on the Map and Map the Salesforce object. After clicking on the Map, Map your field Dialogue box is open in which we can find the field and click on the Map button.

Edit Field Mapping
Edit Field Mapping

Step 5: After clicking on the Map option, you can see that the Field Mapping is completed, and then click on Next.

Mass import data into salesforce
Mass import data into salesforce

Step 6: After clicking on the Next, Review the information and click on the Start Import button.

Review and start importing
Review and start importing

Step 7: After clicking on the Start Import button, the dialogue box is open on which the text is written, Click on Ok to view your import status on the Bulk Data Load Job Page.

Import data has started
Import data has started

Step 8: After clicking on the Ok button you can see that the Bulk Data Load Jobs Page is open in which you can see that under the Batches the status is shown completed.

Import mass data into salesforce
Import mass data into salesforce

So, with this, we understand how to mass import data into salesforce.

Conclusion:

In this tutorial, we have learned how to import data into salesforce, and also we have covered how to import bulk data into salesforce. This can be performed on both salesforce lightning and salesforce classic.

  • How to import data into Salesforce
  • How to import data into Salesforce lightning
  • Import data into salesforce classic
  • How to import data into salesforce from CSV
  • How to import bulk data into salesforce
  • How to mass import data into salesforce

You may like the following salesforce tutorials: