Is it possible to convert confluence page data into CSV?

[Varun P]

Hello Group,

We are working on a project and we want to explore converting confluence page data into a CSV file with Headers, Title, and Page ID as columns and S.No as rows. We tried exporting the page contents to JSON format and converting it into CSV format, but it didn't work properly because of the body.storage contains XHTML response and the python Json converter are not converting them into the format.

 Any help on this would be appreciated. Thanks

[Nic Brough -Adaptavist-]

CSV is not a suitable storage format for Confluence data, so I have to ask the question of "why"?  What are you doing this for, what is the actual problem you are trying to solve by doing this?

As the format is useless for Confluence data, there's no way to export it.  The best you'll be able to do is to write an extract that reads pages over the REST interface, jams the resulting data into CSV and loses some of it.

[Varun P]

We are creating an ML model that needs the confluence data as training inputs and we thought CSV is a better format to load this confluence data to the ML model. Please suggest what is the best way to load the confluence document data to the ML model, if you think that CSV is not a better option.

[Fabio Racobaldo _Herzum_]

Hi @Varun P and welcome,

if you are on a server instance, you could retrieve those information using a query. On a cloud instance, you need to use rest API and write a script that perform that type of conversion.

Fabio

[Varun P]

The storage.body data is in XHTML format. The generic python scripts are not able to properly convert the XHTML data to CSV or any other formats. Do we have any available XHTML converter to convert the Confluence storage.body data to any other formats?