How to Convert XLSX to CSV

Other ways to convert XLSX to CSV

1. 1

   Excel

   Open the workbook, click the sheet you want, then File → Save As → CSV UTF-8 (Comma delimited). Excel saves only the active sheet, so repeat for each sheet. Values are written the way the cells display them.

2. 2

   LibreOffice Calc (free)

   File → Save As → Text CSV, then choose the character set (UTF-8) and the field delimiter in the next dialog. Command line: soffice --headless --convert-to csv input.xlsx, which exports the first sheet.

3. 3

   Python pandas

   for name, df in pd.read_excel('input.xlsx', sheet_name=None).items(): df.to_csv(f'{name}.csv', index=False). sheet_name=None reads every sheet. Install with pip install pandas openpyxl. pandas writes the stored values, not the formatted ones.

4. 4

   Check the CSV

   Open it in a text editor: columns should be split by commas, and text that contains commas should sit inside quotes. Check date and long-number columns, since tools write them differently.