Skip to main content
BatchCard
Guides

Importing Spreadsheets

This takes about 5 minutes.

By the end of this guide, you'll have imported gift cards from a spreadsheet (CSV or XLSX) into BatchCard, with columns mapped, data validated, and cards created.

When to use a spreadsheet import

Spreadsheet imports work best when you:

  • Need to create 50 or more gift cards at once
  • Have gift card data in an existing spreadsheet
  • Need different values, prefixes, recipients, or messages within the same batch
  • Are migrating gift card data from another platform
  • Have a shared online spreadsheet you want to import by URL (Business plan)

For smaller batches with a single value, creating gift cards directly is faster.

Migrating from another platform? See the migration guides for platform-specific export steps (Square, Toast, Lightspeed, Clover) and how to preserve your existing codes.

File import requires a Starter, Pro, or Business plan. Free plan merchants can create batches manually.

Prepare your spreadsheet

BatchCard accepts CSV (.csv) and XLSX (.xlsx) files. You can use Excel, Google Sheets, Numbers, or any app that exports to these formats.

Download a template to get started. Both CSV and XLSX formats include all 11 columns with example data. The XLSX version includes clickable column headers that link to the format reference.

Import template

Pre-formatted with all 11 columns and example data.

Supported columns

Your spreadsheet can include any of the 11 columns listed below. Only Value is required. Columns can appear in any order, and extra columns are fine (you can skip them during the mapping step).

ColumnRequiredDescription
ValueYesDollar amount of the gift card (0.01 to 2,000.00)
CodeNoAn existing card's own code, so the card keeps the code a customer already holds. Must be 8 to 20 letters or numbers; a code outside that range is rejected for that row before any card is created
Code PrefixNoCharacters added before the random gift card code
Code SuffixNoCharacters added after the random gift card code
Recipient EmailNoCustomer the card is added to in Shopify, and the address the email goes to if you turn notifications on
First NameNoRecipient's first name for email personalization
Last NameNoRecipient's last name for email personalization
MessageNoPersonal message included in the notification email (max 200 characters)
Expiration DateNoDate the gift card expires, must be in the future (Pro and above)
NoteNoPrivate, per-card note saved to each gift card in Shopify (Pro and above)
TagsNoComma-separated labels for organizing your batch

The app auto-detects common column name variations. For example, a column labeled "Amount" maps to "Value," and "Email" maps to "Recipient Email." See the format reference for the full list of accepted column names.

What the Recipient Email column does

A row that carries an email address gets its gift card added to that customer's profile in your store's Shopify admin, so you and the customer can both find the card there. If no customer has that address yet, BatchCard creates one, saved as not subscribed to marketing, so nobody lands on your marketing list. The same address is what BatchCard uses if you send the gift card email.

The import form states the count before you create the batch, and this page uses its words:

Cards with an email address are added to N customer profiles in Shopify. Once a card is on a profile it stays there, and Shopify does not let you move it.

BatchCard creates a customer for any address not yet in your store. No email goes out unless Send notification emails to recipients is on.

Both sentences hold whether you turn email notifications on or off, because the cards go on the profiles either way. Adding a card to a customer profile sends nothing to anyone. Emails go out only when you turn notifications on for the batch, or when you send them later from the batch page. For when the cards reach the profiles relative to the emails, see sending notifications.

Note vs. Internal Notes

The Note column applies a separate note to each gift card. The Internal Notes field on the Create Gift Cards page applies one note to the whole batch. Per-card notes are saved to each gift card in Shopify; the batch note lives in BatchCard. See the CSV format reference.

Tips for clean data

  • Remove blank rows at the bottom of your spreadsheet
  • Save as CSV (UTF-8) if your spreadsheet app gives you encoding options
  • Currency symbols like $ or EUR are stripped automatically
  • If your XLSX workbook has multiple sheets, you can pick which sheet to import after uploading

Sharing your file

Direct upload (all import plans)

On the BatchCard dashboard, find the From file tile in the Create gift cards card. Drop your spreadsheet on the tile, or click Add file to browse your computer. Either way, the file carries straight into the import wizard.

This is the primary and most reliable way to import.

URL import (Business plan only)

URL import is available on the Business plan only. Direct file upload is available on all import plans (Starter, Pro, Business).

In the From URL tile in the Create gift cards card, paste a public URL to a CSV or XLSX file hosted online and click Import from URL. Supported sources include:

  • Google Sheets: Go to File, then Share, then Share with others. Change access to "Anyone with the link." Copy the link and paste it into the URL import field. BatchCard opens the whole spreadsheet, so you can import any tab in it. If it has more than one tab, choose a tab from the Sheet menu on the column mapping step. Google Sheets calls them tabs, and BatchCard lists them as sheets. BatchCard selects a tab whose name contains "gift card" first, or the first tab if none does. To start on a specific tab, open it and copy the link from your browser's address bar. If BatchCard cannot match the tab your link names, it tells you which sheet it opened. Google Sheets shortens tab names longer than 31 characters and removes / and : when it sends the file. For example, a 47-character tab name appears in the Sheet menu as its first 31 characters. Check the sheet, or choose another from the Sheet menu.
  • Dropbox: Use the shared link for your file.
  • Direct file URLs: Any publicly accessible URL ending in .csv or .xlsx.

OneDrive and SharePoint sharing links are not supported yet. Download the file from OneDrive or SharePoint, then upload it on the From file tile instead.

The file must be publicly accessible (no login required to download it).

If a link import fails, find the message below and follow its fix:

  • Not shared: Share the file with "Anyone with the link."
  • Downloads turned off (Google Sheets): In the Share dialog, click the Settings gear. Under "People who can download, copy, print, and access via Gemini", check Viewers.
  • File over 10 MB: Links can import files up to 10 MB. Download the sheet you need as a CSV and upload it. Or move that sheet into its own file and import that link.
  • No response in 30 seconds: Large workbooks can take longer than 30 seconds to send. Try again, or download the sheet you need as a CSV and upload it.
  • Published to the web: Publish the sheet as CSV instead of Web page and paste that link. Or paste the link from Copy link in the Share dialog.
  • Dropbox link: The link may be turned off, or the file may be deleted or not shared. Open the link in a private browser window to see what Dropbox shows.
  • OneDrive or SharePoint: These sharing links are not supported yet. Download the file, then upload it on the From file tile.
  • Private address or no secure connection: The link may lead to a private network, or to a site without a secure connection. Download the file and upload it instead.
  • BatchCard couldn't get the file: Check that the link opens in a private browser window, then try again. If it still fails, download the file and upload it.
  • The site answered with an error: Check that the link opens and downloads the file in a private browser window. If it still fails, download the file and upload it.
  • Too many forwarding steps: Use a direct link to the file, or download the file and upload it.
  • Empty sheet: Download the sheet you need as a CSV and upload it. For a Google Sheets link, open the sheet you want and copy the link from the address bar.

The import flow

Step 1: Upload your file

Drop your file on the From file tile, or click Add file and select it. The app reads and parses the file in your browser. You will see the filename, row count, and any immediate errors (wrong file type, missing headers, no data rows, or too many rows).

Step 2: Map your columns

The app auto-matches your column headers to BatchCard fields. Review the mapping and correct any mismatches using the dropdown menus. Set unneeded columns to "Skip."

The "Value" field must be mapped. A preview of the first 5 rows is shown so you can verify the mapping looks correct.

If your file maps an Expiration Date column on a plan that does not support expiration dates, BatchCard tells you here instead of silently skipping it. The column is ignored and the cards are created without expiration dates. Expiration dates are available on the Pro plan and above.

Step 3: Validate your data

The app checks every row against the format rules for each field (value range, email format, date format, code length, and more). Valid rows show a checkmark. Rows with errors show the specific issue next to the row.

You can download an error report as a CSV file listing only the rows with problems. Fix errors in your original file and re-upload, or proceed with only the valid rows.

Codes stored as numbers can lose their leading zeros. For example, 0012345678 can arrive as 12345678. BatchCard shows a caution on this step when your code column is stored as numbers. That covers XLSX files you upload and XLSX files from a link, Google Sheets links included. To keep each code exactly as it appears, export the sheet as a CSV file and upload that. CSV files never show this caution.

See import errors for a list of every error message and how to fix it.

Step 4: Configure and create

Set your batch name, tags, notification preferences, scheduling, and expiration. Then click Create to submit the batch. The app uses Shopify's bulk operation API to create all gift cards.

Step 5: View your results

Once creation is complete, view the finished batch with all created gift cards. Click Export to download the results as a CSV file with the full gift card codes.

Tips for large imports

  • For files over 1,000 rows, the creation process may take a few minutes. The batch detail page updates automatically as cards are created, so there is no need to refresh.
  • An import accepts up to 10,000 rows. If your file is larger, split it into smaller imports.
  • Use the downloadable template to avoid column mapping issues.
  • Test with a small file (5 to 10 rows) first before doing a large import.

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

On this page