Can you embed a live Excel file in Confluence Cloud?

[Alison Milne]

Can you embed a live Excel file in Confluence Cloud?

Can the HTML macro be used to do this?

[Kelly Arrey · Accepted solution]

Hi @Alison Milne, 

There are two approaches:

• You can use the /excel macro to display an attached Excel file - I haven't worked with that
• You can use the /link macro to embed an Excel file which is stored in SharePoint
  • When you click on the link in edit mode, you'll probably see the options of displaying the link as:
    
    • URL
    • Inline
    • Card
      
  • Select Inline or Card, then select the link again and chose Embed
    
  • The caveat is that Excel and Confluence aren't quite old enough to share their toys yet :eyeroll:, so there's no way to tell Excel which tab of the Excel file you want to see on the Confluence page. Oh well.

[Alison Milne]

That's simpler than I thought it would be. Thank you.

[Andrew Lord]

Hi @Kelly Arrey

I am also interested in the approach you outlined for Embedding Excel in confluence but I appear to be hitting some sort of permissions issues. 

URL, Inline and Link all work fine but as soon as I choose Embed the users including myself are prompted to Log in 

The link is to SharePoint with access to anyone within the organisation. We are all logged in when we attempt to open. 

Any ideas on what ii should try next?

Many thanks,

Andy

[Kelly Arrey]

@Andrew Lord Hi Andy, beyond my expertise unfortunately. What happens if you click "Sign in"? Perhaps your Confluence admin can help? 

:fingers-crossed:

Kel

[Kim Oliver Drechsel]

I got the same issue. Clicking Login opens a login popup, but after login nothing happens, the embedded file still wants you to login to microsoft.

[Sharon Halpin · Accepted solution]

 @Alison Milne  Another option:  If you're using Power BI, publish the excel spreadsheet to Power BI (Online) and then embed the Power Bi Reports into Confluence Pages via the iFrame macro.

This gives you live data that can be sorted, filtered etc - depending upon the content/format of the data etc.

I'm using this and can highly recommend.  Probably not want you are looking for but maybe something for the future?

[Alison Milne]

I'll look into this. We're introducing Power BI at the moment. This could be very useful.

[Sharon Halpin]

@Alison Milne   Some bumph from Microsoft that I found useful

https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-embed-secure

[Timothée Quesada · Accepted solution]

If your Excel is on OneDrive or Sharepoint, you can embed it on a Confluence page. 

Just change the render, not inline, not a card but embed. 

https://support.atlassian.com/confluence-cloud/docs/insert-the-microsoft-onedrive-for-business-macro/

[Andrew Lord]

The app doesn't work with the new editor. Outdated and ineffective. :-(

[Katerina Rudkovskaya _Stiltsoft_]

Hi @Alison Milne,

You may try our Table Filter and Charts for Confluence app and its Table Spreadsheet macro.
You’ll be able to import your Excel file into Confluence and then continue working with it right there using all the basic Excel functions.

[Oki__PolarisOffice_]

@Alison Milne 

If you need to add an exel file in the confluence page, Polaris spreadsheet can be a good option. 

Our app, Polaris spreadsheet allows you to embed an existing excel files in a confluence page and directly edit it.
It offers full editing capabilities for excel files and provides an advanced view mode that allows you to use filters, scroll, and find. Please check the details.
A month's free trial is available now! 

Atlassian Marketplace 

[Alison Milne]

Good to know, but not looking to purchase anything at the moment.