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

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:

   git clone https://github.com/[your-username]/github-copilot-usage.git
   cd github-copilot-usage

2. Install dependencies:

   npm install

3. Start the development server:

   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 for detailed instructions.

Quick deploy:

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