"Import" > "Update Rows"
I want to import data to an existing data sheet whereby it will upload the data from my source sheet excel to my existing data set and match by the unique identifier
I found the below instructions but the "Import" > "Update Rows" option is not available, can someone guide me on how to access this option?
Yes, in Smartsheet, you can import data into an existing sheet and match by a unique identifier using the "Update Rows" feature. This allows you to import data from an Excel file, a CSV file, or other supported file types, and update existing rows based on a unique identifier. Here's how you can do it:
- Prepare Your Import File: Ensure your import file has a column that contains the unique identifier that matches a column in your existing Smartsheet. This identifier will be used to match rows during the import.
- Open Your Existing Sheet in Smartsheet: Go to the Smartsheet with the data set you want to update.
- Start the Import: Click on "File" in the top menu, then choose "Import" > "Update Rows".
- Select Your File: Follow the prompts to select and upload your import file from your computer.
- Map Columns: In the import wizard, you'll be asked to map the columns from your import file to your existing Smartsheet columns. Make sure to map your unique identifier column correctly.
- Review and Finish: Review the changes that will be made and then confirm to complete the update. Only the rows with matching unique identifiers will be updated.
Answers
-
Those instructions are for the Premium Add-on Data Shuttle. Without that, you will need either the API, a third party app, or manual copy/paste.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Thank you for the feedback. I have a Smartsheet business account, I assume this will be additional license fees for Data Shuttle?
-
Hi @Johan S
I hope you're well and safe!
Yes, it's a Premium App that requires an additional license.
More info:
I hope that helps!
Have a fantastic weekend & Happy Holidays!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives