Grabbing excel fields and displaying value in a smartsheet field

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

Find more posts tagged with

API and Developers

Integrations

Support

Cell linking

Comments

Shaine Greenwood

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

Sign in to join the conversation!

Quick Links

Trending discussions

Does a view-only user need a license to use the API?
Hello everyone, I will need to use Smartsheet API to ingest data from Smartsheet to an object storage. To do that, my client will create a view only account for me. If I understand correctly, to use the API the account needs to be licensed, so we will need to pay for this "service account". That is correct?
Using Control Center to Track Folder Updates?
Hello, I am unsure of the feasibility of this goal but am hoping someone could provide some insight. Within my organization we have the following structure Workspace → Workspace → Folder. Within this folder we have additional folders that are added through an API integration we have setup. I am hoping we would be able to…
Will and API token for a report give access to the Sheet the Report generated from?
Hi, I have a large Smartsheet, I want to generate a row report that reduces information displayed down to a specific group. For that Row Report, if I were to generate an API token and share it to a third party, will that third part have access to the information on the original 'Grid' sheet, or will it be reduced to what…