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,254,242
Community Members
 
Community Events
164
Community Groups

How to copy data from excel to confluence in table format

I have a table in excel, but when i copy the data from excel and paste it in confluence page, its taking the data as an image. However, i would like to add the data as a table in confluence. 

 

I have a big table, and now i dont want to type everything again in confluence as I would like to continue to track it in confluence rather than excel.

Could anyone share how this can be done ?

10 answers

  1. From the confluence "Insert table"
  2. Copy the excel table and place the curser at the top left cell of the confluence table and paste

Yes @Kannan S S -- that works well. I think they must've improved the flow since it works basically as expected.

This only half works.  I'm having to copy paste 1 or 2 rows at a time.  No reason it does this.  I've been able to do this with entire spreadsheets in the past.  

Is there really not a more intuitive way of moving something as basic as a table?

Everyone is well versed in creating documents in Microsoft Office products. The default behaviour should be for a list created in Excel to paste as a table in Confluence. It's completely impractical to create a table of hundreds of lines in order to paste a table from another application.

As with a lot of these online applications, the functionality is shoehorned in making it a bespoke task, rather than supporting the majority application seamlessly.

Is there anyone who doesn't expect a seamless copy and paste operation to just work?

Try Copy pasting the table in Power Point first and then from Power point to confluence page, worked fine for me, I use this way out

Hi there,

As this question mentions our Table Filter and Charts for Confluence app, we are happy to introduce its new macro – Table Spreadsheet.

The macro allows you to work with fully functional Excel spreadsheets right in Confluence. You’ll be able to use cells’ formulas, filters, conditional formatting, etc., create pivot tables and charts from the page view and edit mode.

The Table Spreadsheet macro is available for Cloud and Server/Data Center.

You can also use the Table Filter and Charts for Confluence app: it contains the CSV macro and you will be able to import tables easily from CSV or TSV data sources (URL or attached files).

Hey @Katerina Kovriga _Stiltsoft_ 

In an effort to maintain transparency in the Community, please be sure to clearly identify this as your company's application and state your affiliation with the company when responding to Community posts. Please have a good read-through of the other Atlassian Community online guidelines for Marketplace vendors and Solution Partners.

Thank you!

Best, Max

Like # people like this

Hi @Max Foerster - Decadis AG ,

Thanks for the tip - got my profile name updated.

@Prabhamani  Why don't you directly attach your excel files to a confluence page instead of copying/pasting data? 

Our app, Polaris spreadsheet allows you to embed an existing excel and CSV files in a confluence page and directly edit it.
It offers full editing capabilities for excel files and provides an advanced view mode that allows you to use filters, scroll, and find. Please check the details.
A month's free trial is available now! 

Atlassian Marketplace 

0 votes
RV I'm New Here May 13, 2022

It's a Microsoft world :-(

I wanted to make the readers aware that it works perfectly in Open Office Calc.

If you copy from Open Office Calc and paste into an empty Confluence table then the pasted table is perfectly presented!

 

**UPDATED RESOLUTION**

To resolve another issue, I just ran the "Restore Settings to their Original Defaults" option on Chrome.  That resolves the problem entirely (no work-around needed).

 

However, if that doesn't work, the work-around below is still functional:

*************

 

 

This is a bug/feature that must have just started- As you stated, copied Excel cells now paste into Confluence as a picture instead of text (I'm using the Chrome browser).  

Here's the work-around I was able to use (instead of PPT): 
1. Copy the table from Excel
2. Paste it into Word
3. Copy it from Word
4. Paste it into Confluence

This helps retain Excel's "text" when pasting into confluence.

Legacy editor helped.  not perfect.

0 votes
Thomas Schlegel Community Leader Jan 22, 2020

Hi @shetty ,

copy & paste from Excel works fine for me. I do the following:

  • create an empty table in Confluence with the number of rows your excel table has
  • Select the data in Excel and copy
  • Put the cursor into the first cell and paste

  

@Thomas Schlegel 

Will try 

Thank You

Like # people like this

Try Copy pasting the table in Power Point first and then from Power point to confluence page, worked fine for me, I use this way out

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Confluence Cloud

Presenter Mode for Confluence is here 🖥 👩‍💻

👋  Hello Community!  My name is Stephanie Zhang, and I’m a product manager on the Confluence cloud team. Today, I’m excited to announce the rollout of  Presenter Mode : a ...

1,975 views 18 39
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