FormatDrop
How-To Guide

How to Convert CSV to Excel (XLSX)

CSV files are plain text — just values separated by commas. Converting to XLSX adds column formatting, data types, formulas, charts, and the full power of Excel. This is a common step when receiving data exports from databases, APIs, or software that outputs CSV.

Open CSV to XLSX Converter

Step-by-step instructions

  1. 1

    Open CSV in Excel and save as XLSX

    In Excel, go to File → Open → browse for the CSV file. Excel opens the Text Import Wizard — set the delimiter (comma, semicolon, tab), column types, and encoding. After importing, go to File → Save As → choose Excel Workbook (.xlsx). This is the simplest approach for a single file.

    Go to converter
  2. 2

    Drag-and-drop into Excel

    Drag the CSV file directly into an open Excel window. Excel opens it as a new workbook. Check that columns are parsed correctly — date columns, number columns, and text columns should be recognised. If dates or numbers appear as text, select the column and use Data → Text to Columns to reparse. Then save as XLSX.

  3. 3

    Convert using Python pandas

    For batch conversion or automation: `import pandas as pd; df = pd.read_csv('input.csv'); df.to_excel('output.xlsx', index=False, engine='openpyxl')`. Install requirements: `pip install pandas openpyxl`. This preserves data types correctly and works on any platform. Add `sheet_name='Sheet1'` to name the output sheet.

  4. 4

    Format the XLSX after conversion

    After converting, apply formatting: select number columns and format as Number or Currency. Set date columns to Date format. Freeze the header row (View → Freeze Panes → Freeze Top Row). Add an AutoFilter (Data → Filter). Resize columns to fit (select all, then Format → AutoFit Column Width). These steps make the XLSX more usable than the raw CSV import.

Why convert CSV to XLSX?

CSV files are just data — no formatting, no formulas, no charts. Converting to XLSX lets you add all the analytical power of Excel: pivot tables, charts, conditional formatting, formulas, and professional presentation. This is standard practice when receiving data exports for reporting or analysis.

Your files never leave your device

FormatDrop runs the conversion engine entirely inside your browser using WebAssembly. No file upload. No server. Nothing stored. You can verify this by opening DevTools → Network tab and watching: zero upload requests.

Frequently asked questions

Why does my CSV open incorrectly in Excel?
Common issues: wrong delimiter (CSV uses commas, but some regions use semicolons — check the file's actual delimiter and set it correctly in the import wizard). Date formats parsed as text (Excel may not recognise international date formats). Encoding issues (use UTF-8 encoding when saving CSV). Use Data → From Text/CSV in Excel for more control over the import.
How do I convert multiple CSV files to XLSX at once?
Python pandas: `import os, pandas as pd; [pd.read_csv(f).to_excel(f.replace('.csv','.xlsx'), index=False, engine='openpyxl') for f in os.listdir('.') if f.endswith('.csv')]`. LibreOffice macro can also batch-convert. Excel's Power Query can combine multiple CSV files into one XLSX (Data → Get Data → From File → From Folder).
Can I add formulas when converting CSV to XLSX?
Not automatically during conversion — formulas must be added after converting. Once the CSV is open as XLSX, you can add formulas normally. A good workflow: convert CSV to XLSX, then use an Excel template that adds the required formulas automatically via Power Query or VBA.
Convert CSV to XLSX Now — Free

No account. No upload. Works in any browser.

More guides

How to Convert HEIC to JPGHow to Convert PNG to PDFHow to Convert MOV to MP4How to Convert WebP to JPG