Copy and Paste from Excel into Smartsheet Project

Andrée Starå

Hi Alice,

How did it go? Did you get a solution to your problem?

Best,

Andrée Starå - Workflow Consultant @ Get Done

Andrée Starå

Hi ,

How did it go? Did you get a solution to your problem?

Best,

Andrée Starå - Workflow Consultant @ Get Done

Andrée Starå

Hi Alfonse,

I've reached out to the others that had issues to see if they solved it. I've seen that there have been some issues that maybe could be connected to this. In the meanwhile, I would recommend that you also reach out directly to the support team.

https://help.smartsheet.com/contact

I hope this helps you!

Best,

Andrée Starå - Workflow Consultant @ Get Done

Britt

Hi Andree,

 

I'm having the same issue - Mac OS, Safari browser, copy column/selected column in excel 2013 to Smartsheet (column or selected column) doesn't operate (paste options greyed out). Import isn't possible without export/manipulate file/import which defeats the purpose of the smart sheet (and adoption of the product) and now shows I made updates to all cells instead of retaining author for other fields. Can we get a quick fix from smartsheet for this?

Andrée Starå

Hi Britt,

I would recommend that you also reach out directly to the support team. I'll get back to you if I get an update.

https://help.smartsheet.com/contact

I hope this helps you!

Best,

Andrée Starå - Workflow Consultant @ Get Done

lbriggs88666

I was looking up this issue as I was having a similar problem.  I just figure it out.  I was selecting one cell in Smartsheet thinking when it pasted it would automatically drop down to the cells below like excel does.  It was pasting everything in that cell.  Once I selected the correct number of cells in Smartsheet it pasted correctly.  Hope this helps someone else!

Andrée Starå

Hi,

Thanks for sharing!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Mattias

Dont know if this helps but I found that copy/paste from an Excel 97-2003 in read-only didnt work.

Re-saving it in .xlsx format and reopening the file made copy/paste work.

Andrée Starå

Great to know!

Thanks for sharing!

Best,

Andrée

asolomon1855

I am having this issue, however, I don't even have the option of pasting either from Excel or from another Smartsheet. I copy the data and when I go to paste, the option is greyed out. I am using the most up to date version of Chrome. I have had this issue for some time now and realize it has been an issue on here for the last year and I am surprised there has not been a more permanent solution as opposed to all these workarounds. Has support made any moves to rectify this? If there is any help out there, thanks in advance.

Andrée Starå

Hi,

It should work. What kind of data and how much? 

Hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

 

jessical111351

I'm also having this issue. I right click a cell and the option to paste is greyed out. I'm using Chrome.

Andrée Starå

Hi Jessica,

I'm not sure why it happens. I'll get back to the post if I find out the reason.

If you haven’t already, I would recommend that you reach out to the Smartsheet Support Team. Smartsheet Support Team

I hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Jun Huang

Been in a Smartsheet Enterprise account for a few months now and all of a sudden, I can't copy and paste from my Excel sheet into Smartsheet. I mean this is crazy. I can't update my main datablock. It's only about 1700 rows and I respect the 50 column, 500 row limits. I mean I do this 2 to 3 times daily. And yesterday afternoon, I hit CtrlV and the screen blinks for a split second and that's it. Like it didn't understand the paste command. Wtf. This is like a major problem and now I find out it isn't even uncommon. Tried Chrome, IE, Edge. Two different computers.

Alex Donnell

I copied 400+ rows out of Excel into Smartsheets yesterday with no problem. Today it won't let me paste in one row from Excel. What happened?

This is basic functionality that seriously limits the usefulness of Smartsheets.

Looks like lots of people have this issue and there is no solution?