export projects to csv

[letusskate]

Product Feedback

Once i use github projects, I got a feeling of smooth and natural. It's a really good thing for me to manage my coding plan.
but when I want to export it to make pictures or powerpoint, I found it really difficult. I have to copy and paste for about a whole day. I think if there is a icon to export the project to csv, it does make sence.

[jge162]

Hello @letusskate You could probably write a python script to manage that for you. Hopefully you know how to run a python script.
Should be easy. the possibilities are endless, I have even created a GitHub Action that could run a script (not this example) to commit the csv to a repo too. So it can be done yes.

import csv
import requests

# Replace the URL below with your GitHub project API URL
url = "https://api.github.com/repos/{your-username}/{your-repo}/issues"

# Replace the token below with your GitHub API token
token = "{your-github-api-token}"

headers = {"Authorization": f"Token {token}"}

response = requests.get(url, headers=headers)
issues = response.json()

# Replace the filename below with the name you want to give your CSV file
filename = "github_project_issues.csv"

with open(filename, "w", newline="") as csvfile:
    writer = csv.writer(csvfile)
    writer.writerow(["Title", "Body", "Labels"])

    for issue in issues:
        title = issue["title"]
        body = issue["body"]
        labels = [label["name"] for label in issue["labels"]]
        writer.writerow([title, body, ", ".join(labels)])

print(f"Data exported to {filename}")

[Farristom]

I need support

[sameer1098alam]

Still you need suport

[sakil2233]

47733

[nattchantasit-hash]

Some one is using GitHub to spy on me...Iam apinan sangthong

[AyanSinhaMahapatra]

This would be a nice to have feature. +1 for export to CSV

[pombredanne]

What about the import of a CSV?

[pombredanne]

@jge162 Your script is for plain issues, not for projects AFAICS?

[jge162]

The script is just a pseudo code idea. I do not know enough to write one for his issue. Just giving him/her ideas.

[Jhonn-tradintg01]

Jhonn

[pombredanne]

Short of an easy import/export from/to a tabular format (CSV or XLSX), this project feature is mostly harmless :]

[queenofcorgis]

👋🏼 Hi there! Thanks for sharing this feedback and workarounds y'all. I've passed along this request to our Product team. If/when I have any updates - I'll circle back here.

[chrisglein]

Lots of related issues on this. To help interlink: #5411 #6217 #47733 #48389 #31983

[rileybroughten]

You can now export your project view to a CSV file! Check it out on the changelog announcement and let us know what you think 🚀

[AyanSinhaMahapatra]

Thanks for adding this!

[letusskate]

Thank you!
You are a good team!
Wish github all the best!

[tiarakelly]

Hi, Will descriptions be added to the exports in the future?

[Thuliomac]

meu caro meu vs code travou nao abre foto nao faz nada estou perdendo a chance de fazer meu primeiro projeto e começar meu curso so isso e ainda nao consegui com o git nao e culpa de vcs mais da outra forma tava mais facil

[montana64]

http://blkchairbknpn73cfjhevhla7rkp4ed5gg2knctvv7it4lioy22defid.onion/

[juan430]

👍

[Armanidashh]

Where can I go for help? With a real agent

[Thuliomac]

como exporto um projeto csv se nao ta codando nem no vscode mudou tudo as extensoes um monte de coisas que estava acostumado a codar nao tem mais

[jan454060-ai]

ff

[abigonah]

Hello everyone
My name is Arghavan Last name is Bigonah I'm very Glad to see everybody here I'm pianist. I'm engineer computer From Iran and student at Law school

[abigonah]

I'm Happy to see everybody Here Good luck.

[mickjigar]

Can we get a way to export the "Description" (body text) or "comments"?

[warasingh]

มีข้อมูลเก่าเพียงแค่นี้เองเหรอควรปิดเว็บไซต์ไปซะและจัดการสำนักพัฒนาที่มีส่วนเกี่ยวข้องกับเว็บไซต์นี้ทุกคนข้อมูลของผมไม่เห็นมีเลย