Whether you’re moving leads from a spreadsheet, syncing contacts from another CRM, or bringing years of customer records into Salesforce, CSV files are usually the easiest way to get your data in. Still, many admins and sales teams get stuck when it’s time to upload CSV to Salesforce, as a single wrong date format or missing field can make the whole import fail.
No worries; we’re here to make it easy! In this guide, we’ll walk you through 10 ways to get your data into Salesforce (four core methods plus six handy apps), including:
- How to prepare your CSV files for upload
- Method 1: Upload CSV via Data Import Wizard
- Method 2: Upload CSV via Data Loader
- Method 3: Upload CSV into one single object
- Common errors and how to fix them
- 6 bonus apps to import data into Salesforce
- Method 4: Full store migration with LitExtension
Not sure which way to upload CSV to Salesforce fits your data? Here’s a quick comparison before we dive in:
|
Method |
Best for |
Record limit |
Supported data |
Skill level |
|
Data Import Wizard |
Importing common CRM records with a guided, browser-based tool; no installation needed |
Up to 50,000 records per import |
Accounts, contacts, leads, solutions, campaign members, person accounts, and custom objects |
Beginner |
|
Basic Data Import |
Quickly adding new contacts or leads (Enterprise and Performance editions only) |
Up to 50,000 records per import |
New contacts and leads only |
Beginner |
|
Data Loader |
Large, recurring, or scheduled imports, plus updates and deletes |
Up to 150 million records (with Bulk API 2.0) |
Most standard and custom objects, including those the wizard doesn’t support |
Intermediate to advanced |
|
CSV File Import app |
Orgs with CSV Data Management that import into one object with reusable mappings |
Files up to about 100 MB |
Objects supported by the User Interface API |
Beginner |
|
Third-party apps |
Scheduled imports, imports from cloud storage, or editing Salesforce data in Excel |
Depends on the app and plan |
Varies by app |
Beginner to intermediate |
|
LitExtension |
Moving an entire eCommerce store to Salesforce Commerce Cloud |
Handled by our experts |
Products, variants, categories, customers, orders, coupons, reviews, CMS pages, and blog posts |
No technical skills needed |
Ready? Keep scrolling!
How to Prepare Your CSV Files for Upload
Before you upload CSV to Salesforce, the very first step is obviously preparing your CSV files correctly! By doing so, you’ll save yourself a lot of troubleshooting later. It’s also wise to back up your existing Salesforce data first (from Setup, search for “Data Export”) and, for bigger projects, run through our Salesforce data migration checklist.

Setting up the header and records
First, keep in mind that every CSV file starts with a header row, which defines the field names for the object you want to work with. Each line after the header represents a single record, and the values in that record are separated by commas.
A key rule here is consistency: all records in one file must belong to the same Salesforce object. For instance, if you’re uploading Contacts, the entire file must only include Contact records. When you create an import job, Salesforce requires you to specify the object, and mixing objects in the same file will cause the process to fail.
Cleaning your data before import
Next, take a few minutes to clean up your file. Remove duplicate rows, delete columns you don’t need, and fix typos. Also, standardize values that should look the same; for example, “CA,” “Calif.,” and “California” should all follow one single format.
Finally, test the import with a small file of around 10 to 20 records before uploading everything. Then, open a few of those records in Salesforce to check that each value landed in the right field.
Converting Excel files to CSV
If your data lives in an Excel workbook, you’ll need to convert it before you upload CSV to Salesforce, since the built-in import tools only read CSV files. In Excel, go to “File” > “Save As” (or “Save a Copy”) and choose “CSV UTF-8 (Comma delimited) (*.csv)” as the file type. In Google Sheets, go to “File” > “Download” > “Comma Separated Values (.csv).”
Keep in mind that a CSV file only holds one sheet, so save each sheet as a separate file. Formulas are also saved as their current values, not as formulas.
Choosing the right file format
To stay on the safe side, save your CSVs in UTF-8 and use commas as delimiters, as these are the defaults for most Salesforce import tools. That said, the Data Import Wizard also accepts tab-separated files, while Data Loader lets you pick a tab or another character as the delimiter in its settings.
On some international computers, Excel may default to semicolons instead of commas. To confirm, open your CSV in a text editor like Notepad: if you see rows such as Tom;Jones;[email protected], then your delimiter is wrong. You’ll need to replace all semicolons with commas. On Windows, this can be done easily with the Find and Replace function (CTRL + H).
Once corrected and saved, your file will be ready for Salesforce to read.
Formatting field values correctly
Even with the right file format, a few small details in your values can still break your attempt to upload CSV to Salesforce:
- Commas, quotes, and line breaks: Wrap any value that contains a comma, line break, or double quote in double quotes, e.g., “Director of Operations, Western Region”. If the value itself contains double quotes, type each one twice (“”).
- Extra spaces: Spaces around commas aren’t trimmed, so a row like John, Smith will import the last name as ” Smith” with a leading space.
- Blank cells: Empty values are ignored when you update records. To clear an existing value with Data Loader or the API, enter #N/A instead.
- Leading zeros: Excel often strips leading zeros from ZIP codes, phone numbers, or customer IDs (e.g., 02134 becomes 2134). Format those columns as Text before saving, then double-check them in a text editor.
- One bad row: A single broken row (such as an unclosed quote) can disrupt the whole import. If a large file fails, split it into smaller batches to find the culprit.
Here’s what a clean sample CSV file for Contacts looks like:
FirstName,LastName,Title,Email,Phone,MailingPostalCode
Tom,Jones,"Director of Operations, Western Region",[email protected],(555) 123-4567,02134
Maria,Garcia,Sales Manager,[email protected],(555) 987-6543,94105
Handling required and optional fields
When you upload CSV to Salesforce to insert new records, you must include every field Salesforce marks as required. If those are missing, the record will be rejected.
For updates, Salesforce processes only the fields you provide and ignores the rest, so you can safely update selected attributes without affecting others. This flexibility is useful, but it also means you must plan carefully which fields to include to avoid incomplete or inconsistent data.
Managing relationships between objects
Salesforce objects are often linked to each other, and when you upload CSV to Salesforce, your file can reflect those connections.
For example, Contacts are typically tied to Accounts. In your header row, you can represent this relationship with a syntax like RelationshipName.IndexedFieldName. So if you want to reference a Contact’s parent Account by its external ID, your header could read Account.External_ID__c.
For custom objects, Salesforce uses __r to indicate relationships, so a field like Mother_Of_Child__c would become Mother_Of_Child__r.External_ID__c in your header. This way, your import not only creates records but also preserves the correct parent-child links.
A few more rules to keep in mind:
- Import parent records before child records (e.g., Accounts before Contacts), so the parents already exist when you link to them.
- You can only reference a parent from a child record, one level up (not from parent to child or up to the “grandparent”). The parent field you match on must also be an indexed field, such as an external ID.
- Self-relationships work too. For instance, ReportsTo.Email links a Contact to the Contact they report to.
- For polymorphic fields that can point to more than one object, such as a Task’s WhoId (a Lead or a Contact), add the object type in front: Lead:Who.Email.
Working with special fields
Certain field types in Salesforce come with formatting rules you can’t ignore.
For instance, lookup fields must use valid Salesforce IDs, either 15-character case-sensitive or 18-character case-insensitive alphanumeric strings. Picklist values should match an existing value exactly. If the picklist is restricted, any value that isn’t on the list will fail; if it isn’t restricted, Salesforce saves the new value as is, which can quickly clutter your data. For multi-select picklists, separate each value with a semicolon.
Date and DateTime fields are particularly sensitive. Data Loader and the API accept the YYYY-MM-DD format for dates, for example, 2025-09-08 for September 8, 2025. For a combined date and time, use the ISO 8601 format YYYY-MM-DDThh:mm:ssZ. An example would be 2025-09-08T14:30:00Z, representing 2:30 PM UTC. The “T” separates the date and time, and the “Z” indicates UTC. The Data Import Wizard, on the other hand, reads dates in your user locale’s format (e.g., MM/DD/YYYY for US users).
Meanwhile, Boolean (checkbox) fields take true or false, so true will check the box while false leaves it unchecked (the Data Import Wizard also accepts 1 and 0). For currency fields, do not include symbols or commas; enter only the numeric value. Salesforce automatically formats these according to your organization’s currency settings.
Email addresses must follow international standards (RFC 5321). That means one and only one @ symbol, no consecutive dots, and no illegal characters like spaces or unescaped quotes. [email protected] is valid, but [email protected] or a@b@[email protected] will fail.
Last but not least, formula fields and other read-only fields can’t receive imported data, so leave them out of your file. Records that break a validation rule or trigger condition will also fail, so you may want to deactivate those rules temporarily and switch them back on after the import.
Now you are ready to upload CSV to Salesforce!
Method 1: How to Upload CSV to Salesforce with Data Import Wizard
The Data Import Wizard is Salesforce’s built-in, browser-based tool to upload CSV to Salesforce and the easiest place to start if you’re new to importing. It lets you bring in up to 50,000 records at a time across seven data types: accounts, contacts, leads, solutions, campaign members, person accounts, and custom objects. Plus, it’s available in all Salesforce editions except Database.com, with nothing to install.
Just remember that it only accepts CSV files and runs one import job at a time (including jobs started from other browser windows). It also can’t be scheduled and doesn’t cover some objects, such as opportunities and cases, so for bigger or more complex jobs, Data Loader (Method 2) is a better fit.
If the wizard covers your needs, here’s how to upload CSV to Salesforce with it:
Step 1: Create the import file and launch the wizard
First, create a clean CSV file using the tips above to prevent errors and duplicate data. You can also check out Salesforce’s guide to preparing CSV files for import.

Next, from Setup, enter “Data Import Wizard” in the “Quick Find” box and select it. Review the welcome page, then click “Launch Wizard.” You can also open the wizard from the Tools list on an object’s home page, while non-admins can find it in their personal settings.

Step 2: Choose the data to import
Now, select the type of Salesforce import data:
- Click “Standard Objects” to import accounts, contacts, leads, solutions, person accounts, or articles. For other data types, choose “Custom Objects.”
- Choose “Add new records” to create new items only, “Update existing records” to edit existing ones (no new items), or “Add new and update existing records” to do both at the same time.
- If desired, specify matching criteria (e.g., by Name, which is case-sensitive for custom objects) and decide whether the imported records should trigger workflow rules and processes.
Once done, drag and drop your CSV file into the upload area. Then, pick a character encoding (the default works for most files) and a value separator (comma or tab), and click “Next.”

Step 3: Map your data fields
After you upload the CSV file, the Data Import Wizard will automatically map as many fields as possible to Salesforce fields. Review and adjust them if necessary (click “Change” to edit an automatic mapping).
Keep in mind that unmapped fields won’t be imported. For each remaining field, click “Map” next to it and select up to 10 Salesforce fields to link. For accounts and contacts, you can also save unmapped data in the “Account Note” or “Contact Note” field.

Step 4: Start your Salesforce data import
Next, confirm your mappings on the “Review” page (and click “Previous” to make changes if needed), then click “Start Import” to begin your Salesforce bulk upload.

Step 5: Monitor your import
Finally, monitor the progress in one of the following places:
- The “Recent Import Jobs” chart on the Data Import Wizard home page
- The “Bulk Data Load Jobs” page in Setup (admins only, and not available in Professional Edition)
- The relevant object tabs, such as Contacts or Accounts (for non-admins)

You’ll also receive an email once the import is complete. And that’s it! Your Salesforce CSV import is underway.
Quick option for contacts and leads: Basic Data Import
Only need to add new contacts or leads? If you’re on the Enterprise or Performance edition, Salesforce also offers a simplified flow called Basic Data Import, which handles up to 50,000 contacts and leads at a time. Ask your Salesforce admin to turn it on; you’ll also need the View Setup and Configuration permission, plus permission to import contacts or leads.

That said, this option is limited to two data types and only creates new records (it can’t update existing ones). It also reads UTF-8 files only and spots duplicate leads by name alone. So, for anything beyond a quick contact or lead upload, stick with the Data Import Wizard steps above.
Method 2: How to Upload CSV to Salesforce with Data Loader
If you’re working with more than 50,000 records, objects the wizard doesn’t support, or imports you need to repeat regularly, Data Loader is the official tool to upload CSV to Salesforce at scale. This free desktop app from Salesforce can insert, update, upsert, delete, hard delete, and export records, and it handles up to 150 million records when used with Bulk API 2.0.
Data Loader is available in the Enterprise, Performance, Unlimited, and Developer editions and runs on both Windows and macOS. Here’s how to use it:
Step 1: Install and log in to Data Loader
First, make sure your computer has Java Runtime Environment (JRE) 17 or later. Then, from Setup, enter “Data Loader” in the “Quick Find” box, download the latest version for your operating system, unzip it, and run the installer. Salesforce only supports the latest version, so remember to update it from time to time.
Next, open Data Loader, choose an operation, and log in with your Salesforce account. Select “Production” for your live org or “Sandbox” for a test environment.
Step 2: Choose the operation
Pick the operation that matches your goal:
- Insert: Creates new records.
- Update: Changes existing records, matched by their Salesforce ID.
- Upsert: Updates records that already exist and inserts the rest, matched by ID or an external ID field.
- Delete: Removes records by ID. Hard Delete skips the Recycle Bin and requires Bulk API.
Step 3: Select the object and your CSV file
Now, choose the Salesforce object you want to import into (tick “Show all Salesforce objects” if you can’t find it), browse to your CSV file, and click “Next.” Data Loader will check the file and show how many records it found. For upserts, you’ll also choose which field to match on.
Step 4: Map fields
Click “Create or Edit a Map,” then “Auto-Match Fields to Columns” to let Data Loader map columns with matching names automatically. Drag any remaining Salesforce fields onto the right columns manually. If you plan to repeat this import, click “Save Mapping” to store it as an .sdl file you can reuse next time.
Step 5: Run the import and check the results
Choose a folder to store the result files, then click “Finish” to start. Once the job is done, Data Loader creates two files: a success file listing every record that went through (with its new Salesforce ID) and an error file explaining why any record failed. Fix those errors in your CSV, then re-import only the failed rows.
For larger files, turn on “Use Bulk API” or “Use Bulk API 2.0” in Data Loader’s Settings to process records in parallel batches. And on Windows, you can run Data Loader from the command line to schedule recurring imports, such as a nightly sync from another system.
Moving Your Whole Store to Salesforce Commerce Cloud?
Skip the CSV files. LitExtension’s experts transfer your products, customers, orders, and more to Salesforce Commerce Cloud accurately and securely.

Method 3: How to Upload CSV to Salesforce into One Single Object
Some Salesforce orgs also include a CSV File Import app, which comes with a feature called CSV Data Management. It offers a shorter, guided process focused on one object at a time, with field mappings you can save and reuse.
Note that this app is only included with certain Salesforce products, such as Automotive, Education, Manufacturing, Net Zero, and Nonprofit Cloud, or Sales and Service Cloud with a Revenue Lifecycle Management license. Users also need the CSV Basic Data Import permission set. If that applies to your org, here’s how to upload CSV to Salesforce with the app:

Step 1: Locate the CSV File Import app
First, go to the App Launcher and search for the CSV File Import app. If it doesn’t appear, ask your admin to assign the permission set and make the CSV File Import tab visible (in older orgs, it can stay hidden even after the permission set is assigned). Then, open the app, click “Import,” and select “Upload CSV File.”
Step 2: Upload your CSV file
Next, upload your file. It must be UTF-8 encoded and should stay under 100 MB. Besides commas, this app also accepts semicolons, tabs, pipes, carets, and backquotes as delimiters, while date fields must follow the yyyy-MM-dd format.
After uploading, Salesforce shows you the file size and a preview of the first ten rows so you can verify that the correct file has been chosen. After making sure everything looks accurate, click “Next.”
Step 3: Select the Salesforce object and import type
At this point, choose the Salesforce object that will hold your data. You’ll also need to pick the import type: insert (add new records), update (edit existing ones), or upsert (both). Note that updates require the record ID column in your file, while upserts need either the ID or an external ID. With these options selected, click “Next.”
Step 4: Map CSV columns to Salesforce fields
Salesforce now attempts to map the CSV file’s columns to the appropriate object fields automatically. If your column headers are identical to the field names in Salesforce, much of this mapping will already be done. However, you should carefully review each field and manually map any unmatched data to ensure accuracy.
And if you’d like to save time for future imports, select “Save mapping configuration” to store this setup for reuse. Likewise, if you already have a saved mapping, select “Use a saved mapping configuration” and choose it here to streamline the process.
Step 5: Finish the import
When your mappings are finalized, click “Next” one final time and then choose “Import.” The import runs in the background, and you’ll be notified when it’s done.
Once the process is complete, download and check the import logs. These logs confirm whether your records were imported successfully and highlight any errors you may need to address. Need to fill several related objects from one file? Users with the CSV Advanced Data Import permission set can also import CSV data into multiple objects at the same time.
Common Errors When Uploading CSV to Salesforce (and How to Fix Them)
Even with careful preparation, attempts to upload CSV to Salesforce don’t always go to plan. Here are the most common issues we’ve seen and how to fix them:
Missing permissions
If you can’t find the import tool or get an “insufficient access” message, your user profile probably lacks the right permissions. You’ll need permission to import the object in question (plus create and edit access to it), and Data Loader also requires API access. Ask your Salesforce admin to check your profile or permission sets.
Wrong field formats
Dates in the wrong format, picklist values that don’t exist in a restricted picklist, and currency values with symbols are among the most frequent causes of failed rows. Check the error file or import log to see which field caused the problem, then fix it using the formatting rules above.
Required fields and validation rules
Errors such as REQUIRED_FIELD_MISSING or FIELD_CUSTOM_VALIDATION_EXCEPTION mean a record is missing a required value or breaks a validation rule. Add the missing values to your file, or ask your admin to deactivate the rule temporarily and switch it back on after the import.
Duplicate rules blocking records
If your org uses duplicate rules, records that match existing ones may be blocked (often with a DUPLICATES_DETECTED error). To avoid this, update or upsert the existing records instead of inserting new ones, or ask your admin to adjust the duplicate rule for the import.
Garbled characters
Strange symbols in names or addresses usually point to an encoding mismatch. Save your file as CSV UTF-8 and make sure the encoding you select in the import tool matches the file.
Files too large or imports timing out
The Data Import Wizard stops at 50,000 records per import. For bigger files, split your data into smaller batches or switch to Data Loader with Bulk API enabled.
After the import: verify your data
Once you upload CSV to Salesforce successfully, don’t skip this final check:
- Spot-check a handful of records to make sure every value landed in the right field.
- Run a quick report to compare the number of imported records with the number of rows in your CSV.
- Confirm that relationships are intact, e.g., Contacts are linked to the correct Accounts.
- Switch back on any validation rules, workflows, or duplicate rules you deactivated.
- Keep your success and error files (or import logs) in case you need to trace a problem later.
Bonus: 6 Apps to Upload CSV to Salesforce
Aside from Salesforce’s own tools, you might want to consider one of the six third-party apps below to upload CSV to Salesforce. They add extras that the built-in tools don’t offer, such as imports from cloud storage, flexible scheduling, or editing Salesforce data right in Excel.
We rated each app on ease of use, record limits, data transformation, scheduling, pricing, and support. Based on our research and hands-on testing, here’s a quick rundown to help you decide which one to use to upload CSV to Salesforce:
|
App (our rating) |
Best for |
Pricing |
Pros |
Cons |
|
Dataloader.io (4.5/5) |
Quick, scheduled imports for small to mid-sized teams |
Free (10,000 records/month); Professional $99/user/month; Enterprise $299/user/month |
– Drag-and-drop design with excellent usability |
– Free plan capped at 10,000 records per month and 10 MB files |
|
XL-Connector (4.2/5) |
Teams that manage Salesforce data in Excel |
Free edition available; paid editions from $10/month |
– Import, update, upsert, and delete records right from Excel |
– Requires Microsoft Excel |
|
Skyvia (4.0/5) |
Scheduled imports from cloud storage, such as Google Drive, Dropbox, or FTP |
Free (10k records/month); paid plans from $79/month billed annually |
– Fully cloud-based with no local installation required |
– Free plan limited to 10k records per month and daily scheduling |
|
Workbench (3.8/5) |
Admins and developers who need a free, web-based toolkit |
Free (open source) |
– Supports comprehensive operations (query, import, export, delete, etc.) |
– Not maintained by Salesforce, so there’s no official support or bug fixes |
|
Salesforce Inspector Reloaded (3.8/5) |
Quick, small imports straight from your browser |
Free (open source) |
– Free browser extension for Chrome, Edge, and Firefox |
– Community-built with no official support |
|
Impowr, formerly SimpleImport (3.3/5) |
Users who want to import Excel files without converting them to CSV |
Paid; contact the vendor for pricing |
– Supports multiple file types (.CSV, .XLS, .XLSX, .ODS) |
– Lacks scalability for large-scale data imports |
Method 4: Import Data to Salesforce with LitExtension
The methods above work well when you upload CSV to Salesforce for CRM records like contacts, leads, or accounts. But what if your CSV files are actually exports from another eCommerce platform, and you’re moving your entire store to Salesforce Commerce Cloud? In that case, manual CSV uploads quickly become risky: products, variants, customers, and orders all need to stay linked, and one broken relationship can mean hours of cleanup.
That’s where LitExtension All-in-One Migration comes in. Our experts can transfer your products and variants, categories, customers, orders, coupons, reviews, and even CMS pages and blog posts. Plus, with 15+ years of experience, we know how to tailor each migration to your unique needs. If you’re still weighing the platform, our Salesforce Commerce Cloud review and Salesforce B2B Commerce pricing breakdown are a good place to start.
Here’s how to import data into Salesforce with LitExtension:

Step 1: Consultation with LitExtension experts
The first step is to get in touch with our team to schedule a consultation. During this session, we’ll explore all your specific import and migration needs, including categories, orders, products, customer information, or even custom features from your current eCommerce store.
Once your requirements have been thoroughly discussed and finalized, you only need to sign the Service Level Agreement (SLA) and complete your payment. From there, a dedicated Personal Assistant will take over the process.
Step 2: Data mapping and setup by experts
Next, our experts will do the following to prepare your new Salesforce store for migration:
- Setting up and validating your new store (installing required plugins and preparing the environment)
- Mapping your data fields to match Salesforce Commerce Cloud
- Setting up additional options, such as 301 redirects
- Running demo migrations for each data type for you to review
Throughout this step, we’ll offer unlimited demo migrations to give you full visibility into the progress and let you provide input whenever necessary.
Step 3: Perform full Salesforce migration
Once everything is ready, we proceed with the full-scale migration. You’ll receive regular progress updates from your Personal Assistant via ticket, Slack, or WhatsApp. Before handing over, we run multiple rounds of in-house automated testing to confirm every record has arrived correctly. Best of all, all additional options, such as 301 redirects, are included at no extra charge!
Ongoing support beyond migration
After the migration is complete, our team will thoroughly review your new store to ensure it’s running smoothly and fully aligned with the goals we established in the first step.
Furthermore, our support doesn’t stop there. For up to 60 days after the migration, we’ll keep supporting you with 2 free re-migrations, plus free and unlimited smart updates and recent data migrations (as long as the new data doesn’t exceed 5% of the initial migration).
Let Our Experts Handle Your Salesforce Migration!
With the All-in-One Migration Service, our experts plan, map, and transfer your store data to Salesforce Commerce Cloud, then test everything before you launch.

Upload CSV to Salesforce: FAQs
Can you upload a CSV file to Salesforce?
Yes. You can upload CSV to Salesforce with the built-in Data Import Wizard (up to 50,000 records), Data Loader (up to 150 million records with Bulk API 2.0), Basic Data Import for new contacts and leads, or third-party apps such as Dataloader.io and Skyvia. Some orgs also have the CSV File Import app for single-object imports.
How do I upload an Excel spreadsheet to Salesforce?
Salesforce’s built-in tools don’t read Excel files directly, so save your spreadsheet as a CSV first (“File” > “Save As” > “CSV UTF-8 (Comma delimited)”). Then, use the Data Import Wizard for up to 50,000 records, or Data Loader for larger files and objects the wizard doesn’t support. Apps like XL-Connector and Impowr can also import Excel data without conversion.
Which CSV format should I use for Salesforce?
When you upload CSV to Salesforce, use a UTF-8 encoded, comma-delimited CSV file for the best compatibility. The Data Import Wizard also accepts tab-separated values, and Data Loader lets you choose a tab or another delimiter in its settings.
What is the maximum number of records I can import into Salesforce?
The Data Import Wizard and Basic Data Import handle up to 50,000 records per import, while Data Loader can process up to 150 million records with Bulk API 2.0. Your actual limit also depends on your permissions and your org’s data storage.
How do I bulk upload data to Salesforce?
To bulk upload data to Salesforce, create a clean CSV file with your data. Then, use the Data Import Wizard for smaller imports of up to 50,000 records, or Data Loader with Bulk API or Bulk API 2.0 enabled for large datasets and complex imports.
How do I import contacts into Salesforce from CSV?
Prepare a CSV file with your contact data, then log in to Salesforce, go to Setup, and search for the Data Import Wizard. Launch it, choose “Accounts and Contacts” under Standard Objects, upload your CSV, map the fields, and start the import. If you’re on the Enterprise or Performance edition, you can also use Basic Data Import to add new contacts.
How do I update existing records with a CSV file?
Include a column that identifies each record, such as the Salesforce ID or an external ID. Then, choose “Update existing records” in the Data Import Wizard, or run an Update or Upsert operation in Data Loader. Blank cells are ignored during updates, so only the fields you include will change.
Why is my Salesforce CSV import failing?
When an attempt to upload CSV to Salesforce fails, the most common causes are missing required fields, wrong date or picklist formats, validation rules, duplicate rules, missing permissions, and the wrong file encoding. Check the error file (in Data Loader) or the import status (in the Data Import Wizard) to see which records failed and why.
Can I schedule automatic CSV imports to Salesforce?
The Data Import Wizard doesn’t support scheduling, so to upload CSV to Salesforce automatically, you can run Data Loader from the command line on Windows to schedule recurring imports, or use a third-party app like Dataloader.io or Skyvia to schedule imports from cloud storage.
Final Words
All in all, there’s no single best way to upload CSV to Salesforce; it depends on your data. For quick imports of up to 50,000 records into common objects, the Data Import Wizard is the easiest choice. For larger, recurring, or more complex jobs, Data Loader or one of the third-party apps above will save you plenty of time.
And if you’re moving an entire eCommerce store to Salesforce Commerce Cloud, LitExtension can take the heavy lifting off your plate. With 15+ years of expertise and 300,000+ successful migrations across 100+ countries, we’re here to make your Salesforce migration smooth and completely hassle-free.
For more information, check out our guide on how to use Salesforce Commerce and join our Facebook community.
