It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How to copy and paste entire table in Confluence 4.1

Craig Hylwa Jan 09, 2012

Editor improvements Copy and paste table improvements You can now copy and paste multiple table rows and entire tables. There are also new keyboard shortcuts. You can now use Alt+Up Arrow or Alt+Down Arrow to add a row above or below the current row.

This is listed as a new feature of 4.1 however I am unable to locate the functionality of this. Has it been implemented?

9 answers

20 votes
Arithzari Oct 10, 2016

Thanks @njinji. The quickest for me was similar:

  • 1 : Create single cell table
  • 2 : Unformat header (remove header row)
  • 3 : Select all rows in source table
  • 4 : Copy rows (CTRL SHIFT C)
  • 5 : Place cursor in destination table
  • 6 : Paste rows (CTRL SHIFT V)
  • 7 : Delete last empty row in destination table
Shawanna Rouse Aug 19, 2017

Perfectly done! This worked exactly as stated.

Like # people like this
Patrick Nelson Aug 23, 2017

Another similar technique would be to:

  1. Select text from above & below the table you wish to copy
  2. Paste into the destination.
  3. Delete excess text above/below the pasted table in destination.

To me this was simpler, especially since unfortunately the technique mentioned by @Arithzari didn't work for me.

Like # people like this
Irina Natliashvili Nov 10, 2017

Thank you very much @Patrick Nelson. Your solution worked great!

Like Patrick Nelson likes this
Nilesh Lahoti Mar 30, 2018

Thank You. This works well.  Saves time.

Roman May 01, 2018

@Patrick Nelson - A bunch of thanks. Day saved.

Nathan Anderson May 02, 2018

My Company uses Macs. The command key isn't doing this correctly. 

Like Ramita Rajaa likes this
Ivo Gonçalves May 10, 2018

Command key works fine for me, using macOS High Sierra.

Thanks for the hint on removal of header row, that's worth gold!

Kostas Anastasiou Jun 20, 2018

 

Wow, it was so simple! Thanks @Patrick Nelson!!!

Like Patrick Nelson likes this
Victoria Danner Nov 10, 2018

Another Thank You to Patrick Nelson.  This technique worked beautifully!

Alok Joshi Nov 20, 2018

Thanks @Patrick Nelson! Your solution was simple and it works!

Like Patrick Nelson likes this
Lingjie SG I'm New Here Feb 13, 2019 • edited

Hey @Patrick Nelson, my one has tables only. So I added testing words before and after the table and give it a go. This is magic. Thanks.

Like Patrick Nelson likes this
Giulio Campobassi I'm New Here Feb 25, 2019 • edited

I can't believe this is still an issue in 2019... c'mon Atlassian.. Let's get out of the 90's!!!!!!   #FeatureRequest

Like Matthew Lyberg likes this
Arithzari Feb 27, 2019

It's 6 years later, and no reasonable feedback or change has been made.

Today marks the threshold : I'm starting the process of breaking away from Atlassian and moving to a better tool.

Like # people like this
Patrick Nelson Mar 06, 2019

How I feel coming back a few years later, realizing how many people I had helped 😄

hackerman.gif

Like # people like this
Kiran Majeed Mar 28, 2019

Thanks Patrick Nelson , it helped !!!

Like Patrick Nelson likes this
Luke Robb Jun 03, 2019

This man deserves a beer, Helped me 30seconds ago

11 votes
Earl Hathaway May 24, 2012

Your software is crap. Previously: I can create tables with || for the headers and | for the table elements. Now: well, nothing you've touched with your awful editor works right and I'm searching help for HOW TO PASTE A BLOODY TABLE. I'm also begging the cto to stop sending you people money.

Nic Brough [Adaptavist] Community Leader May 24, 2012

Mmm, well, much as I also dislike some things about the new editor, there's no need to be quite so aggressive. If you ask for help nicely, you might get some constructive help. Yelling and being rude gets you ignored or even shut out.

If you really don't get on with the new editor, then you're already doing the right thing in asking your company to switch to another system. I know you're not alone - a lot of my clients have said "we're not moving to v4" and are either waiting to see if there's an adequate fix forthcoming or initiated migrations away from Confluence because of this.

Like Sugetha KANDIAH likes this
Renjith Pillai May 24, 2012

+1 for Nic's comment.

Arithzari Feb 27, 2019 • edited

I agree with @Nic Brough [Adaptavist]However, in the light of a failed process, aggression helps highlight the problem : Atlassian simply does not (or cannot) process constructive feedback. Aggression is simply the next escalation. Atlassian would do well to take note how much 'aggression' on their support forums is based on escalated frustration at the absence of logical and expected functionality.

The hints are not being taken.
The right thing to do is to stop using Atlassian. Talk with you wallet, and talk back in a language that Atalssian will listen to : using superior competition.

Multiple other useful and simple suggestions by myself (other accounts) and other constructive feedback have not been acted on.

Today marks the threshold : I'm starting the process of breaking away from Atlassian and moving to a better tool.

Tillman Dickson Jr. Apr 30, 2019

I have to agree with Earl here. Bitbucket is fine, SourceTree is pretty good; Confluence and Jira are some of the worst software I've used in 35 years as an engineer. Confluence is buggy as all get out and Jira is a usability nightmare.

5 votes
Danielle Zhu Jan 09, 2012

I don't think these improvements affect UI changes in the editor from 4.0 to 4.1. Basically, to copy multiple rows, just highlight table rows, select "Copy Table Row" toolbar button, move the cursor to where you want to paste, and then select "Paste Table Row" button. Alt+Up Arrow or Alt+Down are just keyboard shortcuts. For more information on working with tables, please see: http://confluence.atlassian.com/display/DOC/Working+with+Tables

0 votes
njinji Jun 05, 2015

Guys, 1. create a new table with the same number of columns (just a header and 1 row is fine) 2. highlight all the rows you want from the old table and click the copy table rows icon 3. click into a cell in the new table and press the paste table rows icon so you see instead of copying the entire table you are pasting all the rows -- same thing!

0 votes
Andrey Khaneev Aug 23, 2017

If you are using Table Filter and Charts add-on, you can use a Copy Table button to copy any table to the clipboard in a single click.

0 votes
Stefan Eidelloth Feb 06, 2018 • edited Feb 13, 2018

Here is a related bug report:

https://jira.atlassian.com/browse/CONFCLOUD-58589?jql=text%20~%20%22copy%20text%20and%20table%22

Suggested work around is to copy from the finished/published version, open the editor and paste it which did not work for me.

 

What worked for me was to

* Go to edit mode, mark a mixed section with text and table and copy it

* Go the target section and paste

* Manually delete the remaining empty table (very annoying).

This only works once: After paste I am not able to select the next section to copy.

=>Save the current state. Go again to the edit mode. Now you can do the next copy paste operation.

 

 

0 votes
Craig Harrington Jun 14, 2018

Copy your table from Excel into Word, then from Word into Confluence. 
This may not apply to each person's environment, but it's a lot simpler than going through plugins and multi-step processes.

0 votes
Attila Vangel Jul 31, 2018

I tried to copy a table from a Confluence page to an email I was writing (not just link, but copy).
I tried to do it in Linux, and my email client is Thunderbird.
Whenever I selected the table (and the text around it), it did not select the table headers, and the formatting of the pasted table did not look good (I think it did not have border lines).
I tried it both with Firefox and Chrome.
The solution was to go to edit mode in Confluence and there the table did copy correctly (also with the header line), and when pasted to Thunderbird, it looked OK.
Hope this helps.
BTW I use Confluence 6.2.4, but a search for my problem brought me to this page.

0 votes
Sishir Gupta Sep 07, 2018

Goto http://excel2jira.bluurgh.com/

Paste your excel table and you will get the characters to paste in jira.

 

It worked for me. 

Suggest an answer

Log in or Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Published in Confluence

6 Awesome Ways to Apply Trello, JIRA and Confluence to your Project

I attended  Atlassian Summit 2019  and learned a lot from the presenters, attendees and knowledgeable Atlassian product managers. The presentations I attended focused on applying Agile, pla...

853 views 6 16
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