Guide · Events and stages
Alphabetical seating chart: turn your guest list and table numbers into an A–Z "find your seat" sign, free
By Blink Brief · Updated · How pages are made
Paste your guest list, with each guest's table, into the tool on this page, sort it by last name, and print the A–Z list in 2, 3 or 4 columns, or copy it into Canva or Word to make the sign. It reads names and tables copied from Excel, Google Sheets, Numbers or a CSV file, and turns them into "Núñez, Ana · Table 4", A to Z, with a letter over each group. No tables yet? The free Seating Chart maker assigns them and prints the same kind of A–Z list.
Short answer
- Copy two columns from your spreadsheet, the name and the table, and paste them into Paste your guest list below.
- Choose Sort by Last name or First name, then Print or save as PDF (2, 3 or 4 columns, US Letter or A4), Copy the list for Canva or Word, or Download CSV.
- Guests haven't got tables yet? Assign them in the Seating Chart maker first; it reads a Household or Group column and keeps each household at one table when it fits.
Make the A–Z list
Open your guest list in Excel, Google Sheets or Numbers, select the name column and the table column with their header row, copy, and paste here. A CSV file opens in any of the three. The list updates as you paste or type.
Make the A–Z list from your names and tables
A header row with Name or Guest (or First name and Last name) and Table says which column is which. Name the table column Table. Without a header row, the first column is the name and the last is the table. Typing it yourself: a comma between name and table, and a "Last, First" name in quotes.
Columns, Paper and Title change only the printout. In the print window, choose the same paper size and portrait, or Save as PDF for a file. The list is read in this browser tab and never uploaded; close the tab and it's gone.
To make the list by hand:
- In your spreadsheet, keep one row per guest with a Last name, a First name and a Table column. If the names are in one column, add a Last name column and fill it in.
- Sort the sheet by Last name, A to Z, then by First name.
- Make a column that joins them as "Last, First" and copy it with the Table column.
- Paste into Word and lay the text out in columns (Layout › Columns, in Microsoft's words), or into a text box in Canva. Add a letter over each group if you like, and print.
What it does with your list
- Columns: tabs (a copy from a spreadsheet), commas or semicolons. A header row in English is read: Name, Guest, Guest name or Full name, or First name and Last name, and Table, Table number or Table name. Other columns are left out.
- Last names: in a single name column, the last word is the last name, so "Ana María Núñez" sorts under N. A name written "Núñez, Ana" is read as last name, then first name. With First name and Last name columns, those are used.
- Tables: a number becomes "Table 4"; words stay as you wrote them ("Head table", "Sweetheart table").
- Problems it names: a guest with no table is listed with "no table", and the line under the box gives the line number; the same name twice is kept twice and named; empty lines are skipped. The count reads "150 guests, 18 tables."
- Sorting: in your browser's language, with accents sorted as letters: in English, Núñez comes with the N's and Øyelast with the O's; in Swedish, Ångström comes after Z. A name with no Latin letters, such as a Chinese name, stays as you wrote it; in an English browser it sorts after the Latin letters. Marks in front of a name are skipped, so 't Hooft sorts with the T's, and a name with no letters or digits, such as "?", goes under #.
- The printout: only the list prints, with your title at the top, the letter headings in bold, and each guest's table at the end of a dotted line. The text is 14 pt in 2 columns, 13 pt in 3 and 12 pt in 4. In a Chromium test with 0.4-inch margins, 150 guests took 2 sheets of US Letter in 3 columns, and 3 sheets in 2 columns.
- Copy and CSV: Copy the list gives the preview's text, one guest per line with the letters between groups. Download CSV gives two columns, Name and Table, A to Z, with the names as the preview shows them and without the letters.
Last name or first name first
Sort by last name for a wedding or a gala, where the list is long and a family's names then sit side by side. Sort by first name for a party where people know each other by first name, such as a birthday or an office dinner. With Last name, the list reads "Núñez, Ana"; with First name, "Ana Núñez".
Names the last-word rule gets wrong, and how to type them:
- Two-word last names (de la Cruz, García López, van der Berg): write them "Last, First" in quotes, as
"de la Cruz, María", or use separate First name and Last name columns. - Jr., Sr., III: "Sam Lee Jr." would sort under J. Write
"Lee, Sam Jr.". - Hyphens and apostrophes stay part of the name: O'Neil-Smith sorts under O.
- Names in Chinese, Japanese or Korean characters are listed as written and aren't split.
Couples and families: one line each, or together
Both are common, and it's your choice:
- One line per guest: each person finds their own name, and a couple with two last names appears under both.
- One line per couple or family: a shorter list and a smaller sign. Type it as
"Lee, Ana and Sam",4or"Lee, the family",7, so it sorts under Lee, not under the last word.
Children and plus-ones need a line of their own on a one-line-per-guest list ("Guest of Sam Lee" works), or they're covered by the family line.
From Zola, The Knot or Joy: export first
Download the guest list from the wedding site as a file, open it in Excel or Google Sheets, and copy the name and table columns into the tool. How to export your guest list from Zola, The Knot, Joy or Minted shows each site's button; the Paperless Post, Evite and Partiful guide does the same for invitation apps.
If the file has no table column, add one in the spreadsheet and fill it in, or let the Seating Chart maker assign the tables (next section). Move the guests who declined to another tab before you copy, so they don't end up on the sign.
No tables yet: assign them first
- Paste or upload the guest list into the free Seating Chart maker. It reads a Name column (or First name and Last name) and a Group, Household, Party or Family column, and keeps each household at one table when it fits.
- Set Seats per table, check the tables, and move anyone you want somewhere else.
- Press Print escort list and tables: it prints every guest A to Z by last name with their table, then one list per table for the venue.
- For a list in 2, 3 or 4 columns with your own title, press Download CSV there, open the file, and paste its Name and Table columns into the tool on this page.
The Seating Chart maker assigns the tables; the tool on this page only sorts the tables you already have.
On a sign: paste the list into Canva or Word
For a sign on an easel, press Copy the list and paste it into a design. The tool doesn't choose fonts or draw a sign; Canva and Word do.
- Canva: start from a seating chart template (Canva's page: search for "Seating Chart"), make the design the size of your board, and paste the list into text boxes, one per column. How to make a wedding seating chart in Canva covers the templates and printing.
- Word: paste the list, select it, and choose Layout › Columns, then the number of columns (Microsoft's steps for Word for Microsoft 365 and Word 2016 to 2024). Save it as a PDF for printing. How to make a seating chart in Word builds the by-table lists in the same file.
Boards for signs come in 18 × 24 and 24 × 36 inches, among other sizes; Canva's seating chart page says a large one "can be as big as 24 x 36 inches". To pick a text size, count the lines: guests plus letter headings, divided by the columns. The arithmetic for 150 guests with about 20 letter headings, in 3 columns on a portrait board:
| Board | Height for the list | Lines a column | Text size, about |
|---|---|---|---|
| 24 × 36 in | 30 in (6 in for the title and margins) | 57 | 28 pt |
| 18 × 24 in | 19.5 in (4.5 in for the title and margins) | 57 | 18 pt |
Text size at a line spacing of 1.35: line height = height ÷ lines.
Escort cards or place cards instead
An A–Z sign is one board; escort cards are one card per guest on a table at the entrance, in A–Z order, each with the guest's table. The free place card maker reads the same Name and Table columns: paste the same list there, choose Flat escort card under Card, set Order to A–Z by last name, and turn on Print the table on the card. It prints 4 or 8 cards to a Letter or A4 sheet, and folded place cards for the tables too.
If you'd rather keep the guest list, tables and RSVPs in one app, Seating chart apps compared lists the apps with CSV import and their prices.
Questions
Should a seating chart be alphabetical or by table?
Canva's seating chart page names both ways and says "alphabetically is easier for guests to navigate", while by table lets you show the groups. Each guest looks for one name, their own, so an A–Z list by last name finds it fastest; a by-table chart suits a small party where every table fits on the board.
Is there a free alphabetical seating chart generator?
Yes: the tool on this page. Paste the names and tables from your spreadsheet, choose last name or first name, and print the A–Z list in 2, 3 or 4 columns, copy it, or download it as a CSV. It's free, with no sign-up, and the list is never uploaded.
How big should an alphabetical seating chart sign be?
Canva says a large seating chart "can be as big as 24 x 36 inches"; 18 × 24 inches is the other common board. Count the lines first: guests plus letter headings, divided by the columns. 150 guests with about 20 headings in 3 columns is about 57 lines a column, which fits a 24 × 36 board at roughly 28 pt text, and an 18 × 24 board at roughly 18 pt.
Do I list couples on one line or two?
Either works. One line per guest lets each person find their own name; one line per couple or family ("Lee, Ana and Sam") makes the list shorter. Put each person under their own last name when a couple doesn't share one.
Sources
- Canva: Create a seating chart: FAQ: alphabetical or by table; "as big as 24 x 36 inches". Read on 16 November 2026.
- Microsoft: Create multiple columns in Word: Word for Microsoft 365, 2016 to 2024. Read on 16 November 2026.