Importing Excel into existing sheet

Braden Bradford · 09/20/16

I am looking for a way to automate an import process.

1. Can you import into an existing sheet?

2. What I am trying to accomplish is, I keep an update of projects in Smartsheet but I have to manually update notes which come from a daily report I receive. Is there a way to take the daily report and merge the data from smartsheet and excel?

Thanks

Gwyneth C · 09/20/16

Hi Braden,

I can answer the first question...the answer is that importing always creates anewsheet.

More detail about importing from Excel is here:

http://help.smartsheet.com/articles/504553-importing-files-to-create-new-sheets

Reaching out to the community for ideas about automation (as you've done), is a great idea. Interested to hear how/whether others are solving for similar scenarios.

Tony Davidson - SmartSheet Certified User 2016 · 09/20/16

I am not aware of a way to do that merge and would be interested to see if that's a capability.

Laura · 11/02/16

Were you able to successfully merge the data from smartsheet and excel?

Also, when you import an excel sheet into SS and then update the original excel sheet, SS will NOT update correct? Is it possible for SS to update live through an excel sheet?

J. Craig Williams · 11/08/16

If you are on an Enterprise account, data in Smartsheet can be viewed via the ODBC connection in Excel.

https://help.smartsheet.com/articles/1910037-using-the-smartsheet-live-data-connector-enterprise-only-

Depending on what the data is and how it is produced will determine the options for merging it. I'd need to know more to give a more valid answer.

Is one tool being to enter the data and another to manipulate/analyze it?

Or is the data updates done in both?

Or is the manipulation/analysis done in both?

罗ts of variables to play with.

Craig

Marcin P · 10/13/17

Hi,

I have a SS with imported data from excel. I have added few columns before original data and few after.

I have two questions:

1. Is it possible to import data from excel into existing sheet without loosing these added columns?

As far as I found, it's not possible, so I found a little workaround:

2. I have cleared all basic columns (except added ones) and just copied data from excel ctrl+C and ctrl+V, but this allows us to copy no more than 500 rows at the time and all activities taken before in added columns stays as they were before. So I have to mark up all coulumns and just delete what's there.

It's quite painful, so it could be totally wonderful if we could just import data column by column into existing sheet.

I hope you guys at Smartsheet are working on it

best regards

Marcin

J. Craig Williams · 10/13/17

(1) No. Imports go to new sheet.

I only see one question.

Here's what I do:

Case 1: Only new data (columns do not match)

Import Excel (to new Sheet)
Rearrange columns if necessary. For my most common Case 1, the Excel data (generated by another program), I need to rearrange two columns to get the order of 5 columns of interest to match the Sheet in Smartsheet.
Select all content in the imported sheet (Copy)
Paste all content to the bottom of the destination sheet.
如果适用新行移动到适当的层次结构。
Delete imported sheet

Note: If columns match one-to-one, Copy Rows or Move Rows also works.

Case 2: Excel data is the "master", row count same

Process is the same as Case 1, except the matching data range in the destination is deleted first.

Case 3: Excel is the "master", row count changes

We use AppSheet to provide the link between Excel and Smartsheet. Sync occurs at the touch of button. New rows are added to Smartsheet when needed by AppSheet. Existing rows that no longer match are maintained in Smartsheet until user decides to delete them (another AppSheet process)

I hope this helps.

Craig

Andrée Starå · 10/11/18

Hi,

Smartsheet just released a new add-on called Data Uploader that could be an option.

Please see the attached link/screenshot for more information.

//www.santa-greenland.com/datauploader

I hope this helps you!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

jgneely72151 · 12/13/18

Yes, it would be great if you can append an import to an existing sheet. Please add this to your product enhancements list.

Thanks!

Jennifer Neely

Teri Ann Oursler · 01/21/19

Craig,

I tried the steps you mention above and I cannot get my 1518 rows of data to copy from one SmartSheet to another. The copy does nothing. I have let it sit for 2 full minutes and never get it copied. If I select just 499 rows it work, but slowly.

Help, I need to update the data in my Smartsheet that is linked to my reports and dashboard at least every 2 weeks.

Thanks, Teri

Gwyneth C · 01/22/19

嗨,珍妮花,

As Andre notes, this is currently available with Data Uploader. Specifics on requirements and how it works are outlined here:

https://help.smartsheet.com/articles/2478361-data-uploader

If you have a moment, please do add you own use case scenario to the product enhancements list by using theSubmit Product Enhancement Requestlink here (or under Quick links).

Thanks!

MichaelTomar · 12/15/22

You can automate data import from CSV to Smartsheet usingSkyvia. It is a no-code data integration platform. It is a freemium product.

Importing Excel into existing sheet

Comments

Categories