Jeera to Excel

Pull Jira tickets into a colour-coded Excel workbook — right from VS Code.

Features

• One-click pull — fetches all tickets from any Jira project or custom JQL query with live progress
• Colour-coded Excel — each Jira status gets its own worksheet with a matching tab colour and header
• Resolution notes — add fix status, notes, and files changed per ticket; exported as a colour-coded column
• Auto-filter + frozen header — every column is filterable; the header row stays visible while scrolling
• Summary sheet — a bird's-eye count of all statuses in one place
• Secure credentials — your API token is stored in VS Code's encrypted SecretStorage, never written to disk in plain text
• ./tickets/ output — exports drop into a tickets/ folder in your workspace automatically

Installation

From the Marketplace (coming soon)

Search for "Jeera to Excel" in the VS Code Extensions panel.

From the .vsix file

1. Download jeera-to-excel-x.x.x.vsix from Releases
2. Open VS Code → Extensions sidebar → ··· menu → Install from VSIX…
3. Select the downloaded file and reload VS Code

Quick Setup

Step 1 — Get your Atlassian API token

1. Go to → id.atlassian.com/manage-profile/security/api-tokens
2. Click Create API token, give it a name (e.g. vscode), and copy the token

Step 2 — Open the panel

Press Ctrl+Shift+P (or Cmd+Shift+P on Mac) and run:

Jeera to Excel: Open Panel

Step 3 — Fill in Configuration tab

Step 4 — Pull & Export

1. Click Save Configuration → then Test Connection
2. Switch to Tickets tab → click Pull Tickets from Jira
3. (Optional) Switch to Resolutions tab → add notes for fixed tickets
4. Switch to Export tab → click Export to Excel
5. File appears at ./tickets/jira_tickets_2025_xx_xx.xlsx

Commands

All commands are accessible via Ctrl+Shift+P.

Excel Output Format

Each exported workbook contains:

• Summary sheet — status counts at a glance
• One sheet per status (Done, In Progress, To Do, In Review, Blocked, etc.) with:

Status colours

Resolution note colours

Settings (VS Code)

You can also configure the extension directly in VS Code Settings (Ctrl+,):

{
  "jeeraToExcel.baseUrl": "https://yourcompany.atlassian.net",
  "jeeraToExcel.email": "you@company.com",
  "jeeraToExcel.projectKey": "EB",
  "jeeraToExcel.jql": "",
  "jeeraToExcel.maxResults": 200,
  "jeeraToExcel.outputDir": "",
  "jeeraToExcel.statusGroups": {
    "In Progress": "Active",
    "Needs Fixes": "Rework"
  }
}

Note: The API token is not stored in settings.json. It is always saved via the panel or VS Code's secret storage.

Building from Source

git clone https://github.com/Same3rAijaz/jeera-to-excel.git
cd jeera-to-excel
npm install --include=dev
npm run compile
npm run package          # produces jeera-to-excel-x.x.x.vsix

Requirements: Node.js 18+, npm 9+

Contributing

1. Fork the repo
2. Create a feature branch: git checkout -b feature/my-feature
3. Make your changes and compile: npm run compile
4. Open a PR against master

Author

Sameer Aijaz

• GitHub: @Same3rAijaz
• Email: aijazsameer5@gmail.com

License

MIT — free to use, modify, and distribute.