TinySandyFree Online Tools

XLSX to CSV Converter

Export the sheets of an Excel workbook to CSV. Choose one sheet or all sheets (delivered as a ZIP with one CSV per sheet), pick the delimiter and quoting style, and decide whether numbers and dates should appear as Excel displays them or as raw values. Formula cells export the last calculated value stored in the file. It all runs in your browser.

Spreadsheet & CSV Runs in your browser

Convert an Excel Workbook to CSV

Drag and drop an Excel file here, or click to browseAccepted: XLSX, XLSM, XLS, ODS. Up to 25 MB.
Prefixes text cells that start with = + - @ with an apostrophe.

How to Use the XLSX to CSV

  1. Choose your workbook; the sheet list fills in automatically.
  2. Select one sheet or all sheets and set delimiter, quoting and line endings.
  3. Choose displayed or raw values; tick the formula-injection protection if the CSV will be opened in a spreadsheet by others.
  4. Press Convert, check the preview and download the CSV (or the ZIP).

About This Tool

Developers and analysts who need CSV from an Excel file for imports, scripts, databases or version control, and anyone who needs a semicolon or tab separated export.

Input: XLSX / XLS / XLSM / ODS  ·  Output: CSV.

Features and Limitations

Features

  • Single sheet or every sheet in one ZIP.
  • Comma, semicolon, tab or pipe delimiters, optional quoting of all fields and LF or CRLF line endings.
  • Displayed values (dates, currency, percentages as in Excel) or raw values with full precision.
  • Optional UTF-8 BOM and an optional guard against CSV formula injection.

Limitations

  • Formulas are exported as the last values saved in the file; they are not recalculated, so a file that was never calculated may give empty cells.
  • Only cell values are exported: formatting, images, charts, comments and hidden-row information are not.
  • Merged cells export their value in the first cell only, and password-protected workbooks cannot be opened.
  • The formula-injection option changes the data (adds an apostrophe) and is off by default.
  • Processing happens on your device, so very large files depend on your browser's available memory.

Example

A sheet with the header “name;qty” exported with a semicolon delimiter and CRLF line endings gives lines such as Widget;3 separated by Windows line breaks.

Frequently Asked Questions

Why does my CSV show numbers differently from Excel?

With “As displayed in Excel” you get the formatted text (for example 12.50 or 31/05/2024). With “Raw values” numbers keep full precision and dates are written in ISO format.

What is CSV formula injection?

If a CSV cell starts with = + - or @, spreadsheet programs may treat it as a formula. Turning on the protection prefixes such text cells with an apostrophe so that they are shown as text.

How do I export every sheet?

Choose “All sheets” in the Sheet list. You get a ZIP file with one CSV per sheet.

Why do accents look wrong when I open the CSV in Excel?

Excel often needs a UTF-8 byte order mark. Tick the BOM option and convert again.

Is my workbook uploaded?

No. It is read and converted in your browser.

Related Tools

More like this: all Spreadsheet & CSV tools, all Files & Documents tools or the TinySandy home page.