CSV to Google Sheets (VS Code Extension)

Export local .csv files directly to Google Sheets from VS Code.

Features

• Right-click a CSV file and export it to a new Google Sheet.
• OAuth authentication with Google.
• Chunked writes for larger CSV files.
• Token storage in VS Code secret storage.

Google Cloud Setup (Production)

1. Create a Google Cloud project.
2. Enable the Google Sheets API.
3. Configure the OAuth consent screen:
   • App name, support email, developer contact.
   • Add scope: https://www.googleapis.com/auth/spreadsheets.
4. Create OAuth credentials:
   • Preferred: Desktop app client ID.
   • Legacy option: Web app client ID/secret with loopback redirect URI.
5. Optional VS Code overrides:
   • csvToGsheets.googleClientId (extension ships with a default client ID)
   • csvToGsheets.googleClientSecret (optional for desktop flows)
   • csvToGsheets.googleRedirectPort (default: 42813)

Development

npm run compile
npm run lint
npm test

Security Notes

• OAuth flow uses loopback callback, PKCE, and state validation.
• Tokens are stored in VS Code Secret Storage.
• Logout revokes credentials and clears local token cache.