How do I paste data into a table using Confluence 5.7?

To insert large tables with the second option you need to first hit Ctrl + Shift + D and then paste in the table in wiki markup form.

Wrap the table in any macros required if you know the macro name and parms. This can be a serious PITA to do after a table has been created in the Confluence 5 GUI.

Click Insert and the resulting table will be converted to the new wiki format into the page.


According to this link, I'd assume it's a bug with the version of Confluence, at least as far as the sorting goes.

Looking through the Confluence JIRA, there appear to have been several issues with copy/pasting from Excel over the development. At least there's a workaround:

Workaround:

  • Go to the editor again

  • Cut out the (unsortable) table

  • Paste it again

  • Mark the first row as Header

  • Save the page

-> Now the table is sortable

If that does not work, please install the The confluence source editor, then edit the page to:

  1. Remove the row " "

  2. Replace all "td" tag to "th" tag for the first row of the table. For example, the column name "Number" will need to change from "Number" to "Number".


I went a circuitous route to accomplish this:

  • Made a text file with my information and tab-separated the fields
  • Pasted this data in to Google Sheets
  • Copied the cells from Google Sheets
  • Pasted them in to the a pre-made table in Confluence

It was still faster than writing each field manually.

Tags:

Confluence