Information
# GitHub Copilot Premium Requests Usage Analyzer
A single-page application that visualizes GitHub Copilot premium request usage data from CSV exports. This tool helps you understand your team's Copilot usage patterns.
## Quick Start
Need to analyze the premium requests CSV?
I created a SPA with Spark and Coding Agent to display an overview of the Premium Requests CSV that you can currently download (no API yet ), so share it where needed!
Hosted on GitHub Pages: [GitHub Copilot Premium Requests Usage Analyzer](https://xebia.github.io/github-copilot-premium-reqs-usage/)
Upload the CSV from the enterprise export (Billing and Licenses → Usage → Export dropdown right top)
Result:



## Features
- Upload and parse GitHub Copilot usage CSV data
- Visualize usage over time with interactive charts
- See request distribution by model
- Track compliant vs. exceeding quota requests
- Analyze usage patterns with daily breakdown charts
## Getting Started
### Prerequisites
- Node.js 16+ and npm
### Installation
1. Clone this repository:
\`\`\`bash
git clone https://github.com/[your-username]/github-copilot-usage.git
cd github-copilot-usage
\`\`\`
2. Install dependencies:
\`\`\`bash
npm install
\`\`\`
3. Start the development server:
\`\`\`bash
npm run dev
\`\`\`
4. Open http://localhost:5000 in your browser
## CSV Format
The application accepts either of the following CSV export formats from GitHub Copilot premium requests:
**Original format (until October):**
\`\`\`
"Timestamp","User","Model","Requests Used","Exceeds Monthly Quota","Total Monthly Quota"
"2025-06-11T05:13:27.8766440Z","UserName","gpt-4.1-2025-04-14","1","False","Unlimited"
\`\`\`
**New format (starting from October):**
\`\`\`
"date","username","model","quantity","exceeds_quota","total_monthly_quota"
"2025-06-11","UserName","GPT-5","1","False","300"
\`\`\`
> Column order does not matter and extra columns are ignored. Both formats are supported for backward compatibility.
## Deployment
### GitHub Pages
This project is configured for easy deployment to GitHub Pages. See [DEPLOYMENT.md](DEPLOYMENT.md) for detailed instructions.
Quick deploy:
\`\`\`bash
npm run deploy
\`\`\`
## Built With
- React
- TypeScript
- Vite
- Recharts
- shadcn/ui components
- Tailwind CSS
## License
This project is licensed under the MIT License - see the LICENSE file for details.
## Acknowledgments
- GitHub Copilot for helping with development
- The shadcn/ui team for the beautiful components
- Recharts for the charting library