Place Card Maker

How to Print Place Cards from Google Sheets | Step-by-Step Guide

If your guest list already lives in Google Sheets, you do not need to retype names one by one into a design tool. The practical workflow is to clean the sheet, import the rows into a place card template, generate one PDF for the full batch, and print at actual size.

The key steps are:

  1. Prepare a clean Google Sheet with one guest per row and clear headers.
  2. Keep only the columns you want to print, such as Guest Name, Table, Seat, or Meal.
  3. Import the sheet into Place Card Maker from Google Sheets or via /import-data?source=google-sheets.
  4. Choose a template and map each column to the correct text field.
  5. Preview the full batch and export one print-ready PDF.
  6. Print at 100% / Actual Size on cardstock or Avery-compatible stock.

That is the fastest way to make printable place cards from Google Sheets without manually duplicating designs.

Use one header row and one guest per row:

Guest NameTableSeatMealNotes
Emma Johnson8A1VegetarianFamily table
Noah Carter8A2Chicken
Mia Davis3B4FishSpeaker

The most important rule is consistency. If a column is optional, leave cells blank instead of mixing different formats in the same column.

Best practices before import

  • Put headers in Row 1.
  • Remove blank rows in the middle of the list.
  • Keep table numbers formatted consistently.
  • Use one main name field if possible: Guest Name.
  • Only keep Meal, Seat, or Notes if they actually need to print.

Step-by-Step: How to Print Place Cards from Google Sheets

Step 1: Clean the guest list first

Google Sheets is excellent for collaboration, but place card printing works best when the sheet is simple.

Check these items before import:

  • every guest is on exactly one row
  • header names are clear
  • spelling and capitalization are final
  • extra planning columns are hidden or removed if they should not print

Step 2: Choose how to bring the sheet in

You have two practical options:

  1. Use the Google Sheets import flow at /import-data?source=google-sheets
  2. Export the sheet as CSV and use the CSV workflow if that is simpler for your setup

If you already need a CSV export for another tool, use How to Print Place Cards from CSV. If you want to stay in Sheets, keep the Google Sheets workflow.

Step 3: Pick the place card format

Before generating the full batch, decide what you are printing:

  • tent cards for seated dinners
  • flat place cards for holders or escort displays
  • Avery-compatible layouts such as 5302 or 5388

If you are not sure which size to use, compare them first in Place Card Sizes.

Step 4: Map spreadsheet columns to the design

After import, map fields once:

  • Guest Name to the main name line
  • Table if you want table assignments shown
  • Seat if exact seat positions matter
  • Meal only if catering or service staff need it on the card

This is the point where Google Sheets becomes useful: one clean sheet can generate dozens or hundreds of cards without editing each card individually.

Step 5: Preview the full batch

Before exporting, scan the preview for:

  • long names wrapping awkwardly
  • empty cards caused by blank rows
  • table numbers displaying as text with unwanted spaces
  • meal labels that should be abbreviated

Fix the sheet first, then re-import or refresh. It is faster than repairing each card manually after export.

Step 6: Export the PDF and print correctly

When the preview looks right:

  1. Export one PDF for the full guest list.
  2. Open it in Acrobat or Preview.
  3. Print on cardstock or Avery-compatible stock.
  4. Set scale to 100% / Actual Size.
  5. Run one plain-paper test before the final print.

For most home printing setups, that single setting, 100% / Actual Size, is the difference between aligned cards and wasted paper.

Common Problems When Printing Place Cards from Google Sheets

The imported names look wrong

Usually the source sheet is the problem, not the template. Check for extra spaces, merged cells, or multiple guests combined in one row.

Some cards are blank

Blank rows in the Google Sheet often create blank output rows. Delete them before import.

The PDF does not line up with Avery stock

Print scaling is usually the issue. Make sure the PDF viewer is not using Fit, Shrink, or any auto-scaling mode.

I updated the sheet but the cards did not update

Refresh or re-import the data before exporting again. Treat the sheet as the source of truth.

When Google Sheets Is the Right Workflow

Google Sheets is the best starting point when:

  • multiple people are editing the guest list
  • table assignments are still changing
  • meal choices or seat labels are stored in columns
  • you want a repeatable spreadsheet-to-print workflow

If you are working from a static file export instead, the better landing page is How to Print Place Cards from CSV.

If you specifically need a Word mail merge process, use How to Create Place Cards for Events Using Microsoft Word & Excel.