To enable the legacy Text Import Wizard in Excel for Microsoft 365 on Windows, open File > Options > Data, expand Show legacy data import wizards, select From Text (Legacy), and choose OK. Then go to Data > Get Data > Legacy Wizards > From Text (Legacy) to start it. The wizard lets you choose how text-file columns are separated and how Excel interprets each column, which can help prevent problems with dates, leading zeros, and regional number formats.
What You’ll Need
- A desktop version of Excel for Microsoft 365 on Windows. The legacy wizard setting described here is for Windows Excel; Excel for the web does not provide this setting.
- A text-based file to import, such as a .txt, .csv, or .prn file, saved somewhere you can browse to. If you are only checking the setting, you can enable it without having a file ready.
- Some idea of how the file is structured: for example, whether fields are separated by commas, tabs, or another character, or aligned in fixed-width columns.
- If the workbook contains important work, save it before importing. You can also import into a new blank workbook to keep the source data separate from existing sheets.
Step-by-Step
- Open Excel’s Options. In Excel for Microsoft 365 on Windows, select File in the upper-left corner, then choose Options near the bottom of the left-hand menu. If a workbook is already open, this opens the Excel Options dialog; it does not change the workbook’s data.
- Go to the Data options. In the Excel Options dialog, select Data in the left-hand list. Find the section named Show legacy data import wizards. Depending on the Excel build and window size, you may need to scroll within the dialog to see it.
- Turn on the text wizard. Expand Show legacy data import wizards if it appears collapsed. Select the checkbox labeled From Text (Legacy). If you also see other legacy import options, leave them unchecked unless you specifically need them; enabling this text option is enough to make the text wizard available.
- Save the preference. Select OK to close Excel Options. The setting is an Excel application preference, rather than a setting saved inside one particular workbook. If the checkbox was already selected, the wizard is already enabled, so you can move on to importing a file.
- Start the legacy import command. Open the Data tab on the ribbon. Choose Get Data, point to Legacy Wizards, and select From Text (Legacy). In some Excel builds the wording or placement of the Get Data menu can vary slightly, but look for Legacy Wizards under the Data tab rather than the newer From Text/CSV command.
- Select your source file. In the file picker, browse to the text file, select it, and choose Import. If the file does not appear, check the file-type filter at the bottom of the picker or change it to show text files and all files. Selecting a file does not edit or delete the original source.
- Choose the file layout in Step 1. The wizard asks whether the data is Delimited or Fixed width. Choose Delimited when a character such as a comma or tab separates fields. Choose Fixed width when columns line up in consistent character positions and there are no reliable separators. Set the file origin or encoding if the preview shows incorrect characters, and check that the preview resembles the source data before choosing Next.
- Set separators and text handling in Step 2. For delimited data, select the delimiter used in the file, such as Tab, Comma, Semicolon, or Space. You can enter a different separator in Other. If fields that contain a delimiter are surrounded by quotation marks, check the Text qualifier setting and make sure the preview keeps those fields together. For fixed-width data, add, move, or remove the divider lines so that each intended field occupies its own column.
- Choose column formats in Step 3. Select a column in the preview, then choose a format such as General, Text, or Date. Use Text for identifiers, postal codes, account numbers, and other values where leading zeros or exact characters matter. Use a date format that matches the order in the source, such as month-day-year or day-month-year. If a column should not be imported, select it and mark it as Do not import column (skip).
- Choose where to put the imported data. Select Finish. Excel asks where to place the result: choose Existing worksheet and select a starting cell if you want the data in the open sheet, or choose New worksheet to keep the import separate. Check that the destination area is empty or that you are comfortable placing data there, then confirm the import.
- Review the result before using it. Check several rows and columns against the source file. Pay particular attention to values with leading zeros, dates, long numbers, accented characters, and text containing the delimiter. If anything was split or converted incorrectly, undo the import if appropriate, run the wizard again, and correct the delimiter, encoding, or column format before finishing.
The wizard’s three preview steps are useful because they let you make decisions before data is placed in the sheet. A comma-separated file is not necessarily a simple case: a description field can contain commas inside quotation marks, and a number such as 00127 can lose its first zeros if Excel treats it as a number. Preview the data and assign formats deliberately rather than clicking through every screen unchanged.
Common Mistakes
- Using the newer import command by accident. Data > From Text/CSV opens the newer import experience, commonly based on Power Query. It is useful for many imports, but it is not the legacy three-step Text Import Wizard. Choose Data > Get Data > Legacy Wizards > From Text (Legacy) when you specifically need the older wizard.
- Choosing the wrong delimiter. If a comma-separated file is imported as tab-delimited, an entire row may land in one column. Conversely, selecting a delimiter that appears inside ordinary text can split a field into extra columns. Use the preview and check how quoted fields are handled.
- Leaving every column as General. Excel may interpret text that looks numeric as a number, remove leading zeros, or turn date-like strings into dates. Set identifier columns to Text before importing. Formatting a damaged value as Text afterward does not necessarily restore characters that were already removed.
- Misreading dates. A date such as 04/05/2026 can mean April 5 or May 4 depending on the source convention. Choose the date order that matches the file, not simply the convention used on your computer. Verify a few dates after import.
- Placing the import over existing data. The wizard can put the results into an existing worksheet. Selecting a starting cell that already contains information may overwrite or obscure data. Use a new worksheet or an empty destination area if you are unsure.
Tips
- Keep a clean source copy. Importing does not require changing the original text file. Preserve it so you can repeat the import with different settings if the preview or result is wrong.
- Use Text for codes, not just numbers. Product codes, postal codes, and employee IDs can consist of digits but still be labels. Importing them as Text preserves leading zeros and avoids unwanted numeric formatting.
- Check the character encoding. If names or symbols display as question marks or odd characters, return to Step 1 and try the appropriate file origin or encoding. UTF-8 is common for files created by modern systems, but the correct choice depends on how the source was saved.
- Know when to use the newer importer. For a one-time import, the wizard is a straightforward way to control delimiters and column types. For a repeatable process that you need to refresh, Data > From Text/CSV may be more suitable because it can create a Power Query connection and preserve transformation steps.
- Use a test import for high-impact files. If the data will be used for reporting or records, import a copy into a new worksheet first. Confirm row counts, column boundaries, and representative values before replacing or updating any working data.
- Remember the Mac and web difference. The checkbox path in this guide applies to Windows Excel. On a Mac, use the available Data > From Text/CSV import route in your Excel version; the Windows Legacy Wizards setting may not be present. Excel for the web does not offer this legacy wizard, so use desktop Excel when you specifically need it.
Troubleshooting
You cannot find Show legacy data import wizards. Confirm that you are using the desktop Excel app on Windows, not Excel for the web or another spreadsheet program. In Windows Excel, return to File > Options > Data and scroll through the page. If the command still is not available, your organization may manage Office settings or use a restricted installation; ask your Microsoft 365 administrator whether the desktop app is up to date and whether legacy import features are permitted.
From Text (Legacy) does not appear under Get Data. Reopen File > Options > Data and make sure the specific From Text (Legacy) checkbox is selected, then choose OK. Close and reopen Excel if the ribbon has not refreshed. Also confirm you are checking Data > Get Data > Legacy Wizards, not the separate From Text/CSV button. Menu layout can differ between builds, but the enabled legacy command should be in the Data tab’s Legacy Wizards group or menu.
The file opens in a worksheet instead of the wizard. Do not double-click the file in File Explorer if that action opens it directly. Open Excel first and launch the legacy command through Data > Get Data > Legacy Wizards > From Text (Legacy), then browse to the file. If Excel is configured to open a particular text format directly, using the ribbon command is the more reliable way to request the wizard.
All the data appears in one column, or a field is split unexpectedly. Run the import again and choose the correct delimiter in Step 2. Look at the source file in a plain-text editor to check whether it uses commas, tabs, semicolons, or another separator. If a text value contains commas, confirm the text qualifier matches the quotation marks used in the file. For fixed-width data, adjust the column break lines in the preview instead of choosing Delimited.
Zeros disappear, dates change, or characters look wrong. Reimport from the unchanged original file. Set affected code columns to Text in Step 3, choose a date format consistent with the source, and try a different file origin if characters are garbled. If the values were already imported and converted, changing the cells’ number format may not bring back lost zeros or the original date text; a fresh import with the right settings is safer.
Frequently Asked Questions
Is the Text Import Wizard still available in Excel for Microsoft 365?
Yes. In desktop Excel for Windows, enable From Text (Legacy) under File > Options > Data, then open it from Data > Get Data > Legacy Wizards. It is a legacy command, so it may not be shown until enabled.
Does enabling the wizard change how all CSV files open?
No. Enabling the command adds a way to start the legacy import process. It does not automatically convert every CSV import to use the wizard, and it does not change the contents of files on your computer.
Is From Text (Legacy) the same as From Text/CSV?
No. From Text (Legacy) opens the older step-by-step import wizard. From Text/CSV opens Excel’s newer import experience, which can use Power Query. Both can bring text data into Excel, but their controls and workflows differ.
Can I use the legacy wizard in Excel for Mac or Excel for the web?
The Windows setting and ribbon path in this guide do not apply to Excel for the web, which does not provide the legacy wizard. Mac versions have a different set of import options and may not show the Windows Legacy Wizards checkbox. Use the available Data > From Text/CSV command on Mac, or open the workbook in Excel for Windows if you specifically need this legacy wizard.
Will the wizard preserve leading zeros?
It can, if you select the relevant column in Step 3 and set its format to Text before completing the import. If you leave a code such as 00042 as General, Excel may treat it as the number 42. Import again from the original file if the zeros have already been lost.
Can I undo an import?
For an import you just completed, Ctrl+Z in Windows Excel will often undo the latest worksheet change. If you have made further changes or the result is uncertain, close without saving or restore a saved copy. Keeping the original text file and importing into a new worksheet makes recovery simpler.
Related
- Excel Calendar With Correct Dates: A Step-by-Step Guide
- Excel AutoSave: How to Turn It Off and Keep Changes Safe
- Delete a Protected Sheet in Excel: Steps and Fixes
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Create a Signature Line in OutlookTo create an email signature in Outlook, open the signature settings for your version of Outlook, add your…
- Excel Goal Seek Maximum Value: Find the Actual MaximumExcel Goal Seek cannot find the maximum value of a formula by itself: it finds an input that…
- How to Rank in Excel From Top to BottomTo rank values from highest to lowest in Excel, enter =RANK.EQ(B2,$B$2:$B$10,0) beside the first value, then fill the…
- How to Edit a PivotTable in ExcelTo edit a PivotTable in Excel for Microsoft 365 on Windows, click any cell inside it, then use…
- Share a Calendar in Outlook Web: Step-by-Step GuideTo share a calendar in Outlook on the web, open Calendar, find the calendar under My calendars, choose…
- ArcGIS for Excel Heat Maps: Setup, Uses, and LimitsYes. ArcGIS for Excel can display mapped point data as a heat map: add your location data to…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.