How to Open the Text Import Wizard in Excel on Windows

How-to basics · Updated November 21, 2026

To open Excel’s legacy Text Import Wizard in Microsoft 365 for Windows, first enable it at File > Options > Data by selecting From Text (Legacy) under Show legacy data import wizards. Then go to Data > Get Data > Legacy Wizards > From Text (Legacy) and select your text file. The wizard lets you choose how Excel separates fields and formats columns before loading the data.

This is useful when a text file needs more control than Excel’s newer import experience provides—for example, when you need to preserve ID numbers with leading zeros, handle an unusual delimiter, or choose a date format before import. The legacy wizard is a desktop Excel feature; Excel for the web does not provide this same wizard.

What You’ll Need

  • Excel for Microsoft 365 for Windows. These instructions use the Windows desktop app. Ribbon labels can vary slightly between builds, but the legacy wizard is enabled from Excel Options.
  • A text file to import. Common examples include .txt, .csv, and other delimited text files. Know, if possible, whether the fields are separated by commas, tabs, semicolons, or another character.
  • Access to the file. If it is stored on a network drive or in a protected folder, make sure you can open it and that it is not locked by another application.
  • A destination plan. Decide whether the imported data should go into a new worksheet or into a particular cell in the current workbook. If you are importing into an existing sheet, check that the destination area is clear.

Step-by-Step

  1. Open the desktop Excel app. Start Excel and open the workbook that should receive the data, or create a blank workbook. If you are importing sensitive or important data, keep an untouched copy of the source file. The wizard imports a copy of its contents; it does not need to alter the original text file.
  2. Open Excel Options. Select File in the upper-left corner, then choose Options near the bottom of the left-hand menu. This opens the Excel Options dialog. If you do not see Options, make sure you are in the Windows desktop application rather than Excel for the web.
  3. Enable the legacy text wizard. In Excel Options, choose Data. Find the section called Show legacy data import wizards, then select the checkbox for From Text (Legacy). The checkboxes shown can vary by Excel build. Select only the text option if that is all you need, then click OK to save the setting. You generally only need to enable it once for that Excel installation.
  4. Launch the wizard from the Data tab. Select the Data tab on the ribbon. Open Get Data, point to or select Legacy Wizards, and choose From Text (Legacy). Depending on the ribbon layout, the Legacy Wizards command may appear as a submenu. This is the legacy command; From Text/CSV opens the newer import experience instead.
  5. Select the source file. In the file selection window, browse to the text file, select it, and choose Import or Open, depending on the dialog wording. If you cannot find the file, check the file type filter at the bottom of the window and change it to show text files or all files. Confirm that you have picked the intended file before continuing.
  6. Set the file type and character encoding in Step 1. The wizard asks whether the source is Delimited or Fixed width. Choose Delimited when separator characters divide the fields; choose Fixed width when fields line up in columns at set character positions. Review the preview. If accented letters or other symbols look wrong, change the File origin setting to the encoding used by the file, such as UTF-8 when that is how it was saved. Click Next.
  7. Choose how fields are divided in Step 2. For a delimited file, select the separator used in the source, such as Tab, Semicolon, Comma, or Space. If the file uses a different character, select Other and enter it. Watch the data preview: each field should appear in its own column. Set the Text qualifier if values are enclosed in quotation marks, and use Treat consecutive delimiters as one only when repeated separators should not create empty fields. For fixed-width data, click or drag the column break markers in the preview to place or adjust divisions. Click Next when the preview looks right.
  8. Set column formats in Step 3. Select a column in the preview and choose its format. General lets Excel interpret values automatically; Text preserves entries such as product codes and ZIP codes as text; and Date lets you specify the order of date components, such as MDY or DMY. Choose Do not import column (skip) for a field you do not need. Check every column that could be mistaken for a number or date before proceeding.
  9. Choose where the imported data goes. Click Finish. In the Import Data dialog, select Existing worksheet and confirm the destination cell if you want the results in the open sheet. Select New worksheet to keep the import separate. Check the destination carefully: importing over occupied cells can replace their contents. Click OK to load the data.
  10. Verify the result. Compare several rows with the source file. Check that fields landed in the intended columns, headers are in the right place, special characters display correctly, and codes or dates have the intended formats. If anything is wrong, undo the import promptly with Ctrl+Z and repeat the wizard with adjusted settings. If you have already made other changes, remove the imported range carefully rather than undoing unrelated work.

Common Mistakes

Opening the modern import tool instead. The command called From Text/CSV uses Excel’s newer import experience, not the three-step legacy wizard. To get the wizard, enable From Text (Legacy) in Excel Options and use it under Get Data > Legacy Wizards.

Guessing the delimiter. Choosing comma when the file uses tabs, semicolons, or a different separator can put an entire row into one column or split values in the wrong places. Use the preview rather than relying on the file extension. A .csv file often uses commas, but regional settings and the program that created it can affect the separator.

Letting Excel reinterpret identifiers. Values such as 00481 can become 481 if imported as numbers. Long account or tracking numbers can also lose precision when treated as numeric values. Set those columns to Text in Step 3 before finishing.

Ignoring date order and quotation marks. A date such as 03/04/2026 can mean March 4 or April 3 depending on the source convention. Choose the correct date order, or import the field as text if you need to inspect it first. Also, a text qualifier such as a quotation mark keeps a comma inside a quoted value from splitting that value into two fields.

Importing over existing information. Selecting an occupied destination cell can overwrite data in the area the import fills. Choose a new worksheet if you are uncertain about the size of the incoming data.

Tips

  • Use the preview as your guide. Before clicking Next, check representative rows—including rows with blank fields, quoted text, or unusual characters. The first row may not reveal a problem that appears later.
  • Keep identifiers as text from the start. Formatting a cell as Text after Excel has already removed leading zeros does not restore them. Set the column format in Step 3 before the import completes.
  • Do not assume every comma separates fields. In a properly quoted delimited file, a comma inside quotation marks can be part of a value. Set the text qualifier to match the file and confirm in the preview that quoted values stay together.
  • Choose a new worksheet for a first attempt. This makes it easier to inspect the import without disturbing an existing table. Once it looks correct, you can move or copy the data where it belongs.
  • Use the modern tool when it suits the job. For a straightforward CSV, Data > From Text/CSV may be enough and offers a preview before loading. Choose the legacy wizard when you specifically need its column-by-column format choices or fixed-width setup.
  • Know the platform difference. On a Mac, Excel’s available text-import commands and dialogs differ, and the Windows legacy wizard path may not be available in the same form. Use the Mac app’s Data tab and its available text/CSV import command. In Excel for the web, use the browser’s available file-opening or import options, or open the workbook in desktop Excel when you need the legacy wizard.

Troubleshooting

“From Text (Legacy)” is missing. Reopen File > Options > Data and confirm that From Text (Legacy) is selected under Show legacy data import wizards. Click OK, then check Data > Get Data again. If the option is not available, confirm you are using the Windows desktop version of Excel and that it is up to date. Some managed work installations may also have features restricted by an administrator.

The wizard opens, but all the data appears in one column. Return to Step 2 and select the actual delimiter. If the file is separated by a character not listed, choose Other and type that character. If the fields are aligned by position rather than separated by a character, go back to Step 1 and select Fixed width. Check several rows in the preview before importing again.

Values split into too many columns. A delimiter may also occur inside text values. Set the correct text qualifier, usually a quotation mark when the source encloses text in quotes. If the file uses a different quoting convention, inspect it in a plain-text editor and match the wizard’s setting to the file.

Accented characters appear as symbols or question marks. The file origin or encoding may be wrong. Go back to Step 1 and try the encoding the source application used; UTF-8 is common for files saved by many modern programs. If you do not know the encoding, make a copy of the source and test likely choices using the preview rather than repeatedly changing the original file.

Leading zeros disappear or dates change meaning. Undo the import if possible, reopen the wizard, and set affected columns to Text or select the correct date order in Step 3. Changing a cell’s display format after import may not recover digits or date components Excel has already reinterpreted.

You are using Excel for Mac or the web. The Windows instructions depend on Excel Options and the Legacy Wizards menu. If those controls are absent, use the text/CSV import features available in your version, or open the file in Excel for Microsoft 365 for Windows to access this exact legacy workflow. Menu availability can depend on the app version and update channel.

Frequently Asked Questions

Is the Text Import Wizard still available in Excel?
Yes. In Microsoft 365 for Windows, the legacy wizard remains available, but it is usually hidden until you enable From Text (Legacy) in File > Options > Data.

What is the difference between From Text (Legacy) and From Text/CSV?
From Text (Legacy) opens the older step-by-step wizard, with options for delimiter or fixed-width parsing and column formats. From Text/CSV opens the newer import experience. Both can import text data, but their dialogs and controls differ.

Can I open the wizard with a keyboard shortcut?
There is no single standard shortcut that directly opens the legacy wizard in current Microsoft 365 for Windows. Use the ribbon path Data > Get Data > Legacy Wizards > From Text (Legacy). Ribbon Key Tips may vary by build, so the visible command is the dependable route.

Can I use the wizard to import a CSV file?
Yes. Select the CSV file with From Text (Legacy), then choose the delimiter shown by the file—often a comma, but not always. Check the preview and set column formats before loading.

Why is my ID number missing its leading zeros?
Excel likely interpreted the field as a number. Repeat the import and set that column to Text in Step 3. The wizard cannot restore zeros that were already removed in a previous import unless they are still present in the source file.

Can I undo an import?
Usually, press Ctrl+Z immediately after importing to undo the last action. If you have performed other work since the import, undo could remove those later changes instead, so inspect the workbook and remove only the imported data if needed.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.