How do I paste a list into a new Confluence table?

I have a long list (350-450 file names) which I need to paste into individual rows in a table. I've tried:

|a|

|b|

|c|

using insert Wiki markup.

But all that does is create an embedded table in the first selected cell.

Thanks,

David

6 answers

1 accepted

Hello David,

I could not quite understand the error that you are getting, but trying to answer the question itself you could use something like you've proposed, and use the wikimarkup as well.

Can you try with this code if it works?

||Name||Email||
|User1|user1@gmail.com|
|User2|user2@gmail.com|
|User3|user3@gmail.com|
|User4|user4@gmail.com|
|User5|user5@gmail.com|
|User6|user6@gmail.com|

And the following Table would be created:

Hope this is what you want, if not let me know so I can help you.

Cheers,

Gui

Gui,

I was trying to add rows into an existing table. They just went into the first cell.

Your suggestion works.

Since my table has empty columns I'm doing something like:

||First||Second||Third||
|one| | |
|two| | |
|three| | |
|four| | |
|five| | |

Thanks,
David

This approach no longer works

If you click on Insert More Content, select Markup and insert your tabular data, it works

Thanks, that worked nicely!

I was having the same problem and this solved it for me:

http://ffeathers.wordpress.com/2011/11/20/how-to-convert-a-bulleted-list-to-a-table-in-confluence-4/

Take your list and paste/import into Excel. Copy rows from Excel. Paste into new Confluence table. It *should* paste each item into its own cell

I had a long list in a text file, pasting via excel first worked a charm!

This program sucks. Why are we constantly searching for solutions that better programs have already developed, literally decades ago?

Couldn't agree more.  I started adding 15 minutes a day for "admin" on my timesheet after we switched to using this.  I waste so much time every time I use this.

Pasting in the provided example doesn't work for me. I'm using OSX, Chrome, Confluence Cloud, with the concurrent editors beta

Please make use of copy row (shift + Ctl +C) and paste (shift + Ctl +V) row feature available in confluence page.

This doesn't work, because the Shifth-Ctl-V does not work!  There is an open bug on that (for a ridiculously long time), though I think it was finally fixed in the last release (which my company does not have).

Here is a workaround I use, but you need access to JIRA.

To create a table in Confluence from delimited data:

  1. Change the data to use the JIRA format using | as delimeters (|| for headers) with your favourite editor
  2. Open any JIRA item and start adding a comment. 
  3. Select the Text tab (there should be two tabs Visual and Text)
  4. Paste in the data
  5. Select the Visual tab and the table will appear
  6. Select the tab and press Ctrl+C to copy
  7. Navigate to your Confluence page in edit mode and Ctrl+V to paste

The table will appear in Confluence.

You can then cancel the Comment in JIRA so it isn't added.

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Kesha Thillainayagam
Posted Friday in Confluence

We want to hear how your non-technical teams are using Confluence!

Hi Community! Kesha (kay-sha) from the Confluence marketing team here! Can you share stories with us on how your non-technical (think Marketing, Sales, HR, legal, etc.) teams are using Confluen...

325 views 16 10
Join discussion

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you