Link Database to Excel

Link Database To Excel is a tool for linking databases through webdata with Excel, LibreOffice Calc or other sheet applications which support webdata.

How it works

• add a datasource and connect to your favorite database
• configure an endpoint,
  • create a SQL query
  • determine a name for the endpoint
• link your Excel sheet to the endpoint
  • open excel
  • - select Data
  • -- From Other Sources
  • --- From Web
  • paste the url/endpoint copied from the Endpoints list

SSH Tunnels are also supported which can cirumvent firewalls in some situations.

After the data is imported in Excel, the data will be automatically updated. The frequency depends on the software settings, this can be every minute or on opening the sheet.

Introduction (in dutch)

Download

On request the tool is available for macOS and Linux.

Tags: link database to excel - link database to sheet - link sql query to sheet - link query to libreoffice calc - webdata