Child Item

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.

Find more posts tagged with

Dropbox Paper

Accepted answers

KarenSW

Ticket #17189877

Thank you.

All comments

Hannah

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

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).

directly from excel.png

dropbox incognito screenshot 1.png

Walter

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!

KarenSW

When I copy the lines from my excel program and paste it directly into the paper table it works just fine (other than leaving out the line numbers).

However when open the CSV from within dropbox and highlight and copy the lines (see pic), then paste it into the dropbox table - it pastes them all into one cell, unformatted. I have been doing this for over a year with no issues. I am not sure if its because shipstation has made changes (that is where I download my CSV from). But isn't a CSV a CSV .. ?

dropbox screenshot 1.png

KarenSW

If I can not manage to get this to work as it used to, is there a quick and easy way to populate the number field with successive numbers? Then I can simply paste the data from excel and populate the first field with numbers afterwards.

KarenSW

And to answer your other questions .. I have tried making a new paper doc, a new excel file, a new browser, an incognito browser ... all to no avail.

Jay

Hi @KarenSW, I'd recommend getting in contact with the support team directly for further assistance.

Once you get a ticket ID from the automated response, please let me know the number here so I can locate it in our system.

KarenSW

Ticket #17189877

Thank you.

Walter

Thanks for the ticket ID, Karen. I've found it on our system and passed on your comments there. A member of our support team should be getting back to you soon through your ticket so keep an eye on your email's inbox.

In the meantime, can you let us know how are you pasting those entries into your Paper doc? For example, are you using shortcuts or the right click options?

If you're using ctrl+V to paste, can you try ctrl+shift+V instead and vice versa?

KarenSW

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

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

I'll try this today, thanks.

KarenSW

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

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

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

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

Jay

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!