Home › Guides
XLSX and CSV guides
Plain-English walkthroughs for turning Excel files into CSV (and back), whatever software you have, and for fixing the problems that turn up along the way.
How to convert XLSX to CSV in Excel
Save As on Windows, Mac and the web, which of the four CSV types to pick, and a macro for every sheet.
Read the guide →How to convert XLSX to CSV in Google Sheets
Upload to Drive, open in Sheets, download as CSV. Plus the encoding and size limits to know about.
Read the guide →How to convert XLSX to CSV on a Mac
Use the free Numbers app, Excel for Mac, or your browser. No extra software needed.
Read the guide →How to convert every sheet in an Excel file to CSV
One click in the browser, an Excel macro, Python and pandas, or one LibreOffice command.
Read the guide →Fix garbled characters, lost leading zeros and other CSV problems
Why accents turn into é, zeros vanish and long numbers become E+15, and how to fix each one.
Read the guide →XLSX vs CSV: what's the difference?
Sheets, formatting, formulas, limits and compatibility compared, and when to use each format.
Read the guide →How to convert XLSX to CSV in Python
pandas for every sheet, openpyxl for huge files, engines for .xls/.xlsb/.ods, and the formatting catch.
Read the guide →How to convert XLSX to CSV from the command line
LibreOffice, csvkit, PowerShell and ssconvert commands for batch jobs, every sheet and UTF-8.
Read the guide →How to convert CSV to Excel properly
Import a CSV into Excel without losing zeros, long numbers or accents, then save as XLSX.
Read the guide →Just want the CSV? Convert any .xlsx file in seconds.
Open the converter