Classic file types are no longer available for use as of January 2021. You can transition your classic files or download a PDF. Learn More

Can I have the data from a spreadsheet linked to tables in Wdata? The updates I do in the sheet should reflect back in the tables in wdata.

Answered
Request Demo

Can I have the data from a spreadsheet linked to tables in Wdata? The updates I do in the sheet should reflect back in the tables in wdata.

0

Comments

3 comments

Date Votes
  • Jeff Hickey

    Hello Naresh, Yes you can import data from a Spreadsheet into a Wdata Table. Here are steps on how to do it https://support.workiva.com/hc/en-us/articles/360035643472-Manage-a-Table-s-Datasets#section3

    0
  • venkat naresh yarlagadda

    Thank you Jeff. Say once the data is updated in the tables and if I want to look up the history what was before is it possible?

    0
  • Jeff Hickey

    After you have selected a Sheet to add as a dataset, ensure that the "Import name" is unique (see step 6 in previously mentioned link). This will allow you to create more than one file of data in the Table from the same Sheet. You can then review old files for historical data. But keep in mind that this could introduce duplicate data within the Table if two or more files have the same data.

    0

Please sign in to leave a comment.