Importing Data into Excel

Bringing the tab-delimited text file into Microsoft Excel is straightforward:

  1. First download the MetisDiscoverExport.zip via Discover.
  2. Then extract the file in an appropriate folder.
  3. In Excel via the File menu open the "import file.txt"

This will launch Excel's text import wizard which should detect the import file is a tab-delimited file:

TextImportWizard2

 

TextImportWizard Stage 2

 

A similar text import wizard can also be accessed via the Data tab and selected Get data -> From Text/CSV:

TextImportWizard3