Best way to import data from another source into a confluence table

[Matthew Rouse]

We frequently have data collected from other systems (i.e. SQL queries, excel spreadsheets etc.) that we want to summarise in a table in a confluence page.

What is the best way to achieve this?

Until recently, we had been using the insert markup macro to create tables, by colating the data together and inserting in markup, similar to the below:

||Heading 1||Heading 2||

|cell 1|cell 2|

|cell 3|cell 4|

...

|cell n-1|cell n|

but with this having been removed in the new editor version, this is no longer possible.

Is this possible to achieve now without buying extra add-ons? If not, the manual method of copying one cell into a confluence table will render this exercise impractical.

[Matthew Rouse]

Seems I may have found my own answer? New editor mode now accepts raw copy/paste from excel and understand how to interpret new rows/columns!! :)