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.
<aside> đź’ˇ
As an alternative, you can also use an ODBC connection in Excel to sync data from Peliqan to Excel sheets. Click here for more info.
</aside>
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 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.
