Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,293,754
Community Members
 
Community Events
165
Community Groups

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

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? 

1 answer

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.

Thanks @Katerina Kovriga _Stiltsoft_, good to know! I'll be testing it out next week for sure.

And here is another option to connect you Google Sheets to the Table from CSV macro via a URL:

Step 1 Go to the Publish to the web tab

image2020-10-2_16-57-51.png

Step 2 Choose the CSV type and allow other users to see it

image2020-10-2_16-58-38.png

Step 3 Get the required URL for the Table from CSV macro

image2020-10-2_16-59-9.png

@Katerina Kovriga _Stiltsoft_  what if it is necessary to authenticate using Corp.  account?

 

the macro can't authenticate to the generated shared URL and displays this error

 

Failed to retrieve data from URL:

Request failed: 403 Forbidden

 

In a Macro like Google Drive, it would display an authentication window to get a token from Google services

Any workaround?

Hi @MOh G , I'm sorry, I'm out of the office for the next week.

Please contact our support team.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
Community showcase
Published in Confluence

Confluence: Where work and wellness meet

Feeling overwhelmed by the demands of work and life? With a 25% increase in the prevalence of anxiety and depression worldwide during the pandemic, for most of us, it’s a resounding yes . 🙋‍♀️ ...

763 views 5 21
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you