InstructionsEnabling Excel Legacy Import Options in Microsoft 365
Panel
borderStyle
none
Panel
bgColor
#cdb97d
Should you have any questions or concerns with the instructions, please notify the Technology Service Centerfor assistance.
Panel
bgColor
#cdb97d
This describes how to set up the Office 365 version of Excel to allow you to import text (.txt) files the same way you did under previous versions of Excel. This should be a one-time set-up.
Panel
bgColor
#e4e4e4
borderWidth
3
borderStyle
double
Step 1
Open Excel and select the "file" tab.
Panel
bgColor
#e4e4e4
borderWidth
3
borderStyle
double
Step 2
Select the "Options" tab.
Panel
bgColor
#e4e4e4
borderWidth
3
borderStyle
double
Step 3
Select the "Data" tab.
Panel
bgColor
#e4e4e4
borderWidth
3
borderStyle
double
Step 4
Under the "Show legacy data import wizards", check "From Text (Legacy). Then click the "OK" button.