# Exporting all Topic titles and IDs?

**URL:** https://meta.discourse.org/t/exporting-all-topic-titles-and-ids/78624
**Category:** Development
**Created:** [January 22, 2018, 6:41am UTC](https://meta.discourse.org/t/exporting-all-topic-titles-and-ids/78624 "2018-01-22T06:41:14Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![Frank\_Bailey](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/frank_bailey/32/83927_2.png) [@Frank\_Bailey](https://meta.discourse.org/u/Frank_Bailey)
#### Post date: [January 22, 2018, 6:41am UTC](https://meta.discourse.org/t/exporting-all-topic-titles-and-ids/78624/1 "2018-01-22T06:41:14Z")

</div>

Hey folks, is there a way I can export a list of topic titles and IDs? I’m happy to do it from the command line in the DigitalOcean droplet via SSH if I have to, if someone might be able to point me in the right direction?

---

<div class="post-metadata">

### Author: ![techAPJ](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/techapj/32/342990_2.png) [@techAPJ](https://meta.discourse.org/u/techAPJ)
#### Post date: [January 22, 2018, 7:03am UTC](https://meta.discourse.org/t/exporting-all-topic-titles-and-ids/78624/2 "2018-01-22T07:03:03Z")

</div>

You can do it via [data explorer](https://meta.discourse.org/t/32566?silent=true) plugin:

> [@Discourse Data Explorer](https://meta.discourse.org/t/data-explorer-plugin/32566):
>
> discourse2Summary Discourse [Data Explorer](https://meta.discourse.org/t/32566?silent=true) allows you to make SQL queries against your live database, allowing for up-to-the-minute stats reporting.open_bookInstall Guide This plugin is bundled with Discourse core. There is no need to install the plugin separately.information_source If you’re looking for examples or support for any custom queries, you can find lots of topics in our #Data & reporting category under the #sql-query tag. If there’s not one to suit your pa…

There is an option to export data in CSV format.