Import sticky notes from Spreadsheet doesn't work


Copy paste from Google Table to Miro – transforming in sticky notes is not working. A couples of days ago it just worked fine. Can anybody help?


31 replies

Userlevel 1

According to the docs it should be able to copy and paste multiple cells from a spreadsheet into a Miro board as sticky notes.
While this works fine on Windows it doesn’t work on Mac for me. It always just creates one big textblock with all cells combined.

Anyone one Mac here who experiences the same?

Tested on latest Chrome & Firefox on OSX.

Userlevel 7
Badge +9

Just mail it to support@miro.com 

Someone of the support team will look into this.

Michael

Userlevel 2

Thx @Marina, I managed to do it based on your video. I think that the root cause for this confusion is that the expanation is under the bulk mode text area, I was pasting the cells content there. Maybe you can change this flow so that’s not so confusing, thx

 

Userlevel 7
Badge +5

@Agustin Varela, now I see why you were confused. I will talk to the team about this note inside the bulk mode. 

Userlevel 1

I had the same issue - of getting confused by the “bulk mode” note inside the stickies menu. As of this week, it was still confusing - at least for this Mac User.

Luckily I’ve been working with @Jonathan White to bring a product that is currently combined f2f and online completely into Miro - I think I learn from him half a dozen super useful “power user” tips like this every time we meet!

Userlevel 1

Is anyone (still) having this problem on Mac, across different browsers? This is a huge bummer. Would appreciate any tips/hacks/advice (besides switching to a PC...not an option at the moment, unfortunately)!

me

Userlevel 6
Badge +4

It’s awesome to see your reactions in these A-HA moments @Tristan Forrester!

This is another great example of the community coming together to identify an issue, get some suggestions and support from each other, and then Miro getting involved to address this issue for good.

Nicely done team!

 

Userlevel 2

You’re welcome @Marina!

I am on PC (Firefox) and I was trying to paste the spreadsheet data cells (rows) from the clipboard into the bulk add sticky note section too.

I realized after reading the comments above, and thinking a little more :), that it says to paste onto the board (the frame you are working on or art board area). Confused by same note on screenshots above.

So copy from spreadsheet, then open Miro and just use ctrl-v or cmd-v and you will be prompted with paste options - select sticky notes option. I thought I was experiencing a bug too but just doing it wrong.

Thanks Robert. I was using Excel and had Miro open in Chrome on a Windows laptop. It is working okay now. Might have been a temporary problem on my side. Thanks again.

Userlevel 7
Badge +5

Hi @Lisa Chen @Agustin Varela,

Sorry to hear that :pensive:

There were no more reports about this issue to the Support team. Just to confirm, do you mean that you paste spreadsheet cells right on the board as shown in the gif here?

Please note, that the maximum number of cells that you can paste at a time is 625; the maximum number of characters is 6000.

If you still have a problem, could you please also record a short gif and send it directly to the Support team via the form?

Thank you!

Is anyone (still) having this problem on Mac, across different browsers? This is a huge bummer. Would appreciate any tips/hacks/advice (besides switching to a PC...not an option at the moment, unfortunately)!

I’m glad i found this thread, i was doing it the same way as it seems many people where i was using the “bulk mode” modal, which isn’t really a bulk mode modal….

suddenly experiencing the same problem. Copying cells from excel and they are just entered as a text box if I paste them to Miro.

Pls help… thx 

Userlevel 2

I’ve encountered the same problem. Sad. 

Userlevel 7
Badge +5

We are sorry for the inconvenience. This is a known bug at the moment.

I have checked that @Xinyi Liang has already created the support ticket, so I will also convert @Rüdiger Joppe’s question to a ticket, and the Support team will get back to you via email. 

Thank you for flagging!

 

 

UPD: it was successfully resolved on April 7.

I am having the same problem! Any suggestions?

Userlevel 7
Badge +6

@Kira Brauda - 

are you also using a Mac, as I’ve been able to do it successfully on a Windows PC with Google Chrome?

Kiron

I have used this feature many times but it is not working today. Is there a new bug?

Userlevel 7
Badge +12

I have used this feature many times but it is not working today. Is there a new bug?

What is your set up? WIndows, Mac? What spreadsheet app? (Excel desktop or web, Google Sheets, Apple Numbers?) Are you importing one cell or multiple?

Note: One cell from Google Sheets will import as a text object. This is a limitation due to the way Google Sheets copies a single cell to the clipboard.

Copy paste from Google Table to Miro – transforming in sticky notes is not working. A couples of days ago it just worked fine. Can anybody help?

If importing sticky notes from a spreadsheet into Miro isn't working:

Ensure your spreadsheet is in a compatible format (CSV or XLSX).
Check formatting and content.
Review import settings.
Try with a smaller dataset.
Use an up-to-date browser and Miro version.
Clear browser cache if needed.
Contact Miro support if the issue persists.

Thx @Marina, I managed to do it based on your video. I think that the root cause for this confusion is that the expanation is under the bulk mode text area, I was pasting the cells content there. Maybe you can change this flow so that’s not so confusing, thx

 

 

How do you love a post for saving you a load of pain?

Userlevel 2

hi, I’m having the same on problem on WS + Chrome !!! Any update? thx

I’m now experiencing this too. Cells are pasting as a table into MIRO

Userlevel 7
Badge +12

@Kerrin / @JonoB - Can you provide some details on your specific conditions?

E.g., OS and version (Windows, Mac, etc.), device (laptop, tablet, etc.), application your using to access Miro (browser, desktop app, etc.), which spreadsheet application you are pasting from (Google Sheets, Excel, Excel online/OneDrive, whatever Apple's spreadsheet application is called, etc.).

Reply