The Peliqan Excel add-in allows you to pull in real-time data from Peliqan into Excel. This can include data in the Peliqan data warehouse, data in an external data warehouse, a connected database, tables created in Peliqan, queries written in Peliqan (including Trino queries using the Peliqan federated query engine).
The Peliqan Excel add-in is a great way to provide self-service access to data for business users. For example, accountants can pull-in real-time data from multiple accounting systems from their end-customers.
The add-in is available for Excel on Windows and Mac, as well as Excel in the browser.
Install the Peliqan add-in in Excel
In Excel go to the Home Ribbon, click on Add-ins and select “More add-ins”:
See “Add-ins” on the right hand side of this Home Ribbon in Excel.
This will open the Add-in Store (Microsoft AppSource). Now search for Peliqan and click on “Add”. The add-in will now be added into your Excel in the Home Ribbon. Click on the add-in in the Ribbon to open it.
Login in the Add-in
Login with your Peliqan username & password. When you have 2FA enabled, login with your API token instead. You can find in Peliqan under Admin > Settings > API token. Click on “Generate API token” if you don’t have a token yet.
Sync data into Excel
Once you are logged in inside the add-in, you will see a list of tables and queries that are available to you:
Select a table in the drop-down and click on Sync data, to get real-time data into the current Sheet in Excel. You can repeat this to get updated data. The current Sheet will always be over-written with the new updated data:
As a best practisc, do not edit the data in this Sheet. Instead use other Sheets in Excel to create e.g. reports, and use VLOOKUP
formulas to fetch data from the data sheet.
Keep multiple sheets up-to-date
When you select a Table and click on the “Sync data” button, the add-in will remember your choice. Next time when you open your Excel file and go to the same Sheet, the mapped table will be remembered and automatically selected.
You can add add mappings in multiple sheets in Excel, and click the button “Sync all sheets”, to keep all the sheets updated with a single click of a button:
Sync multiple tables to the same sheet
You can sync multiple tables from Peliqan to the same sheet in Excel, by clicking the “+ Add table” button. Configure a different Start call for each table and make sure the resulting data will not overlap: