How to paste markup (table, including links) into a document

[Dirk Mika]

Up to now, we have run our own Confluence server. There I was able to insert markup via the corresponding menu item. This is apparently no longer possible with the new editor.
If possible, I would also like to avoid having to create a page with the old editor or having to make any detours via Excel or a Google document, as the markup does not exclusively contain a table.

My workflow is that a Python script creates a list of tickets for release notes as a markup table and compiles it with some other information into a markup document. The table contains, among other things, a link to the corresponding ticket.
Is there a way to copy text in a way to the clipboard so that I can insert the whole thing as a table in a page?
Or to import part of the page from a file?

I have read a number of contradictory statements as to whether and how this is supposed to work, hence my question.

[Brant Schroeder · Accepted solution]

@Dirk Mika You can just copy and paste but it has to be in the correct format.  The new Confluence editor supports mediawiki style tables now, see format below.

heading 1 | heading 2 | heading 3
--- | --- | ---
Cell a1 | Cell a2 | Cell a3
Cell b1 | Cell b2 | Cell b3

If you have it in the correct format the editor will convert it to a table for you.  

[Dirk Mika]

If I copy your text and paste it, I'll get this:

I then tried some of the examples over here: https://www.mediawiki.org/wiki/Help:Tables/en

Same result. 

What do I miss?

[Brant Schroeder]

@Dirk Mika I think it is pulling the web formatting.  If you copy and paste it into something like notepad first and then copy from notepad so it does not pull the web formatting and is plain text does it work for you?

[Dirk Mika]

That gives a different result. ;-)

Using your text

heading 1 | heading 2 | heading 3
--- | --- | ---
Cell a1 | Cell a2 | Cell a3
Cell b1 | Cell b2 | Cell b3

gives

But adding a leading "|" like

| heading 1 | heading 2 | heading 3
| --- | --- | ---
| Cell a1 | Cell a2 | Cell a3
| Cell b1 | Cell b2 | Cell b3

did it:

BTW: None of the examples at https://www.mediawiki.org/wiki/Help:Tables/en work. So I wouldn't call it mediawiki style. ;-)

[Marcus Groeber]

What I find interesting about this is that the line

| --- | --- | ---

seems to make or break this automatic formatting of the table - if I remove this, the table is no longer recognized. This appears to contradict the "Confluence wiki markup syntax" documentation I get on the "?" icon in our new cloud instance.

It recommends this formatting, which does not work for me:

||heading 1||heading 2||heading 3||
|cell A1|cell A2|cell A3|
|cell B1|cell B2|cell B3|

This looks like it is worth fixing in the online docs...