How To Convert CSV to Excel

To convert a CSV to Excel, open Excel, go to Data, Get Data, From Text/CSV, pick your file, check the delimiter in the preview, and click Load. Then File, Save As and choose Excel Workbook (.xlsx). Opening the CSV by double-clicking works too, but it does not convert anything: the file stays a CSV until you save it as .xlsx.

That is the whole job in one paragraph. The reason this guide is longer is that Excel quietly damages CSV data on the way in. Leading zeros disappear, long numbers turn into 1.23E+11, dates flip between formats, and sometimes every column lands in column A. This guide covers four conversion methods and, more importantly, how to stop each of those things happening.

Last updated: August 23, 2026

What this guide covers

• What is a CSV file, and why convert it to Excel?
• CSV, XLS or XLSX: which format do you actually want?
• Method 1: Open the CSV directly in Excel
• Method 2: Import with Power Query (recommended)
• Method 3: Import with the Text Import Wizard
• Method 4: Convert multiple CSV files at once
• Which method should you use?
• Why does my CSV open with everything in one column?
• How do you stop Excel damaging your data?
• How to save the CSV as an Excel workbook
• Converting the other way: Excel to CSV
• Frequently asked questions

What Is a CSV File, and Why Convert It to Excel?

A CSV (Comma-Separated Values) file is a plain text file where each line is a row and commas separate the values. It is the standard way systems hand data to each other, which is why almost every export button on the internet gives you one. Have a look inside one in Notepad and you will see the whole format: there is nothing to it but text and commas.

That simplicity is the point, and it is also the limitation. A CSV stores values and nothing else. It cannot hold a formula, a chart, a colour, a column width, a second sheet or a cell format. Convert it to Excel and you get all of that:

• Better data organization: Excel allows sorting, filtering, and formatting.

• Advanced data analysis: Excel provides powerful formulas and pivot tables.

• Graphical representation: Easily create charts and graphs.

• Preserve formatting: Unlike CSV, Excel retains bold text, colors, and custom cell formats.

• Multiple sheets: A CSV is one sheet by definition. An Excel workbook holds as many as you need.

The rule to remember: opening a CSV in Excel is not converting it. Double-click a CSV and Excel displays it happily, but the file on disk is still a CSV, still one sheet, and still incapable of saving a formula. Nothing is converted until you use Save As and pick a workbook format.

CSV, XLS or XLSX: Which Format Do You Actually Want?

Almost everybody wants .xlsx. It is worth thirty seconds to know why, because the file type dropdown offers all three and .xls is a trap.

Why .xls is a trap: it silently truncates. Save a 100,000-row CSV as .xls and you keep 65,536 rows. Excel warns you, the warning is easy to click past, and the missing rows are not obviously missing. If a search brought you here looking to convert CSV to XLS specifically, check first whether the system you are feeding really needs .xls, because most modern software accepts .xlsx.

Method 1: Open the CSV Directly in Excel

The quickest route. Excel opens the file, but remember it remains in CSV format until you save it as a workbook.

• Open Microsoft Excel.

• Click File > Open.

• Navigate to the location of your CSV file.

• In the file type dropdown at the bottom right, select Text Files or All Files so the CSV is visible. If the dropdown shows the filter pattern, it reads *.prn; *.txt; *.csv.

• Select your CSV file and click Open to launch it in a new Excel worksheet.

• Then go to File > Save As and choose Excel Workbook (.xlsx). Skipping this step is the most common mistake with this method.

The catch: this method gives you no control at all. Excel guesses the delimiter, guesses which columns are numbers and which are dates, and applies those guesses before you see anything. If your data has leading zeros, long ID numbers or non-US dates, use Method 2 instead. Once Excel has stripped a leading zero on open, there is no undo that brings it back.

Method 2: Import with Power Query (Recommended)

Power Query is the method to use for anything that matters. You see a preview before anything is imported, you set the data type per column, and the import is repeatable.

1. Open Excel and go to Data > Get Data > From File > From Text/CSV.

   

2. Select your CSV file and click Import.

3. In the preview window, check three things: the File Origin (the encoding, usually UTF-8), the Delimiter, and whether the columns look right in the preview grid.

4. If everything looks correct, click Load to bring the data into Excel.

   

5. If anything needs adjusting, click Transform Data to open the Power Query Editor. Here you can remove blank rows, rename columns, and most importantly right-click a column and choose Change Type > Text to protect codes and IDs.

6. When you are done, click Close & Load.

The single most useful thing in this method: in the Power Query Editor, set any column of IDs, postcodes, product codes or phone numbers to Text before loading. That one action prevents leading zeros vanishing and long numbers turning into scientific notation, which are the two ways CSV imports most often destroy data.

Why use Power Query?

• Handles large datasets better than the Text Import Wizard.

• Allows for automated transformations such as removing blank rows and renaming columns.

• Supports data updates when the source file changes. Click Data > Refresh All and the import runs again with the same settings.

• It is non-destructive. The original CSV is never modified.

Method 3: Import with the Text Import Wizard

The older wizard still exists and some people prefer its three-step layout. There is one step nearly every guide leaves out, and without it the menu path below does not exist.

Turn it on first. The Text Import Wizard is hidden by default in current versions of Excel. Go to File > Options > Data, and under Show legacy data import wizards, tick From Text (Legacy). Click OK. This is documented in Microsoft's own Text Import Wizard reference. If you skipped this and cannot find Legacy Wizards on the Data tab, that is why.

1. Open Excel.

2. Click Data > Get Data > Legacy Wizards > From Text (Legacy).

   

3. Select your CSV file and click Import.

4. In the Text Import Wizard, choose Delimited and click Next.

   

5. Tick the correct delimiter (Comma, Semicolon, or Tab) and watch the preview pane update, then click Next.

6. This is the important step. Click each column header in the preview and set its column data format. Choose Text for anything with leading zeros or more than 15 digits, and use Date with the correct order (DMY or MDY) for date columns.

7. Click Finish, then OK to place the data on the sheet.

Wizard or Power Query? The wizard is quicker for a one-off file where you just need to force two columns to Text. Power Query is better for anything you will repeat, anything large, or anything where you need to see the encoding before committing.

Method 4: Convert Multiple CSV Files at Once

If you have a folder of CSV files, do not open them one at a time. There are two good routes.

Batch convert a folder with Power Query

1. Put every CSV in one folder, with no other files in it.
2. In Excel, go to Data > Get Data > From File > From Folder and select that folder.
3. Click Combine & Transform Data. Excel uses the first file as a template for the rest.
4. Check the preview, set any column that needs it to Text, and click Close & Load.
5. All the files land in one table, with a Source.Name column showing which file each row came from.

This gives you one combined workbook. If you need each CSV as its own separate .xlsx file instead, use the macro below.

Batch convert to separate workbooks with VBA

Paste this into a module (Alt + F11 to open the VBA editor, then Insert > Module) and press F5. It asks you to pick one or more CSV files and saves an .xlsx alongside each one.

Sub ConvertCSVtoExcel()

    Dim files As Variant, f As Variant

    Dim wb As Workbook, newName As String

    files = Application.GetOpenFilename("CSV Files (*.csv), *.csv", , "Select CSV Files", , True)

    If Not IsArray(files) Then Exit Sub

    Application.DisplayAlerts = False

    For Each f In files

        Set wb = Workbooks.Open(f)

        newName = Left(f, InStrRev(f, ".") - 1) & ".xlsx"

        wb.SaveAs newName, FileFormat:=xlOpenXMLWorkbook

        wb.Close False

    Next f

    Application.DisplayAlerts = True

    MsgBox "Converted " & UBound(files) & " file(s) to .xlsx", vbInformation

End Sub

Two things worth knowing about this macro. It builds the new filename with InStrRev to find the last dot, rather than a find-and-replace on ".csv", because a replace would also rename any folder in the path containing that string. And because it uses Workbooks.Open, Excel applies its default guesses to your data. If leading zeros matter, use Power Query rather than this macro.

Which Method Should You Use?

Why Does My CSV Open With Everything in One Column?

This is the most common CSV complaint there is, and it is always a delimiter mismatch. Your file separates values with one character and Excel is looking for a different one.

Three causes, in the order they are likely:

1. The file uses semicolons, not commas. This is standard in most of Europe and South America, where the comma is the decimal separator. A file exported in Germany or Brazil will usually be semicolon-separated even though it is still called a CSV.
2. Your Windows list separator does not match the file. When you double-click a CSV, Excel does not examine the file. It uses the List separator from your Windows regional settings. If that is a comma and the file uses semicolons, everything lands in column A.
3. The file starts with a sep= line. Some systems write sep=; as the first line to declare the delimiter. Excel honours it when opening, but some other tools show it as a stray first row.

Three fixes, easiest first:

• Import instead of opening. Method 2 shows a Delimiter dropdown in the preview. Change it to Semicolon, watch the preview split into columns, click Load. This is the right answer and takes about ten seconds.
• Split it after the fact with Text to Columns. If the data is already sitting in column A, select the column, go to Data > Text to Columns, choose Delimited, tick the delimiter that the file actually uses, and click Finish. Make sure there are enough empty columns to the right first, or you will overwrite data.
• Change the Windows list separator. Only if you open these files constantly. Go to Windows Settings, Time & language, Language & region, Regional format, Additional settings, and change List separator. This changes behaviour for every program on the machine, so it is a bigger hammer than most people need.

Quotable rule: double-clicking a CSV uses your computer's settings, importing a CSV uses the file's settings. That one sentence explains why the same file opens correctly on a colleague's machine and lands in one column on yours.

How Do You Stop Excel Damaging Your Data?

Excel converts as it reads. Most of the time that is helpful. On identifiers it is destructive, and it happens silently.

The rule that prevents almost all of this: if a column is an identifier rather than a quantity, make it Text on the way in. Order numbers, postcodes, phone numbers, SKUs and account references are not numbers you will ever do arithmetic on. Excel does not know that unless you tell it, and by the time you notice, the original digits are gone.

How To Save the CSV as an Excel Workbook

Once your CSV is opened or imported correctly, save it in Excel format to keep the formatting and features.

1. Click File > Save As.

2. Choose a location to save your file.

3. In the Save as type dropdown, select Excel Workbook (*.xlsx).

4. Click Save.

Note: Converting to Excel does not affect the original CSV file. You still have it, and you can go back to it if the import went wrong.

Watch for this prompt: if you edit a CSV in Excel and press Ctrl + S, Excel asks whether you want to keep the CSV format. Saying yes means anything Excel cannot store in a CSV, which is every formula, colour and extra sheet, is discarded without further warning. Use Save As and pick .xlsx instead.

Converting the Other Way: Excel to CSV

Sometimes you need the opposite, usually because a system will only accept a CSV upload.

1. Open the workbook and select the sheet you want to export. A CSV holds one sheet only, so if the workbook has several, Excel exports only the active one.
2. Go to File > Save As.
3. In Save as type, choose CSV UTF-8 (Comma delimited) (*.csv). Pick the UTF-8 version rather than plain CSV whenever your data contains accented or non-Latin characters, because plain CSV can mangle them.
4. Click Save and accept the warning about losing features.

Formulas are exported as their current results, not as formulas. If the receiving system needs the underlying values that is fine, but do not expect the calculations to survive the trip.

Conclusion

Converting a CSV to Excel is genuinely easy. Doing it without losing data takes one extra decision: before the data lands on the sheet, tell Excel which columns are identifiers rather than numbers. Power Query is the only method that makes that decision comfortable, which is why it is the recommendation here even though opening the file directly is faster.

If your columns arrived stacked in column A, that is a delimiter mismatch and not a broken file. Import it instead of opening it, pick the right delimiter in the preview, and it will come out right.

For more easy-to-follow Excel guides and the latest Excel Templates, visit Simple Sheets and the related articles section of this blog post.

Subscribe to Simple Sheets on YouTube for the most straightforward Excel video tutorials!

Frequently Asked Questions

How do I open a CSV file in Excel with proper columns?

Import it rather than double-clicking it. Go to Data, Get Data, From Text/CSV, select the file, and check the Delimiter dropdown in the preview window before clicking Load. If everything landed in column A because you opened it by double-clicking, the file almost certainly uses semicolons while your machine expects commas.

Can I convert multiple CSV files to Excel at once?

Yes, two ways. For one combined table, use Data, Get Data, From File, From Folder, then Combine and Transform Data. For a separate .xlsx per input file, use the VBA macro in Method 4, which lets you select several CSVs and saves a workbook alongside each one.

Will converting a CSV to Excel change my data?

It can, and this is the real risk. Excel strips leading zeros, converts IDs longer than 15 digits to scientific notation, and can read text such as MAR1 as a date. None of it is reversible afterwards. Set identifier columns to Text during the import and none of it happens.

Should I convert CSV to XLS or XLSX?

XLSX in almost every case. XLS is the pre-2007 format and caps out at 65,536 rows and 256 columns, so a large CSV gets silently truncated. Only choose XLS if a legacy system specifically requires it.

Why does my CSV show strange characters like Café instead of Café?

The file is UTF-8 and Excel opened it with a different encoding. Import via Data, Get Data, From Text/CSV and set File Origin to 65001: Unicode (UTF-8) in the preview window. Opening the file by double-clicking gives you no chance to set this.

Is opening a CSV in Excel the same as converting it?

No. Opening displays the data but the file on disk is still a CSV, so it still cannot hold formulas, formatting or a second sheet. The conversion happens when you use File, Save As and choose Excel Workbook (.xlsx).

Related Articles

Mastering Power Query in Excel: A Guide for Beginners

How To Convert Text to Numbers in Excel

How To Import and Export Data in Excel

How to Highlight Cells in Excel

How to Group Rows in Excel

How to Calculate Z-Score in Excel