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 included in the export
The exported spreadsheet contains one row per gift card with these columns:
| Column | Description |
|---|---|
code | The full gift card code |
value | The gift card value |
status | Current status: active, disabled, or redeemed |
created_at | When the gift card was created |
batch_name | The name of the batch this card belongs to |
code_prefix | The code prefix, if one was set |
recipient_email | The recipient's email, if delivery was used |
recipient_name | The recipient's name, if provided |
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