Importing from Excel works one way, but not another?
Hi there,
I am trying to create a new sheet from Excel data. If I create the sheet and then go into the sheet and click File>Import>Import from Microsoft Excel, I can pull the data in, but when I leave the sheet, everything is gone. When I import the data, I follow all the usual import steps, but the Save option is grayed out.
However, in the workspace, if I click Create and then Import from Microsoft Excel, the process works just fine and the data saves.
Does this mean that the File>Import>Import from Microsoft Excel is only for adding data to a sheet that already has a structure (column headers, primary column set)?
Thank you!
Best Answer
-
Genevieve P. Employee AdminTo clarify, when you import data from Excel directly within the App, it will always create anewsheet. That means if you'reina sheet when you click Import, it will bring in the data to an entirely new sheet.
If you then leave Smartsheet and come back to the original, blank sheet you were on when you selected "Import", it will still be blank because data isn't mapped into that sheet. Does that make sense?
See:Import Files to Create New Sheets
Look for a new sheet with the same name as your file and you should find your data there!
Cheers,
Genevieve
Answers
-
Colleen Patterson ✭✭✭✭✭✭
I find that the sheet will pull in as expected, but I need to enter data into at least 1 cell, in order for things to save / be accessible later. As soon as you do it, you would find the sheet to be accessible / findable in the search.
If my answer helped you, please be sure to mark it as Accepted to help future learners locate the information.
-
Andrée Starå ✭✭✭✭✭✭I hope you're well and safe!
Strange!
If you haven’t already, I recommend submitting a support ticket through the newSmartsheet Support Portal.
I hope that helps!
Be safe, and have a fantastic week!
Best,
Andrée Starå| Workflow Consultant / CEO @WORK BOLD
✅做我的帖子(s)帮助或回答你什么stion or solve your problem? Please support the Community bymarking 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:[email protected]| P: +46 (0) - 72 - 510 99 35
Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.
-
Genevieve P. Employee Admin
To clarify, when you import data from Excel directly within the App, it will always create anewsheet. That means if you'reina sheet when you click Import, it will bring in the data to an entirely new sheet.
If you then leave Smartsheet and come back to the original, blank sheet you were on when you selected "Import", it will still be blank because data isn't mapped into that sheet. Does that make sense?
See:Import Files to Create New Sheets
Look for a new sheet with the same name as your file and you should find your data there!
Cheers,
Genevieve
Categories
I hope you're well and safe!<\/p>
There's a known issue at the moment.<\/p>
I'll get back to the post if I can find the thread.<\/p>
I hope that helps!<\/p>
Be safe, and have a fantastic weekend!<\/p>
Best,<\/p>
Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p>
