Fix Excel From Text Legacy Import Wizard Not Opening
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.

- 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.
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.
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.
Click on 'File' in the top-left corner of the Excel ribbon, then select 'Options' at the very bottom of the menu.
In the Excel Options window, click on the 'Data' tab located on the left-hand sidebar.
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.
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.

Use the Standard Modern Data Import Feature
If the legacy wizard continues to fail, you can bypass the issue by utilizing Excel's modern Power Query tool to import text and CSV data.
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. Open WPS Spreadsheet: Launch WPS Office and open a new or existing Spreadsheet.
- 2. Go to the Data Tab: Navigate to the 'Data' tab on the top ribbon menu.
- 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. 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'.

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.




