Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Panel
borderColornone
titleColor#FFFFFF
borderWidth2
titleBGColor#7c0034
borderStylenone
titleInstructionsEnabling Excel Legacy Import Options in Microsoft 365


Panel
borderStylenone


Panel
bgColor#cdb97d

(question)  Should you have any questions or concerns with the instructions, please notify the Technology Service Center for assistance. 

Note

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
borderWidth3
borderStyledouble

Step 1

Open Excel and select the "file" tab.



Panel
bgColor#e4e4e4
borderWidth3
borderStyledouble

Step 2

Select the "Options" tab.


Panel
bgColor#e4e4e4
borderWidth3
borderStyledouble

Step 3

Select the "Data" tab.


Panel
bgColor#e4e4e4
borderWidth3
borderStyledouble

Step 4

Under the "Show legacy data import wizards", check "From Text (Legacy). Then click the "OK" button.



...