Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How to Work With Tables in Confluence Cloud

You can categorize and store data in many ways, but with tables, you add some visual structure which helps understand and interpret information. You can efficiently use tables in work to make your data look neat. There is no need to emphasize the advantages of tables anymore - if you used them once, you already know all the benefits.

Microsoft Excel and Google Spreadsheets are two of the most popular tools for working with tabular data, and they are perfect for both simple operations and advanced use. However, if your company works with specific management systems like Confluence, you might want to store the data there, without incorporating extra resources.

Confluence tables are very convenient for storing various kinds of data or tracking different criteria. You can also make them unique and suitable for any presentation. Keep reading, and you will find out how to create outstanding tables in Confluence Cloud.

The basics of Confluence Cloud tables

So, how do you work with tables in Confluence Cloud?

Create a table

To add a table, click a button at the top control panel or use a Shift+Alt+T shortcut to generate a table with nine cells.

Screenshot_2-min.png

But that is just a template which you can alternate however you want, for example:

  • add more rows and columns or delete them
  • choose header placement
  • pick cell color
  • add statuses and icons and do many more. 

Screenshot_3-min.png

If you want to learn more about customizing your tables in Confluence Cloud, check out our article.

Copy a table

If you need to duplicate a table that was created in Confluence, click the upper left corner of it. Then use the Ctrl+C combination and paste the table into the chosen place.

Screenshot_4-min.png

If you have a table in Excel but want to move it to a Confluence page, select the necessary rows and columns, copy and insert them wherever you need. Users of the old editor need to create one table cell first and then enter the data from Excel there.

Tables from CSV or JSON files

It is possible to convert data from a CSV or JSON file into a Confluence table too. For this, you will need to use the Table from CSV or Table from JSON macros which belong to the Table Filter and Charts for Confluence app. You can import a table from an attachment or specify a URL.

Users of Google Sheets can output their tables on Confluence pages too, using the Table from CSV macro. Read more about it in our documentation.

Screenshot_5-min.png

Further use of table data

Native Confluence features do not allow to filter table data or accumulate it into a pivot table. However, you can use other apps, such as Table Filter and Charts for Confluence, to boost the functionality of Confluence and perform the operations you need.

Table filtering allows navigating through the table easily, while pivot tables and charts help you work with data to create engaging and dynamic dashboards. Let's see what you can do with this app.

Screenshot_7-min.png

Apply filters

Those who work with large tables will appreciate the Table Filter macro. It allows setting one or several filters, only displaying the data that you need. You can apply filters right in the view mode and save the filtered table for further use. If you no longer need the filters, remove them with just a couple of clicks. 

Screenshot_6-min.png

Export the filtered table

After you are done filtering the table, you can export it into a CSV, PDF, or Word file. Click the funnel icon on the right and choose the most suitable format. If you want to download a CSV file, pick the settings.

Screenshot_11-min.png

Aggregate data in pivot tables

Another handy tool to use with big tables is the Pivot Table macro. You can also do simple calculations, like summarizing or multiplying the values or depict literal numbers for the chosen labels.

In the settings of the pivot table, you need to select the columns of the source table. One of these columns will be used to create row labels of the pivot table, and the other should contain the data that you need to aggregate. The last thing you need to do is define the operation type, and the pivot table is right there!

Screenshot_8-min.png

Build charts

For building charts, you can use the Confluence Chart macro, but its features are limited. So, if you want to get the most out of your charts and change them on the fly, the Chart from Table macro will be a more convenient option. You can add it right in the view mode and choose one of the automatically suggested data aggregation types. It offers the most popular chart types:

  • Pie and Donut charts
  • Bubble Pie chart
  • Column, Stacked Column, Bar, Stacked Bar charts
  • Line, Area, Stacked Area charts
  • Time Line, Time Area, Stacked Time Area charts
  • Gantt chart and some more.

Screenshot_12-min.png

In case you need to adjust the size of the chart to the page or hide the source table and the chart management panel, it is also possible.

Multiple macros in use

Table Filter and Charts for Confluence allows you to nest the macros into one another, creating a dynamic dashboard with all types of data. You can do that with the help of the Table Toolbox macro. You can filter your large table, aggregate the values in the pivot table and build various charts and graphs. And if you change something, your pivot table and charts will adjust to the modification as well.

Screenshot_9-min.png

What's next?

Now you see how simple working with tables in Confluence is. And with the help of Table Filter and Charts for Confluence, you can turn a page with a table into a convenient workspace. 

Want to learn more about the app and test it in real time? Visit our demo site. And for any questions or suggestions, make sure to contact us.

1 comment

Mohammed Amine Community Leader Jun 08, 2021

Great article

Comment

Log in or Sign up to comment
TAGS
Community showcase
Published in Confluence Cloud

Confluence Bingo Round 3!

That’s right! Grandma’s back at it again, and this time she’s brought all her friends. In honor of Team '21, this Bingo round is dedicated to all things team-related, and the prizes are no exception....

2,922 views 31 22
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you