How insert table with data?

[Kyrylo Khatsko]

i want to use syntax:

|| x || y ||
| a | b |  

 to insert ALOT data. And this working only for first line. 

What i should do?

[Katerina Kovriga {Stiltsoft}]

Hi there,

As this thread mentions our Table Filter and Charts for Confluence app, we are happy to introduce its new macro – Table Spreadsheet.

The macro allows you to work with fully functional Excel spreadsheets right in Confluence.

You’ll be able to use cells’ formulas, filters, conditional formatting, etc., create pivot tables and charts from the page view&edit mode.

The Table Spreadsheet macro is available for Cloud and Server/Data Center.

[Stiltsoft support]

An update ->

Please check out two additions to our spreadsheet family - Spreadsheet from Table and Table Spreadsheet Include macros.

The first one turns manually created and macro generated (Jira Issues, Page Properties Report) tables into fully functional Excel-like spreadsheet. The second one - helps to reuse parts of your sheets across your Confluence instance.

Hope you may find it useful.

[Dirk Janssen]

Copying and pasting from Excel (on MacOS) worked like a charm for me.  So I would create a csv file instead (using commas instead of |), read the csv into excel, copy the range, paste into Confluence.   

[Katerina Kovriga {Stiltsoft}]

You may also consider using the Table from CSV macro (Table Filter and Charts for Confluence app).

You'll be able to transform your CSV attachments into Confluence tables and connect your Google Sheets (Google Drive) directly via its URL. It is more convenient, especially for big tables.

[nmz787]

pasting from Excel worked perfectly! (MS Windows)

[Tim Smolders]

||header||header||
|row|row|
|row|row|

USED to work. Now it doesn't (new editor).
For me, copy pasting data into Excel FIRST, and then copy pasting from Excel to Confluence/Jira works to paste as table data.

[Ondrej Brablc]

What a productivity booster ;-) Thanks for tip anyway.

[Jeremy M]

Dear Kyrylo,

You could use a tabular CSV or Excel to import alot of data. Is this an option?

[Kyrylo Khatsko]

can you provide more details?

[Jeremy M]

Dear Kyrylo,

You could for example copy all the data from your Excel sheet into a Confluence page.

For CSV you would need This plugin

That add-on will make it possible to enter data using comma seperated values (CSV).

You can also import data to Confluence using other ways;

https://confluence.atlassian.com/doc/import-content-into-confluence-191141.html

Friendly Regards,

Jeremy

[Kyrylo Khatsko]

so ... Atlassian team removed absolutely simple and good syntax.

And asking me to use a plugin?

I need to spend a working day to only ask permission to setup plugin.

I really prefer to use built in features, like syntax. I can parse text to any format. 

[Jeremy M]

Dear Kyrylo,

I do not believe that Atlassian has removed any syntax. There are different ways for importing data into confluence, and the CSV plugin is one of them. But like I stated, there are many ways to do so.. and you can find them all in the documentation that I linked you.

[Kyrylo Khatsko]

Thank you for afford with link. But this is useless one.
>Import content from other Confluence sites

no

>Import content from a Microsoft Word document

 so ... i created a new doc, copy-pasted table from exel. And yes ... it worked. 
 

>Import web content
no

>Import other content
4 times no

And again. Syntax is not working anymore.

[Carl Dichter]

Here are the tips I used to get it to work:

• Open the markup insert by pressing the + button and selecting Markup.
• Paste in your markup.
• Get it to refresh/paint by switching the type of markup language. 
• If it worked, you can click Paste.
• If it doesn't work, so it in smaller batches for a lot of little tables, and attach the tables together afterward.