Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

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,466,648
Community Members
 
Community Events
176
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

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

  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.  

Like 시드_이인희_ likes this

Just make sure you don't have any merged cells in the source and it should paste ok.

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 - K15t ,

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 

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

  

shetty Rising Star Jan 22, 2020

@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

Atlassian Community Events