How to convert a bulleted list to a table in Confluence 4

This happens to me so often: I create a list on a Confluence page, and then discover that I need to add another layer of information to each item in the list. It should be a table! How can I convert it? Thank you Jay Rogers for discovering and sharing this tip.

In Confluence 4.0, to convert a bulleted list to a table:

  1. Copy the list.
  2. Paste into a Microsoft Excel spreadsheet. Excel will treat each bullet and line feed as a separate row.
  3. Select and copy the cells in Excel.
  4. Paste them into the Confluence editor. Voilà!

This trick works in Confluence 4.0, but not in Confluence 3.5. It works with Microsoft Excel, but not with a Google Docs spreadsheet, nor with a Zoho spreadsheet. It is worth trying with other spreadsheet applications, if you happen to have one lying around. Let us know what happens!

Here it is in pictures. Click the images to see an expanded screenshot. Here is a list in the Confluence 4.0 editor:



Copy and paste into Excel, then select the cells in Excel:


Paste into the Confluence editor:



About Sarah Maddox

Technical writer, author and blogger in Sydney

Posted on 20 November 2011, in Confluence, technical writing and tagged , , , . Bookmark the permalink. 5 Comments.

  1. In earlier versions, you just stick the pipe thing in to each excel column and then copy and paste into notepad and then into confluence wiki markup.

  2. One other thing you have forgotten is that this must be done in Internet explorer, as Google Chrome does not turn this into a table….

  3. Likewise, doesn’t work in firefox 39.0

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: