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 logging in 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 menu overview 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 downloading asset data 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 refreshing downloaded tables and views 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 referencing a downloaded table 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 uploading new rows 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 code examples docid\ n3w2kf2 cfm3ihf3 rbvu editing rows 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 deleting rows 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