Can't easily paste a Google Sheets table into a Confluence table?

Manas Kulkarni

Hi there,

We use Confluence for our team's Sprint Retro meetings, and one of the sections is a 3 column table that I populate by copying data from a Google Sheet. 

I used to just be able to copy and paste directly, and the data would populate perfectly in the rows and columns.

However, when I tried today, Confluence tried pasting all of the data into a single cell, even when I tried "Paste and Match Style" (I'm using Chrome if that helps.)

I wonder if this is a bug with the new Confluence layout that I just switched to? 

Katerina Kovriga {Stiltsoft}

Hi @Manas Kulkarni ,

Hope you've already solved your problem because for us everything works fine (have just checked it for Confluence Cloud).

By the way, for large tables we use another workaround:

• copy the share link of your Google Docs Spreadsheet
• change its ending: "edit?usp=sharing" -> "export?&format=tsv" (or "export?&format=csv")
• paste the modified link to your browser and go to it: you will be prompted to download your file in the chosen format
• use the Table from CSV macro to recreate your table in Confluence

The Table from CSV macro is a part of the Table Filter and Charts for Confluence app which can help you to make pivots, perform calculations, merge and transform tables, freeze rows, built custom charts, etc.

It's a wonderful solution to enhance the standard Confluence functionality which provides an opportunity to perform all the required operations in Confluence without switching back to Google Docs or Excel.