Skip to main content

Import sticky notes from Spreadsheet doesn't work

  • March 31, 2020
  • 34 replies
  • 6905 views
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
  • 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

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
  • Damian Usher
  • Beginner
  • November 15, 2023

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
  • November 15, 2023

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
  • Damian Usher
  • Beginner
  • November 15, 2023

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.

    I
    • IGaC
    • New Here
    • 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

      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
        Mironeer
        Forum|alt.badge.img+2
        • Eca
        • Mironeer
        • 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 :)
        Terms & ConditionsAccessibility statement