Skip to main content

Import sticky notes from Spreadsheet doesn't work

Was it helpful?
Show first post

32 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
  • 7286 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
  • 7286 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

Reply


Behind the Canvas: Powering Innovation in Miro

Terms & Conditions