How to Open CSV in Excel 2019, 2016 and Older Versions

Knowing how to open CSV in Excel 2019 — and in 2016, 2013, and 2010 — matters because these versions are still everywhere. Corporate IT departments standardize on them for years, small businesses run them on aging PCs, and plenty of home users never saw a reason to upgrade. The catch: Microsoft changed how Excel imports text files right in the middle of this era. Excel 2016 and 2019 straddle two worlds — the classic Text Import Wizard that veterans know by heart, and the modern Get & Transform Data (Power Query) flow that Microsoft now prefers. Use the wrong one for your file and you’ll fight delimiters and encodings unnecessarily. Everyone searching “open csv in excel 2019” hits the same confusion: the Text Import Wizard moved. Here is exactly where it went.

This guide covers both import paths step by step, explains exactly where the Text Import Wizard hides in Excel 2019 (Microsoft tucked it away), shows how to open CSV in Excel 2016 and earlier, and fixes the classics: everything landing in one column, garbled special characters, dates flipping between US and UK formats, and leading zeros vanishing. Whether your PC runs Windows 10 or 11 in Chicago, Manchester, Toronto, Sydney, or Delhi, the steps are the same — with notes on the regional settings that cause most of the trouble.

Open CSV in Excel 2019: Two Eras — Wizard vs Get Data

From Excel 97 through Excel 2013, there was exactly one way to import a text file properly: Data › From Text, which launched the three-step Text Import Wizard. Step 1: pick delimited vs fixed width and set the file origin (encoding). Step 2: choose your delimiters (tab, semicolon, comma, space, other). Step 3: set each column’s data format (General, Text, Date with format). Millions of office workers learned this dialog the way drivers learn a commute — by repetition.

Then Microsoft introduced Get & Transform Data (Power Query), first as an add-in for Excel 2010/2013, then built into Excel 2016 and later. The new Data › From Text/CSV command shows a smart preview that auto-detects delimiters and encodings, lets you transform data before loading, and can save the whole import as a refreshable query. It’s objectively more powerful — and completely unfamiliar to anyone trained on the wizard.

Here’s where it gets confusing: in Excel 2016 and 2019, both exist, but Microsoft progressively hid the old wizard. In Excel 2019, Data › From Text/CSV is the prominent button, while the legacy wizard must be re-enabled in options. Many “my CSV broke after upgrading Office” stories are really “the import path changed and nobody told me” stories. The good news: once you know both paths, you can pick the right tool — the wizard for quick, predictable imports where you want explicit control; Get Data for recurring reports and messy files that need cleaning. Let’s start with the old faithful.

Method 1: The Text Import Wizard (2019/2016/2013/2010)

The three-step wizard remains the most explicit, predictable way to open a CSV in older Excel. In Excel 2016 and earlier it’s front and center; in Excel 2019 you may need to enable it first (see below).

Enabling the legacy wizard in Excel 2019: Go to File › Options › Data, and under “Show legacy data import wizards” tick From Text (Legacy). Click OK. Now you’ll find it at Data › Get Data › Legacy Wizards › From Text (Legacy).

1. Open Excel to a blank workbook. Go to Data › From Text (2016 and earlier) or Data › Get Data › Legacy Wizards › From Text (Legacy) (2019, after enabling).
2. Select your CSV file and click Import. The Text Import Wizard opens at Step 1 of 3.
3. Step 1: Choose Delimited. Set File origin — pick 65001: Unicode (UTF-8) for modern exports, or the matching Windows encoding for legacy files. Check the preview: if characters look right, click Next.
4. Step 2: Tick the correct Delimiters. Untick Tab (often wrongly defaulted), tick Comma — or Semicolon for European files. Watch the preview: vertical lines should appear exactly where your columns split. Click Next.
5. Step 3: Click each column in the preview and set its Column data format. Crucial: set phone-number, ZIP-code, and ID columns to Text (not General) to protect leading zeros. Set date columns to Date and pick the right order (MDY for US files, DMY for UK/Indian/European files). Click Finish.
6. Choose where to put the data (top-left of the existing worksheet is fine) and click OK.
7. File › Save As, choose Excel Workbook (*.xlsx), and save. Your CSV is now a real Excel file.

Step 3 is where veterans earn their keep. The number of “my ZIP codes lost their zeros” and “my dates flipped” incidents that trace back to skipping Step 3’s column formats is staggering. Two extra minutes here saves hours of cleanup later.

Method 2: File › Open, then Save As XLSX

The simplest path — and the right one for clean, standard CSVs:

1. In Excel, go to File › Open › Browse.
2. In the file-type dropdown (bottom right), select Text Files (*.prn, *.txt, *.csv) or All Files.
3. Select your CSV and click Open. (In Excel 2019/2016 this may route you into the modern import preview; in 2013/2010 it opens directly.)
4. Check the data. If it looks right, go to File › Save As, pick Excel Workbook (*.xlsx), and save.

Method 3: Modern Get Data › From Text/CSV

Excel 2019 and updated Excel 2016 include the modern import that Microsoft 365 users know: Data › From Text/CSV (or Data › Get Data › From File › From Text/CSV). It shows a smart preview with auto-detected delimiter and encoding, which you can override before clicking Load.

The trade-off versus the wizard: the modern dialog is faster for clean files and offers Transform Data (Power Query) for messy ones, but it gives you less explicit per-column control up front — column types are set in the Power Query editor rather than a simple Step 3 list. If you grew up on the wizard and find the new dialog confusing, there’s no shame in re-enabling the legacy path from Method 1. Use the tool you can operate correctly; a correctly-used wizard beats a misused modern dialog every time.

Version differences: 2019 vs 2016 vs 2013 vs 2010

The CSV experience changes subtly across versions, and knowing your version’s quirks saves real time:

Excel 2019: Modern Data › From Text/CSV is the default; the legacy wizard is hidden but re-enableable (File › Options › Data). Best of both worlds once configured. Handles UTF-8 well.

Excel 2016: Transitional. Early builds lean on the classic Data › From Text wizard; later updates add Get & Transform. If your 2016 looks different from a colleague’s 2016, check your update channel — that’s why.

Excel 2013: Classic wizard only (Data › From Text), unless the Power Query add-in was installed. Rock solid for straightforward imports; UTF-8 support requires explicitly choosing 65001 in Step 1.

Excel 2010: Same classic wizard. One gotcha: the default file origin is your system encoding, so UTF-8 files from the modern web will mangle characters unless you set 65001 manually every time.

Across all four: the 1,048,576-row limit is identical, File › Save As › Excel Workbook (*.xlsx) works the same, and double-clicking a CSV guesses settings from your region in every version. The wizard steps themselves haven’t changed in decades — muscle memory from 2003 still applies.

Fixing encoding: the 65001 trick

If your CSV contains anything beyond plain ASCII — accented names (José, Müller), currency symbols (€, £, ₹), or non-Latin scripts — and Excel shows gibberish, the fix is one dropdown. In Step 1 of the Text Import Wizard, change File origin to 65001: Unicode (UTF-8). That number is the Windows code page identifier for UTF-8, and selecting it tells Excel to interpret the file’s bytes as UTF-8 instead of your system’s legacy encoding.

How to tell which encoding your file uses: open it in Notepad. If it looks correct there, it’s almost certainly UTF-8 (Windows 11 Notepad auto-detects well). If it’s also broken in Notepad, the file may be in a legacy encoding like Windows-1252 — try that option in the File origin dropdown instead. When in doubt, 65001 first; it covers the vast majority of modern exports from web platforms, SaaS tools, and banks.

Fixing the one-column problem in old Excel

The classic symptom: every row lands in column A, looking like Name;Email;City. The cause is always a delimiter mismatch between the file and your system’s list separator — most often a semicolon-delimited European file opened on a US/UK/Indian system, or vice versa.

Fix during import: In Step 2 of the Text Import Wizard, untick the wrong delimiter and tick the right one — watch the preview snap into columns. Fix after opening: Select column A, go to Data › Text to Columns, choose Delimited › Next, tick the correct delimiter, and Finish. Permanent fix for recurring files: Save the import as a query (modern path) or record a macro of the Text-to-Columns steps (legacy path) and replay it on each new file.

Deeper coverage lives in our guides to CSV opening in one column and semicolon-delimited CSV files.

Troubleshooting legacy Excel CSV issues

The Text Import Wizard never appears. In 2019, enable it first (File › Options › Data › From Text (Legacy)). In 2016/2013/2010 it’s at Data › From Text directly.

Leading zeros vanished. Re-import and set those columns to Text in Step 3. Post-import, the data is unrecoverable — see keeping leading zeros.

Dates flipped between US and UK formats. In Step 3, set date columns to Date with the correct order (MDY vs DMY) matching the file’s origin country.

Scientific notation ate my long numbers. Step 3 › Text format for ID columns. Excel’s 15-digit precision limit means 16+ digit numbers must be Text.

CSV won’t open — “file format not valid”. The file may actually be tab- or pipe-delimited despite the .csv extension, or it may be corrupted. Check it in Notepad first.

Excel 2010 crashes on large CSVs. Older Excel is less memory-efficient; split the file (large CSV guide) or convert with the browser converter instead.

Dealing with a real head-scratcher? join the discussion in our community forum — include your Excel version and a few anonymized sample rows for the fastest help.

Should You Upgrade from Excel 2019?

The honest answer for CSV work specifically: probably not, unless something else pushes you. Excel 2019 opens, imports, and saves CSV-derived workbooks as well as it ever did, and the techniques in this guide will keep working for years. But it’s worth knowing what you’d gain — and what you’re quietly losing — by staying put.

What newer Excel adds

Microsoft 365’s Excel has moved on in ways that matter for data work: dynamic arrays (formulas that spill results across cells — no more Ctrl+Shift+Enter), XLOOKUP (VLOOKUP’s smarter successor), richer data types (stocks, geography that refresh live), a much-improved Power Query editor, and real-time co-authoring. None of these change basic CSV importing, but they change what you can do with the data afterward.

What staying costs you

Two things erode over time: security updates (perpetual-license Office versions have a fixed support lifecycle — check Microsoft’s lifecycle page for your version’s dates) and file compatibility at the edges (workbooks using the newest functions show errors or static values when opened in 2019). If colleagues keep sending you files that “don’t work right,” that’s the nudge.

The pragmatic middle path

You don’t have to choose once and forever. Keep Excel 2019 for daily work, and use Excel for the web (free) when you need a newer function or want to co-author. Or do CSV conversion in a free tool — the browser converter, LibreOffice Calc — and reserve Excel 2019 for analysis. Upgrade when the features earn it, not from vague anxiety about age: for opening CSVs and saving XLSX files, 2019 remains a perfectly good hammer.

Excel 2019 on Mac: CSV Differences

Everything so far assumed Windows — but Excel 2019 for Mac has its own quirks worth knowing, since the Mac version’s CSV handling differs in a few sharp edges.

Delimiter detection is weaker on Mac. Excel for Mac leans on macOS locale settings rather than offering the full Text Import Wizard experience Windows users know. The legacy wizard path (Data › Get Data › From File › From Text/CSV) exists, but Mac Excel’s preview dialog has fewer explicit controls than its Windows twin. For semicolon-delimited European files, Mac users hit the one-column problem more often — and the fix is the same: set the delimiter manually in the import dialog, or pre-process in Numbers (which sniffs delimiters better) and export to XLSX.

Encoding defaults differ. macOS is UTF-8 native, so modern CSVs usually open cleanly — but CSVs exported from old Windows software in legacy encodings (Windows-1252) garble just as happily on Mac. In the From Text/CSV dialog, check the File Origin setting and try the Western European (Windows) option when UTF-8 fails.

The pragmatic Mac workflow: many Mac-based Excel 2019 users end up with a hybrid — import tricky CSVs in Apple Numbers (superior auto-detection), export to XLSX, then do the real work in Excel. There’s no shame in it; use each tool for what it’s best at. Our CSV to Excel on Mac guide covers this workflow in full, including the Get Info default-app fix that stops CSVs opening in the wrong program. One final Mac-specific note: if you use Excel 2019 alongside newer Microsoft 365 apps on the same Mac (a common setup during transitions), keep an eye on which version owns your .csv association — the two can fight over it after updates.