To convert a CSV file to an Excel workbook in Microsoft Excel for Microsoft 365 on Windows, select Data > From Text/CSV, choose the file, check the preview, and select Load. Then use File > Save As and choose Excel Workbook (*.xlsx); for a simple file, you can also open the CSV directly and save it as an .xlsx workbook.
What a CSV-to-Excel conversion actually does
CSV stands for comma-separated values. It is a plain-text format that stores rows of data, with fields commonly separated by commas. A CSV can be opened in a text editor, but it does not contain the workbook features people usually associate with Excel: cell formatting, multiple worksheets, charts, tables, or saved formulas. Converting one to Excel means bringing its rows and columns into Excel and saving the result in a workbook format such as .xlsx.
The distinction matters because changing the file extension is not a conversion. Renaming orders.csv to orders.xlsx does not create a valid Excel workbook. Open or import the data in Excel, then save it using the Excel Workbook file type. The original CSV can remain as a separate copy for sharing with systems that require plain text.
CSV files are also not all identical. Some use semicolons or tabs instead of commas, and text fields may be enclosed in quotation marks. A file can include an encoding choice that affects accented letters and other characters. Excel’s import preview helps you check how the particular file is structured before it becomes a worksheet.
Choose between opening and importing
Opening a CSV directly is the fastest method when the file is ordinary, uses familiar dates and numbers, and does not contain values that Excel might misread. In Excel for Windows, choose File > Open, browse to the CSV, and open it. If the file is not shown, select an appropriate file type in the Open dialog or browse to its folder. Review the columns, then use File > Save As and select .xlsx.
Importing is a better choice when you need to control separators, encoding, data types, or columns that must remain text. Select Data > From Text/CSV, choose the file, and review the preview. Excel may detect the delimiter and data types automatically; check those choices rather than assuming they are right. Select Load to place the data in a worksheet, or Transform Data to inspect and adjust it in Power Query before loading.
- Open directly: convenient for a quick conversion of a simple, familiar CSV.
- Import through Data: preferable when the file has unusual delimiters, special characters, identifiers, or dates that need careful handling.
- Power Query: useful when you need repeatable cleanup or expect to import an updated version of the same file later.
On Excel for Mac, opening a CSV through File > Open is a straightforward option. Import tools and their availability can differ by Mac Excel version; if your Data tab offers From Text/CSV or a text-import command, use its preview and type controls. Excel for the web can open and edit many workbooks, but for a local CSV import with detailed parsing controls, the desktop app is usually the more dependable choice.
Import a CSV with control over its columns
For a careful import in Excel for Microsoft 365 on Windows, follow these steps:
- Open a blank workbook, or the workbook where you want the data to go.
- Select Data > From Text/CSV and browse to the CSV file.
- In the preview, confirm the delimiter separates the fields into the expected columns. If Excel has selected the wrong delimiter, choose the correct one from the delimiter options.
- Check whether the characters display correctly and whether dates and numbers look plausible. If a column needs special treatment, select Transform Data to adjust its type in Power Query.
- Choose Load to bring the data into Excel. If you used Power Query, load the transformed result when it is ready.
- Save the workbook with File > Save As, choose Excel Workbook (*.xlsx), and give the new file a clear name.
Keep the CSV until you have checked the workbook. Compare a few records near the top and bottom, confirm the column count, and look for values that have changed unexpectedly. If the file is a recurring report, Power Query can make later imports more consistent: after setting up the query, use Data > Refresh All to refresh connected data when the source is available. A refresh is not a substitute for checking that a replacement file has the expected structure.
Protect dates, identifiers, and long numbers
The most common conversion problem is not a failed import; it is a value that looks reasonable but has been changed. Excel tries to interpret data. That can be helpful for ordinary numbers, but damaging for codes and identifiers. For example, a product code such as 004271 may be interpreted as the number 4271, losing its leading zeros. A long tracking number may display in scientific notation, and Excel retains only 15 digits of numeric precision. If every digit matters, import that column as text instead of treating it as a number.
Dates can also be ambiguous. A value such as 03/04/2026 may mean March 4 or April 3, depending on the date convention used by the source. If Excel interprets it using a different regional convention, the date can be silently misread. Review the preview and, where needed, use Transform Data to set the column’s type and locale deliberately. If a value is a label rather than a date for calculation, importing it as text can avoid unwanted interpretation.
Other details worth checking include:
- Leading zeros: preserve postal codes, account references, and product IDs as text when the zeros are meaningful.
- Decimal and thousands separators: a number written as
1.234,56may be interpreted differently from1,234.56, depending on regional settings. - Text encoding: if names or symbols appear garbled, try an import that lets you select the file origin or encoding. UTF-8 is common, but the source file’s encoding determines the correct choice.
- Empty fields: consecutive delimiters can represent a blank value. Check that blank fields have not shifted later data into the wrong columns.
What is preserved, and what is not
A CSV normally carries the text values and row-and-column arrangement of a single data table. It does not carry Excel formatting such as bold headings, number formats, column widths, filters, or worksheet names. It also cannot store several worksheets in one file. After conversion, you can add those workbook features and save them in .xlsx.
Do not expect formulas in a CSV to behave like saved Excel formulas. A CSV can contain text that looks like a formula, but it has no workbook calculation model or formatting metadata. Similarly, if a spreadsheet was exported to CSV, only the selected sheet’s data is generally represented in that file; other sheets and workbook features are not part of the CSV. If you need an original workbook’s formulas, charts, or multiple tabs, ask for the .xlsx file rather than trying to reconstruct features that the CSV does not contain.
Excel worksheets support up to 1,048,576 rows and 16,384 columns. If a CSV has more rows than a worksheet can hold, it cannot all fit on one sheet; use a database, data model, or another tool designed for larger datasets instead. Saving as .xlsx also does not make the data inherently more accurate: it preserves what Excel has imported, including any interpretation errors. Check sensitive values before treating the workbook as the definitive copy.
Save as Excel and choose a suitable format
After the data is loaded, select File > Save As, choose a location, and select Excel Workbook (*.xlsx) from the file-type list. Use a new filename if you want to preserve the source CSV. Excel may warn that some features are not compatible with CSV when saving changes back to a .csv file; choosing .xlsx avoids discarding workbook features you have added.
Choose the format according to how the file will be used:
- .xlsx: the usual choice for an Excel workbook without VBA macros. It can store multiple sheets, formatting, formulas, and other workbook content.
- .xlsm: for a workbook that needs to retain VBA macros. A CSV has no macros to preserve, so this is relevant only if you add or use macro-enabled workbook content.
- .csv: for exchanging plain tabular text with another application. Saving back to CSV removes workbook-only features and typically saves only the active worksheet’s data.
Privacy, security, and online converters
A desktop import keeps the conversion within Excel on your computer, which is often the better choice for customer records, payroll data, medical information, or other sensitive material. Online converters can be convenient for a one-off file, but uploading a CSV sends its contents to a third-party service. Before doing that, check the service’s privacy terms, retention policy, and whether your organization permits external uploads. Never assume a file is private just because the conversion page is free.
Also treat CSV files from untrusted sources with care. A field beginning with a character such as an equals sign can be interpreted as a formula by spreadsheet software in some circumstances. This kind of formula injection can be used to make a workbook perform unexpected actions when opened. If you do not trust the source, inspect suspicious cells and import fields as text where appropriate; do not enable or run unexpected content. CSV itself does not contain VBA macros, but that does not make every cell’s content harmless.
Common conversion problems and fixes
- Everything appears in one column: import again with Data > From Text/CSV and select the separator actually used by the file. Some regional settings or programs produce semicolon-delimited files.
- Names display as strange characters: use the import preview’s file-origin or encoding option, if available, and select the encoding that matches the source. Confirm the text looks correct before loading.
- Zeros at the beginning disappeared: reimport the original CSV and set the affected column to text before loading. Formatting a number after zeros are lost will not restore the original characters.
- Dates changed or reversed: reimport from the original and interpret the column using the source’s date convention or locale. Do not rely on the already-converted value if you cannot confirm what it meant.
- The workbook still has a .csv extension: use File > Save As and explicitly select Excel Workbook (*.xlsx). Changing only the filename extension is not enough.
- Only one worksheet is available: that is expected for a CSV. The format represents one table, not a multi-sheet workbook.
Frequently Asked Questions
How do I convert CSV to Excel without losing data?
Import through Data > From Text/CSV, check the preview, and set identifiers or long digit strings to text when necessary. Verify dates, leading zeros, and character encoding before saving as .xlsx. Keep the original CSV until the result has been checked.
Can I convert a CSV file to Excel for free?
If you already have access to Excel, its open and import features can convert CSV data to an .xlsx workbook. Other spreadsheet programs may also open and export CSV files, but menu names and how they interpret data differ. Online converters may be free to use, but consider privacy before uploading a file.
Why does Excel put my CSV data in one column?
Excel may have detected the wrong delimiter. The file might use semicolons or tabs rather than commas, or its regional conventions may differ from Excel’s. Import it using Data > From Text/CSV and choose the delimiter that matches the source.
Will converting CSV to XLSX keep formulas and multiple sheets?
No. A CSV does not contain workbook formulas as functioning Excel formulas, formatting, charts, or multiple worksheets. It stores plain tabular data. If those workbook features matter, obtain the original Excel workbook if it is available.
Can I convert CSV to Excel without Microsoft Excel?
Yes. Spreadsheet applications such as LibreOffice Calc can open CSV files and save them in spreadsheet formats, and some online services offer conversion. Check the imported data and the output format in whichever tool you choose, especially for dates, encodings, and leading zeros.
Related
- Excel Data Validation Date Picker: Setup and Options
- Excel Data Validation for Dates: Rules and Examples
- Data Validation Checks in Excel: Rules and Examples
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- AG Grid Merge Cells: Row and Column Spanning ExplainedYes—AG Grid can make a cell span adjacent rows or columns, but it does not provide a general-purpose…
- How to Create a Real Handwritten Signature in OutlookTo create a real handwritten signature in Outlook, write your name on paper, save a clear photo or…
- How to Change the View in Outlook Sent ItemsTo change how sent messages appear, open the Sent Items folder and use Outlook’s view controls: in classic…
- Excel Day of Year: Find the Day Number for Any DateTo find the day of the year in Excel, put a real Excel date in A2 and enter…
- How to Insert a Signature in Word 365: Image, Line, or InkTo insert a handwritten signature in Word 365, scan or photograph it, save it as an image, then…
- How to Create a Postcard Template in Microsoft WordCreate a postcard template in Word by setting a custom page size, arranging the front and back on…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.