Tag Archive: Excel

Excel is everyone’s favourite for working with data. So for most users they want to get data from Sage 200 into Excel. Despite there already being a number of ways to achieve this, I think Sage 200c final brings an easy, quick and useable option.

Send To Excel is a new feature within Sage 200c which allows you to send data into Excel from a report, in a useable format for Excel.

It adds the raw data from the report to Excel and inserts it as a table so you can begin working with the data straight away by sorting and filtering each column. The format of the data also means you can quickly begin to work with it using Pivot tables and charts etc.

This means there is no reformatting, no deleting of duplicated fields and no un-merging of cells. All of which can be experienced with the Export to .csv and/or .xls option.

Also this functionality has no hidden/extra Sage 200 Services costs which come with the Excel Reporting (although as an aside Sage 200c does introduce some new ‘Free’ Excel reports).

So, how does Send to Excel Work?

Simply generate your report to Preview (NB. This is currently only available using the Preview Output Mode, not using the Spooler Preview).

There is now a new Send to Excel button.

Send to Excel button

Once the button is selected Excel is instantly executed and the data will be presented in the format below:

Send to Excel report


I came across an interesting issue recently where a user was printing out a Pro Forma Invoice, but the details section was blank. This was happening even though the information showed on both the Pro Forma entry screens and the Preview of the Pro Forma Invoice print.

Having looked into various scenarios, such as the obvious Sage support checks (Standard layout, demo data, Different user etc.), I managed to find the problem related to how certain users were entering line details. The problem only occurred on Free Text Lines, however the users were Copying details from an Excel spreadsheet and Pasting them into the Line details.

There is obviously some sort of conflict with the formatting of Excel data which is preventing it from physically being printed out.

This problem will occur in all types of Order/Return Line entry, including amending the Item Line Description for a Standard Item Line. Therefore do NOT copy and paste from Excel