How to set up the sheet
One row per card, one column per field. Common column names are matched to fields for you. No template fits yet? New template from these columns makes one, with every column as a field on it, and you arrange it afterwards.
| Field | What it’s for |
|---|---|
| Name | The card’s title |
| Type Line | Creature, Spell, Event, whatever your game calls it |
| Cost | What it takes to play |
| Effect Text | The rules on the card |
| Flavor Text | The line nobody needs but everyone reads |
| Color | green, red, blue, gold, purple, teal, gray, black or white |
| Power, Toughness | Numbers for fights |
| Template | Which of your existing templates to use, by name, for a game with several |
| Anything else | A field of its own on a new template: Rarity, Faction, Art Prompt |
Three ways to bring it in
Upload a .csv, .tsv or .txt file, paste a Google Sheets link, or copy the cells from Google Sheets or Excel and paste them. Excel files need saving as CSV first, or you can paste from Excel directly.
Importing twice
Importing again adds new cards rather than updating the ones you already brought in, so delete the old ones first when you replace a set. After import, Data is a spreadsheet of its own: sort, filter and edit there, and the cards update everywhere, including on a table in play.
The link isn’t live: a change in Google Sheets comes across the next time you import. If you need a sheet that stays synced, Dextrous and ShuffleKit both offer that.
Step by step
- Open Import. Choose A spreadsheet.
- Bring the sheet in. Upload the file, paste a Sheets link, or paste the cells.
- Make a template from the columns. Press New template from these columns, or pick a template you already have and check how the columns matched.
- Import, then arrange it. Press Import, then open Templates and arrange the fields. Every row follows.
- Make a deck and play. Put it on the table and share the link, or open Print for a PDF.
Questions
Can I import from Google Sheets?
Yes: paste the sheet’s link, or copy and paste the cells. It’s a one-time import, not a live sync.
Can I get my cards back out as a CSV?
Yes. Your cards export as a CSV, and paid plans can export a whole game with its images and templates as a zip.
How many copies of each card can I set?
Copies are set in Decks, not in the sheet, so one card list can make several different decks.
Want a sheet to start from?
Every page under card templates has a sample CSV to download and edit.
Related: Card templates with sample CSVs · Adding cards, in detail · The best card game template tools · vs Dextrous · all tools.