Connecting spreadsheets/tables across wiki pages

Question

Is there a way for Confluence to connect a spreadsheet/table across different pages? Or possibly a plugin that could accomplish this?

Essentially I want to have a master page that would have a spreadsheet that contains a master budget. Then I have some child pages that would take the data from the spreadsheet on the master page and display on a spreadsheet in those child pages.

Natalie Paramonova _Stiltsoft_ · Answer

Hi Tim,

If you need to pull data from separated pages on one page and create a master table, you can use the Table Filter and Charts app. Starting from version 5.0 the app includes improved Table Excerpt Include macro that let you multi-excerpt tables from different sources (current page, child pages, pages by labels and more) and the Table Transformer macro that let you merge and transform tables using the default presets and custom SQL queries.

The steps may be as follows:

1. Insert the Table Excerpt macro, set the Excerpt name parameter, and place the tables (or Office Excell macro) within the macro body on every page.

2. Add the Table Excerpt Include macro on the master page, specify Excerpt name and select an appropriate Excerpt source.

3. Wrap the Table Excerpt include macro in the Table Transformer macro, use the default presets or custom SQL queries to merge all the tables in one.

The Table Excerpt Include and Table Transformer macros are available in Confluence Server and Data Center for now.

If you have a large master table and want to display it partially on different pages, you can wrap the table in the Table Excerpt macro and insert the Table Excerpt Include macros on different pages. Then you can wrap the Table Excerpt Include macros in the Table Filter macro and set filters to show only necessary data.

Please let me know if you need more details.

JP _AC Bielefeld Leader_ · Answer

You could also use the Excel macro & configure it to your needs (Worksheet, area to display, etc) on each affected page. The Excel macro always uses the master page & the excel file on the master page as reference. You could have the first worksheet used & displayed on the master page & a child worksheet used by any referencing child pages. When you then integrate an app like Cenote Lockpoint, which locks the excel file when someone is editing it, you might have a nice solution...

Best

JP

Andrey Khaneev _StiltSoft_ · Answer

Also there are Total row and Total column options in Table Filter macro.