Using the Excel Add-In
The Hunni Excel Add-In gives you access to all your Hunni data, directly in Excel.
The add-in is free for all users, so anyone you share to can create a free account and access the data through the add-in.
The Add-In is also useful for adding, editing, or deleting data from Tables quickly.
Log into the Add-In using the same email and password you use to login to the web portal via the Login button on the far left of the Hunni Excel ribbon menu.
- Download Tables or Views
- Upload new rows to a table
- Edit rows on Tables
- Delete rows on Tables
- Submit changes made using the (2) Upload, (3) Edit, or (4) Delete rows functions
- Refresh Tables or Views downloaded using the (1) Download Data function
You can quickly download data from any asset in excel using the Download Data button on the ribbon menu.
- First select the Root Folder of the Table or View you want to download
- Choose the asset you would like to download
- Select the columns you'd like to include in your download
- Choose where you'd like your table to populate in your Excel workbook
You can refresh downloaded assets for any data updates using the Refresh button located on the Excel ribbon. Refreshing an asset will update it with current data in the same location with the same column selections from the original download.
- Click into any cell in the Table you want to refresh
- Click the Refresh button on the Hunni Excel ribbon
You can refrence downloaded Tables in an Excel workbook to create formulas, pivot tables, charts, etc. Excel guide on using structured table references.
When you refresh a downloaded Hunni Table, the table reference name will not change. Do not change the table reference name in Excel if you plan on refreshing the Table, as it may disrupt your functions using Excel's structured table reference.
You can add new rows to Tables using the Upload Rows button located on the Hunni Excel Ribbon menu.
- First select the Root Folder of the Table you want to add rows to
- Choose the Table
- Choose where you'd like your upload Table to populate in your Excel workbook
- Click Create Upload Table button
- An empty table with the column headers for your Table will populate where you can enter new rows to be added to your table
- Click the Submit button on the Hunni ribbon menu to submit the new rows. Your cursor must be in the Upload Table to indicate which Table you want to submit.
You cannot upload data to file columns. Uploading a file ID or a file name will not associate it to a row. Files must be uploaded through the expanded grid row editor in the web portal or through the API .
You can edit Table data using the Edit Rows button located on the Hunni Excel Ribbon menu.
- First select the Root Folder of the Table you want to edit
- Choose the Table
- Choose where you'd like your Table to populate in your Excel workbook
- Click Retrieve Rows button
- The Table will populate in the output location where you can edit data values.
- Click the Submit button on the Hunni ribbon menu to submit the row edits. Your cursor must be in the Edit Table to indicate which Table you want to submit.
You can delete Table rows using the Delete Rows button located on the Hunni Excel Ribbon menu.
- First select the Root Folder of the Table you want to edit
- Choose the Table
- Choose where you'd like your Table to populate in your Excel workbook
- Click Retrieve Rows button
- The Table will populate in the output location. There will be an empty "Delete?" column as the last column. To select rows to delete, enter a Y in that column for each row.
- Click the Submit button on the Hunni ribbon menu to submit the deleted rows. Your active cursor must be inside the Delete Table to indicate which Table you want to submit.
