Import and Export Excel files

Import a file by opening it in Excel

  • Do one of the following:

    • Go to Data tab > Get External Data group > select the source of the file to import to Excel

    • Go to File tab > click Open > select Text Files in the Open dialog box

  • Follow the Import Data Wizard dialog box

 

Export data to a text file by saving it

  • Go to File tab > click Save as

  • In the Save As dialog box, click the Save as type down arrow > choose the text file format for the worksheet either Text or CSV

Note: Make sure to delete formulas or images in the worksheet to save as .CSV because .csv files can only contain text