How to Load Data from a Excel File into Instadeq
💠Would you like to go over this topic with an instadeq specialist?
📅 Book a Call Free of Charge
Create new "Spreadsheet File" card
Create a new empty card by selecting the Add Card + button that's above and below each card in a deck, then from the available options select Spreadsheet File.
Load file via drag & drop
Drag a file and drop it into the card's drop area to load it, the drop area should highlight while dragging.
Promote Row to Header option
If the first row of cells are the names of the columns enable this option to promote them to column names, the result will be like a table that has worksheets.
Load file via file picker
Alternatively you can click the drop area to open a file picker and select the file there.
Persistent overview: Store in channel?
Persistent cards will ask you if you want to store the data into a channel.
Data stored in a channel will load automatically when a deck or dashboard that depends on cards configured with the same channel name is loaded, they will also get new values when you store new files, this will make dashboards, charts and decks reflect the latest data as soon as it is stored.
💠Would you like to go over this topic with an instadeq specialist?
📅 Book a Call Free of Charge