I have some CSV data in the clipboard that I'm trying to paste into a Google sheet (Chrome, Windows 7). There isn't really a direct paste option for CSV data (like the "Paste Unformatted Text" option in OpenOffice), but I noticed that sometimes a little clipboard icon appears and if you click it a menu with "split text to columns" comes up.
The problem I'm having is, I don't know how to activate this menu and do the actual paste:
Once I click "split text to columns" a separator selector pops up, then... I don't know what the next step is. Selecting a separator just leaves the pop up on the screen, Ctrl+V doesn't do anything, clicking elsewhere closes it, and I'm not sure how to perform the actual action.
So, two questions:
- How do I actually perform this action?
- What is it that triggers that little clipboard thing to come up? I can't actually control it, it just sometimes appears on its own.
I'm not looking for other ways to import CSV data, there are other working solutions e.g. saving to a file then importing. I'm specifically wondering about this context menu action.