Link confluence (wiki page) in excel sheet

[Vani Shah]

I want to link the confluence page (wiki page) in excel sheet, which will help me get the desired data from the linked wiki page in excel upon refresh. i tried using get data from web option in excel but it is not authenticating the link.

[Tomislav Tobijas]

Hi @Vani Shah ,

I believe this is somewhat known limitation > when you have internal content that can also be additionally restricted, Excel features often struggle to authenticate. 

Here's a related feature request/suggestion on the topic: Apps can't access restricted content in Confluence Cloud 

If you need to automate data extraction from Confluence into Excel, you may need to explore custom scripting using the Confluence REST API, handling authentication (such as with APIs) within scripts, and then importing the resulting data into Excel.
But, I'd say this is a 'grey area' (at least for me) as it's not that much explored 👀

Cheers,
Tobi