Seat Allocator

Only the number of students is required. Select your classroom, enter enrollment, and click Allocate Seats — the tool spreads students evenly across the room, avoids broken seats, and produces a fresh random arrangement on every press — press Allocate Seats again at any time to generate a new assignment. Left-handed seats are assigned individually as needed.

Supported classrooms: BLOC 102 · BLOC 117 · BLOC 128 · BLOC 149 · BLOC 160 · BLOC 161 · BLOC 164 · BLOC 166 · BLOC 169 · BSBE 115 · CHEM 100 · HECC 105 · HECC 108 · HECC 110 · HECC 200 · HECC 203 · HECC 207 · HECC 209 · HELD 100 · HELD 107 · HELD 109 · HELD 111 · HELD 113 · HELD 200 · ILSB 1105 · RICH 114

How to paste seat assignments into a column of your Excel roster

After allocating, click ↓ Roster (TXT) above the seating chart to download allocated_seats.txt.

Each line of the file is a sequence number followed by a tab and the seat ID. The list is already shuffled, so line k is the seat for student k in your roster.

1	A14
2	B7
3	M3
…
  1. Open allocated_seats.txt in any text editor (Notepad, TextEdit, VS Code), press Ctrl+A (or ⌘+A) to select all, then Ctrl+C (⌘+C) to copy.
  2. In Excel, click the cell next to your first student's name and paste with Ctrl+V (⌘+V). Excel splits at the tab automatically — the sequence numbers go into one column and the seat IDs into the next.
  3. Delete the sequence-number column. The remaining column is your seat assignments aligned with the roster.

Alternative (Excel for Windows): Data → From Text/CSV, choose the file, set the delimiter to Tab, then untick the first column in the preview before clicking Load.

Key: Empty Aisle Table Excluded Broken Available Allocated Left-handed Moveable chair