# How to get a csv report of DOIs?

**URL:** <https://community.crossref.org/t/how-to-get-a-csv-report-of-dois/4428>\
**Category:** Reports\
**Tags:** rest-api, depositor-report, journal\
**Created:** [29 November 2023 03:35 UTC](https://community.crossref.org/t/how-to-get-a-csv-report-of-dois/4428 "2023-11-29T03:35:16Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![cyan](https://avatars.discourse-cdn.com/v4/letter/c/278dde/32.png) [@cyan](https://community.crossref.org/u/cyan)\
**Post date:** [29 November 2023 03:35 UTC](https://community.crossref.org/t/how-to-get-a-csv-report-of-dois/4428/1 "2023-11-29T03:35:16Z")

</div>

Hi there,

I am a publisher of 9 journals, and wondering how I can get a breakdown by journal along with the number of DOIs.

Is there any link for the publisher to check?

---

<div class="post-metadata">

**Author:** ![pdavis](https://sea2.discourse-cdn.com/flex020/user_avatar/community.crossref.org/pdavis/32/981_2.png) [@pdavis](https://community.crossref.org/u/pdavis)\
**Post date:** [30 November 2023 10:15 UTC](https://community.crossref.org/t/how-to-get-a-csv-report-of-dois/4428/3 "2023-11-30T10:15:09Z")

</div>

Hello @cyan ,

Many thanks for posting.

So you can access this information in a couple of ways, you can use the depositor report located here: [crossref.org : : depositor](https://www.crossref.org/06members/51depositor.html)

You will see a list of members of Crossref, so you would need to find yourselves in the list, then clicking on your name will reveal a list of your journals and the number of DOIs against those journals. You can also access a list of the individual DOIs against the journals by clicking on the journal name.

You can also access the list via the REST API, using a query URL like the one below exchanging the prefix 10.5555 with your own.  
[https://api.crossref.org/prefixes/10.5555/works?facet=container-title:\*&rows=0](https://api.crossref.org/prefixes/10.5555/works?facet=container-title:*&rows=0)

As for getting a CSV report, that is a little more difficult as you would need to convert that yourself but I am trying to working on a tool to help our members out with that.

In the meantime I could get a CSV created for you with that information, as a one off and attach it here, I would need your prefix to get that information over to you.

I hope this helps.

Thank you,  
Paul

---

<div class="post-metadata">

**Author:** ![cyan](https://avatars.discourse-cdn.com/v4/letter/c/278dde/32.png) [@cyan](https://community.crossref.org/u/cyan)\
**Post date:** [1 December 2023 01:18 UTC](https://community.crossref.org/t/how-to-get-a-csv-report-of-dois/4428/4 "2023-12-01T01:18:14Z")

</div>

Thanks, Paul, your information is very useful. I’m wondering if there is any way that the list is a monthly breakdown.

---

<div class="post-metadata">

**Author:** ![pdavis](https://sea2.discourse-cdn.com/flex020/user_avatar/community.crossref.org/pdavis/32/981_2.png) [@pdavis](https://community.crossref.org/u/pdavis)\
**Post date:** [1 December 2023 11:01 UTC](https://community.crossref.org/t/how-to-get-a-csv-report-of-dois/4428/5 "2023-12-01T11:01:06Z")

</div>

Thanks for the reply.

If you wanted a monthly breakdown then you could add some created date filters into the query URL for the REST API.

e.g. [https://api.crossref.org/prefixes/10.5555/works?facet=container-title:\*&rows=0&filter=from-created-date:2023-11,until-created-date:2023-11](https://api.crossref.org/prefixes/10.5555/works?facet=container-title:*&rows=0&filter=from-created-date:2023-11,until-created-date:2023-11)

This query would return the details of content created/first registered in November 2023.

So you could adjust the months or time periods using this query to return that information.

I hope this helps.  
Many thanks,  
Paul