Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How do you export space page titles into an excel file? Is this possible?

Hello, 

I would like to audit the content in each space and to start I need to export the content into an excel file. I can export into other file types but this is not exactly what I'm looking for. Maybe this is a simple step I missing, not sure.

2 answers

2 accepted

If you can parse JSON into your excel spreadsheet, then the REST API would be a good place to start.

An example for getting all the pages and blogposts from Confluence Cloud for a space with space key "analytics":
https://dsapps.atlassian.net/wiki/rest/api/space/analytics/content

Likely you'll have to login to get this from your own Confluence, but you can get hold of all your Confluence space content in batches of 100 pages e.g.

Screenshot 2021-05-05 at 18.45.16.png

This shows the page titles and can show much more if required.

More details here:
https://developer.atlassian.com/cloud/confluence/rest/api-group-space/#api-api-space-spacekey-content-get

0 votes
Answer accepted
Pramodh Community Leader May 05, 2021

Hi @Ashley Bird 

Welcome to the Community!!

Here is the solution I have found :-)

We need jq to parse JSON Output of API

First get all the Space Key in your Confluence Site, following is the API to do so 

curl --request GET \
--url 'https://ORG-NAME.atlassian.net/wiki/rest/api/space' \
--user 'USERNAME:TOKEN' \
--header 'Accept: application/json' | jq '.results | .[].key'

If you are looking at only one Space and once you have got all the Space Key from the above command follow the below API to get the Page titles in respective Space


curl --request GET \
--url 'https://ORG-NAME.atlassian.net/wiki/rest/api/space/{SPACE-KEY}/content'
--user 'USERNAME:TOKEN'
--header 'Accept: application/json' | jq '.page.results | .[].title'

Replace ORG-NAME, USERNAME, TOKEN, and SPACE-KEY Variables

Thanks,
Pramodh 

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Confluence

Miss the Confluence demos at Team 21? Watch them here!

Phew, Atlassian Team 2021 blew by. With dozens of demos and a handful of keynotes, you may have missed some of the awesome Confluence Cloud sessions. Don't' worry, you can watch them all here or on Y...

349 views 2 6
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you