How to Print Sage 300 CRE Reports to Excel
When it has to be in Excel
Submitted by Sage Certified Consultant, Kyle Zeigler.
Even with all of the power of Sage 300 Construction and Real Estate reporting, sometimes you just need to have the data in an Excel worksheet. Depending on your role within your company, you may need to periodically send information to benefits providers, auditors, banks, finance companies, government agencies, or even potential clients. Many times the recipient wants the information in Excel and often in a particular format. It’s actually not difficult when you know how to print Sage 300 reports to Excel.
Knowing this simple trick can save time when you need to compile that employee census or payroll information, those job lists with contract, estimate and job cost totals, lists of open receivables or payables invoices, equipment lists, and so on.
You begin by choosing the Sage 300 CRE report that contains the information you need. The best reports to use are those that present the data in a columnar format. Instead of printing the report to paper, print the report as a .txt file to a location where you can easily retrieve it (such as your desktop).
“Print” reports to Excel:
- In the Print Selection window, click on “Printer Setup”.
- Check the box “Print to file”.
- Click “Ok” and then click “Start”.
- In the “Save in” window, navigate to the location where you want to save the .txt file.
- Enter a name for your file in the “File name” window.
- In the “Save as type” window, select “Plain text (*.txt)” from the dropdown.
- Click “Save”.
- Open a new Excel worksheet and then “Open” the text file from the “File” menu. The Text Import Wizard will appear.
- Follow the instructions on each of the three Wizard screens and click “Finish.”
When defining columns on the second screen, you’ll want to ignore page headings and create column breaks according to the size of the data in the report columns. If your report contains numeric totals, it helps to scroll all the way to the bottom of the report and use the totals to create column breaks.
To finish your new worksheet, you will want to clean up the report headers, remove page breaks, and possibly rearrange or reformat columns.
Don’t forget to save your Excel workbook and happy reporting!
The opposite direction?!
Want to import data INTO (instead of from) your Sage 300 CRE software? Here’s how!
Need to add users or modules in Sage 300 CRE? Help’s here.
Need a Sage 300 CRE refresher? Book a few hours with an ETHOSystems consultant – at YOUR office!
Email us to schedule today!