Skip to content

Instantly share code, notes, and snippets.

@nikhita
Created February 10, 2021 06:04
Show Gist options
  • Save nikhita/54108c8fabc1ec79094410d07495f2e9 to your computer and use it in GitHub Desktop.
Save nikhita/54108c8fabc1ec79094410d07495f2e9 to your computer and use it in GitHub Desktop.
Generate a list of all repos in a GitHub to paste into Excel
#!/usr/bin/env bash
# This script generates a list of repos in a GitHub org.
# The list can be pasted directly to a Microsoft Excel sheet.
# You will need to use your GitHub username in the username field.
# Update the page=N number to get the complete list of repos.
curl --silent --user "username" "https://api.github.com/orgs/vmware/repos?page=1&per_page=100" | npx jq '.[].html_url' | while read repo
do
echo "=Hyperlink("$repo","$repo")"
done
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment