How to Convert CSV to Excel: 4 Easy Ways in 2026

To convert CSV to Excel, open the file in Excel and save it as an Excel Workbook (.xlsx). If your data has leading zeros, long numbers, or dates, import it instead with Data > From Text/CSV. That way you control each column's format. Google Sheets and AI tools offer two more routes.
This guide covers four ways to convert CSV to Excel, when to use each, and how to fix the problems that appear most often. Steps come from Microsoft and Google support pages, read on November 11, 2026.
Which way to choose
Each method suits a different file and a different goal.
| Way | Best for | Keeps leading zeros? | Repeats easily? |
|---|---|---|---|
| 1. Open in Excel and save as .xlsx | Simple files with plain numbers and text | No, unless you change settings | No |
| 2. Import with Data > From Text/CSV | Files with codes, long numbers, or dates | Yes, if you set the column to Text | Yes, with Refresh |
| 3. Import into Google Sheets | No Excel installed, or shared team files | Depends on import options | No |
| 4. Clean and analyze with AI | Messy exports you need to summarize or chart | Check the result | Yes |
If you only need to look at the data once, Way 1 is fastest. If you get the same export every week, Way 2 saves the most time.
Before you start: check your CSV file
A CSV file is plain text. Each line is a row, and a comma usually separates each field. Microsoft describes CSV files as text files "in which the comma character (,) typically separates each field of text."
Open the file in a text editor first, such as Notepad or TextEdit. Check four things:
- The delimiter. Is it a comma, a semicolon, or a tab? Files from some regions use semicolons.
- The header row. Does the first line hold column names?
- Sensitive columns. Are there ZIP codes, account numbers, or product codes that start with zero?
- Date format. Are dates written as day-month or month-day?
These checks take a minute. They tell you whether the quick method will work or whether you need the import method.
It also helps to know where the file came from. Exports from banks, shops, and CRMs often follow the same layout each time. Learn the quirks of one export, such as a semicolon delimiter or a day-month date. Then you can set up the import once and reuse it for every new file. Write those quirks down in a short note next to the workbook.
Finally, decide what the Excel file is for. If it feeds a report, you will want clean types and a table. If it is a one-time look, the quick method is enough.
If your data starts as a PDF rather than a text export, see our guide on how to convert PDF to Excel instead.
Size matters too. Microsoft says "You can import or export up to 1,048,576 rows and 16,384 columns." Larger files will be cut off when opened in a single sheet.
Way 1: Open the CSV in Excel and save as .xlsx
This is the fastest way to convert CSV to Excel when the data is simple.
- In Excel, go to File > Open and browse to the folder with your CSV.
- Select Text Files in the file type list, if the CSV does not appear.
- Double-click the file. Microsoft says "Excel automatically opens the text file and displays the data in a new workbook."
- Go to File > Save As.
- In the file type list, choose Excel Workbook (.xlsx).
- Name the file and select Save.
Step 5 is the step people miss. Microsoft notes that opening the file "does not change the format of the file." The title bar still shows the .csv extension until the file is saved as .xlsx. If you skip that step, formulas, formatting, and extra sheets will not be kept in the CSV.
The quick method has one weakness. Microsoft says "When Excel opens a .csv file, it uses the current default data format settings to interpret how to import each column of data." That is where leading zeros vanish and dates shift. If your file has those columns, use Way 2.
Way 2: Import with Data > From Text/CSV
The import method lets you check and set each column before the data lands in your sheet. It is the safest way to convert CSV to Excel when the format matters.
- Open a blank workbook and click the cell where the data should start.
- On the Data tab, in the Get & Transform Data group, select From Text/CSV.
- Locate the CSV file and select Import.
- In the preview window, check the Delimiter and File Origin settings.
- Select Transform Data if any column needs a different type.
- Select a column header, then go to Home > Transform > Data Type and choose Text for codes and IDs.
- Select Close & Load.
- Use File > Save As to store the workbook as an Excel Workbook (.xlsx).
Microsoft's guide to keeping leading zeros explains why step 6 matters. Its support page says "Excel automatically removes leading zeros, and converts large numbers to scientific notation, like 1.23E+15." Setting the column to Text in Power Query keeps the original values.
The preview also handles other delimiters. Microsoft's Power Query documentation lists "colon, comma, equals sign, semicolon, space, tab, a custom delimiter," and fixed width.
Data type detection is worth a look. Power Query can base it "on the first 200 rows or on the entire data set." Microsoft warns "Since inference can be incorrect, double check settings before loading."
The biggest benefit comes next month. Microsoft says "If your data changes in the future, you can go to Data > Refresh, and Excel will automatically update your data." Your column types and steps are applied again.
Way 3: Import the CSV into Google Sheets
If you do not have Excel, Google Sheets can open the file and export it as an Excel workbook.
- Open a spreadsheet in Google Sheets.
- At the top, click File > Import.
- Choose your .csv file.
- Select an import option, such as Create new spreadsheet or Insert new sheets.
- Under Separator character, pick Detect automatically, Tab, Comma, or Custom.
- Click Import.
- To get an Excel file, choose File > Download > Microsoft Excel (.xlsx).
Google's help page lists six import options in total. They include "Replace current sheet" and "Append rows to current sheet," which help when you add new data to an existing file.
This route suits teams that share files in Google Drive. Check codes and dates after import, since automatic detection can change them too.
Way 4: Clean and analyze the CSV with AI
Sometimes the goal is not just an .xlsx file. You need the data cleaned, summarized, and charted. An AI tool can handle the cleanup and the first analysis in one pass.
Here is the method in three steps, using Powerdrill Bloom.
Step 1: Upload your CSV file
Upload the file to Powerdrill Bloom. The Open CSV File page says you can "Open CSV files effortlessly and analyze data fast with AI." It also says you can "upload up to 10 files at once into a dataset."
If you have several exports, such as one per month, upload them together.
Step 2: Describe the cleanup and analysis in natural language
Say what you need. For example: "Keep ZIP codes as text, convert the order date to a real date, and show revenue by month."
The CSV AI Assistant says Powerdrill Bloom "automatically analyzes your CSV files, detecting key metrics, trends, and correlations in seconds."
Step 3: Check the results and export
Compare a few rows with the original file, especially codes and dates. Then export what you need. The CSV AI Assistant page lists "One-Click Export to PPT, Infographics & Notions," and says you can "Export polished PowerPoint decks, infographics, or detailed reports."
To combine several exports first, the Merge CSV File page covers merges by "specific column matches, sorting orders, or other criteria you define."
How to convert many files at once
Some teams receive one export per store, per region, or per day. Opening each file and saving it is slow. Power Query can combine them in one step.
Microsoft's Power Query documentation gives the route: "To import multiple text/CSV files at once, use a multi-file connector such as the Folder connector." Here is how that works in Excel:
- Put all the files in one folder, with the same columns in the same order.
- On the Data tab, select Get Data > From File > From Folder.
- Browse to the folder and confirm.
- Select Combine & Transform Data.
- Set the column types once, just as in Way 2.
- Select Close & Load, then save the workbook as .xlsx.
Each new file dropped into the folder joins the table on the next refresh. This turns a weekly chore into one click.
Two rules keep the combined table clean. First, every file must use the same headers. Second, keep only data files in the folder, since any extra file will be read too.
How to save an Excel file back to text format
Sometimes the trip goes the other way. A system may only accept text files for upload. Microsoft's steps for exporting are short:
- Go to File > Save As.
- In Save as type, choose CSV (Comma delimited) or Text (Tab delimited).
- Choose a folder and select Save.
Two warnings appear, and both matter. Microsoft says the first dialog reminds you "that only the current worksheet will be saved to the new file." The second warns that your worksheet "may contain features that are not supported by text file formats."
In practice, formulas become their results, and formatting and charts are dropped. Store the export as a separate file, and keep the .xlsx version for your own work.
A CSV to Excel example
Here is a worked example for a made-up store. Northwind Outdoors exports an orders file from its shop each week. The file has 2,400 rows and five columns.
| order_id | order_date | zip_code | sku | amount |
|---|---|---|---|---|
| 4521000012345678 | 03/04/2026 | 02139 | 00731 | 84.50 |
| 4521000012345679 | 03/04/2026 | 10001 | 01422 | 129.00 |
What happens with Way 1. The store manager double-clicks the file. Three problems appear:
- ZIP code 02139 becomes 2139, and SKU 00731 becomes 731.
- Order ID shows as 4.521E+15. Microsoft notes Excel truncates numbers "to 15 digits of precision," so the last digit is lost.
- Order date 03/04/2026 may read as March 4 or April 3, depending on regional settings.
What happens with Way 2. The manager imports with From Text/CSV and selects Transform Data. They set order_id, zip_code, and sku to Text and order_date to Date. All 2,400 rows load with the original values. Next week, the manager replaces the file and selects Data > Refresh.
What the manager learns. The quick method looked fine at first glance. Only the import method kept every ID usable for lookups.
Fix common problems after converting
These are the problems that appear most often when people convert CSV to Excel.
Leading zeros disappear. Re-import with From Text/CSV and set the column to Text. For a quick fix inside one workbook, Microsoft also suggests a custom number format, such as 00000 for a five-digit postal code.
Long numbers turn into 1.23E+15. Set the column to Text before loading. Microsoft says Excel can convert "large numbers to scientific notation" and truncate them to 15 digits.
All data lands in one column. The delimiter is wrong. Choose the right delimiter in the import preview, or use Data > Text to Columns.
Strange characters appear. The file encoding is different. In the import preview, change File Origin. Microsoft's documentation notes "the character set isn't inferred."
Dates look wrong. Set the column type to Date with the correct locale in Power Query, or keep it as Text and convert it later.
Numbers are stored as text. A small green triangle appears in the corner of each cell. Microsoft's import guide points to its articles on converting numbers and dates stored as text after import.
Excel changes data automatically. In Excel for Microsoft 365 and Excel 2024, Microsoft offers Automatic Data Conversions settings. You can turn off "Removing leading zeros from numerical text and converting to a number."
CSV vs. Excel: what changes when you convert
Converting changes more than the file extension.
| CSV | Excel (.xlsx) | |
|---|---|---|
| What it stores | Plain text values | Values, formulas, formats, charts |
| Sheets | One | Many |
| Formatting | None | Fonts, colors, number formats |
| Size | Small | Larger |
| Best use | Moving data between systems | Analysis and reporting |
Keep the original file as a backup. Many systems expect the plain text format for re-import, so do not overwrite it with your edited version.
If the next step is a chart, our guide on how to turn a CSV file into a chart picks up from here.
When you are ready to skip the cleanup steps, try Powerdrill Bloom with this week's export.
Frequently asked questions
How do I convert a CSV file to Excel?
Open the CSV in Excel, then go to File > Save As and choose Excel Workbook (.xlsx). For files with codes or dates, use Data > From Text/CSV instead.
How do I convert CSV to Excel without losing leading zeros?
Import the file with Data > From Text/CSV, select Transform Data, and set the column type to Text. Then select Close & Load.
Why does Excel put all CSV data in one column?
The delimiter does not match. Use the import preview to choose the correct delimiter, such as a semicolon or tab, or use Text to Columns.
Can I convert CSV to Excel without Excel?
Yes. Import the CSV into Google Sheets with File > Import, then download it as a Microsoft Excel (.xlsx) file.
What is the difference between CSV and XLSX?
A CSV file stores plain text values in one sheet. An XLSX file stores values, formulas, formatting, charts, and multiple sheets.
Sources: Microsoft Support, Import or export text (.txt or .csv) files · Microsoft Support, Keeping leading zeros and large numbers · Microsoft Learn, Power Query Text/CSV connector · Google Docs Editors Help, Import data sets and spreadsheets.