copy a confluence table to excel, WITHOUT third party apps / plugins?

[Lloyd Bullard]

Hi, 

I have the same issue as this user here - 

https://community.atlassian.com/t5/Confluence-questions/How-to-copy-table-from-Confluence-to-Excel/qaq-p/2234256

copying and pasting a table from confluence to excel to filter / add formulas etc. causes cell formatting issues. 

I am not able to install third party addons, macros etc. as such things need scrutiny by the IT team before they are added, and given their backlog I am not going to get a macro only I need through their review process. 

what solutions do people have? I can currently screenshot part of a page and use excels "image to table" tool, but that does not work for very large or wide pages. 

thanks in advance. 

[Kristian Klima]

Hello @Lloyd Bullard 

Try using Google Sheet as an intermediary.

I copied the following table from the Confluence page view mode to Google Sheets

https://agent-docs.emplifi.io/home/Training/shortcut-menus-and-keyboard-shortcuts#ShortcutMenusandKeyboardShortcuts-CommonShortcuts 

(Note: the link is from our site built with Scroll Viewport, hence the visual difference).

This was the result:

You can either copy/paste content from Gsheets to Excel or export an xls file.

Hope this helps.

[Shane Johnson]

This was the fix for me. Excel kept messing up the data, but Google Sheets worked for me.