This support note applies to:
Article ID: 310
Certain reports in Accountants Office can be previewed as plain text, which can then be imported into Excel to allow additional analysis of the report data, sorting, etc.
You can do this in couple of ways:
- Copy and paste the report content into Excel; or
- Click the To Word icon then Save the .RTF document as .TXT and open this document in Excel.
To copy and paste in Excel
- Preview the report, select the required data and press CTRL + C. The required data is copied to the windows clipboard.
- Open Microsoft Excel and press CTRL + V. The data is pasted all into one column, usually column A.
- Select this column then from the Data menu select Text to Columns.... The Wizard opens.
- Accept the defaults and click Finish. This will separate the data into the relevant columns.
To use the To Word option
- Preview the report and click the To Word icon. The Save As window appears.
- Select Rich Text File (RTF), select the required location and click Save. The document is saved in the selected location.
- Open Microsoft Word the .RTF file in Microsoft Word and from the File menu select Save As..., The Save As window appears.
- Select Plain Text (.TXT) and select the required location. The file is saved to this location as Tab delimited but discards text formatting information such as Bold, Fonts, etc.
- Open Microsoft Excel and open the .TXT file. The Text Import Wizard opens.
- Select Delimited and click Next. The Wizard continues with Tab selected as the delimiter by default.
- Click Finish. The data now appears in columns.
