Grabbing excel fields and displaying value in a smartsheet field

mmcgibbony · 03/22/18

I'm trying to figure this out....

I have 100's of excel files that are not formatted in rows and columns but these excel files all have the same fields and headers configured like a report. I want to "connect" these cells of each of the files to populate a row with columns representing the fields of the excel field name. Is there a tool that will allow me to create row for each spreadsheet to populate the equivalent column from each excel spreadsheet?

Appreciate the help.

Mike

example of excel fields that I'd like to map to smartsheets.png

Shaine Greenwood · 03/27/18

Hi Mike,

There currently isn't a way to link cells in excel to cells in Smartsheet such that the excel data will automatically populate/update in Smartsheet.

Although this might take some work, I'd recommend adding your excel data to Smartsheet as individual sheets. You may be able to import the excel files individually as sheet. Information on this is available in the help center: https://help.smartsheet.com/articles/504553-importing-files-to-create-new-sheets

Then you could create cell links between sheets as needed, which will update one sheet's value from another sheet. More on this here: https://help.smartsheet.com/articles/861579-cell-linking

You could also use formulas to reference data from other sheets: https://help.smartsheet.com/articles/2476606-formulas-reference-data-from-other-sheets

Grabbing excel fields and displaying value in a smartsheet field

Comments

Categories