Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
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 keep the most current Excel data on a Confluence page?

Edited

Team A documents stuff almost exclusively through Excel. Team B documents stuff almost exclusively through Confluence.

B relies heavily on A's Excel data, so periodically someone manually copies individual Excel cells onto Confluence. Beyond being inefficient, the problem is that the Excel file gets updated fairly regularly, the Confluence pages doesn't, so Team B ends up referencing outdated information. 

I want Team A to be able to edit their Excel files like they normally do, and I want Team B to receive that new data on Confluence in real time.

I tried out the "Office Excel" macro, but it looks like it'd still require someone to re-attach the Excel file. I see the Companion app for Cloud is retiring in 2022, so that doesn't look like a solution either.

Is there a macro that I can tell to "look for X filename.xlsx in A:\blah\blah file path"? Or something else?

 

-edited a typo.

2 answers

1 accepted

3 votes
Answer accepted
Bill Bailey Community Leader Dec 23, 2021

Have you tried beating Team A? ;-)  

Has Team A tried editing in place?

edit-an-attached-file 

If they followed this method, then at least the attached file would always be current.

 

A more robust solution would be this paid plugin:

excel-for-confluence 

We have used this before to try to bridge the gap between the ludites mired in the 00s and us cool people. ;-)

And you might need to get Team A to meet Team B halfway and have the infor within their spreadhseets replicated on some other sheet to make it easier for Team B to consume.

Thanks for the recommendations! 

Hi @Catherine Snell ,

We can also suggest trying our app - Table Filter and Charts for Confluence.

The app provides the Table from CSV macro that allows you to connect CSV files via attachments and URLs (Google Spreadsheets as well) to Confluence.

The recreated table can be further filtered, aggregated, recalculated and visualized right in Confluence with the help of other macros provided by the add-on.

Suggest an answer

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

🏠 Say hello to the new Confluence Home!

Hi Atlassian Community, My name is DJ Chung, and I’m a Product Manager on the Confluence Cloud team. Today, I’m excited to share a new and improved version of Home. The new Home helps you ...

39,227 views 28 126
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