Data import in Salesforce is the process of bringing records and information from an external source typically a CSV file or a database into your Salesforce organization. Whether you’re migrating from a legacy CRM, onboarding a new dataset, or syncing data from a spreadsheet, data import is one of the most fundamental skills any Salesforce Admin needs to master.
Salesforce supports any data source that can be saved in comma-delimited text format (.csv). Once your file is ready, there are three primary operations you can perform during an import:
➤ Insert
Creates brand-new records in Salesforce. Used when bringing in data for the first time and there are no existing matching records in the org.
➤ Update
Modifies existing Salesforce records. Requires either the Salesforce Record ID or an External ID to match and update the correct records.
➤ Upsert
A combination of Insert and Update. If a matching record exists, it updates it. If no match is found, it creates a new record. This is the most versatile and commonly used operation for ongoing data management.
Why Data Import Matters for Salesforce Admins
Data is the lifeblood of any Salesforce org. Without accurate, up-to-date records, your reports are unreliable, automations fail to trigger correctly, and your sales and service teams can’t do their jobs effectively. Here’s why every Salesforce Admin must have solid data import skills:
CRM Migrations:
Moving from tools like HubSpot, Zoho, or spreadsheets into Salesforce requires bulk data importing.
Data Enrichment:
Keeping contacts, leads, and accounts accurate by regularly importing updated external data.
Automation Readiness:
Workflows, Process Builders, and Flows all depend on clean, well-structured data existing in the org.
Compliance & Reporting:
Accurate imported data ensures that reports, dashboards, and audits reflect ground truth.
Exam Relevance:
Data import is a core topic in the Salesforce Administrator Certification exam it’s essential knowledge you must master.
Admin Tip : Understanding the right tool for the right job is what separates a good Salesforce admin from a great one. Read on to learn exactly when and how to use each tool.
The Three Primary Tools for Data Import in Salesforce
Salesforce offers three main tools for importing data, each with its own strengths, limitations, and ideal use cases.
Tool 1: Data Import Wizard
The Data Import Wizard is a built-in, browser-based tool accessible directly from Salesforce Setup. It’s the go-to option for most everyday import tasks and is user-friendly enough for beginners.
How to access: Setup → Quick Find → Data Import Wizard
Key capabilities:
- Supports 5 standard objects: Contacts, Leads, Accounts, Campaign Members, and Solutions
- Supports all custom objects
- Allows up to 50,000 records per import
- Includes duplicate-checking — a standout advantage over other tools
- No installation required (runs in the browser)
Tool 2: Salesforce Data Loader
The Data Loader is a desktop client application from Salesforce built for high-volume and automated imports.
Key capabilities:
- Handles up to 5 million records per operation
- Supports all standard and custom objects
- Can be operated via a GUI or the command line (for automation/scheduling)
- Available for Windows and macOS
- Does not check for duplicates automatically
Data Loader is available for Enterprise, Unlimited, Performance, Developer, and Database.com editions only.
Tool 3: Dataloader.io
Dataloader.io is a cloud-based, third-party tool that runs entirely in your browser — no installation required.
Key capabilities:
- Supports import, export, upsert, and delete on all standard and custom objects
- Free tier handles up to 10,000 records/month with a 10 MB file size limit
- Paid plans remove record and file size restrictions
- Supports scheduled/automated tasks (paid plans)
- Works with all Salesforce editions
How to Use the Data Import Wizard (Step-by-Step)
The Data Import Wizard is the most accessible way to perform a data import in Salesforce. Here’s a complete walkthrough:
Step 1: Prepare Your CSV File
Export your data into a .csv file. Ensure column headers match (or can be mapped to) Salesforce field API names. Remove blank rows or special characters that could cause errors.
Step 2: Open the Data Import Wizard
Go to Setup → Quick Find → “Data Import Wizard”. Click “Launch Wizard!” to start.
Step 3: Choose the Object and Operation
Select the object type (e.g., Contacts, Leads, Accounts, or a custom object). Then choose your operation: Add new records, Update existing records, or Add and update records (Upsert).
Step 4: Set Duplicate Matching Rules
Choose how duplicates should be identified — by Salesforce ID, email, name, etc. This helps prevent duplicate records before they’re created.
Step 5: Upload Your File and Map Fields
Upload your .csv file. The wizard will attempt to auto-map column headers to Salesforce fields. Review all mappings carefully and correct any mismatches before proceeding.
Step 6: Review and Start Import
Review your settings on the summary page. Click “Start Import”. You’ll receive an email notification when the import is complete, along with a status report showing successes and any errors.
Pro Tip: Always test your import with a small sample file (10–20 records) before importing thousands. This helps catch field mapping errors and validation rule failures early.
5. How to Use Salesforce Data Loader
Data Loader is ideal for large-scale imports, automated jobs, or scenarios where you need to work with object types not supported by the Import Wizard.
Installation
Download Data Loader from Setup → Data Management → Data Loader. Available for Windows and macOS.
Running a UI-Based Import
Step 1: Log In and Select Operation Open Data Loader, log in with your Salesforce credentials (plus your security token if outside a trusted IP range). Select your operation: Insert, Update, Upsert, Delete, or Export.
Step 2: Choose the Object Select the Salesforce object you want to import data into. Data Loader lists all available standard and custom objects.
Step 3: Browse for Your CSV File Select your source .csv file. Click “Next” to proceed to field mapping.
Step 4: Map Fields Use the mapping interface to match CSV columns to Salesforce fields. You can save mapping files (.sdl) for reuse in future imports.
Step 5: Run and Review Results Click “Finish” to start the import. Data Loader generates success and error log files (.csv) you can review to understand which records were imported and which failed.
Important: Data Loader does not check for duplicates. Always run a SOQL query or use a deduplication tool before performing large inserts.
Command-Line Automation
Data Loader’s CLI allows you to schedule nightly or recurring imports using configuration files and batch scripts — ideal for syncing data with external systems without manual intervention.
How to Use Dataloader.io
Dataloader.io requires no installation and is ideal for users who want a fast, visual, browser-based import experience.
Step 1: Connect to Salesforce Go to dataloader.io and click “Login with Salesforce.” Authorize the app to access your org.
Step 2: Create a New Task Click “New Task” and select your operation type (Import, Export, Delete, or Upsert) and the target Salesforce object.
Step 3: Upload Your File and Map Fields Upload your CSV and map columns to Salesforce fields using the visual mapping interface. Supports manual mapping and auto-detect.
Step 4: Run and Monitor Click “Run” to execute the task. The results dashboard shows success and error counts in real time. Download error reports to handle failed records.
Note: The free plan supports up to 10,000 records/month and files up to 10 MB. For higher volumes, a paid plan is required.
7. Tool Comparison: Which One Should You Use?
| Feature | Data Import Wizard | Data Loader | Dataloader.io |
|---|---|---|---|
| Max Records | 50,000 | 5,000,000 | Varies by plan |
| Supported Objects | 5 standard + custom | All standard + custom | All standard + custom |
| Duplicate Detection | Yes | No | No |
| Export Capability | No | Yes | Yes |
| Installation Required | No (browser-based) | Yes (desktop app) | No (cloud-based) |
| Automation / Scheduling | No | Yes (CLI) | Yes (paid) |
| Salesforce Editions | All (except Personal) | Enterprise, Unlimited, Performance, Developer | All |
| Best For | Simple, small–medium imports with duplicate control | High-volume and automated imports | Quick browser-based imports without setup |
Quick Rule of Thumb:
- Use the Import Wizard for anything under 50k records where duplicates are a concern.
- Use Data Loader when you need automation or volume above 50k.
- Use Dataloader.io when you need a fast, no-install cloud solution.
8. Key Considerations Before You Import
Before running any data import in Salesforce, keep the following in mind to avoid failures and data quality issues.
Picklist and Multi-Select Picklist Fields
If your CSV contains values that don’t match an existing (restricted) picklist option, Salesforce will warn you. For multi-select picklists, separate multiple values in your CSV with a semicolon (;).
Checkbox Fields
Use 1 or True for checked, and 0 or False for unchecked.
Date and Date/Time Fields
Ensure date values in your CSV match the format configured in your Salesforce org’s locale settings. Mismatched date formats are a common import failure point.
Formula Fields
Formula fields are read-only — they auto-calculate values based on other fields. You cannot import data into formula fields, so exclude them from your CSV mapping.
Validation Rules and Lookup Filters
Salesforce runs all active validation rules during import. Records that fail validation are not imported. Consider temporarily deactivating blocking validation rules before a large migration (and re-activating them immediately after).
Universally Required Fields
If a universally required field is missing from your import file, the entire import will fail. Always check your object’s required fields before preparing your CSV.
Default Field Values
For unmapped picklist, multi-select picklist, and checkbox fields, Salesforce automatically inserts the field’s configured default value into the new or updated record.
9. Data Import Best Practices
Following these best practices will help you execute clean, reliable imports every time.
| # | Best Practice | Why It Matters |
|---|---|---|
| 1 | Clean your data first | Standardize formats, remove duplicates, fix blanks before importing |
| 2 | Test in a Sandbox | Catch errors without impacting your production org |
| 3 | Import in smaller batches | Easier error identification and rollback on large files |
| 4 | Use External IDs | Prevents duplicate creation during repeated upsert imports |
| 5 | Disable unnecessary triggers & rules | Prevents unintended side effects and speeds up processing |
| 6 | Document every import | Invaluable for audits, troubleshooting, and compliance |
| 7 | Back up before importing | Gives you a clean restore point if something goes wrong |
| 8 | Review error logs carefully | Patterns in errors often reveal systemic data or config issues |
Common Mistakes and How to Avoid Them
Even experienced Salesforce admins make data import mistakes. Here are the most common ones and how to avoid them.
Importing Without a Test Run
Skipping a Sandbox test or small sample import is the fastest path to a messy production org. Always test first.
Ignoring the Error Log
A 95% success rate on a 100,000-record file still means 5,000 missing records. Always review the full error report.
Incorrect Date Formats
Date fields are a surprisingly common failure point. Confirm your CSV uses the exact date format matching your Salesforce locale settings.
Not Mapping Required Fields
If a required field (like Account Name on an Account record) is missing or unmapped, the import fails for every single record.
Using the Wrong Tool for the Job
Trying to import 200,000 records with the Import Wizard, or using Data Loader when you need duplicate checking — both create unnecessary problems. Know your tools.
Not Handling Relationships Correctly
When importing child records, include the parent record’s ID (or External ID) to establish the relationship. Missing relationship fields results in orphaned or incorrectly linked records.
Frequently Asked Questions
Q: What file format does Salesforce support for data import? Salesforce supports CSV (comma-separated values) files. Any application that can export to .csv — Excel, Google Sheets, a legacy CRM — can serve as a data source.
Q: How many records can I import at once in Salesforce? It depends on the tool. The Data Import Wizard supports up to 50,000 records. The Data Loader handles up to 5 million records. Dataloader.io limits vary by plan (10,000/month on the free tier).
Q: Can I import data without the Salesforce Record ID? Yes. For update or upsert operations, you can use an External ID field — a custom field that holds a unique identifier from your external system (like an ERP customer number or legacy database ID).
Q: Does the Data Import Wizard check for duplicate records? Yes — the Data Import Wizard includes built-in duplicate detection. It can match records by email, name, Salesforce ID, or other fields. The Data Loader and Dataloader.io do not include automatic duplicate checking.
Q: Can I import data into all Salesforce objects? Not with every tool. The Data Import Wizard is limited to 5 standard objects plus custom objects. The Data Loader and Dataloader.io support all standard and custom objects.
Q: Is data import covered in the Salesforce Admin certification exam? Yes! Data import in Salesforce — including the tools, use cases, and best practices — is a tested topic in the Salesforce Certified Administrator exam. You should know the differences between the Import Wizard and Data Loader, and when to use each one.
Q: What happens if my import file contains validation rule violations? Records that fail Salesforce validation rules during import are not imported. They appear in the error log with the relevant validation rule description. You’ll need to fix the data or temporarily deactivate the rule before re-importing.
Ready to Become a Certified Salesforce Admin?
Data import is just one piece of the puzzle. If you’re serious about becoming a Salesforce Certified Administrator, you need comprehensive, structured training that covers every exam topic — from data management and security to automation and reporting.
Salesforce Admin Certification Course — MyTutorialRack
What you’ll get:
- Complete exam curriculum aligned to the latest Salesforce Admin exam guide
- Hands-on practice with real Salesforce orgs
- Mock tests and topic-wise quizzes
- Expert instructor guidance
- Certification-ready preparation from day one
Join thousands of students who have used this course to pass their Salesforce Admin exam and launch thriving careers. Enroll today →
Found this guide helpful? Share it with your fellow Salesforce learners!
