Importing Gift Cards from a CSV
Expresso Gift Cards can create gift cards from a CSV file, including gift cards that keep their codes from another system. This article covers the columns, the formats the app accepts, and the rules for custom codes.
Import a file
- Click Import CSV and choose your file.
- Review the rows. The app flags errors and warnings, and you can edit any cell before you continue.
- If customers already have these gift cards, uncheck Send email notifications to recipients. Otherwise each recipient gets a new gift card email from Shopify.
- Click Create Gift Cards, or Schedule for Later to create them at a set time.
Import 5 to 10 rows first to check your file. On the free plan, every row counts toward your 25 gift cards a month, and the app tells you before creating anything if the file has more rows than you have left.
Columns
Your file needs the firstname, lastname, email and amount columns. Every row needs an email and an amount above 0. Names can be left blank.
| Column | What to enter | Example |
|---|---|---|
firstname | Recipient's first name | Jane |
lastname | Recipient's last name | Smith |
email | Recipient's email address | jane@example.com |
amount | Gift card value | 50.00 |
message | Optional. Shown in the gift card email, up to 200 characters | Happy birthday! |
note | Optional. Visible only in your Shopify admin | Loyalty reward |
expireson | Optional. Expiry date. Leave it empty for no expiry | 2027-12-31 |
code | Optional. Custom code. Leave it empty and Shopify generates one | HOLIDAY2026 |
Headers aren't case-sensitive, and the app ignores spaces, dashes and underscores in them, so First Name and first_name both work. It also accepts these alternatives:
| Column | Also accepted |
|---|---|
firstname | first, fname, givenname |
lastname | last, lname, surname, familyname |
email | emailaddress, mail |
amount | value, balance, price |
message | msg |
note | notes, internalnote |
expireson | expires, expirydate, expiry, expirationdate, expiration |
code | giftcardcode, cardcode |
How the app cleans your data
- Amounts. The app strips currency symbols ($, €, £, ¥), commas and spaces, so
$2,500.00becomes2500.00. Amounts over 1,000,000 get a warning. - Dates. Use
YYYY-MM-DD.MM/DD/YYYYandDD-MM-YYYYwork too. A date in the past is an error. - Emails. The app fixes common typos, such as
gmial.com,gmai.com,yahooo.comandhotmial.com, and shows each fix as a warning so you can check it.
Custom codes
Fill in the code column to keep the codes your customers already have. Rows without a code get a new one from Shopify, so one file can mix both.
- Codes must be 8 to 20 characters, letters and numbers only. No spaces, dashes or symbols.
- Codes aren't case-sensitive, so
HOLIDAY2026andholiday2026are the same code. - Each code must be unique in your store. The app flags duplicates within the file before creating anything. A code your store already uses fails for that gift card only, and the app reports which gift cards failed.
- The app creates gift cards with custom codes one at a time, so large files take longer. Split very large files into batches of a few hundred.
Keep a copy of your original file for your records.
Questions? Email support@anatolilabs.com.
Was this article helpful?
Your feedback helps us improve our documentation.

