Share this content

How to extract accounting data into Excel?

Linking Excel to Sage or other accounting software


I'm hoping to get some advice on tips to extract data from accouting software into Excel. So instead of continuously downloading the same report, I could refresh a table in Excel.

I'm aware that there are ODBC links, but I am struggling to find places where I can learn about these and how to apply them. If anyone has got any advice, it'd be greatly appreciated.




Please login or register to join the discussion.

By NHGlos
25th Mar 2019 13:35


A company I worked for several years ago used ODBC to extract data from Sage 50 into Excel, it was set up using a guide produced by the ICAEW - it may have been called something like "Automating Management Accounts".

Using ODBC to extract meaningful data requires the user to have some knowledge of the database in question, have you contacted Sage to see if they produce any guidance. Having used ODBC with much larger SQL databases, the flexibility in the extraction from Sage 50 (in terms of what is extracted, how it looks etc.) is relatively limited but I would say a little more user friendly.

Thanks (0)
By tom123
25th Mar 2019 14:33

ODBC is definitely the way to go - but you need to learn how it all works. Probably beyond the scope of questions on here.

Having said that, I could not do any of my work without ODBC - all of my reports and queries are developed this way - I have a library of about 100 set up on our ERP system.

Worth persevering with, and then you will never be printing out tables and sitting with highlighter pens again :)

Thanks (0)
25th Mar 2019 15:56

Please ignore the below, it is wrong...

[I think ODBC only works with Sage Line 50 (if it is still called that?)

Sage 200 has it's own way of doing things.

I'm happy to be told I'm wrong, though...]

Thanks (0)
Share this content