How to make a spreadsheet editable on confluence page

Dear Team,

Please help in getting an option for making an excel spreadsheet editable in actual format and i am currently using the macbook.

Regards

Ankita

5 answers

0 votes

Spreadsheets are attachments, so you can edit them natively - download, edit and upload the new version.

0 votes
Davin Studer Community Champion Mar 08, 2017

If you use the excel macro you can click the "Edit in Excel" link above the rendered version of the Spreadsheet and it will launch Excel using WebDAV such that saving pushes the changes back into Confluence without having to download a local copy and re-upload.

I used to use one of the "Media" macros to embed an excel file; I would see the "Edit in Excel link, which would open the file in Excel. Then when I saved the file, it would automatically save to the embedded version (and maintain versioning in attachment history). This seems to no longer be available (Cloud). What happened to this feature?

Davin Studer Community Champion Jan 17, 2019

It is still available, but currently it is not available with the Word/Excel/PowerPoint macros. Go to the page menu (the ellipsis menu in the top right of the screen) and click on Attachments. On the attachments page you should see "Edit file" links on the right side of the attachments table.

0 votes

The GoEdit add-on offers exactly what you look for.

You can try Excellentable Spreadsheet for Confluence. It lets you to create and edit spreadsheets natively in Confluence with full support for import and export to XLSX, CSV and PDF.

Hi All,

I tried all the above options but unfortunately still not able to edit the excel sheet on the confluence. Only way working as of now is download edit and upload a new file. I also noticed that the office connector plugin(version 7.0.3) which is available with the confluence  version 6.11.0 doesn't contain all the modules which were available in office connector 5.0.7. Because in the older version we were able to get an option of "edit in office" for any of the office attachments. Kindly help us in resolving it.

Note: I tried in all the possible browsers. IE, chrome and firefox

Thanks,

Mounica

No sure if this helps but, 

USE CHROME

I added my excel in the attachments(click three dots right hand top corner of page and select attachments). Drag and drop. Go back to page. Select Edit or E for shortcut. Type  {excel and select Office Excel and document should auto populate in the file name field.  Insert. After saving edit you should have an Edit document field populate above the excel. I then selected edit or e again to add a filter to minimize the view by typing {filter and selecting table filter. click insert with no changes. click and drag the excel icon for your file to the table filter open space.  click table filter header and click table view and scroll to Show first N rows and type 0(zero). This will show only the header row on real time page and make the view more manageable. You can now use the edit document to edit and save semi real time. A refresh of the page and changes are now visible.  

Easiest solution i have found. 

Thank you narcisco cruz.

I got it working with the help of new companion app.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Mar 12, 2019 in Confluence

Confluence Admin Certification now $150 for Community Members

More and more people are building their careers with Atlassian, and we want you to be at the front of this wave! Important Dates Start the Certification Prep Course by 2 April 2019 Take your e...

281 views 2 11
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you