# XLSX CSV Batch Converter

Batch convert CSV/TSV to XLSX or convert XLSX back to CSV/TSV with delimiter and encoding handling

> Canonical page: https://test.elysiatools.com/en/tools/xlsx-csv-batch-converter

- **Category:** Format Conversion

- **Keywords:** xlsx, csv, tsv, batch, encoding, delimiter, excel

## Overview

Batch conversion for spreadsheet text formats.

- CSV/TSV/TXT -> XLSX
- XLSX/XLS -> CSV/TSV
- Auto mode detects direction by extension

Designed to reduce delimiter and text-encoding problems in cross-platform workflows.

## Inputs

- **Source Files** (file)
- **Conversion Mode** (select)
- **Source Text Encoding** (select)
- **Output Text Encoding** (select)
- **Input Delimiter** (select)
- **Output Delimiter** (select)
- **Sheet Name** (text): Sheet1
- **Include Header** (checkbox)
- **Always Return ZIP** (checkbox)

## When to use

- You have multiple CSV or TSV exports that need to be packaged into formatted XLSX spreadsheets.
- You need to export Excel workbooks to CSV with UTF-8 BOM, GBK, or Shift_JIS encoding to avoid display errors in regional spreadsheet tools.
- You have data tables using tabs, semicolons, or pipes that need conversion into comma-separated files or Excel sheets.

## How it works

- Upload up to 50 files (.csv, .tsv, .txt, .xlsx, or .xls, each up to 100 MB) under Source Files.
- Set Conversion Mode to Auto by Extension, CSV/TSV to XLSX, or XLSX to CSV/TSV.
- Adjust Input Delimiter, Output Delimiter, Source Text Encoding, Output Text Encoding, or Sheet Name as required by your target application.
- Download the converted output file, which is packaged as a ZIP archive if multiple files are processed or if Always Return ZIP is enabled.

## Use cases

- Bulk Vendor Import: Converting heterogeneous CSV and TSV partner catalogs into uniform XLSX workbooks named Sheet1 for back-office review.
- Cross-Platform CSV Export: Converting XLSX workbooks into UTF-8 with BOM comma-delimited files for accounting software that misinterprets plain UTF-8.
- Separator Migration: Converting semicolon- or pipe-delimited server log exports into standard comma-delimited CSVs in bulk.

## Frequently asked questions

### What file formats and batch limits does this converter support?

It accepts .csv, .tsv, .txt, .xlsx, and .xls files, supporting up to 50 files per run; each file may be up to 100 MB (104,857,600 bytes). The file count and size limits are separate.

### Why is UTF-8 with BOM the default output encoding for CSVs?

The UTF-8 Byte Order Mark (BOM) signals to desktop spreadsheet software, including Microsoft Excel, that non-ASCII characters should be rendered without text corruption.

### How does Auto by Extension mode work?

It inspects each file extension: .csv, .tsv, and .txt files are converted to XLSX, while .xlsx and .xls files are converted to delimited text.

### Which text delimiters can be configured?

Input and output delimiters support Comma (,), Semicolon (;), Tab (\t), and Pipe (|). The input delimiter also includes an Auto Detect option.

### Can I exclude the header row from the output?

For CSV/TSV to XLSX, unchecking Include Header adds a synthetic header (Column 1, Column 2, ...) and keeps all data rows. For XLSX to CSV/TSV, it omits the first row. Check the output before using it.

### Which worksheet is used for XLSX to CSV/TSV?

The converter uses the worksheet named in Sheet Name; if that name is not found, it falls back to the workbook's first worksheet.

## Related tools

- [Subtitle Translation Sheet (CSV Excel)](https://test.elysiatools.com/en/tools/subtitle-translation-sheet): Round-trip subtitles through the spreadsheets translation teams actually use: export SRT/VTT cues to a CSV or Excel table (index, start, end, source, target, notes) and re-import the filled sheet as translated SRT — timings locked, in-cell line breaks preserved, and semicolon CSV with UTF-8 BOM for European Excel.
- [JSON-LD Generator from CSV](https://test.elysiatools.com/en/tools/json-ld-generator-from-csv): Turn CSV or Excel rows into Schema.org JSON-LD for articles, products, or events, with validation-ready output for SEO workflows
- [XLSX Sheet to CSV Pack](https://test.elysiatools.com/en/tools/xlsx-sheet-to-csv-pack): Export each Excel worksheet as an individual CSV file and include a manifest with schema/statistics
- [Excel to CSV Converter](https://test.elysiatools.com/en/tools/excel-to-csv): Convert Excel file to CSV format, extracting data from the first worksheet
- [Time Series Forecast & Seasonality Analyzer](https://test.elysiatools.com/en/tools/time-series-forecast-seasonality-analyzer): Forecast future periods from CSV or JSON time-series data and inspect trend, seasonal, and residual decomposition in one report
- [XLSX Multi Sheet Splitter](https://test.elysiatools.com/en/tools/xlsx-multi-sheet-splitter): Split a multi-sheet workbook into independent files by sheet name, with ZIP output
- [CSV / Excel Diff Tool](https://test.elysiatools.com/en/tools/csv-excel-diff-tool): Compare two CSV or XLSX datasets and export a PDF report with row, column, and cell-level differences
- [Time Series Anomaly Detector](https://test.elysiatools.com/en/tools/time-series-anomaly-detector): Upload CSV or JSON time series data, detect anomalies with Z-Score and IQR methods, and return a chart-backed report

## Samples

- [XLSX Samples](https://test.elysiatools.com/en/samples/xlsx-samples): Sample XLSX spreadsheets for worksheet parsing and data extraction testing
- [XLS Samples](https://test.elysiatools.com/en/samples/xls-samples): Sample legacy Excel (XLS) files for binary spreadsheet parsing and import tests
- [Windows String Processing - C# Samples](https://test.elysiatools.com/en/samples/windows-string-processing-csharp): Comprehensive C# string processing examples for Windows platform including string manipulation, splitting, joining, regex operations, and text analysis
- [CSV Samples](https://test.elysiatools.com/en/samples/csv-samples): Sample CSV files with various data types, sizes, and complexity levels

## Related content

- [XLSX ETL Ingestion and Warehouse Handoff](https://test.elysiatools.com/en/hubs/xlsx-etl-ingestion-workflows): Turn mixed workbook and CSV sources into traceable, schema-aware outputs for SQL loading, Parquet pipelines, and object-storage batch handoff.
- [Tabular Data Conversion Workflow](https://test.elysiatools.com/en/hubs/csv-convert): Convert CSV, spreadsheets, JSON, HTML tables, Markdown, XML, and text while checking headers, delimiters, types, and encoding.
