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

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

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

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.

Userlevel 7
Badge +12

@SarahmeetMiro - While .csv files will open in a spreadsheet application, e.g., MS Excel, they do not contain the same formatting data that Miro is expecting to see when copied to a clipboard. Instead, CSV is basically plaintext data with commas in between the values. 

Try opening the CVS file in your spreadsheet application, saving it (Save as...) that application's standard format, e.g., MS Excel's .xlsx, and then copying-pasting into Miro.

Also experiencing this. Pasting from a CSV just inserts everything into one text block-- I am not prompted to paste as stickies. 

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.

Userlevel 7
Badge +12

@Kerrin & @JonoB - Thanks for the info. I have created the following post and tagged you in it here:

https://community.miro.com/ask-the-community-45/potential-bug-some-spreadsheet-cells-pasting-as-text-rather-than-sticky-notes-8642

I have also submitted a support ticket with Miro.

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

 

Mac OS (not with me now so can’t give you the version, but it should be quite up to date)  

Tried app and browser version /safari, copying from Excel App

 

Tried on same miro board on Windows, via browser / firefox-  and it worked all fine. 

 

thanks for checking! 

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

Sure thing,

Windows 10, laptop, through chrome but also through the miro app. Cells copied from Microsoft Excel local file

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

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

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 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 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!

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

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

You’re welcome @Marina!

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

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!

Userlevel 2

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

@Marina I’m on a PC and still have this problem.  Using Chrome.

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

Reply