Microsoft Excel For Mac Text Import Wizard Can%27t See All Columns

Now in Excel365, we have the Get & Transform area available, which has been described in an older post of mine. The Get & Transform area of the Data tab on the ribbon is superior in terms of DataConnectors and Transformational capabilities. However though, sometimes we just want to use one of the old wizards to import our data such as the LegacyWizards.

The Legacy Wizards do not appear in the Get & Transform area now, they are just hidden waiting for us to turn them on. Below you can find out How To Turn On The Legacy Wizards In Microsoft Excel 365.

We must select the File tab in order to move to Backstage View. Once in BackstageView, from the left of the drop down menu we select the category Options as shown in the image below.

Once we select the Option command, the ExcelOptions dialog box appears, where from the left once more, we select the category Data. Under this category we can ChangeOptionsRelatedToDataImportAndDataAnalysis, as shown below.

Microsoft Excel For Mac Text Import Wizard Can%27t See All Columns

Microsoft Excel For Mac Text Import Wizard Can 27t See All Columns Rows

If you can't download the Power Query add-in, you can use the Text Import Wizard. In this case, we're importing a text file, but the data transformation steps are the same for data imported from other sources, such as XML, Web, JSON, etc. Click the Power Query tab in the Ribbon, then select Get External Data From Text. Change the CSV file extension to TXT (when you open a TXT file with Excel it will start the text file import wizard where you can choose the delimiter) - or - In your CSV file(s), use a text editor to replace all commas, with semicolons;- or - In your Windows Control Panel, change your Regional and Language settings. Go to the Data tab Get External Data From Text. Then, in the Import Text File dialog box, double-click the text file that you want to import, and the Text Import Wizard dialog will open. Step 1 of 3 Original data type If items in the text file are separated by tabs, colons, semicolons, spaces,.

At the bottom part of the Data area we notice the area mentioning ShowLegacyDataImportWizards. All we need to do is to activate or deactivate the check boxes at the left of the commands that we need, and which will be displayed in Excel. The commands that are available are the following:

  • From Web
  • From SQL
  • From XML Data Import

Once we do all the adjustments that we need, we press the Ok button at the bottom right corner of the Excel Options dialog box, in order for us to return to Excel and for our adjustments to take place.

Microsoft Excel For Mac Text Import Wizard Can 27t See All Columns Excel

In the image below, I have activated all the LegacyDataImportWizards, from the ExcelOptions dialog box, and then from the Data tab and from the left area of the ribbon named Get & Transform Data, we select the GetData command as shown below and from Now, from the drop-down menu we notice the LegacyWizards command, with all the available commands that we activated.

Microsoft excel for mac text import wizard can 27t see all columns rowsMicrosoft excel for mac text import wizard can 27t see all columns rows

Below you can check out the video describing Turn On The Legacy Wizards In Microsoft Excel 365.

Don’t Forget To Subscribe To My YouTube Channel.