Switching to Material from another system? You can bring all of your existing gift cards over at once by uploading a spreadsheet, instead of entering them one at a time. Imported cards work just like any other gift card in Material.
What you'll need
- A CSV file with two columns: Code and Balance
- Full access to Gift Cards in your Material account (if you don't see the Import button, ask your account owner)
Preparing your file
The easiest way to start is to download the template from the import page — it's a ready-made CSV with the correct columns and one example row.
Code | Balance |
12345678 | 10.00 |
- Code is the gift card number: 8–20 characters, letters and numbers only (no spaces or dashes).
- Balance is the card's remaining balance in dollars —
24.00and$24.00both work. Each card can hold up to $3,000.
- You can import up to 10,000 cards in one file. If you have more, split them into multiple files.
Importing your cards
- Go to More → Gift Cards and click Import in the top right.
- Click Select file and choose your CSV (or drag and drop it onto the upload box).
- Material checks your file and shows you anything that needs attention:
- Errors (like an invalid code or balance) must be fixed in your file before you can continue. The message tells you exactly which rows to look at.
- Warnings mean some card numbers already exist in your account. Those rows will simply be skipped — you can continue without changing your file.
- Click Confirm & import.
- Stay on the page while the import runs. When it finishes, you'll see a summary of how many cards were imported and how many were skipped.
Importing never changes a gift card you already have. If a card number in your file already exists, that row is skipped and the existing card keeps its balance — so it's always safe to re-upload a file, even one you've imported before.
If the import stops partway
If something goes wrong with one of the rows, the import stops at that row and tells you which one. Everything above that row has already been imported.
To finish up:
- Fix the row the message points to.
- Re-upload the file and import again — the rows that were already imported will be skipped automatically, and the rest will come in.
Still stuck? Reach out to us through the Help Center and we'll get you sorted.