Excel to CSV
Convert Excel XLS or XLSX workbooks to CSV, export the active worksheet or all worksheets, choose the delimiter, and download multiple sheets together as a ZIP archive.
Continue with These Tools
Finished using Excel to CSV? Here are some related tools that people commonly use next to complete their workflow faster.
CSV to Excel
Convert CSV files to Excel XLSX spreadsheets while preserving text values, leading zeros and structured tabular data.
Split Excel
Split Excel workbooks into separate XLSX files by worksheet or divide a large worksheet into smaller files by row count.
Split CSV
Split large CSV files into smaller CSV parts by row count, optionally repeat the header row, preserve common delimiters, and download all generated files in one ZIP archive.
XML to Excel
Convert XML files to Excel XLSX spreadsheets by detecting repeated records, flattening nested elements and attributes, and preserving structured data safely.
Excel to XML
Convert Excel XLS or XLSX workbooks to XML, export the active worksheet or all worksheets, preserve sheet structure, and control the generated XML element names.
XML to CSV
Convert XML files to CSV by detecting repeating records, flattening nested elements and attributes, preserving repeated values, and choosing the output delimiter.
CSV to JSON
Convert CSV files to JSON with automatic delimiter detection, UTF-8 handling, duplicate-header protection, streaming conversion and optional pretty formatting.
How to Convert Excel to CSV
Upload an XLS or XLSX workbook and convert its active worksheet to CSV, or export every worksheet as a separate CSV file. You can choose the CSV delimiter and SwiftVecto packages multiple worksheet exports into one ZIP archive.
Overview
The SwiftVecto Excel to CSV converter transforms Microsoft Excel workbooks into plain-text CSV files for use with databases, CRM platforms, accounting systems, ecommerce tools, development workflows and other data-processing systems. The active worksheet can be exported as one CSV file, or every worksheet can be exported separately and packaged into a ZIP archive.
Benefits
How It Works
Upload one XLS or XLSX workbook.
Choose whether to export the active worksheet or every worksheet.
Choose the delimiter for the generated CSV files.
SwiftVecto loads the workbook and identifies the worksheet or worksheets to export.
Each selected worksheet is written using proper CSV quoting rules.
Formula cells are exported using their calculated values where supported.
UTF-8 output is generated with a byte order mark for spreadsheet compatibility.
If only the active worksheet is selected, one CSV file is generated.
If all worksheets are selected, one CSV is generated per worksheet and packaged into a ZIP archive.
Download the completed output.
How to Use This Tool
-
1Choose or drop one Excel workbook.
-
2Select Active Worksheet or All Worksheets.
-
3Choose the CSV delimiter.
-
4Start the Excel to CSV conversion.
-
5Wait while SwiftVecto reads the workbook and creates the CSV output.
-
6Download the generated CSV file or ZIP archive.
Helpful Tips
- Choose Active Worksheet when you only need the sheet currently marked active in the workbook.
- Choose All Worksheets when every workbook tab needs to be exported.
- Comma is the most common CSV delimiter and is a good default for general use.
- Semicolon-delimited CSV is commonly used in some regional spreadsheet configurations.
- Tab-delimited output is useful when field values frequently contain commas.
- Pipe-delimited output can be useful for data-import workflows where commas and tabs appear frequently in values.
- CSV cannot preserve Excel formatting, charts, merged cells or multiple worksheets in one file.
- CSV also cannot preserve Excel formulas as formulas, so exported cells normally contain their calculated values.
- Keep the original workbook if you need formatting or formulas later.
- Review important CSV exports before importing them into another system.
Common Uses
Convert an XLSX customer list to comma-delimited CSV.
Convert a legacy XLS workbook to CSV.
Export the active inventory worksheet to CSV.
Export every monthly worksheet into separate CSV files.
Convert Excel data to semicolon-delimited CSV for another business system.
Convert a worksheet into tab-delimited text-compatible CSV.
Export all workbook sheets to CSV and download them together as a ZIP.
Worked Examples
The following examples demonstrate how this tool can be used in realistic scenarios.
Active worksheet only
A workbook containing Sales, Finance and Inventory has Inventory marked as active. Active Worksheet mode exports only Inventory as a CSV file.
All worksheets
A workbook containing January, February and March worksheets is converted into three separate CSV files and packaged into one ZIP download.
Semicolon delimiter
Selecting Semicolon produces fields separated with semicolons instead of commas for systems or regional settings that expect that format.
Formula cells
An Excel cell containing a supported formula such as =SUM(B2:B20) is exported using its calculated value because CSV cannot store an Excel formula as a live formula.
Common Mistakes
Avoid these common mistakes to achieve the most accurate results.
- Expecting CSV to preserve workbook formatting.
- Expecting multiple worksheets to remain inside one CSV file.
- Choosing Active Worksheet when the required data is located on another sheet.
- Selecting a delimiter that the destination system does not support.
- Expecting charts, images or merged cells to appear in CSV output.
- Expecting Excel formulas to remain executable formulas after CSV conversion.
- Uploading a password-protected or encrypted workbook.
- Uploading CSV or another non-Excel file renamed to .xlsx.
Glossary
Definitions of the most important terms used by this tool.
XLS
The older binary Microsoft Excel workbook format commonly used by Excel 97-2003.
XLSX
The modern Microsoft Excel workbook format based on Office Open XML.
CSV
A plain-text tabular format in which fields are separated using a delimiter such as a comma, semicolon, tab or pipe.
Active Worksheet
The worksheet saved as the currently selected sheet inside an Excel workbook.
Delimiter
The character used to separate fields in the generated CSV file.
UTF-8
A widely used text encoding that supports characters from many languages.
Byte Order Mark
A short marker written at the beginning of the CSV file to help applications such as Microsoft Excel recognise UTF-8 encoding.
ZIP Archive
A compressed package used to download multiple worksheet CSV files together.
Frequently Asked Questions
Can I convert XLSX to CSV?
Yes. SwiftVecto supports modern XLSX workbooks.
Can I convert XLS to CSV?
Yes. Legacy XLS workbooks are also supported.
Can I export only one worksheet?
Yes. Active Worksheet mode exports the worksheet saved as active in the uploaded workbook.
Can I export every Excel worksheet?
Yes. All Worksheets mode exports every sheet into its own CSV file and packages the files together as a ZIP archive.
Why can CSV not contain multiple worksheets?
CSV is a plain-text table format and has no concept of workbook tabs or worksheets. Each worksheet therefore requires its own CSV file.
Can I choose the CSV delimiter?
Yes. You can choose comma, semicolon, tab or pipe.
What delimiter should I use?
Comma is the most common general-purpose option. Use another delimiter when the receiving system specifically requires it.
What happens to Excel formulas?
CSV cannot store live Excel formulas. SwiftVecto exports calculated formula values where PhpSpreadsheet can calculate them.
Will formatting be preserved?
No. CSV stores data only. Fonts, colours, borders, merged cells, charts, images and other Excel formatting are not part of the CSV format.
Will leading zeros be preserved?
CSV itself stores text representations of values, but how another application displays them after opening the CSV depends on that application's import and type-detection behaviour.
What encoding does SwiftVecto use?
Generated CSV files use UTF-8 with a byte order mark for broad spreadsheet compatibility.
Does it support empty worksheets?
When All Worksheets is selected, SwiftVecto exports workbook sheets even if they contain little or no data rather than silently omitting them.
Can it convert password-protected Excel files?
No. Password-protected or encrypted workbooks must be unlocked before conversion.
Does SwiftVecto alter my Excel workbook?
No. The uploaded workbook is copied into an isolated processing workspace and remains unchanged.
Things to Know
- One Excel workbook is processed per conversion.
- XLS and XLSX source files are supported.
- Active Worksheet mode generates one CSV download.
- All Worksheets mode generates one CSV per worksheet and packages them into a ZIP archive.
- Comma, semicolon, tab and pipe delimiters are supported.
- Generated CSV uses UTF-8 with a byte order mark.
- CSV output uses CRLF line endings for broad Windows compatibility.
- CSV cannot preserve workbook formatting or multiple sheets.
- Supported formulas are exported using calculated values.
- Worksheet order is preserved in all-worksheet exports.
- Generated worksheet filenames are sanitised for filesystem safety.
Disclaimer
CSV is a simpler format than Excel and cannot preserve formatting, charts, images, formulas as formulas, merged cells or workbook-level features.
Formula calculation may not perfectly reproduce every advanced Excel function or external workbook reference.
The application used to open a CSV may automatically reinterpret dates, numbers or leading-zero identifiers.
Password-protected or encrypted Excel files cannot be processed.
Users should review important exported datasets before relying on them for financial, legal, operational or other critical workflows.