Summary  
This chapter demonstrates how to map and transform spreadsheet data fields to match a target schema before bulk importing, including renaming headers, converting data formats, handling unsupported or missing fields, and validating values to prevent import errors.

General domain of usage  
Customer relationship management data import (Salesforce lead integration)

EcoMarket Deliveries has decided to outsource lead generation to a third party. This third party has gathered data on thousands of retirement centers across the U.S. and delivered it as a spreadsheet. Now, our task is to import this data into Salesforce effectively, ensuring all relevant information is properly mapped.

### Helpful resources for prepping your data:
<a href="https://help.salesforce.com/s/articleView?id=000385167&type=1" target="_blank"><svg width="1em" height="1em" viewBox="0 0 30 32" fill="none" xmlns="http://www.w3.org/2000/svg"><path fill="none" stroke="#098f67" style="stroke: var(--color1, #098f67)" stroke-linejoin="miter" stroke-linecap="round" stroke-miterlimit="4" stroke-width="2.4156" d="M17.289 17.305v0c-1.754 1.754-4.597 1.754-6.351 0l-7.76-7.759c-1.755-1.755-1.755-4.601 0-6.356v0c1.753-1.753 4.595-1.756 6.351-0.005l6.208 6.187"></path><path fill="none" stroke="#098f67" style="stroke: var(--color1, #098f67)" stroke-linejoin="miter" stroke-linecap="round" stroke-miterlimit="4" stroke-width="2.4156" d="M12.504 13.97v0c1.754-1.754 4.597-1.754 6.351 0l7.762 7.762c1.754 1.754 1.754 4.597 0 6.351v0c-1.754 1.754-4.597 1.754-6.351 0l-5.953-5.953"></path></svg> Format the 'Date' and 'Date Time' data in a CSV file For Salesforce Data Loader</a>;

<a href="https://help.salesforce.com/s/articleView?id=000381876&type=1" target="_blank"><svg width="1em" height="1em" viewBox="0 0 30 32" fill="none" xmlns="http://www.w3.org/2000/svg"><path fill="none" stroke="#098f67" style="stroke: var(--color1, #098f67)" stroke-linejoin="miter" stroke-linecap="round" stroke-miterlimit="4" stroke-width="2.4156" d="M17.289 17.305v0c-1.754 1.754-4.597 1.754-6.351 0l-7.76-7.759c-1.755-1.755-1.755-4.601 0-6.356v0c1.753-1.753 4.595-1.756 6.351-0.005l6.208 6.187"></path><path fill="none" stroke="#098f67" style="stroke: var(--color1, #098f67)" stroke-linejoin="miter" stroke-linecap="round" stroke-miterlimit="4" stroke-width="2.4156" d="M12.504 13.97v0c1.754-1.754 4.597-1.754 6.351 0l7.762 7.762c1.754 1.754 1.754 4.597 0 6.351v0c-1.754 1.754-4.597 1.754-6.351 0l-5.953-5.953"></path></svg> Prepare a CSV File for an Import or Update in Salesforce</a>;

<a href="https://developer.salesforce.com/docs/atlas.en-us.dataLoader.meta/dataLoader/supported_data_types.htm" target="_blank"><svg width="1em" height="1em" viewBox="0 0 30 32" fill="none" xmlns="http://www.w3.org/2000/svg"><path fill="none" stroke="#098f67" style="stroke: var(--color1, #098f67)" stroke-linejoin="miter" stroke-linecap="round" stroke-miterlimit="4" stroke-width="2.4156" d="M17.289 17.305v0c-1.754 1.754-4.597 1.754-6.351 0l-7.76-7.759c-1.755-1.755-1.755-4.601 0-6.356v0c1.753-1.753 4.595-1.756 6.351-0.005l6.208 6.187"></path><path fill="none" stroke="#098f67" style="stroke: var(--color1, #098f67)" stroke-linejoin="miter" stroke-linecap="round" stroke-miterlimit="4" stroke-width="2.4156" d="M12.504 13.97v0c1.754-1.754 4.597-1.754 6.351 0l7.762 7.762c1.754 1.754 1.754 4.597 0 6.351v0c-1.754 1.754-4.597 1.754-6.351 0l-5.953-5.953"></path></svg> Data Types Supported by Data Loader</a>.


When preparing a spreadsheet for importing leads, why might you need to change "$1,000,000" to "1000000"?

This is an introductory class for beginners who haven't used a CRM before but will need to use Salesforce as a core part of their job. Jobs include business analysts, marketers, PR, content writers,  and all who can be required to work with salesforce in different capacities (one marketer might focus on qualifying leads, one might be interested in closing opportunities, one might be managing the email schedule). As it turns out, more and more of these jobs require knowledge of Salesforce (or other CRMs), and it's a barrier to getting hired.

You'll get crystal clear on why Salesforce is such a game-changer for businesses by diving into a relatable real-world scenario. Through the story of EcoMarket Deliveries, you'll explore the common pain points businesses face without a structured CRM system—from disorganized data to missed opportunities—and discover exactly how Salesforce solves these challenges with powerful, streamlined solutions.

What is the primary function of the Sales tab in Salesforce?

Which of the following best describes an "Opportunity" in Salesforce?

Why might EcoMarket Deliveries want to create custom fields in Salesforce?

In Salesforce, how can customer segmentation benefit EcoMarket Deliveries' marketing strategy?

When importing lead data, what should you do if a spreadsheet field name does not match Salesforce's expected field name?

Learn to navigate and customize the Salesforce interface while mastering key concepts like leads, opportunities, accounts, and contacts. Tackle real-world challenges with EcoMarket Deliveries, from adding new leads manually to bulk importing them efficiently. Gain practical skills to qualify and convert leads, moving them through the sales funnel to drive business success.

Learn to turn prospects into customers using EcoMarket strategies, understand what opportunities signify, and get hands-on with creating and editing opportunity records. Explore sales stages for revenue forecasting and discover how to associate products or services with deals to enhance your sales workflow.

Learn to set up Salesforce Service Cloud, manage cases, and leverage the Knowledge Panel for enhanced customer support.

Discover how to segment emails, apply advanced filters, and automate communications using Merge Mail. Improve response times and maintain consistency in messaging with Salesforce's built-in email optimization features.

Master Salesforce reporting and analytics by creating reports, dashboards, and leveraging data insights.

Importing Leads into Salesforce

Helpful resources for prepping your data: