Gimme CSV

About

# Gimme CSV - Chrome Extension

**Export tables from any webpage to Excel with one right-click!**

This Chrome extension lets you export any table from any website directly to a CSV file that Excel can open. All processing happens locally in your browser - no data is sent anywhere.

## 🚀 How to Install

### For Development/Testing:
1. Download or clone this repository
2. Open Chrome and go to `chrome://extensions/`
3. Enable "Developer mode" (toggle in top right)
4. Click "Load unpacked" and select this folder
5. The extension will appear in your Chrome toolbar

### For Production:
1. Package the extension as a .zip file
2. Upload to Chrome Web Store for distribution

## 📖 How to Use

1. **Find a table** on any webpage (like the Yahoo Finance example you mentioned)
2. **Right-click** on the table
3. **Choose "Pls Gimme CSV"** from the context menu
4. **Your CSV file downloads automatically!** 📊

## 🔧 How It Works (For Teaching)

This extension is built with these key components:

### `manifest.json`
- The "blueprint" of our extension
- Tells Chrome what permissions we need and which files to run
- Uses Manifest V3 (the latest standard)

### `content.js` 
- Runs on every webpage you visit
- Detects tables and handles the CSV conversion
- Contains the main logic for finding and processing tables

### `background.js`
- Runs in the background and manages the context menu
- Handles communication between the extension and webpages
- Creates the "Pls Gimme CSV" right-click option

### `popup.html`
- The interface users see when they click the extension icon
- Provides instructions and shows the extension is working

## 🛡️ Privacy & Security

- **Local processing only** - no data leaves your browser
- **Minimal permissions** - only needs to read webpage content and create downloads
- **No external requests** - everything happens in your browser
- **Open source** - you can see exactly what the code does

## 🎯 Perfect For

- **Equity compensation professionals** who need to export stock data
- **Financial analysts** working with market data
- **Researchers** collecting data from websites
- **Anyone** who needs to get table data into Excel quickly

## 🔍 Technical Details

The extension works by:
1. **Detecting tables** using CSS selectors (`table` elements)
2. **Converting HTML to CSV** by parsing table rows and cells
3. **Handling special characters** like commas and quotes properly
4. **Creating downloadable files** using the browser's Blob API
5. **Providing user feedback** with notifications

## 📝 Example Websites

Try it on:
- Yahoo Finance stock tables
- Wikipedia data tables  
- Any website with `<table>` elements
- Financial data websites
- Research databases

## 🚨 Troubleshooting

- **No context menu?** Make sure you're right-clicking on a table
- **Empty CSV?** The table might not have visible data
- **Multiple tables?** The extension exports the first table found
- **Not working?** Check the browser console for error messages

## 🔄 Updates & Maintenance

To update the extension:
1. Make changes to the code
2. Go to `chrome://extensions/`
3. Click the refresh icon on the extension
4. Test on a webpage with tables

---

**Built with ❤️ for equity compensation and other finance professionals who need to get data into Excel fast!**