XLS to CSV Converter

Get a CSV from an old Excel XLS file to load the data into a CRM, database, marketplace, analytics tool, or script

No software installation • Fast conversion • Private and secure

1K+
users
44K+
conversions

When you need CSV from XLS

XLS shows up often in old price lists, archives, exports from accounting systems, and files created before the shift to XLSX became widespread. While such a file opens as a spreadsheet you can work with it in an editor. But for loading data into a CRM, database, ad platform, marketplace, or script, you usually need CSV.

Converting XLS to CSV extracts cell values and saves them as a simple text file with delimiters. CSV is easier to import, verify, pass between systems, and process programmatically.

What is preserved in the CSV

CSV receives the table data: text, numbers, dates, and the current results of formulas. Formatting, colors, borders, column widths, charts, images, macros, comments, and interactive elements are not preserved. CSV is not a full Excel workbook - it is a flat data table.

If the XLS has multiple sheets, make sure in advance that the data you need is on the sheet that will be exported. For an editable modern spreadsheet use XLS to XLSX, and for an open office format use XLS to ODS.

What matters for import

CSV looks simple, but errors often surface after conversion. Dates can be read in a different locale, phone numbers and SKUs can lose leading zeros, long numbers can become scientific notation, and the delimiter may not match what the target system expects.

Before loading, check the header row, delimiter, encoding, date format, and columns containing identifiers. If the data comes from a modern Excel file, use XLSX to CSV. If you later need an Excel file from the CSV, use CSV to XLSX.

What it works well for

XLS to CSV works well for customer lists, product catalogs, price lists, orders, inventory levels, payments, registries, and reports where rows and columns are what matter. Complex financial models, dashboards, macro-dependent workbooks, and visual reports should not be converted to CSV without manual review, because logic and formatting will be lost.

What is XLS to CSV conversion used for

Customer import

Move an old XLS customer database into a CRM or email service through CSV.

Price list for a marketplace

Prepare products, prices, and stock levels from old Excel for upload to an online marketplace.

Archive data

Extract data from old XLS files for further processing and storage.

Analytics

Pass a spreadsheet to a BI tool, Python, R, or any other tool that accepts CSV.

Tips for converting XLS to CSV

1

Clean the first row

Column headers should be clear and free of merged cells.

2

Check the delimiter

International integrations often expect a comma; some systems use a semicolon. Confirm what the target system needs.

3

Protect SKUs

Import phone numbers, SKUs, and barcodes as text to avoid losing leading zeros.

4

Compare row counts

After conversion, verify that all needed rows made it into the CSV and no empty trailing rows were added.

Frequently Asked Questions

Are formulas preserved when converting XLS to CSV?
CSV receives the current cell values, not the formulas. After conversion, formula recalculation is not possible.
What happens to table formatting?
Formatting is not carried over. CSV stores only data rows and delimiters between values.
Is CSV suitable for a CRM?
Yes, CSV is commonly used to import contacts, deals, products, and orders. Check the CRM's delimiter and encoding requirements.
How do I keep leading zeros in SKUs?
When importing into the target system, set those columns to a text type; otherwise they may be read as numbers.
Can I export multiple XLS sheets?
CSV represents one table. If the workbook has multiple sheets, prepare and convert each one separately.
How does XLS to CSV differ from XLS to XLSX?
CSV is for data and import. XLSX preserves the structure of an editable Excel workbook and is better suited for office work.