Exporting Codes
By the end of this guide, you'll have exported your gift card codes as a spreadsheet file you can open in Excel, Google Sheets, or any spreadsheet app.
Export a single batch
- Open BatchCard in your Shopify admin.
- Click the batch you want to export.
- Click Export as CSV.
- BatchCard downloads a spreadsheet file to your computer.
Export multiple batches
- Go to the BatchCard dashboard.
- Select the batches you want to export by clicking the checkbox next to each one.
- Click Export Selected.
BatchCard combines the selected batches into a single spreadsheet file.
What's in your export
Your export is a spreadsheet (CSV) file named like batchcard_your-batch-name_2026-05-20_143022.csv. It includes one row per gift card.
These columns are always included:
| Column | What it contains |
|---|---|
| Code | The full gift card code. Included for active cards only. |
| Value | The card's value. |
| Status | Active, failed, or cancelled. |
| Created Date | When the card was created. |
| Prefix | The code prefix, if you set one. |
| Suffix | The code suffix, if you set one. |
| Batch Name | The name of this batch. |
| Tags | The batch's tags, separated by semicolons. |
| Shopify Gift Card ID | The card's ID in Shopify. |
These columns are included only when they apply to the batch:
| Column | Appears when |
|---|---|
| Recipient Email, Recipient First Name, Recipient Last Name, Message, Notification Status | The batch sends email notifications, or any card has a recipient. |
| Note | Any card in the batch has a per-card note. |
| Expires On | Any card has an expiration date. |
| Delivery Status | The batch sends email notifications. |
| Scheduled Send At | The batch is scheduled for later. |
Note column
The Note column holds the private, per-card note from your import. It is for your team only and is never shown to customers. See the CSV format reference.
Open the export in a spreadsheet app
Excel
Double-click the downloaded CSV file. Excel opens it automatically.
Google Sheets
- Go to sheets.google.com and click Blank spreadsheet.
- Click File > Import.
- Click Upload and choose the downloaded CSV file.
- Click Import data.
Numbers (Mac)
Double-click the downloaded CSV file. Numbers opens it automatically.
Common use cases for exports
| Use case | What to do |
|---|---|
| Accounting | Export codes with values and dates. Import into your accounting software. |
| Physical distribution | Export codes and print them for in-store handouts or gift card inserts. |
| External delivery | Export codes with recipient details and use your own email system. |
| Backup | Export all batches periodically as a record of every code created. |
Exported files contain the full gift card codes. Store them securely, just like you would store cash or credit card numbers.
Result
Your gift card codes are exported and ready to use in any spreadsheet app.
Learn more
- CSV import and export features — full overview of import and export capabilities
- CSV format reference — detailed column specifications
Ready to try this? Install BatchCard free.
Create bulk gift cards from a CSV or form. Set up your first batch in minutes.
Install Free on Shopify