Skip to main content

Import sticky notes from Spreadsheet doesn't work

Was it helpful?
Show first post

34 replies

S

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

Robert Johnson
Forum|alt.badge.img+13
  • Robert Johnson
  • Volunteer Community Moderator
  • 7335 replies
  • March 30, 2023

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

Volunteer Community Moderator | Visual Thinker | Frame many items at once using MultiFrame.ca
R
Rüdiger Joppe wrote:

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.

D

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

Robert Johnson
Forum|alt.badge.img+13
  • Robert Johnson
  • Volunteer Community Moderator
  • 7335 replies
  • November 15, 2023
Damian Usher wrote:

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.

Volunteer Community Moderator | Visual Thinker | Frame many items at once using MultiFrame.ca
D

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.

Robert Johnson
1 person likes this
  • Robert Johnson
    Robert Johnson
I
  • IGaC
  • New Here
  • 1 reply
  • January 9, 2025

I am experiencing an issue where an HTML table is successfully copied to the clipboard using the Clipboard API, but it cannot be pasted into Miro. The same HTML table works correctly in other environments (e.g., when pasted into Excel or Google Docs), indicating that the problem lies not with the Clipboard API, but with how Miro handles formatted HTML.

Below is an example of the HTML table I am attempting to paste into Miro:

<html xmlns:o="urn:schemas-microsoft-com:office:office"

      xmlns:x="urn:schemas-microsoft-com:office:excel"

      xmlns="http://www.w3.org/TR/REC-html40">

  <head>

    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">

    <meta name="Generator" content="Microsoft Excel 15">

    <style>

      <!--

      table {

        border-collapse: collapse;

        width: 100%;

      }

      th, td {

        border: 1px solid #ddd;

        padding: 5px;

        text-align: left;

      }

      th {

        background-color: #f4f4f4;

      }

      .xl65 {

        text-align: left;

        vertical-align: top;

      }

      -->

    </style>

  </head>

  <body>

    <table x:str border="0" cellpadding="0" cellspacing="0">

      <tr>

        <td></td>

        <th>Column 1<br>Description 1</th>

        <th>Column 2<br>Description 2</th>

      </tr>

      <tr>

        <th>Row 1<br>Description 1</th>

        <td class="xl65">Idea 1<br>Details 1</td>

        <td class="xl65">Idea 2<br>Details 2</td>

      </tr>

      <tr>

        <th>Row 2<br>Description 2</th>

        <td class="xl65">Idea 3<br>Details 3</td>

        <td class="xl65">Idea 4<br>Details 4</td>

      </tr>

    </table>

  </body>

</html>
I’m using Microsoft Windows 11 Enterprise, Chrome 131

Eca
1 person likes this
  • Eca
    Eca
Patrik Lindström

I am using a Mac and I now five years later get the exact same problem. Using the bulk mode i get one sticky notes with all the rows.  I have tried Chrome and Safari. 
I have tried copying it from google spreadsheet. Paste data in texteditor as VSCode and copy from there. I have tried using the Miro MacOs Desktop App with same result. 
What did work was copying the data to a spreadsheet as google sheet copy the column with data then just paste it on the canvas. Then I get a dialogue about how I want it pasted: as a table, etc and tada as sticky notes. When I choose that it worked both in Desktop app and in Chrome.

Eca
1 person likes this
  • Eca
    Eca
Eca
Mironeer
Forum|alt.badge.img+2
  • Eca
  • Mironeer
  • 2053 replies
  • April 11, 2025

Hi ​@Patrik Lindström, thanks for sharing all the steps you tried!

 

If you're able to share a short video or a screenshot of the copy-paste behavior (especially from the moment you paste into the board), that would really help us see what might be going wrong.

Thanks again for contributing to the thread — looking forward to figuring this out with you!

Eca :)

Reply


Behind the Canvas Highlights + Your Turn to Weigh In

Terms & Conditions