Why doesn't Confluence like Excel / Word tables?

Question

I copied and pasted a formatted Word table onto a Confluence page and it almost had a hissy fit!! It held the basic table format, but the font went bonkers in some cases and one cell was totally hosed up, I couldn't even get my cursor in it. I ended up fiddling with the source code.

It was suggested that I try the copy and paste via Excel - yeah, that didn't work.

SO, now I had an analyst come up and ask if there was a way to get a 300 line Excel spreadsheet into Confluence.

HELP. Please, would someone explain how best to get Word / Excel tables into Confluence without them becoming all screwed up? I am obviously missing something (as I am in my 3rd week of using Confluence, that is NOT surprising at all)... Many thanks!!

Julie Tholen · Answer

Well, it depends. Is the content of the table static? If yes, make it pretty in word and then do a screenshot and save the image, c&p onto the page. Save the original table in case it needs to be updated.

If it is a table that has dynamic data, you will just have to use either a page trmplate that has a table built in or a table macro or the plan Jane confluence table option.  Make friends with a code jockey that has admon rights.

Ellen de Groot · Answer

Hi Julie,

Do you also have a good suggestion for a Word Table? I would appreciate your help.

Julie Tholen · Answer

Hi Karen,

As best as I can tell you upload the Excel spread to your space. Then go to the page that you want to display it on. Select the Insert More Content option (+V). Search for Excel in the macro field. Once selected it will ask you what Excel file you would like to display. Good luck! Let me know if it works for you.