Copy and Paste from OneNote

Trever Johnson
[From Support Ticket]: Being able to paste text and images from OneNote directly into ClickUp.
Log In
Activity Feed
Sort by

Gregory McDaniel
When pasting from an application that cuts/copies in formats that include both an image and any common text format, the default behavior should be to paste in a common text format rather than the image. There are other requests arguing for/against plain text as the default format, I’ll leave it to those to settle that, but ClickUp designers should be able to quantify that an image when there’s also a common text format is usually wrong. And default to what's usually right, and if they want to allow pasting as an image for some reason then make that the option, the non-default behavior.
Microsoft OneNote is the prime example source I’m aware of. Yes, paste-as-plain-text is available but it increases my cognitive load to have to remember to do something nonstandard because of where I copied it from. All other Paste destinations I’ve found default to text rather than the image. In my experience the image version of text is always wrong. In what use case is the image-when-also-text correct? The text in an image can’t be searched, or do you OCR all images by default so that they are included in searches?
Every time I make this mistake I get a permanent entry in Activity.
Even this input box does it wrong.
A
Alessandro Verdoni
I guess that a good use of clicup could allow us to abandon onenote.
problem solved.

Chris Lorenz
This is indeed a very frustrating issue. I regularly take notes in OneNote while working on a task and when I want to paste one of the important notes into ClickUp to leave documentation for future developers I have to first paste the text block into notepad, and then into ClickUp, or else it pastes as an image.
J
Jeff MacNeill
Agreed. This would be extremely helpful for our company.
G
Greg Miliatis
Agree with the others that Clickup's paste should allow this.
As a workaround, you can paste into a Google doc, then copy that text & paste into Clickup to retain your OneNote formatting. The quickest way is in your browser, to type docs.new (& hit Enter), which creates a new Google doc, then paste in your clipboard. After you're done copying from the doc to ClickUp, just remember to move your dummy Google doc to the trash.
A
Andrew Tomassetti
I have also just come across this. To paste anything from OneNote, it keeps the formatting and for some reason creates an IMG file instead of showing text. Support let me know that you can do CTRL + SHIFT + V, which will paste only text. However, it would be good when pasting for ClickUp to give an option to keep the formatting, text only, etc.
J
James Daniel
I have been a big OneNote user for a few years now. I'm considering moving it all to something else which is a bit less passive, and am considering ClickUp (which I already use for Tasks), among others.
I have a large number of OneNote pages which consist mainly or solely of tables. Some of them are very large. I want them to show up in ClickUp as grids on pages in docs (that being the closest equivalent to the way they are in OneNote). I need the migration process to be quick and efficient because of the volume of stuff to be moved.
I have tried copying an entire page and pasting. This renders as an image in ClickUp, which is not revisable and of no practical value to me. Likewise copying the OneNote container in which the table is located, or copying all the rows of the table (using the OneNote table handles. These again produce an image in ClickUp.
If I select the
contents
of the table rather than the actual rows, this pastes into ClickUp as text (which is a step forward), but it doesn't come over as a grid. Each row of the table pastes as a separate row of text, with the column values separated by spaces. Getting this into a ClickUp grid would be a huge (and error-prone) manual task. Enough to be a show-stopper.I need ClickUp to do the obvious thing: when I select an entire table in OneNote, copy it, then paste it into a OneNote page, I want it to show up as a ClickUp "/table" with the same number of rows and columns as the OneNote original and all the cells populated with the text from the corresponding cell in the OneNote table.
As noted in another comment, "bouncing" this material off Word or Excel produces what I want (a ClickUp table, populated with cell data), but it's not as efficient as it could be, and the more steps there are, the more open to error the process is.
NB Going via Word produces clean results, but going via Excel produces spurious horizontal cell divisions where there is multi-line text in a cell in the original.
=================================
2023 05 13 Edit:
All the above relates to copying the source material using a desktop app.
Where the source material is in a Notebook hosted on OneDrive, there is a more direct solution - open the Notebook in the OneNote web app (now part of 365) and copy your table from there. In my testing, it pastes perfectly onto a ClickUp page.
B
Bear Humphreys
I have come to this via searching to see if others have problems with text copied from a OneNote page being treated as an uneditable
image
of that text in either ClickUp comments or description fields, or in a new Doc file.Interestingly, if you paste it in as a task title, it is handled properly as text.
Didn't really know if it was a ClickUp bug as such, or whether it is just Microsoft doing something funky and proprietary with the copied block in OneNote.
Other apps handle OneNote text copies differently. For example, in my journal app, pasted text comes through as normal, but it adds an image file of that text separately as well. So, an image tag or identifier of some sort, as part of the copied 'file', is obviously there.
In another note app, it just uses the text, so it must be capable of being ignored.
Anyway, I can see with only a few comments over nearly two years this isn't a huge problem for many, but at least I've found somewhere to put my observations!
J
James Daniel
Bear Humphreys: The Windows clipboard (and AFAIK the Mac clipboard is similar) acts as a middle-man between the app where the copy is coming from and the app where the paste is going to. The "from" app tells the clipboard what formats it can provide and the "to" app chooses which of those it wants to use.
I think OneNote provides an image as lowest common denominator, but I know that when you paste an entire OneNote table into Word or Excel or Coda, it comes across as a table - not a picture of a table or a bunch of sort-of formatted text. From that I would infer that OneNote is capable of providing the clipboard with info that
could
allow ClickUp to do a better job than it presently does.By the same token, when a OneNote table is pasted into Word then re-copied into ClickUp, you get a much better result. So ClickUp is capable of getting this right (given exactly the same content) with some sources. Just that OneNote isn't one of those sources, at the moment.
I suspect that this would be a more popular enhancement request if it weren't for the existence of a workaround. I would guess that everyone who uses OneNote has ready access to Word.

Gregory McDaniel
James Daniel OneNote provides copied text to the clipboard in these formats:
OneNote 2016 Internal
HTML Format
System.String
UnicodeText
Text
EnhancedMetafile
DeviceIndependentBitmap
It's up to the pasting application to select from the format(s) it wants to fetch from the clipboard. I would think one of the text formats would be the lowest common denominator, something that would paste into Windows Notepad.
R
Richard Driver
Can this please be prioritized.
C
Charissa Jelliff-Jones
The fact that text from OneNote only pastes as an image is ridiculously frustrating. I use OneNote for everything, and have to paste it into a Word Doc first, THEN into ClickUp. Such a waste of time.
Load More
→