Push excel sheets in confluence to sql

[aditya bandaru]

Hello everyone,

Can someone please help me with my below query.

I will upload excel sheets in confluence.  can you please suggest how I can get access these files and insert them into SQL? 

[Nic Brough -Adaptavist- · Accepted solution]

I would not upload them to Confluence.  There's nothing in Confluence that could read data out of a sheet and push into another remote database, you'd need to find or write apps to do that.

It would be far easier to write something that can push your excel data directly into your database,, no need to use Confluence at all for this.

[aditya bandaru]

Thank you Brough for your response.

My team members are using confluence to share the data(excel sheet). I am looking to create SQL queries and dashboards out of it.

Can you suggest what is the best method I can follow. 

[Nic Brough -Adaptavist-]

I would download the files from Confluence, and write something in excel that generates the SQL you need from it, and then executes it in your remote database.

[aditya bandaru]

Thank you Brough. That is definetly helpful