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:

Bullets

Bullets

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

Excel

Paste into the Confluence editor:

Table

Table

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:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

%d bloggers like this: