How to Convert CSV to Excel: The 4 Methods That Keep Your Data Intact (Power Query First)

CodexFuse Team · 2026-10-28T09:28:10.099Z · 13 min read

Converting CSV to Excel is easy — keeping the data intact is the hard part. Here are four methods, led by Power Query, that protect leading zeros, dates, and accented characters.

Learning how to convert CSV to Excel takes about five minutes — but keeping the data intact is where most people get caught out. A CSV file is plain text with values separated by commas, and Excel happily opens it. The trouble starts silently: a ZIP code like 02134 becomes 2134, a 16-digit order number turns into 1.2E+15, and a date written 03/04/2026 flips from March to April. This guide covers four methods that convert CSV to Excel properly, led by Power Query, so your numbers, dates, and characters arrive exactly as they left. If you just need a clean workbook fast and do not have Excel open, the free CSV to Excel converter turns your file into a real .xlsx in the browser, with auto delimiter detection and a preview grid to check before you download.

How do you convert a CSV file to Excel?

To convert a CSV file to Excel, import it with Power Query instead of opening it directly, set each fragile column's type before the data loads, and save the result as an .xlsx workbook. Importing — not opening — is the whole trick, because it lets you decide what each column means before Excel guesses.

  1. Open a new, blank workbook in Excel. Do not open the CSV file itself.
  2. Go to the Data tab and click From Text/CSV.
  3. Pick your file. In the preview, set the delimiter (comma, semicolon, or tab) and the File Origin to Unicode (UTF-8).
  4. Click Transform Data and set any ID, ZIP code, or phone column to the Text type, so leading zeros survive.
  5. Click Close & Load, then save the workbook as an Excel file (.xlsx).

That is the safe path, and the rest of this guide explains when each of the four methods fits, what can go wrong with each one, and how to fix it.

Why opening a CSV is not the same as converting it

Opening a CSV in Excel only displays it. The file is still a .csv until you save it as a workbook, and the next save can drop everything back to plain text. If you add a formula, apply formatting, or build a chart and then click plain Save, Excel will try to save the file as CSV again — which strips all of that work out. The conversion only happens when you choose File, then Save As, and pick Excel Workbook (.xlsx).

Renaming the file does not work either. Changing report.csv to report.xlsx in File Explorer only changes the name, not the contents. An .xlsx file is a zipped XML archive with cell types, sheet metadata, and shared strings, while a CSV is plain text. Excel will show a format-mismatch warning for a renamed file, because the contents do not match the extension. A real conversion builds a valid .xlsx structure — which is exactly what the methods below do.

Converting is worth doing because a workbook unlocks what a CSV cannot hold. Formulas and functions — from a simple SUM to the lookups in our XLOOKUP guide — work on live data. You get rich formatting, charts, multiple worksheets, and PivotTables for summarising large files. A CSV can store the data; only a workbook lets you work with it.

Which method should you use?

Pick the method by the file in front of you, not by habit. The four methods below all end with a real .xlsx workbook, but they protect your data very differently.

MethodBest forProtects your data?Needs Excel?
1. Open directlyA quick look at clean dataNo — Excel auto-guesses every column typeYes
2. Power Query importClean, repeatable importsYes — you set each column type firstYes (Excel 2016 or newer)
3. Text Import WizardOlder Excel versionsYes — step-by-step type controlYes
4. Browser converterOne-step .xlsx, no setupYes — review the grid before downloadingNo

Use Method 1 for a quick glance at simple data. Use Power Query whenever the file has IDs, dates, or anything you cannot afford to lose — and especially when you will re-import the same report again. Reach for the Text Import Wizard on older Excel. And when there is no Excel around, or you want a clean .xlsx in three clicks, the browser converter wins.

Method 1: Open the CSV directly in Excel

Double-clicking a CSV is the fastest route, and it is fine when the data is simple text and numbers with nothing fragile. Skip it if your file has IDs with leading zeros, long numbers, or mixed date formats.

  1. Locate the CSV file on your computer.
  2. Right-click it, hover over Open with, and select Microsoft Excel. If Excel is already the default program for CSVs, a double-click does the same thing.
  3. Excel splits the commas into columns automatically. Review the sheet and check a few cells — if zeros or dates look wrong, close the file without saving and use Method 2 instead.
  4. Go to File, then Save As, and change the file type from "CSV (Comma delimited)" to "Excel Workbook (*.xlsx)". Give it a name and click Save.

That last step is the conversion. If you stop after opening, the file is still a CSV, and your next save may drop everything back to plain text. This method is ideal for quick-and-dirty conversions where the data is straightforward and you know the file uses standard commas as delimiters.

Method 2: Import with Power Query (the method that keeps your data)

Power Query is the safest way to convert CSV to Excel without losing formatting. Found under Data, then Get Data, it previews the file and lets you assign each column a type before a single row lands in the sheet. It is also repeatable: refresh the query and a new version of the CSV re-imports with the same rules. It exists in Excel 2016 and later, including Microsoft 365.

  1. Open a new, blank workbook in Excel. Do not open the CSV file directly.
  2. Go to the Data tab and click From Text/CSV in the Get & Transform Data group.
  3. Select your file and click Import. A preview window shows the first rows and three important options: the delimiter, the File Origin (encoding), and Data Type Detection.
  4. Check the delimiter. Excel usually auto-detects it, but if the columns look wrong, pick the right one — comma, semicolon, tab, or a custom character.
  5. Set File Origin to Unicode (UTF-8) so accented characters display correctly.
  6. Leave Data Type Detection on its default, "Based on first 200 rows", unless you plan to set types by hand in the next step.
  7. Click Transform Data if any column needs a type you choose. For every ID, ZIP code, or phone column, change its type to Text so leading zeros stay.
  8. Click Close & Load. The data lands in a fresh worksheet, typed the way you chose.
  9. Save as .xlsx to finish the conversion.

Microsoft's own documentation recommends this import path for anything beyond a throwaway file, and once you have used it twice it is faster than fixing broken columns by hand. The one habit that matters most is step 7: set fragile columns to Text before the data loads, because a zero stripped on import cannot be recovered afterwards.

Method 3: Use the Text Import Wizard on older Excel

The classic Text Import Wizard is the answer on Excel 2013 and earlier, or when you want the classic step-by-step control. It is also the fix for the "how to open a CSV in Excel with columns" problem, when a file refuses to split correctly.

  1. Open a blank workbook. Go to Data, then Get External Data, then From Text.
  2. Choose your CSV and click Import to launch the wizard.
  3. Step 1: select Delimited, then set File Origin to 65001: Unicode (UTF-8).
  4. Step 2: tick the right delimiter. Watch the preview until the columns line up.
  5. Step 3: click each column that holds IDs or codes and set it to Text. Set date columns to Date, with the correct order (month-day-year or day-month-year).
  6. Click Finish, choose where to drop the data, then Save As .xlsx.

In newer Excel the wizard is hidden by default. You can turn it back on under File, then Options, then Data, in the "Show legacy data import wizards" section — check the box for "From Text (Legacy)". It then appears under Data, then Get Data, then Legacy Wizards, then From Text (Legacy). The wizard's real strength is step 3: explicitly setting a column's data type before import is the most reliable way to preserve leading zeros.

Method 4: Convert CSV to Excel online, with no Excel installed

Sometimes you do not have Excel open, you are on a borrowed laptop, or you just want a clean .xlsx without clicking through a wizard. That is where a browser converter earns its place. The free CSV to Excel converter reads your file in the browser, detects the delimiter automatically, and shows a preview grid so you can spot a bad column before downloading. Nothing needs installing, and the file never has to leave your device for the conversion to work.

  1. Open the converter and drop your .csv onto the page, or click to choose it.
  2. Review the preview grid. Check the ID and ZIP code columns — if a value looks off, fix it in the source file and re-import.
  3. Click download and you get a clean .xlsx workbook, ready to open in Excel, Google Sheets, Numbers, or LibreOffice Calc.

Use this method when there is no Excel on the machine, when the file is a one-off, or when you want to check the result before committing to it. For a file you will re-import every week, Power Query (Method 2) is still the better habit, because a saved query refreshes with one click. If you later need the reverse trip, the free Excel to CSV converter turns a spreadsheet back into a CSV, with custom delimiters and sheet selection.

The five things Excel quietly changes when it guesses a CSV

When you just open a CSV, Excel makes silent guesses about every column. It decides what is a number, what is a date, and what is text — and it is wrong often enough to cost you an afternoon. These are the five changes that catch people out, with a real example of each and the fix.

What Excel changesExample in the CSVWhat you see after openingHow to stop it
Leading zeros strippedZIP code 021342134 — the zero is goneSet the column to Text before import
Long numbers mangled16-digit order number 41111111111111114.11111E+15 in scientific notationSet the column to Text before import
Dates flipped03/04/2026 (3 April, day-first)March 4, 2026 — month and day swappedSet the column to Date with the correct order
Accents turned to symbolsCustomer name "José""José" — garbled charactersSet File Origin to Unicode (UTF-8)
Everything in one columnSemicolon-separated exportAll values jammed into column APick the right delimiter in the import step

Two of these are permanent. A stripped leading zero and a mangled 16-digit number cannot be recovered from the opened sheet — the original digits are gone, and reformatting the cell afterwards only changes how the wrong value is displayed. That is why the fix always happens at import time, never after. The date flip is the sneakiest of the five, because nothing looks broken: March 4 and April 3 are both valid dates, so the error only surfaces weeks later when a report does not add up. The one-column problem is the easiest to spot and the easiest to fix — it means Excel expected a different separator than the file uses, which is common with European exports that use semicolons instead of commas.

How to convert multiple CSV files to Excel at once

When a folder full of CSVs needs the same treatment, do not open them one by one. In Excel, go to Data, then Get Data, then From File, then From Folder, and point it at the folder. Click Combine & Transform Data, and Excel uses the first file as a template for the rest. Check the preview, set any column that needs it to Text, and click Close & Load. All the files land in one table, with a Source.Name column showing which file each row came from — and next month, refreshing the query pulls the new files in automatically.

That gives you one combined workbook. If you need each CSV as its own separate .xlsx file instead, convert them one at a time with the browser converter, or use a small VBA macro that opens each CSV and saves it as .xlsx. One warning about the macro route: because it uses Workbooks.Open, Excel applies its default guesses to your data, so if leading zeros matter, use Power Query rather than the macro.

Converting CSV to Excel on a Mac

Excel for Mac has the same From Text/CSV import under the Data tab, so Method 2 works the same way. If you use Apple Numbers instead, open the CSV in Numbers, then choose File, then Export To, then Excel to save an .xlsx. Numbers is gentler with leading zeros than a raw Excel open, but it still helps to check ID columns before you export. When you are on someone else's Mac with neither app installed, the browser converter is the fastest path to a workbook.

Developers moving spreadsheet data into code often need one more hop: if your destination is a JSON file rather than a workbook, the free Excel-to-JSON converter handles that step. And if a file you receive turns out to be XML rather than a CSV — a sitemap, a config export, or an API response — our guide on how to open an XML file in your browser covers that case.

Sources

Frequently asked questions

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

No. Opening a CSV only displays it, and the file stays a .csv. To actually convert it you must click File, then Save As, and choose Excel Workbook (.xlsx). Only then do formulas, multiple sheets, and cell formatting get saved with the file.

How do I convert CSV to Excel without losing leading zeros?

Import the file instead of opening it. Use Data, then Get Data, then From Text/CSV, click Transform Data, and set the column that holds your IDs or ZIP codes to the Text type before loading. Text columns keep every leading zero, so 00123 stays 00123 instead of becoming 123.

Why does my CSV open with all data in one column?

Excel expected a different separator than your file uses. In many European locales Excel treats the semicolon as the list separator, so a comma-separated file will not split. Re-import through Power Query or the Text Import Wizard and set the delimiter to comma by hand to fix it.

Can I convert CSV to Excel without installing anything?

Yes. A browser-based converter such as the free CSV to Excel converter reads the file on your device and downloads a real .xlsx workbook, with no software to install. It works on any computer, including one that does not have Excel.

How do I convert multiple CSV files to Excel at once?

Use Power Query. In Excel go to Data, then Get Data, then From File, then From Folder, and point it at the folder of CSVs. Power Query combines them into one query you clean once and load together, and you can refresh it later to pull in new files automatically.