Excel to Salesforce CSV converter for Data Loader and Import Wizard
Salesforce imports records from CSV, not from XLSX. Match each Excel column to a Salesforce field name, convert the sheet to UTF-8 CSV with ISO dates, then load it with the Data Import Wizard or Data Loader and check the field mapping screen. XlsConverter prepares the file, and you control the load and the object in Salesforce.
Short answer
To upload an Excel file to Salesforce, save the sheet as UTF-8 CSV with one record per row and headers that match field labels or API names, then load it with the Data Import Wizard or Data Loader. Keep Salesforce IDs and phone numbers as text, write dates as yyyy-mm-dd, and review the mapping screen before you run the job. XlsConverter creates that CSV from XLSX or XLS in a browser or batch, with the sheet, delimiter and date format fixed.
A sales ops or Salesforce admin gets a lead list from an event, an account export from a billing system or a spreadsheet from an acquired company, and all of it arrives as Excel. Salesforce loads records from CSV files, so every workbook has to become a clean CSV before the Data Import Wizard or Data Loader will take it. When that happens every week, hand editing and re-saving is slow and error prone.
Line up the columns first, one record per row and one header per field, then convert with comma and UTF-8 selected. The UTF-8 CSV conversion guide explains the encoding choices. If several files arrive at once, batch convert Excel to CSV with identical settings so every file loads the same way.
How to convert Excel to Salesforce CSV in three steps
- 1Prepare the records in Excel. Use one row per record, one header per field, and remove title rows, subtotals and notes. Keep Salesforce record IDs, phone numbers and ZIP codes stored as text so leading zeros and long values survive.
- 2Choose the sheet, then CSV, comma and UTF-8, and pick ISO 8601 dates for date columns. Convert and open the download to confirm the headers, the date columns and any special characters in names and addresses.
- 3In Salesforce, choose the Data Import Wizard for common objects or Data Loader for larger or scheduled loads. Select the object and operation, map each CSV column to a field, review the mapping screen and run a small test load first.
Prepare Excel columns for a Salesforce import
Salesforce matches CSV columns to fields on a mapping screen, so clear headers save time. Use field labels or API names such as FirstName, LastName, Email, Company and Phone for leads and contacts. According to Salesforce documentation, required fields differ by object, and Last Name and Company are the usual minimum for leads, so check the object you load. Multi-select picklist values go in one cell separated by semicolons. Dates and datetimes should be written in ISO style, for example 2026-03-15.
Salesforce record IDs come in a 15 character case sensitive form and an 18 character case insensitive form. Excel lookups such as VLOOKUP ignore case, so two different 15 character IDs can look identical. Use the 18 character ID in any workbook you match on, and store ID columns as text. When you update existing records, include the ID column, and when you upsert, use an external ID field that is unique in the org.
Data Loader has a setting to read all CSV files as UTF-8, and a CSV saved in another encoding produces garbled names with accents or symbols. Convert once with UTF-8 selected and you do not depend on that setting. XlsConverter prepares file format only. It does not check your data against validation rules, duplicate rules or required fields in your org, so run a small test load before the full import.
Import leads and contacts from Excel into Salesforce
Lead and contact lists are the most common Excel to Salesforce job. Name, email, company, title and phone sit in separate columns, and the same list often needs to be loaded into a campaign as well. Convert the finished tab to CSV, load it as leads or contacts, and keep the original workbook as the source of record.
Phone numbers and ZIP codes need text storage in Excel, otherwise leading zeros disappear before conversion. Check formulas too, since the CSV contains the calculated value and not the formula. If the list contains accented names, confirm they look right in the CSV before loading.
Fix a Salesforce CSV import with garbled characters or wrong dates
Garbled characters mean the file was not read as UTF-8. Convert again with comma and UTF-8 selected, then open the CSV in a text editor to see the real content. Wrong dates usually come from a mix of US and EU formats in the workbook, so choose one output format and apply it to every date column.
If a column is skipped, compare its header with the field label or API name on the mapping screen and adjust it. XlsConverter does not split a file by row, so divide very large sources across tabs and export one CSV per tab. Conversion prepares the format and does not guarantee that every record passes the validation rules in your org.
Prepare Salesforce CSV files every week
Use Pro when you convert event, partner or regional lists together for a weekly load. Use Business when the same sender delivers workbooks with changing headers and you want inbox or cloud pickup with saved header renaming. Business pipelines accept files from an email inbox, S3, Google Drive, Dropbox or a URL on a schedule or every new file, then deliver to SFTP, S3, a webhook or email. The automatic Excel to CSV workflow describes the pattern.
Pro costs 49 USD per month, or 24 USD per month billed yearly, with 2,000 conversions and 100 MB files. Business costs 149 USD per month, or 74 USD per month billed yearly, with 10,000 conversions, 20 pipelines, 5 seats and 1,000 AI runs. See Pro and Business plans for your volume. Teams that also feed a finance system can use the Excel to NetSuite CSV converter with its own template. The one-time demo covers the first 100 rows.
Compare ways to get an Excel file into Salesforce
| Method | Preparation | How records reach Salesforce | Ongoing work | Best for |
|---|---|---|---|---|
| Save As CSV UTF-8 in Excel by hand | Edit headers, set formats, save the file | Upload with the Data Import Wizard or Data Loader | Repeat the preparation for every workbook | Occasional lists with stable columns |
| Data Import Wizard | Prepare the CSV, then use the guided steps | Browser based import for common objects and smaller loads | Repeat the mapping for each file | Admins loading leads, contacts or accounts |
| Data Loader or an integration tool | Prepare the CSV or configure a connector | Large loads, scheduled jobs or direct connectors | Maintain mappings and credentials | Big volumes, upserts and automation inside Salesforce |
| XlsConverter | Match columns, choose sheet, delimiter and date format | You load the prepared CSV with the Wizard or Data Loader | Review the file and run a test load | Recurring workbooks needing UTF-8 CSV and batch conversion |
Data Loader and integration tools win when you need large volumes, scheduled loads or a direct connection from the source system into Salesforce. The Data Import Wizard is enough for small one-off lists. XlsConverter fits repeatable file preparation with batch conversion and saved header templates before any of those tools.
Excel to Salesforce CSV questions
How do I import an Excel file into Salesforce?
Save the prepared sheet as a UTF-8 CSV with one record per row, then load it with the Data Import Wizard or Data Loader. Choose the object and operation, map each CSV column to a field and review the mapping screen. Run a small test load before the full file.
Can Salesforce import an XLSX file directly?
Salesforce import tools read CSV files, so convert the XLSX first. Some third party connectors read Excel directly, which suits scheduled syncs. For a repeatable file based workflow, convert each workbook to UTF-8 CSV with the sheet and date format you choose, then import it with the standard tools.
What CSV format does Salesforce Data Loader need?
Use a header row with field labels or API names, one record per row, UTF-8 encoding and consistent date formats. Data Loader has a setting to read all CSV files as UTF-8, but it is safer to save the file correctly. Required fields depend on the object you load.
How do I fix garbled characters in a Salesforce CSV import?
The file was most likely not saved as UTF-8. Convert again with comma and UTF-8 selected, then open the CSV in a text editor to confirm accents and symbols look right. Re-saving in a spreadsheet app can change the encoding again, so load the converted file directly.
What date format should an Excel to Salesforce CSV use?
Use ISO style dates such as 2026-03-15 in every date column, which avoids day and month swaps between US and EU settings. The converter and batch screens offer ISO 8601, US and EU date output. Check a few rows in the CSV before loading, since Salesforce reads what the file contains.
Why do Salesforce IDs from Excel not match?
Excel lookups ignore case, but 15 character Salesforce IDs are case sensitive, so different IDs can look the same. Use the 18 character ID in workbooks you match on and store the column as text. That also protects long values from being changed by Excel number formatting.
Does XlsConverter upload records directly to Salesforce?
No, XlsConverter prepares CSV files that you load yourself with the Data Import Wizard or Data Loader. Business pipelines deliver to SFTP, S3, a webhook or email and do not log in to Salesforce. Choose an integration tool if you need records pushed straight from the source system.
Related converters
Convert full files and batches
Pro starts at $24 per month billed yearly. Cancel any time.