Skip to main content
Open

Copy multiple cells from excel into one sticky note

  • November 19, 2020
  • 4 replies
  • 1269 views
  • Eca
    Eca
  • Mohamed Abdurahman
  • Katie Gould

Copy multiple cells from excel into one sticky note.

Or copy an excel row into a single sticky note. Currently if I want to put data from multiple cells on a sticky note I need to create a column/cell in excel with a long text string concatenating the cells together and then copy that one long string into a sticky note. It doesn't read very well. This would help with bulk importing data from other systems for planning purposes. 

Was it helpful?

4 replies

  • Beginner
  • 5 replies
  • November 20, 2020

@Tracy Dumpert As a temporary workaround there are a couple of things you might try. 

First: Control-Shift-V (or apple equiv.) should paste without formatting and that may paste your text content without row formatting. 

Another idea: You can paste your copied row to a notepad, then recopy it from the notepad and paste it into the sticky note. The notepad should remove the formatting. 

As an FYI, I don’t actually use Excel, but was unable to reproduce your issue using google sheets, which in my experience, has been a better experience. Full disclosure, I used excel for at least 10 years before switching and I’ll not go back if I can help it. I know it doesn’t fix your exact concern but it was worth the mention.  :relaxed:

 


  • Author
  • Beginner
  • 3 replies
  • November 20, 2020

Thanks for the reply Chris.

When you say you were unable to reproduce with google sheets, do you mean you cannot copy a row into a sticky note from there either? I see there is actually a product by Zapier that does what I need, but it is for Google Sheets.

 

 


  • Beginner
  • 5 replies
  • November 20, 2020

Hi Tracy,

Nah, I meant there is no issue copying a row of cells, or a column of cells, and pasting it into the sticky note. It pastes as a paragraph, which is expected, since a sticky note wouldn’t be expected to have tables, but it pastes in without issue. 

As for something that would do what you need in an automated way, yes it would have to be something with (1) a cloud service, (2) an API and (3) who invested in a Zapier app (integration) Google sheets is cloud, has an API and has invested in the Zapier integration. Microsoft Excel has zero out of three, as far as I know.

For what it’s worth, migrating to google sheets is pretty simple, and uploading and converting an excel sheet to a google sheet is pretty seamless (most formulas and such migrate without effort - but not all)

And its also free, unlike Excel. :)

Again, I’ll lean in the direction of not trying to ‘pitch’ it to you. But the google sheets / zapier automation is also one my company uses a lot and it works well. For my 4 person team, Zapier performs (via automation) over a thousand tasks per week.

Cheers


I have the same question. To help explain the business need.

  • all data currently lives in a CSV file
  • 50 rows of data
  • each row contains 5 columns
  • would like to import all the data in 1 fell swoop
  • after import would like to have 50 individual stickies/shapes/etc
  • each shape contains all the column cell data across a row

Is this doable?

 

Thanks, 

Chris


Reply