Get list of all published or draft articles titles & URLs to export to Excel? | Community
Skip to main content

Get list of all published or draft articles titles & URLs to export to Excel?

  • January 3, 2017
  • 3 replies
  • 0 views

Mary12

Is there an easy method to produce a list of all Draft or Published article titles and their corresponding URL's ?  Specifically a list that it easily exported or copied into a spreadsheet.  I was hoping to have this for traffic reporting

This topic has been closed for replies.

3 replies

Hi Mary,

 

You could use the Help Center API to get a list all articles. That will return the data in a JSON format which you can convert into CSV or Excel.

 

More info about that here.


Ashley27
  • December 3, 2020

Can someone tell me exactly how to use this to get a CSV of EVERY ARTICLE In our guide? Talk to me like I'm your grandmother and have no idea what an API is or how to use it. 


  • December 9, 2020

Hi Ashley. I see you got a good response over at: https://support.zendesk.com/hc/en-us/articles/223696008/comments/360005696574 and entered a feature request, too — thanks for that!

As you discovered, there's not an easy, built-in way. If you want an additional take on a solution to compare and contrast to one from above, this one does does something similar: Backing up your knowledge base with the Zendesk API