How to Convert CSV to Excel Step by Step (Import File Wizard)
Ever opened a CSV in Excel only to watch your data smash itself into a single column or mangle every accented character? This walkthrough fixes that by using Excel's built-in From Text/CSV importer, so your rows, headers, and encoding all land cleanly on a fresh sheet. By the end, you'll be able to bring any CSV into a blank workbook and save it as a proper .xlsx file with a formatted Excel table.
Covered inside:
→ Starting from a blank workbook off the Excel Start screen
→ Locating From Text/CSV inside the Get and Transform Data group on the Data tab
→ Browsing to and importing the CSV through the Import Data dialog
→ Setting File Origin to 65001 Unicode UTF-8 so symbols and accents come through
→ Confirming the Comma delimiter and reviewing the preview table for clean column alignment
→ Leaving Data Type Detection on the first 200 rows and clicking Load to drop the data as a blue and white Excel table
Quick question for the comments: did you stick with the default 200-row data type detection, or did you switch delimiters because your file used something other than a comma? Curious what your CSV looked like.
#Excel #CSVtoExcel #ExcelTutorial #DataImport #PowerQuery #ExcelTips #SpreadsheetSkills #UTF8 #ExcelTables #OfficeProductivity #Excel2026