How to Convert Excel to CSV: Step-by-Step Guide

Convert Excel to CSV

Converting Excel to CSV matters most when your excel data needs to move somewhere that does not read xlsx files. APIs, SQL databases, and import tools for websites and CRMs almost always expect a plain csv file, not a full excel workbook.

Microsoft Excel, part of the Microsoft Office suite, is usually the source, while the destination is a database, an analytics dashboard, or a data science pipeline built for data exchange. Most data analysis tools accept CSV, since it is the safest format for data moving between unrelated systems.

A CSV file also strips out formulas, formatting, and multiple sheets. That keeps the file size small, but it means you should always convert from a saved copy of your spreadsheet, never your only source file.

This guide walks through the standard Save As method to convert excel to csv, the CSV UTF-8 format for special characters, a VBA macro to convert multiple excel sheets to csv, csv converter options beyond Excel, and the fix for leading zeros that get dropped during conversion.

Before You Convert Excel to CSV

A few checks before you convert Excel to CSV will save you a redo later.

• Save a copy of your original xlsx file first, since a csv file cannot store formulas, formatting, or multiple sheets.
• Decide which sheet holds the excel spreadsheet data you need, since CSV export only saves the worksheet that is active.
• Check for leading zeros, phone numbers, or ID codes that Microsoft Excel might convert to plain numbers.
• Check for accented characters, currency symbols, or non-English text that need UTF-8 encoding to display correctly.

Method 1: Convert Excel to CSV With Save As (Comma Delimited)

This is the built-in, no-setup way to convert excel to csv.

Steps

1. Open the workbook and click the sheet you want to export.
2. Go to File, then Save As, or press F12 for the dialog.
3. Choose a save location and keep or edit the file name.
4. Open the file type dropdown and choose CSV (Comma delimited).
5. Click Save, then click Yes when Excel warns that some features are not compatible with the CSV format.

Best for: A single sheet of plain text and numbers, no special characters or leading zeros to protect.

Excel only ever saves the active sheet to a csv file. If your workbook has several sheets, repeat these steps for each one, or use the VBA macro in Method 3.

Both an xls file and a newer xlsx file convert the same way, though older xls formats sometimes need the Text Import Wizard to preserve special characters.

Method 2: Convert Excel to CSV UTF-8

Standard CSV format uses your system's default encoding, which can turn accents, currency symbols, or non-Latin text into garbled characters once the file is opened elsewhere.

Steps

1. Go to File, then Save As, or press F12.
2. Choose a save location and file name.
3. Open the file type dropdown and choose CSV UTF-8 (Comma delimited).
4. Click Save, then click Yes on the compatibility warning.

Best for: Data with accented letters, non-English text, or symbols that need to display correctly in other software.

If your version of Excel does not show a CSV UTF-8 option in the Save as type dropdown, open the Save As dialog, choose CSV (Comma delimited), click Tools, then Web Options, and set the Encoding tab to Unicode (UTF-8) before saving.

This workaround covers Excel 2007 and other older editions that predate the built-in UTF-8 file format. Once your file is utf-8 encoded, accented letters and symbols display correctly in every downstream tool.

Method 3: VBA Macro to Convert Multiple Excel Sheets to CSV

Save As only handles one worksheet at a time. A short macro converts every sheet in the workbook to its own CSV file in one run. This is far faster than a manual repeat for a large workbook.

It works whether you need to convert excel files to csv one at a time or convert dozens of files to csv format in a single run. For a large batch, exporting excel files to csv format automatically saves real time compared with repeating Method 1 by hand.

Excel Formula

Sub ExportAllSheetsToCSV()

Dim wb As Workbook

Dim ws As Worksheet

Dim wbNew As Workbook

Dim savePath As String

Set wb = ActiveWorkbook

savePath = wb.Path & ""

For Each ws In wb.Worksheets

ws.Copy

Set wbNew = ActiveWorkbook

Application.DisplayAlerts = False

wbNew.SaveAs Filename:=savePath & ws.Name & ".csv", _

FileFormat:=xlCSV

Application.DisplayAlerts = True

wbNew.Close SaveChanges:=False

Next ws

MsgBox "Done. Each sheet was saved as its own CSV file."

End Sub

Steps

1. Open the workbook and press Alt+F11 to open the VBA editor.
2. Click Insert, then Module.
3. Paste the code above into the module window.
4. Press F5 to run the macro.
5. Check the workbook's folder for one sheet per file, each named after its worksheet.

Best for: Workbooks with multiple sheets that all need to become separate CSV files without repeating Save As by hand.

You may need to enable macros in Trust Center settings if Excel blocks the macro from running. Back up your workbook first, since the macro creates and closes new files automatically.

This same loop structure can be adapted to export to other formats or push rows into a SQL table.

CSV Converter Options Beyond Excel

If you do not have Excel installed, or need a free online way to convert xlsx to csv, a few alternatives cover most cases.

• Google Sheets opens xlsx files and exports File > Download > CSV automatically in UTF-8, with no extra encoding steps and no hidden fees.
• A free online csv converter or xls to csv converter accepts an xlsx or xls upload and returns a converted file, useful for a single quick conversion. Most tools use a simple file upload button, so you rarely need to install anything.
• Python's pandas library fits batch conversion, when you need to convert excel to csv online or offline for many large files at once without opening each one by hand.

Best for: Shared computers, one-off conversions, or batch conversion of many files without a full Excel license.

Whether you are looking for an xlsx to csv converter, want to convert xls to csv online, need a csv online free option, or just want a free xlsx to csv result, the same Google Sheets or online tool approach applies.

Some tools turn an excel file into csv format instantly through drag and drop, which is the fastest way to convert to csv without installing anything. Always check the csv output before importing it elsewhere, since a wrong delimiter can break the whole file.

A word of caution: uploading files to a free online converter means your data leaves your device. Keep sensitive spreadsheets, such as recipient lists or financial records, inside Excel or another trusted tool with strong data security instead.

Method 4: Keep Leading Zeros When You Convert Excel to CSV

Standard CSV format drops leading zeros from ID numbers, ZIP codes, and phone numbers because Excel treats them as plain numbers, not as text.

Steps

1. Select the column that contains the leading zeros.
2. Right-click and choose Format Cells.
3. On the Number tab, choose Text, then click OK.
4. Re-enter or reformat the raw data so Excel stores it as text.
5. Save As CSV as usual using Method 1 or Method 2.

Best for: Account numbers, ZIP codes, or product codes that must keep their exact digit count and preferred format.

Formatting the column as text before you save keeps the digits in a simple text format that survives the CSV save. Opening that CSV file back up in Excel will still drop them again, since Excel reformats numbers on open, not on save.

To avoid that, import the csv file using Data > From Text/CSV and set that column's file format to Text during import. CSV files store raw data only, which keeps file size down but drops every visual cue.

Excel to CSV Conversion Methods Compared

Common Excel to CSV Mistakes and Fixes

• Only one sheet exports: Save As only saves the active sheet. Repeat per sheet or use the VBA macro in Method 3.
• Leading zeros disappear: Format the column as Text before saving, and import, rather than open, the csv file afterward.
• Accented characters look garbled: Use the CSV UTF-8 format instead of standard CSV.
• Renaming xlsx to .csv instead of converting: This only changes the file type. Always use Save As to actually convert the file format.
• Formulas and formatting go missing: This is expected. A CSV file only stores your data as plain text, not formulas, so keep your original xlsx as a backup.

After Your Excel File Is Ready

Preparing your spreadsheet is only the first step. If you're creating certificates for employees, students, event attendees, or training participants, you'll eventually need to generate and distribute those credentials. With Wauld, you can:

• Upload a CSV file in minutes
• Generate thousands of personalized certificates or badges
• Automatically populate names, dates, IDs, and other dynamic fields
• Add QR-code verification
• Email credentials to recipients automatically
• Track opens, downloads, and shares from a single dashboard Instead of manually creating certificates one by one after preparing your Excel sheet, you can automate the entire issuance workflow.

Learn more about preparing a spreadsheet for bulk certificate issuance or see how teams connect Excel data straight into Wauld for automated delivery.