Text import wizard :: 2016 on
The Excel 2016 "Text Import Wizard"" was replaced by "Get & Transform" in version 1704 Text Import Wizard Gone? How to Import CSV and Text Files in Excel
Version 1704 (Build 8067.2157) was released on 18 May 2017 Office 365 ProPlus - Version and build numbers of update channel releases
This release date was preceded by two update announcements:
- May 2, 2017, update for Excel 2016 (KB3191861)
- May 2, 2017, update for Get & Transform features in Excel 2016
Information for Office 365 subscribers is provided at: Data import and analysis options. This article has the greatest relevance to your current problem.
To resolve your problem, identify the Excel Build number, in the context of the above links.
If you are still experiencing issues, then perform the data import component on an FBE lab computer with Excel 2013. Or assign the task to another member of your group whose Excel version has Legacy text import functioning.