cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Announcements
We are making some updates so the Community might be down for a few hours on Monday the 11th of November. Apologies for the inconvenience and thank you for your patience. You can find out more here.

View, download, and export

Need support with viewing, downloading, and exporting files and folders from your Dropbox account? Find help from the Dropbox Community.

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Re: Pasting data from Excel into a paper table pastes them into a single cell

Pasting data from Excel into a paper table pastes them into a single cell

KarenSW
Helpful | Level 6
Go to solution

For the past year this has worked flawlessly:

 

* copy rows from excel spreadsheet

* paste those rows into my premade Paper table (current selected cell becomes point for creating new rows)

 

Now it no longer works. When I copy the data from excel and paste it into paper, all the data goes into a single cell (the one currently selected). Has something changed? Or is my paper table possibly corrupted?

 

I do not need formulas or any excel features, just the text data (its a csv file I download daily from my online orders).

 

EDIT: 
I discovered if I copy directly from the excel spreadsheet it will paste properly into the paper table (un-numbered).

The way I USED to be able to do this is open the excel file from WITHIN dropbox, copy the data (including the numbers that excel adds on the left) and then paste it into the table. I really liked doing it this way because then the pasted lines are numbered.  However that is what no longer works, it will all paste into a single cell without the numbers, not even the commas appear. 

16 Replies 16

KarenSW
Helpful | Level 6
Go to solution

CTRL-C / CTRL-V (copy/paste)

 

Like I mentioned .. I have been doing this for almost a year. Once in awhile it would paste all the data into the first cell so I would go back and copy it again and it would work. Now it does it every time.

KarenSW
Helpful | Level 6
Go to solution

"can you try ctrl+shift+V instead and  vice versa?"

 

I'll try this today, thanks.

KarenSW
Helpful | Level 6
Go to solution

When I did ctrl+shift+V it did paste with the numbers included (unlike before), however its still all in one cell.dropbox screenshot 1.png

KarenSW
Helpful | Level 6
Go to solution

The way I am doing this in the meantime is I copy it from within excel, paste everything into the 2nd column, then manually add the numbers to the first column one at a time. A bit inconvenient but it's all I can do. 

Walter
Dropbox Staff
Go to solution

Thanks for testing this out for me and sorry to hear there's still an issue, Karen.

 

I can see that an expert of our team has sent you an email to help the investigation, so I'd recommend taking this from there as they'll be able to assist further at this point.

 

Let me know if you have anything else to add or ask in the meantime. 


Walter
Community Moderator @ Dropbox
dropbox.com/support


Heart Did this post help you? If so, give it a Like below to let us know.
:arrows_counterclockwise: Need help with something else? Ask me a question!
:pushpin: Find Tips & Tricks Discover more ways to use Dropbox here!
:arrows_counterclockwise: Interested in Community Groups? Click here to join

KarenSW
Helpful | Level 6
Go to solution

The issue has been resolved. Dropbox support was able to duplicate the issue and fixed it on their end. Excellent customer support! A++

Jay
Dropbox Staff
Go to solution

I'm glad to hear that they were able to locate and resolve the issue.

 

If you need any further assistance in future, please let us know. Enjoy your weekend!


Jay
Community Moderator @ Dropbox
dropbox.com/support


Heart Did this post help you? If so, give it a Like below to let us know.
:arrows_counterclockwise: Need help with something else? Ask me a question!
:pushpin: Find Tips & Tricks Discover more ways to use Dropbox here!
:arrows_counterclockwise: Interested in Community Groups? Click here to join!

Need more support?