Need to see if your shared folder is taking up space on your dropbox 👨‍💻? Find out how to check here.

Forum Discussion

KarenSW's avatar
KarenSW
Helpful | Level 6
4 years ago
Solved

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

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. 

Download
Dropbox Paper

16 Replies

Replies have been turned off for this discussion
Show More
  • KarenSW's avatar
    KarenSW
    Helpful | Level 6
    4 years ago

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

     

    I'll try this today, thanks.

  • KarenSW's avatar
    KarenSW
    Helpful | Level 6
    4 years ago

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

  • KarenSW's avatar
    KarenSW
    Helpful | Level 6
    4 years ago

    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's avatar
    Walter
    Icon for Dropbox Community Moderator rankDropbox Community Moderator
    4 years ago

    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. 

  • KarenSW's avatar
    KarenSW
    Helpful | Level 6
    4 years ago

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

  • Jay's avatar
    Jay
    Icon for Dropbox Community Moderator rankDropbox Community Moderator
    4 years ago

    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!

About View, download, and export

Node avatar for View, download, and export
Need support with viewing, downloading, and exporting files and folders from your Dropbox account? Find help from the Dropbox Community.

The Dropbox Community team is active from Monday to Friday. We try to respond to you as soon as we can, usually within 2 hours.

If you need more help you can view your support options (expected response time for an email or ticket is 24 hours), or contact us on X, Facebook or Instagram.

For more info on available support options for your Dropbox plan, see this article.

If you found the answer to your question in this Community thread, please 'like' the post to say thanks and to let us know it was useful!