All Collections
Reports and Data Management
Reports
Opening text file exports in Excel
Opening text file exports in Excel

A step by step instructions on how to open a text file in excel

Updated over a week ago

When downloading a report from coreplus it often comes as a text file, but you might want to open it in Excel. This is easy to do. This article will outline three different methods for opening a .txt file in Excel.


This article contains:

1. Copy and paste
2. Drag and drop
3. Open and view all files types


Copy and paste

1. Open the text file and Excel

2. Hold Ctrl+Shift+A or Command+A to highlight all of the text

3. Copy the text

4. Click on the first square of an new Excel file and paste


Drag and drop

1. Open excel and the file location

2. Click on the file and drag it into Excel


Open and view all files types

1. Click open in Excel, then click Browse

2. Change the file types drop-down from All Excel Files to All files

3. Select the file and click open

4. On the Text Import Wizard click Finish.

💡 After completing one of the above methods, you should have your downloaded report displayed in excel. If you save the file in excel, the next time you need it, it'll be in an excel format. Easy as that!


See similar articles regarding your account set up:

Please let us know if you have any questions and don't forget to rate this help article below, so that we can continue to improve our support to you!


Did this answer your question?