Is it possible to add multiple sheets like Excel table in Confluence when insert a table

Donghua SHEN January 7, 2024

Hi there!

I'd like to create a table with multiple sheets in Confluence, the easiest way perhaps is to upload the existing Excel sheets but it doesn't work. So I want to insert a table directly in the page but find no way to add sheets like Excel, any idea to finish this action? 

4 answers

1 accepted

3 votes
Answer accepted
Rilwan Ahmed
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
January 7, 2024

Hi @Donghua SHEN ,

Welcome to the community !!

Please see if the below steps helps you.

Go to your confluence page, click o action menu (3 dots) --> attachments and upload your excel file. 

Once the file is uploaded, click edit on the page, add "Excel" macro and select the uploaded excel file and save the macro and then publish the page. 

More details in https://support.atlassian.com/confluence-cloud/docs/insert-microsoft-office-macros/#InsertMicrosoftOfficemacros-OfficeExcelexcel

Rilwan Ahmed
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
January 8, 2024

Hi @Donghua SHEN ,

Scroll to the end of the macro section, you can see the different sheets mentioned.

image.png

2 votes
Stiltsoft support
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 8, 2024

Hi @Donghua SHEN ,

If you are open to 3rd party solutions, we can suggest using our Table Filter and Charts for Confluence app and its Table Spreadsheet macro.

You'll be able to insert and edit spreadsheets with multiple sheets from the page view and page edit mode.

Besides with the help of the Table Spreadsheet Include macro you'll be able to reuse your sheets across your Confluence and display custom cell ranges wherever you need.

0 votes
Betty Lawrenceso
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
September 30, 2024

I’ve faced similar challenges when trying to integrate my Excel data into Confluence. I ended up just creating separate tables for each sheet on the page, which wasn’t ideal but got the job done. If you want to keep everything organized, consider using the “Include Page” feature to pull content from other pages instead. This way, you can keep your data structured without too much hassle.

0 votes
Donghua SHEN January 7, 2024

Thanks @Rilwan Ahmed  , I managed to insert the table into the page and can edit one of the sheets now with your help. But still got the display problem that other sheets can not be displayed in the page (only displayed the first sheet), any solution for this please?

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events