A CSV file is often the fastest bridge between your guest list and a finished set of place cards. If your data came from Excel, Google Sheets, Airtable, an RSVP app, or another system, exporting to CSV gives you a clean batch-print workflow.
The key steps are:
- Export a clean UTF-8 CSV with one guest per row.
- Keep clear headers such as
Guest Name,Table,Seat, orMeal. - Upload the file at /import-data?source=csv or in Place Card Maker.
- Map the CSV columns to the fields in your place card template.
- Preview the full batch and fix any formatting issues in the CSV source.
- Export one print-ready PDF and print at
100% / Actual Size.
That is the simplest way to create place cards from CSV without manually copying names into Word, Canva, or a document table.
What the CSV Should Look Like
Your CSV only needs a few solid columns:
| Guest Name | Table | Seat | Meal |
|---|---|---|---|
| Emma Johnson | 8 | A1 | Vegetarian |
| Noah Carter | 8 | A2 | Chicken |
| Mia Davis | 3 | B4 | Fish |
Recommended CSV rules
- Put headers on the first row.
- Use comma-separated values, not semicolons.
- Save the file as
UTF-8. - Keep one guest per row.
- Remove blank rows before upload.
If names contain accents or other special characters, UTF-8 matters. It prevents garbled output in the imported place cards.
Step-by-Step: How to Print Place Cards from CSV
Step 1: Export the source file cleanly
Most users do not start with a CSV. They start in:
- Excel
- Google Sheets
- an RSVP tool
- a CRM or contact export
Export only the columns that matter for printing. A smaller CSV is easier to map and review.
Step 2: Upload the CSV
Go to /import-data?source=csv and choose the file from your device.
This works well when you already have a finalized guest list and want the fastest path from spreadsheet export to printable cards.
Step 3: Match the columns
Map the imported CSV fields to the design:
Guest Nameto the main text lineTableif table assignments should printSeatif exact seating is neededMealif meal markers belong on the card
The cleaner the headers, the faster this step goes.
Step 4: Choose the print format
Before export, choose the layout that matches your paper:
- standard tent cards
- flat cards
- Avery-compatible sheets such as
5302or5388
If you need help choosing the right dimensions first, use Place Card Sizes.
Step 5: Preview the batch carefully
Look for these problems:
- missing names caused by blank rows
- odd symbols caused by bad encoding
- extra quotes or commas from messy exports
- text wrapping issues on long names
Fix the source CSV, then upload again. That is faster than editing every card by hand.
Step 6: Export PDF and print
Once the preview looks correct:
- Export the full batch as PDF.
- Open the PDF in Acrobat or Preview.
- Print at
100% / Actual Size. - Test on plain paper first.
- Load cardstock or Avery-compatible sheets for the final run.
Common CSV Problems and Fixes
Strange characters appear in guest names
The CSV is probably not saved as UTF-8. Re-export it with UTF-8 encoding, then upload again.
Too many blank cards were generated
Delete empty rows from the CSV before import.
Columns are not mapping cleanly
Rename headers to simple labels such as Guest Name, Table, and Meal. Avoid vague headers like Column 1 or Data.
The output does not align on the sheet
The PDF print settings are likely shrinking the page. Print at 100% / Actual Size, never Fit to page.
CSV vs. Google Sheets vs. Word
Choose CSV when:
- your guest list comes from another system
- you want a simple file-based workflow
- you do not need a live connection back to the spreadsheet
Choose Google Sheets when:
- multiple people are updating the list
- the seating chart changes often
- you want the spreadsheet to stay editable in the cloud
Choose Word + Excel only when:
- you specifically need a Word document workflow
- you are comfortable with mail merge
For the other two paths, start here:
- How to Print Place Cards from Google Sheets
- How to Create Place Cards for Events Using Microsoft Word & Excel
