I need to be able to export a table from Confluence into CSV or Excel file?

Lynn Crush October 4, 2022

Either from an Excel file that I post or from a native Confluence table.  Either way I have to have an editable file on a confluence page that can have the data exported out.

 

1 answer

4 votes
Katerina Kovriga _Stiltsoft_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 5, 2022

Hi @Lynn Crush ,

We can suggest trying our Table Filter and Charts for Confluence app (the app is developed by our company).

You'll be able to export your tables in the CSV format using the Table Filter macro and/or CSV/XLSX formats with the help of the Table Spreadsheet macro.

Dave Fey June 7, 2023

can the csv export be done programatically?  I see how to manually export but was hoping to export/import directly through a gsheet

Stiltsoft support
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 8, 2023

Hi @Dave Fey ,

Unfortunately, the export can't be done automatically.

What concerns import from Google Sheets, it is possible to connect your sheet via the Table from CSV macro. Then any changes made to the Google Sheet will be automatically visible in Confluence.

Tommy Strømme
Contributor
July 18, 2024

Any update on this?

I work with Power BI. I find that a dashboard for our projects is is lightning fast  there compared to the filtered dashboard i have created in Confluence.

I use Table filter and Table Transformer to filter my page properties report. I have used the "Copy the filter URL" tool and I have the result as a favourite in Edge. This means I can go directly to that , click on export to csv, click ok again to export the csv.

I then have to move it to onedrive (as it defaults to Download folder without option to change) and then rename it to the name of the csv which is automatically picked up by Power BI. 

I really need to get this automated so it exports and overwrites every hour or so. We're running DataCenter version. Surely there must be somewhere I can feed that URL into and specify some parameters for interval, save-location and overwriting?

Alexey Mikhaylov {Stiltsoft}
Contributor
July 18, 2024

Hello @Tommy Strømme,

Please be informed that we have a task in our backlog to provide REST API for CSV Export in Confluence Data Center. I've added your vote for it. If this is implemented in future, we will let you know.

 

Like # people like this
Stiltsoft support
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 4, 2024

Hi @Tommy Strømme ,

Finally, we are here with the update regarding the Export to CSV API - please check this abstract from our documentation with the description of the new feature.

Hope it helps your cases.

Tommy Strømme
Contributor
February 7, 2025

Hi, 

Glad this is in place and finally I have some time to implement this :-) 

I created a URL from the documentation and it straight away downloaded the correct CSV :)

However, I want Power BI do do this and I have created a PAT in Confluence and tried to create a new data source following chatgpt's suggesions..however it fails all the time. This is the reciepe i have been trying (we got datacenter btw). I believe its the authentication that fails somehow. Any idea how to get this right?

let
url = "http://urlthatworksinthebrowswer/macroName=table-filter&macroNumber=1",
authHeader = "Bearer MY_PERSONAL_ACCESS_TOKEN",

Source = Web.Contents(url, [
Headers = [Authorization = authHeader, #"User-Agent" = "Power BI"]
]),

CSV = Csv.Document(Source, [Delimiter=",", Encoding=65001, QuoteStyle=QuoteStyle.None]),
PromotedHeaders = Table.PromoteHeaders(CSV, [PromoteAllScalars=true])
in
PromotedHeaders

Stiltsoft support
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 7, 2025

If the manual url downloads the data as expected, seems that the feature is working.

You may exclude our url from the script and and try something simple to check the permissions.

Tommy Strømme
Contributor
February 7, 2025

Turns out its some internal proxy that is creating a bit of trouble for us :) Thanx!

Like Stiltsoft support likes this
Stiltsoft support
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 7, 2025

Hope you'll make everything work as expected!

Unfortunately, we don't have a Power BI instance to check the authorization peculiarities.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events