Can I export the report data to Excel?
Yes. Just follow these steps:
- From within any report window choose
the menu command "Edit / Copy Text".
- Open up any text editor, such as
Notepad, and paste into a new text file. Save this file.
- Open up Excel and use "File /
Open...". Change the "Files of Type" option to "Text files", and
open up the text file you saved in step #2. This will open the
"Text Import Wizard" in Excel. Choose the "Fixed Width" option,
and follow along with the rest of the prompts to open up this file.
There is also another method which skips
the use of Notepad and saving to a text file. You could also use
this method to get your report data into Excel:
- From within any report window choose
the menu command "Edit / Copy Text".
- Open up Excel, and paste the contents
of the clipboard into a spreadsheet. All of the report data will
be contained in one column. Use the menu command "Data / Text to
Columns..." while the just pasted data is still selected. This
will open the "Convert Text to Columns Wizard" in Excel. Choose
the "Fixed Width" option, and follow along with the rest of the
prompts.
Return to the FAQ.
|