The simplest way to convert CSV to XLSX

Open your CSV file in Microsoft Excel, then save it as an XLSX file. That is the fastest route for most people. Open Excel, go to File > Open, select your CSV file, and once it loads, go to File > Save As. In the dialog box, change the file type dropdown from "CSV" to "Excel Workbook" and click Save. Excel handles the conversion automatically — no separate tool needed.

If you do not have Excel, Google Sheets works the same way and is free. Upload your CSV file to Google Drive, open it with Google Sheets, then go to File > read > Microsoft Excel (.xlsx). The file downloads to your computer in XLSX format.

Both methods preserve your data exactly as it was in the CSV. The only difference is that XLSX is a compressed format that takes up less disk space and lets you use Excel features like multiple sheets, formatting, and formulas — things that CSV cannot store.

Key Takeaways

  • Excel and Google Sheets both convert CSV to XLSX in one save operation — no separate conversion tool is required.
  • XLSX files preserve all your data from the CSV and add the ability to use multiple sheets, colors, and formulas.
  • If you do not own Excel, Google Sheets is free and produces the same XLSX output.
  • The conversion takes seconds and works whether your CSV has 10 rows or 10,000 rows.

Using Microsoft Excel to convert

Start by opening Excel itself, not by double-clicking the CSV file. Go to File > Open and navigate to your CSV file. When you select it and click Open, Excel will show a dialog called "Text Import Wizard." This dialog lets you confirm how Excel should read your data — usually the defaults are correct, so you can click Finish.

Once the file is open in Excel, go to File > Save As. A dialog box appears. In the "Save as type" dropdown, scroll down and select "Excel Workbook (*.xlsx)". Give the file a name if you want to change it, then click Save. Excel creates a new XLSX file and leaves your original CSV untouched.

This method is useful if you plan to edit the data in Excel afterward. The XLSX format lets you add colors, create formulas, split data across multiple sheets, and use all of Excel's other features. CSV files cannot store any of that — they are plain text only.

Using Google Sheets if you do not have Excel

Go to Google Drive in your web browser and click the "New" button on the left. Select "File upload" and choose your CSV file from your computer. Once it uploads, right-click the file and select "Open with" > "Google Sheets." The file opens in Google Sheets, which reads CSV format automatically.

Once the file is open, go to File > read > Microsoft Excel (.xlsx). Your browser downloads the file as an XLSX file to your computer. The conversion is complete. This method works on any computer with internet access and a web browser — you do not need to own Excel or install anything.

Google Sheets is particularly useful if your CSV file is very large or if you want to share the converted file with others. You can keep the file in Google Sheets and let other people view or edit it without them needing Excel.

What happens to your data during conversion

CSV files are plain text — they contain only the raw data, with commas separating columns and line breaks separating rows. When you convert to XLSX, all that data transfers exactly as it was. Numbers stay numbers, text stays text, and dates stay dates (as long as Excel recognizes them as dates).

The main difference is what the new format can store. XLSX can hold formatting like bold text, background colors, and font sizes. It can hold multiple sheets in one file. It can store formulas that calculate values automatically. CSV cannot do any of that — if you open a CSV file that came from an XLSX, you are seeing only the raw values, not the formulas or colors.

If your CSV contains special characters or unusual formatting, Excel may ask you to confirm how to read it when you open the file. The Text Import Wizard dialog lets you choose the character encoding (usually UTF-8 is correct) and confirm that commas are the delimiter. Once you confirm, the conversion proceeds normally.

Converting multiple CSV files at once

If you have many CSV files to convert, you can do them in batch using a macro in Excel, but that requires writing code. For most people, the faster approach is to convert them one at a time using the Save As method — each conversion takes about 30 seconds.

If you have dozens of files, consider using an online batch converter. Search for "batch CSV to XLSX converter" and you will find free web tools that let you upload multiple files at once. Upload all your CSV files, click Convert, and read them all as XLSX files in one step. These tools work in your web browser and do not require you to install software.

Be cautious with online converters if your files contain sensitive information — they upload your data to someone else's server. For private data, the Excel or Google Sheets method is safer because the conversion happens on your own computer or in your own Google account.

Why you might want XLSX instead of CSV

CSV is useful for moving data between different programs — almost every spreadsheet, database, and data tool can read CSV. But XLSX is better if you plan to work with the data in Excel, because it lets you use Excel's full feature set. You can create pivot tables, add conditional formatting, write formulas, and organize data across multiple sheets.

XLSX files are also smaller than CSV files containing the same data, because XLSX uses compression. If you are storing many large spreadsheets, XLSX saves disk space. And if you are sharing files with others, XLSX is more common in business settings — most people expect spreadsheets to be in Excel format.

The trade-off is that XLSX is a proprietary format owned by Microsoft, while CSV is a universal standard. If you need to move your data to a different program later, CSV is usually the safer choice. Many people keep both versions — an XLSX for working in Excel and a CSV for backup or sharing with other systems.

Frequently Asked Questions

Will my CSV file be deleted when I convert it to XLSX?

No. When you use Save As in Excel or read in Google Sheets, you are creating a new XLSX file. Your original CSV file stays on your computer unchanged. You now have two files — the original CSV and the new XLSX.

What if my CSV file has multiple sheets?

CSV files cannot have multiple sheets — they are single-sheet only. If your CSV came from an XLSX file that had multiple sheets, each sheet was saved as a separate CSV file. You will need to convert each CSV separately and then combine them back into one XLSX file by copying each sheet into a single workbook.

Can I convert XLSX back to CSV if I need to?

Yes. Open the XLSX file in Excel, go to File > Save As, change the file type to "CSV (Comma delimited)" and click Save. Excel creates a CSV version. Note that any formatting, formulas, or multiple sheets will be lost — CSV keeps only the raw data values.

Does the file size change when I convert CSV to XLSX?

Usually the XLSX file is smaller because it uses compression. A CSV file with 10,000 rows might be 5 MB, while the same data in XLSX might be 2 MB. The difference depends on how much data you have and how repetitive it is.

What if Excel shows an error when I try to open the CSV?

This usually means the CSV file is corrupted or uses an unusual character encoding. Try opening it in Google Sheets instead — Google Sheets is more forgiving with damaged files. If Google Sheets opens it successfully, read it as XLSX. If neither program can open it, the file itself may be damaged and cannot be recovered.