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

Question

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.

Shane Johnson_ucxl4n · Answer

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

Kristian Klima_gtcuat · Answer

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.