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

Trying to convert excel file to table in confluence, but it's not working

I have an excel spreadsheet that I need to import into Confluence as a Confluence table so it can be edited on Confluence. I've tried multiple things:

- I attached the excel file, which didn't really work well at all and wasn't what I was looking for

-I embedded the file using the Excel office macro and that was better, but to edit it you had to open in in Excel and upload it again which once again wasn't what I was looking for

-I tried to create a table in confluence and then paste the cells from excel into it because I've seen a lot posts saying that should work. But anytime I tried to paste the cells they pasted into confluence as an image. I made sure I wasn't copying as a picture in excel but it still didn't work. I really hoped this method would be the one but it wasn't.

Using external macros is a bit hard due to security reasons so I can't do that either. Anyone have any suggestions?

6 answers

1 accepted

0 votes
Answer accepted

Hi @Vineela Vandanapu

Can you let me know what version of Confluence you are on?  
I am on Confluence Server 6.6.3 and I also use the excel office macro.  When I edit, it does indeed open excel for me to do the edits in externally, but it automatically updates the file I have uploaded too.  there isn't a need for the manual step of save and then re-upload.  I can just save. 

Hi Kimberly and @Vineela Vandanapu

I 've made the experience that edit the document directly works best when using Internet Explorer (I know....) but you have to check some presets in your system, so that saving directly works.

Had a huge discussion about that with our IT department...

Like Christian Vargas likes this

I tried using the macro again and this time saving worked fine, so I'm not sure what the problem was last time. Now when I try to use the macro in a different page though, it can't find the file even though it's definitely attached. I'm not sure what's going on there.

Make sure you have the correct page name defined, in the settings for the Macro.  If it's looking at the wrong page, it won't auto detect it.  

Here is a link to some documentation about working with that Macro.

https://confluence.atlassian.com/conf66/view-file-macro-943962200.html#excel

Hi, I figured it out, I have to publish the page first and then go back and insert the macro. Thanks for your help.

Like Charles Pang likes this

Ah! yes!  I've been tricked by that too, when I was in a hurry.  I should have remembered to mention that.  Glad you were able to sort it out.  I'll add that to my troubleshooting notes, to remind others with the same troubles.

what worked here (with older Confluence versions): copy your spreadsheet into Word, than mark the table in Word and copy/paste it into Confluence

I tried this and it worked albeit clumsily, so for now it looks like this might be my best bet. 

Like mmorales likes this

How do you copy a spreadsheet into word?

not a great feature 

0 votes
Jonathan Smith Community Leader Jul 13, 2018

@Vineela Vandanapu

  Is the requirement to convert the spreadsheet into a native Confluence table? The reason why I ask is because you tried the excel macro.  If a Confluence table is is not a requirement, you can always import the file into a file list and keep it a spreadsheet. 

Note: Excel office macro will show the spreadsheet's content in the first tab, so if you have multiple tabs in your spreadsheet, this won't work.

We tend to keep large spreadsheets in spreadsheets due to the limited functionality (compared to Excel) of Confluence's tables.

Jonathan: using the option "worksheet name" enables you to show every tab when you place the macro as often as you have tabs in your spreadsheet

It's not a requirement to use a native confluence table. I would use the excel macro but it stopped working for some reason on every page I try it on apart from my first test page. Even when the file is attached the macro can't find it, so I'm not exactly sure how to proceed.

figured it out, I have to publish the page first and then go back and insert the macro.

Hi,

With "Easy Tables For Confluence", you can import data from excel into a table in Confluence. Here the plugin and documentation. I hope it will help.

https://marketplace.atlassian.com/apps/1220484/easy-tables-for-confluence?hosting=server&tab=overview

https://softcrts.com/easytables/index.php

Hi, I think I can help you with an app available for Confluence called Excellentable. It allows you to have a fully functional, exportable spreadsheet right inside Confluence. So, instead of using a Confluence table, you can put your data into Excellentable and export it to display perfectly in Excel. You can also import an Excel file to display in Confluence!

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Posted in Confluence

What project did you transition or start on Confluence with the shift to remote work?

It’s been great to hear from fellow users over the last few weeks about the best tips and fun moments you’ve had working on Confluence since the transition to working remote. I’d love to keep the c...

32 views 2 4
Join discussion

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