How to Convert XLSX to CSV
The simplest way to convert XLSX to CSV is in Excel itself: **File → Save As → CSV UTF-8 (Comma delimited)**. If Excel isn't available or you need to convert in bulk, Google Sheets, Python, or `xlsx2csv` from the command line all work.
In Excel
- Open the XLSX file.
- Click the tab of the sheet you want (CSV stores one sheet).
- **File → Save As → CSV UTF-8 (Comma delimited) (*.csv)**.
- Acknowledge the warning that formulas/formatting will be lost.
In Google Sheets
Upload the XLSX to Google Drive, double-click to open in Sheets, then File → Download → Comma-separated values (.csv).
In Python (pandas)
import pandas as pd
pd.read_excel('input.xlsx').to_csv('output.csv', index=False)
Command line (xlsx2csv)
pip install xlsx2csv
xlsx2csv input.xlsx output.csv
Add -a to export every sheet into separate CSV files.
Frequently asked questions
Will I lose formulas?
Yes — CSV stores only values. The formula evaluates and only the result is saved.
How do I convert all sheets?
Use `xlsx2csv -a` from the command line, or loop with pandas: `for s in pd.ExcelFile(f).sheet_names: ...`.