Export Github Issues to XLSX or CSV

I’ve been trying to export all my Github issues to either Excel or as a CSV file, however, when I try to run the following command from the terminal:

curl -i "https://api.github.com/{owner}/{repo}/issues" -u dfuentes

I get prompted to authenticate by entering in my password, but then I get the following returned:

HTTP/1.1 404 Not Found
Server: GitHub.com
Date: Thu, 05 Dec 2019 17:50:38 GMT
Content-Type: application/json; charset=utf-8
Content-Length: 87
Status: 404 Not Found
X-RateLimit-Limit: 5000
X-RateLimit-Remaining: 4993
X-RateLimit-Reset: 1575571423
X-GitHub-Media-Type: github.v3; format=json
Access-Control-Expose-Headers: ETag, Link, Location, Retry-After, X-GitHub-OTP, X-RateLimit-Limit, X-RateLimit-Remaining, X-RateLimit-Reset, X-OAuth-Scopes, X-Accepted-OAuth-Scopes, X-Poll-Interval, X-GitHub-Media-Type
Access-Control-Allow-Origin: *
Strict-Transport-Security: max-age=31536000; includeSubdomains; preload
X-Frame-Options: deny
X-Content-Type-Options: nosniff
X-XSS-Protection: 1; mode=block
Referrer-Policy: origin-when-cross-origin, strict-origin-when-cross-origin
Content-Security-Policy: default-src 'none'
X-GitHub-Request-Id: D1EB:476D:5FAB09:EA04E6:5DE9436E

{
"message": "Not Found",
"documentation_url": "https://developer.github.com/v3"
}

Can anyone assist in helping me understand what I’m doing wrong? Or how else can I export my issues into a CSV / Excel file?

Thanks in advance!

4 Likes

Hi @dfuentes03,

Thank you for being here! Unfortunately, we don’t provide the ability to export issues. This is a request that we have received in the past so I will add your request as a +1. I can’t comment on if/when such a feature might be made available, but your request will be seen by the correct team.

As an alternative, you can use our API to programmatically export that data:

https://developer.github.com/v3/issues/

The data is provided in JSON format.

We have some information about creating backups here:

https://help.github.com/en/articles/backing-up-a-repository

1 Like

Thanks for your detailed response, Andrea
Have a great weekend!

Andrea I too would love the ability to easily export my issues into a spreadsheet to analize the requests from a macro view.  Please mark me down as a user requesting this feature.  Even if there was a print function to print the list of issues in a printer friendly mode.  Currnently I have 5 pages of issues in a project under development and I have to go page by page to print and then the format is pretty ugly-:frowning:

8 Likes

I have created an OAuth app for my own needs. It currently just exports the title, labels, open date, and modified date. I have opened it up so you can either fork it or make pull requests. Here is the link to the Netlify site: https://github-issues-to-excel.netlify.com/. Here is a link to the source: https://github.com/Joshua-rose/github-issues-to-excel. I hope this helps a little

1 Like

Here is a command-line tool (uses the GitHub API referenced) that allows export and import of issues:

https://github.com/gavinr/github-csv-tools