You might see that the Dropbox Community team have been busy working on some major updates to the Community itself! So, here is some info on what’s changed, what’s staying the same and what you can expect from the Dropbox Community overall.

Forum Discussion

KarenSW's avatar
KarenSW
Helpful | Level 6
3 years ago

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. 

  • Hannah's avatar
    Hannah
    Icon for Dropbox Staff rankDropbox Staff

    Hey KarenSW, thanks for reaching out to us.

     

    I was able to test this out on my end, but it worked for me, both when pasting from the Excel sheet itself and within Dropbox.

     

    Would you mind trying this out using a different browser or an incognito/private browsing window?

     

    Let me know what you find!

    • KarenSW's avatar
      KarenSW
      Helpful | Level 6

      Okay I tried it in another browser, and then in incognito mode. Same result (see screenshot). The first screenshot is pasted directly from excel (no numbers). The 2nd screenshot I copied from opening the same CSV file within dropbox (it used to paste correctly and include the line numbers as well).

      • Walter's avatar
        Walter
        Icon for Dropbox Staff rankDropbox Staff

        Hey KarenSW, sorry to jump in, but I just wanted to mention that I just tried this on my end and it's working normally for me too.

         

        Can you clarify how exactly are you copy-pasting this part of your csv file into your table in your Paper doc?

         

        As a test, could you try with another file and/or another Paper doc to see if you get any different results?   

         

        Keep us posted!