Data Import & Export

Fix Excel From Text Legacy Import Wizard Not Opening

Ayan MasoodAyan Masood Nov 10, 2026 871 views

Question details

The user needs to troubleshoot and restore the functionality of the 'From Text (Legacy)' command when the Text Import Wizard fails to appear for importing TXT or CSV files.

How to Fix Excel From Text (Legacy) Import Wizard Not Opening
Product
Microsoft Excel
Device & OS
not provided
Scenario
Importing data from TXT or CSV text files using the legacy data import tools.
Observed behavior
The Text Import Wizard fails to launch or nothing happens after selecting the 'From Text (Legacy)' command and choosing a file.
Before you start

Ensure your Excel application is fully updated, and verify that the TXT or CSV file you are attempting to import is not currently locked, corrupted, or opened by another background program.

Solution 1Recommended

Enable Legacy Data Import Wizards in Excel Options

The most common reason the legacy wizard doesn't appear is that it is disabled by default in newer versions of Excel and needs to be manually activated in the Data settings.

Modern versions of Microsoft 365 and Excel have transitioned to Power Query as the primary data import method, hiding the older wizards. You must explicitly toggle these legacy wizards back on.

1
Open Excel Options

Click on 'File' in the top-left corner of the Excel ribbon, then select 'Options' at the very bottom of the menu.

2
Navigate to Data Settings

In the Excel Options window, click on the 'Data' tab located on the left-hand sidebar.

3
Enable Legacy Wizards

Scroll down to the 'Show legacy data import wizards' section. Check the box next to 'From Text (Legacy)' and click 'OK' to save the changes.

4
Restart Excel and Import

Close and reopen Microsoft Excel. Navigate to Data > Get Data > Legacy Wizards > From Text (Legacy), choose your file, and click Get Data to launch the wizard.

Enable Legacy Data Import Wizards in Excel Options
Verification: Once properly enabled, selecting your TXT or CSV file will correctly trigger the Text Import Wizard pop-up, allowing you to choose your delimiter and column data formats.
Direct Data Import Solution

Import Text and CSV Files Easily with WPS Spreadsheet

If Excel's legacy wizard fails to launch or requires complex configuration, you can accomplish your data import directly using WPS Spreadsheet. WPS Office offers a straightforward, built-in text import wizard that reliably handles CSV and TXT files without requiring deep menu diving.

  1. 1. Open WPS Spreadsheet: Launch WPS Office and open a new or existing Spreadsheet.
  2. 2. Go to the Data Tab: Navigate to the 'Data' tab on the top ribbon menu.
  3. 3. Import Data: Click on 'Import Data' and select the option for your file type, then choose the TXT or CSV file from your computer.
  4. 4. Configure the Wizard: The Text Import Wizard will open automatically. Follow the prompts to set your file origin, select delimiters like commas or tabs, and define data formats before clicking 'Finish'.
Direct and hassle-free text import wizard available by defaultSeamless format compatibility with Microsoft Excel files (.xlsx, .xls, .csv)Free and lightweight software that processes large data files efficientlyFamiliar user interface ensuring zero learning curve
microsoft office alternative - wps office

Frequently Asked Questions

Why is the From Text (Legacy) wizard missing from my Excel Data ribbon?

In newer versions of Microsoft Excel (such as Office 365 and Excel 2019), the legacy text import wizard is hidden by default in favor of the newer Power Query 'Get Data' tool. You must manually enable it through File > Options > Data.

What is the difference between the Legacy Text Import Wizard and Get Data?

The Legacy Text Import Wizard is the older, step-by-step tool used strictly for parsing delimiters and data types upon initial import. 'Get Data' uses Power Query, a modern tool that creates a live, refreshable connection to the source file and allows for complex data transformations before the data is loaded.

Can I import a CSV without using any import wizard?

Yes. You can simply open a CSV file directly via File > Open in Excel or WPS Spreadsheet. The application will automatically parse the data based on your computer's system default list separator, bypassing the wizard completely.