LitExtension Blog
  • Ecommerce Platforms
    • Shopify
    • WooCommerce
    • Magento (Adobe Commerce)
    • Wix
    • Other Platforms
  • eCommerce Migration
    • Shopify Migration
    • WooCommerce Migration
    • Magento Migration
    • Other Migrations
  • Store Growth
  • LitExtension
    • LitExtension Updates
    • Case Study
No Result
View All Result
VISIT LITEXTENSION
LitExtension Blog
  • Ecommerce Platforms
    • Shopify
    • WooCommerce
    • Magento (Adobe Commerce)
    • Wix
    • Other Platforms
  • eCommerce Migration
    • Shopify Migration
    • WooCommerce Migration
    • Magento Migration
    • Other Migrations
  • Store Growth
  • LitExtension
    • LitExtension Updates
    • Case Study
No Result
View All Result
VISIT LITEXTENSION
LitExtension Blog
No Result
View All Result

How to Upload CSV to Salesforce by 10 Different Methods 2026

by Ani Duong
Nov, 2026
in Platform Tutorials, Ecommerce Platforms

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.

upload-csv-to-salesforce
You need to prepare your CSV file for upload.

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.

upload-csv-to-salesforce-wizard-step-1
Step 1. Create a CSV file.

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.

upload-csv-to-salesforce-wizard-step-1b
Step 1. Type “Data Import Wizard” in the Quick Find box and launch.

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.”

upload-csv-to-salesforce-wizard-step-2
Step 2. Choose data types and upload your CSV file.

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.

upload-csv-to-salesforce-wizard-step-3
Step 3. Review the mapped fields and adjust the unmapped data.

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.

upload-csv-to-salesforce-wizard-step-4
Step 4. Import CSV into Salesforce.

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)
upload-csv-to-salesforce-wizard-step-5
Step 5. Monitor the progress in the “Bulk Data Load Jobs” section.

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.

upload-csv-to-salesforce-basic
Ask a Salesforce admin to turn on Basic Data Import.

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.

BOOK FREE CONSULTATION

All-in-One Migration Service

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:

upload-salesforce-single-object
5 steps to upload CSV into one single Salesforce object.

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
– Built by MuleSoft, a Salesforce company
– Task scheduling and imports from Dropbox, Box, and FTP

– Free plan capped at 10,000 records per month and 10 MB files
– Basic data transformations only

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
– Mass update, data cleansing, and lead conversion tools
– Scheduled imports and exports

– Requires Microsoft Excel
– Advanced features are limited to paid editions

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
– Supports data integration, backup, and import/export
– Easy-to-use interface with scheduling capabilities

– Free plan limited to 10k records per month and daily scheduling
– Can be slow for very large datasets, based on our testing

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.)
– Works with both standard and custom objects
– No installation required (web-based)

– Not maintained by Salesforce, so there’s no official support or bug fixes
– Salesforce now recommends its CLI and VS Code tools instead

Salesforce Inspector Reloaded (3.8/5)

Quick, small imports straight from your browser

Free (open source)

– Free browser extension for Chrome, Edge, and Firefox
– Paste data from CSV, Excel, or JSON to import
– Detects the object automatically from an Id column

– Community-built with no official support
– Better for small, ad-hoc imports than large jobs

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)
– Flexible matching without needing record IDs
– Highly rated on AppExchange (4.89/5)

– Lacks scalability for large-scale data imports
– Limited advanced data transformation options


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:

litextension-all-in-one
Importing data into Salesforce with LitExtension only requires three steps.

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.

BOOK FREE CONSULTATION

All-in-One Migration Service

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.

Previous Post

Magento Product Export Guide: How to Export Products in Magento 2

Next Post

WooCommerce Import Customers & Export: 2026 How-to Guide

Ani Duong

Ani Duong

The newest addition to LitExtension’s senior content writer team, Ani pens insightful articles covering a wide range of eCommerce platforms, from the most popular to the newly established.

Table of Contents
  1. How to Prepare Your CSV Files for Upload
    1. Setting up the header and records
    2. Cleaning your data before import
    3. Converting Excel files to CSV
    4. Choosing the right file format
    5. Formatting field values correctly
    6. Handling required and optional fields
    7. Managing relationships between objects
    8. Working with special fields
  2. Method 1: How to Upload CSV to Salesforce with Data Import Wizard
    1. Step 1: Create the import file and launch the wizard
    2. Step 2: Choose the data to import
    3. Step 3: Map your data fields
    4. Step 4: Start your Salesforce data import
    5. Step 5: Monitor your import
    6. Quick option for contacts and leads: Basic Data Import
  3. Method 2: How to Upload CSV to Salesforce with Data Loader
    1. Step 1: Install and log in to Data Loader
    2. Step 2: Choose the operation
    3. Step 3: Select the object and your CSV file
    4. Step 4: Map fields
    5. Step 5: Run the import and check the results
  4. Method 3: How to Upload CSV to Salesforce into One Single Object
    1. Step 1: Locate the CSV File Import app
    2. Step 2: Upload your CSV file
    3. Step 3: Select the Salesforce object and import type
    4. Step 4: Map CSV columns to Salesforce fields
    5. Step 5: Finish the import
  5. Common Errors When Uploading CSV to Salesforce (and How to Fix Them)
    1. Missing permissions
    2. Wrong field formats
    3. Required fields and validation rules
    4. Duplicate rules blocking records
    5. Garbled characters
    6. Files too large or imports timing out
    7. After the import: verify your data
  6. Bonus: 6 Apps to Upload CSV to Salesforce
  7. Method 4: Import Data to Salesforce with LitExtension
    1. Step 1: Consultation with LitExtension experts
    2. Step 2: Data mapping and setup by experts
    3. Step 3: Perform full Salesforce migration
    4. Ongoing support beyond migration
  8. Upload CSV to Salesforce: FAQs
  9. Final Words

Popular eCommerce Migration

  1. Shopify Migration
  2. WooCommerce Migration
  3. Magento Migration
  4. BigCommerce Migration
  5. PrestaShop Migration

Best Ecommerce Platforms

  1. Shopify Review
  2. WooCommerce Review
  3. Wix Ecommerce Review
  4. BigCommerce Review
  5. Best Ecommerce Platforms

 

Popular Migration Pairs

  • Wix to Shopify
  • Magento to Shopify
  • BigCommerce to Shopify
  • WooCommerce to Shopify
  • Shopify to WooCommerce

Company

  • About LitExtension
  • Success Stories
  • Sitemap
  • Disclosures
  • Our Author
  • Contact Us

DMCA.com Protection Status

  • All the Basics to Build eCommerce Website
  • Disclosures
  • LitExtension Authors
  • LitExtension Blog – Shopping Cart Migration Expert & eCommerce News
  • LitExtension Blog Sitemap
  • LitExtension Methodology

© 2011 - 2024 LitExtension.com All Rights Reserved.

No Result
View All Result
  • Ecommerce Platforms
    • Shopify
    • WooCommerce
    • Magento (Adobe Commerce)
    • Wix
    • Other Platforms
  • eCommerce Migration
    • Shopify Migration
    • WooCommerce Migration
    • Magento Migration
    • Other Migrations
  • Store Growth
  • Ecommerce News
    • News & Events
    • Case Studies
VISIT LITEXTENSION

© 2011 - 2024 LitExtension.com All Rights Reserved.