Build group-by reports, join multiple tables, and load live Snowflake data into Excel in seconds. Your analysts stay in the tool they already know.
7-day free trial · No credit card required · Windows + Excel
Built for finance, ops, and reporting teams who live in Excel but need data from Snowflake.
Connect to any Snowflake account with your existing credentials — account, warehouse, role, and database. No data ever touches a third-party server.
Choose your table, pick dimension and measure fields, and set aggregations — SUM, COUNT, AVG, and more. Pilbara Connect writes the SQL for you.
Browse related tables and build star-schema queries with point-and-click join configuration. Handles inner, left, and right joins across multiple dimensions.
Results land in a native Excel table on any sheet. Row limits are configurable. Use Insert Into to target any existing range without overwriting your layout.
Hit Refresh in the ribbon to re-run any query with the same parameters. Refresh All updates every Pilbara Connect table in your workbook at once.
Save your query configuration as a named model and reload it any time. Share models with colleagues who have the same Snowflake access.
Install once, connect to your Snowflake account, and start pulling live data into Excel.
Download and run the one-click installer. Pilbara Connect appears in your Excel ribbon immediately — no admin rights required for install.
Enter your Snowflake account identifier, warehouse, role, and credentials. Your connection details are stored securely on your machine only.
Browse schemas, select tables, choose your fields and aggregations, then click Load. Your results appear in a live Excel table in seconds.
One license per user. Cancel any time. Start with a 7-day free trial — no credit card required.
Questions about volume pricing or team rollouts? Contact us
Download the installer and connect to Snowflake in minutes. No credit card required.
Windows only · ~8 MB installer · Excel 2016+