Templates & Scripts
Ready-made integrations to get you from API key to working prototype in minutes. Download, customize, ship.
Build firearms integrations without the boilerplate
Every GunSpec asset is a working starting point for the firearms specification API: spreadsheet macros, command-line exporters, a typed SDK, and a ready-to-import Postman collection. Drop in your API key and you are pulling live data on makes, models, calibers, and ballistics in minutes.
Whether you are an analyst building a catalog in Excel, a game developer wiring real weapon stats into an engine, or an engineer shipping a comparison tool, these templates cover all 68 endpoints so you never have to hand-write request plumbing or pagination.
Spreadsheets
Excel VBA Module
VBA module (.bas) with macros that pull firearms data directly into Excel. List, search, detail view, and side-by-side comparison - import via Alt+F11.
Google Apps Script
Apps Script for Google Sheets with custom menu and cell functions. =GUNSPEC_LIST(), =GUNSPEC_SEARCH(), =GUNSPEC_FIREARM() - paste into Extensions > Apps Script.
Scripts & SDKs
Python Data Export
CLI script using requests + argparse. Export any endpoint to CSV or JSON. Filter by manufacturer, caliber, or category. Handles pagination automatically.
Node.js / TypeScript SDK
Typed fetch wrapper with full IntelliSense. Covers all 68 endpoints with built-in retry, rate-limit awareness, and async pagination helpers.
API Collections
Postman Collection
Import-ready collection with all 68 endpoints pre-configured. Includes environment variables for API key and base URL. Test scripts validate response schemas.
Which template fits your stack
Every option is free and reaches the same data. Pick by the tool you already work in.
| Template | Format | Language | Best for |
|---|---|---|---|
| Excel VBA Module | BAS | VBA | Analysts who live in Excel and want data in cells |
| Google Apps Script | GS | JavaScript | Shared, always-on sheets with scheduled refresh |
| Python Data Export | PY | Python | Bulk CSV and JSON exports or data pipelines |
| Node.js / TypeScript SDK | TS | TypeScript | Production apps that need a typed client |
| Postman Collection | JSON | JSON | Exploring and testing endpoints before you build |
From API key to working integration
Four steps, no build tooling required.
- 01
Get your free API key
Sign up and generate a key from your dashboard. The free tier covers the full firearms catalog.
- 02
Pick a template
Choose a spreadsheet macro, a script, the SDK, or the Postman collection based on the tool you use.
- 03
Add your key
Drop the key into a single constant. Local downloads auto-detect your development API URL.
- 04
Customize and ship
Filter, export, or extend the template to fit your project, then move it into production.
What people build with these
Real workflows the templates were designed for.
Inventory and catalogs
Pull every make and model into a spreadsheet or app to manage stock, build price lists, or power a storefront catalog.
Browse firearmsGame development
Feed accurate calibers, capacities, and dimensions into FPS and simulation engines for realistic weapon behavior.
Explore data insightsResearch and analytics
Export ballistics and caliber data to CSV for analysis, charts, and reproducible firearms research.
Browse calibersComparison tools
Build side-by-side spec comparisons and decision tools backed by a single source of truth.
Compare firearmsFrequently asked questions
Everything you need before you download.
Are the templates really free?
Yes. Every template and the SDK are free to download and use. You only need a GunSpec API key, and the free tier covers the full firearms catalog.
Do I need to know how to code?
Not for the spreadsheet templates. The Excel and Google Sheets options add menus and cell functions you use without writing code. The Python, Node, and Postman options assume basic developer familiarity.
How do I get an API key?
Create a free account and generate a key from your dashboard. Paste it into the template's API key constant and you are ready to pull live data.
What data can I access?
All 68 endpoints: firearms, manufacturers, calibers, categories, full-text search, comparisons, images, and game stats. The templates handle pagination automatically.
Can I use these commercially?
Yes. You can use the templates and the data they return in commercial products, subject to the API terms of service and your plan's rate limits.
Do they work with local development?
Yes. When you download from localhost the templates set the base URL to your local API automatically, so there is nothing to edit for local testing.
Need something custom?
Can't find what you're looking for? Check the full API docs or reach out - we're happy to help build integrations.