What file formats does BatchCard accept for import?

BatchCard accepts CSV and XLSX files on the Starter plan and above. On the Business plan, you can also import from a URL pointing to Google Sheets, Dropbox, OneDrive, or SharePoint.

Is there a row limit for CSV imports?

The row limit matches your plan's monthly card allowance: 500 rows on Starter, 2,500 on Pro, unlimited on Business. Each row creates one gift card.

Can I export full gift card codes?

Yes. BatchCard captures every full 16-digit code at creation. Export any batch as CSV with complete codes, values, and statuses. Shopify's admin only shows the last four digits.

CSV/XLSX Import & Export

BatchCard CSV Import/Export lets Shopify merchants import gift card data from spreadsheets and export full codes anytime for accounting, distribution, or backup.

See the CSV import walkthrough, learn how merchants use it for corporate gifting, or read the spreadsheet import guide.

Install Free on Shopify

Map your columns, import your data

Upload a CSV or XLSX file with gift card values, quantities, and recipient details. BatchCard maps your columns and validates the data before creating cards.

Export batches as CSV anytime

Download any batch as a CSV file with full gift card codes, values, and status information for your records or external systems.

Import from Google Sheets, Dropbox, OneDrive, or SharePoint

On the Business plan, paste a public URL from Google Sheets, Dropbox, OneDrive, or SharePoint. BatchCard fetches the file and imports it directly. No download-and-reupload required.

URL import field with Google Sheets, Dropbox, OneDrive, and SharePoint icons

How It Works

Prepare your spreadsheet

Create a CSV or XLSX file with columns for gift card value, quantity, and optional recipient emails. Download our template if you need a starting point.

Upload and map columns

Upload your file in BatchCard. The column mapper matches your headers to the required fields and validates the data before processing.

Review and create

Check the preview to confirm values and quantities look correct. Click Create to generate all gift cards in one batch.

Export anytime

Download any batch as CSV with full gift card codes, values, statuses, and recipient details. Use exports for accounting, audits, or external distribution.

Frequently Asked Questions

What file formats does BatchCard accept for import?: BatchCard accepts CSV and XLSX files on the Starter plan and above. On the Business plan, you can also import from a URL pointing to Google Sheets, Dropbox, OneDrive, or SharePoint.
Is there a row limit for CSV imports?: The row limit matches your plan's monthly card allowance: 500 rows on Starter, 2,500 on Pro, unlimited on Business. Each row creates one gift card.
Can I export full gift card codes?: Yes. BatchCard captures every full 16-digit code at creation. Export any batch as CSV with complete codes, values, and statuses. Shopify's admin only shows the last four digits.

Related Features

Bulk Creation

Create hundreds or thousands of gift cards in a single batch. Set values, quantities, and expiration dates all at once.

Learn more

Email Delivery

Starter+

Deliver gift cards to recipients via Shopify's built-in email notification. Track delivery status for every recipient.

Learn more

Custom Codes

Create gift card codes with custom prefixes, suffixes, and configurable length (8-20 characters) to match your brand.

Learn more

Ready to try CSV/XLSX Import & Export?

Install free on Shopify and start creating gift cards in minutes.

Install Free on Shopify