Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,459,112
Community Members
 
Community Events
176
Community Groups

How insert table with data?

 

 

 

 

i want to use syntax:

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

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

What i should do?

4 answers

||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.

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

Like Tim Smolders likes this

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.

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.   

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.

Dear Kyrylo,

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

can you provide more details?

Jeremy M Rising Star Jul 11, 2017

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

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. 

Like # people like this
Jeremy M Rising Star Jul 11, 2017

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.

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.

Like # people like this



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.
Like Hiren Shah likes this

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events