Embed an Excel file in Confluence

[Denyse]

Is there a way to embed an Excel file into the Confluence page rather than using a link to the Excel file? 

[Katerina Kovriga _Stiltsoft_]

Hi there,

The Stiltsoft team is happy to announce that our Table Filter and Charts for Confluence app now provides a new macro – Table Spreadsheet.

The macro allows you to work with fully functional Excel spreadsheets right in Confluence.

You’ll be able to use cells’ formulas, filters, conditional formatting, etc., create pivot tables and charts from the page view and edit mode.

The Table Spreadsheet macro is available for Cloud and Server/Data Center.

[Cristian Caravan]

Hey Denise,

I found your question and its been a few years since you posted it, but dint really see an answer other than buy this plugin do this, so will add it here in case you still need.
1. You need to have the excell page hosted on a sharepoint/cloud (pretty much you have to be able to open an excell sheet from your browser)

2. go to File -> Embed

3. Play around with the options until you find the things you want to synch to

4. go to your confluence page, and add the macro called html-bobswift OR iFrame (i think this comes with the default license, i could be wrong)

5. Go back to your excell, and grab the link generated under "embed Code"

6. Paste that link in the confluence html-boswift macro

7. play around with the width height until you reach the desired result

[Ashton Santee]

This worked for me. Except I used the "iFrame" macro and just had to put in the URL source. I could not find the "html-bobswift" macro or any alternate free one. 

[Cristian Caravan]

I stand corrected, it seems that html-boswift does not come free, will add yours in the solution as well)

[Tanner St_ Pierre]

I'm trying to recreate your success, and I think I'm hitting a sharepoint sharing blocker.  Any advice on how to ensure the embedded link is correctly shared for Confluence to populate correctly?

Thanks for the helpful reply here, the iframe option is very straight forward

[Cristian Caravan]

Hum... 

The only ways I can think are:
1. Have your org create a SharePoint folder with VIEW ONLY permissions for everyone (except a select few), that is separate from the sensitive that, and put a folder in there where you move your excel page

2. THIS MIGHT BREAK YOUR SRM RULES SO CAREFUL, upload to a public sharepoint like google, restrict access to the peoples emails to read only (but like i said that is a security risk so not cool to do depending on the organization Method 2 and 3 go into a bit of details here https://www.wikihow.com/Open-Excel-Files#:~:text=Open%20Microsoft%20Excel%20Online%20in,desktop%20or%20mobile%20internet%20browser.)

Maybe someone else has other thoughts

[Davin Studer]

Yes. You can use the Excel macro or create the link to the excel file. Then in the editor click on the link and select Show as thumbnail.

[Denyse]

No - that didn't work. I tried selecting the thumbnail and although I selected to Edit With when I selected to open the thumbnail, nothing allowed me to key into any cell in the Excel worksheet. I've tried using the Files and Images option - that only creates a .pdf version of the file. If I select Links, I can open the link to the file but that doesn't embed the file into the page, that only launches the file - NOT the same as embedding. I have secured the worksheet such that only 4 fields are available to the user and 2 of those 4 fields are based upon a drop-down of validated values. I need this worksheet to work within the page. If the only option is to open the workbook, I'll have to deal with that. Formatting is not a strong suit for Confluence - yet another example of such.

[Davin Studer]

Oh, you want to be able to edit it. You are not going to be able to edit it in Confluence. Confluence is not meant to be an Excel replacement. They have functions to display Excel contents, but it's never going to be set up to edit Excel files ... that's what Excel is for. That's also why they have the Edit in Office links so that you can quickly launch office, makes changes, and have those changes pushed directly back into Confluence.

[Denyse]

That's why my original question, about embedding an Excel file, not linking to the file, was presented. I had tested and I'm able to launch the Excel file from a link which allows me to use the Excel file as intended by launching the Excel application. But if I select Macros>Files and Images it only creates a PDF version of the worksheet - not usable. And, as a side note, even if I select "Edit With" Confluence is not offering me the MS Office applications with which to modify (edit) the file, which seems like an issue. Then again, if the file is converted to PDF, there would be no reason to expect the Office application to launch. 

[Douglas Pyle]

@Davin Studer"They have functions to display Excel contents". How?

I would like for my users to be able to interact with excel content directly on the page. Not trying to replace Excel, but don't want them to have to download it in order to view, highlight/copy, click links, etc

Thanks, --D

[Davin Studer]

@Douglas Pyle You can use the Excel Macro. Go to the macro browser and search for Excel. Or type "{" (without the quotes)in the editor to bring up the inline macro browser and then type Excel to filter it to the Excel Macro. That macro will let you select an attached Excel file and render it to the page.

[Charisma Riley]

The Office Excel Macro is disappearing soon.  I am looking for a similar solution.

[Davin Studer]

Well, not necessarily. According to CONFSERVER-39829 they reversed course on this with Confluence Cloud and are going to see how that works out with Cloud and may implement the new file viewer into Server.

[Charisma Riley]

@Davin Studer, thanks for that update; I hadn't realized. Do you know if it is possible to specify that a specific worksheet within a workbook be displayed?

UPDATE: Answered my own question; it is not.

[Davin Studer]

Yeah, unfortunately not yet, but hopefully before they would yank it from Server that would be a feature that was implemented by then.

[Jorge Soto]

I'm trying to display an excel file on a Confluence page. I couldn't find the Excel macro in market - is it no longer available?

[Shardul Juyal {Addteq}]

Hi @Jorge Soto 

Directly attaching an excel file will display the spreadsheet in Confluence as a pdf.

If you want to edit the excel inside confluence, you can use our Excellentable plugin

[Mark R. White]

The easiest way to do this is just to add a table to the Confluence page you want it on and copy and paste the excel data into it. To add a table, simply type /table. This will add an excel style table and you can them copy and paste the data you need into it.

[Michelle Bajraktarevic]

Honestly none of that worked for me, the excel macro wants a bunch of complicated file path info instead of just being able to let your browse your computer, you pick an excel OR CSV file, and you hit upload or attach and the thing convert your excel columns and rows into a table and number them if you want or if it's already in there.

The other one wants me to sign up for Atlassian Cloud first and when I try, my work's global login isn't just logging me in, Atlassian is asking me to sign up for something that looks like it costs money and will require IT admin permissions. 

So I went back to my excel, selected just the rows and columns I wanted in the table, and copied and pasted it over, easy breezy.  No formatting transferred but since I already added a numbering column in it before copying and pasting, I'm done.  Atlassian... that excel macro thing is completely not user-friendly if it can't just browse our computer and pick up the file.

[Oki__PolarisOffice_]

Our app, Polaris spreadsheet allows you to embed an existing excel file for your project management in a confluence page and to directly edit it. You can choose excel or CSV files, and the app enables you to check your excel files in a confluence page without any convertiing. 

In addition, it also supports creating a Jira issue or linking a ticket. 

https://marketplace.atlassian.com/apps/1223556/polaris-spreadsheet-for-confluence?hosting=cloud&tab=overview