Bubble Sheet Tools

Answer Sheet Template for Word and Google Docs

Build a simple answer sheet as a table in Word or Docs, see what goes wrong when software must read it, and know when to use a fixed-size PDF.

By the editorial team · Published · Content updated · about 4 min read

Page maintained by Bubble Sheet Tools Editorial Team · Updated

You can make a perfectly usable answer sheet in Word or Google Docs: a table with a row per question and a circle in each option column. What is hard is making one that a camera or scanner can read reliably, because word processors reflow text and printers rescale pages, and a bubble grid is only as good as its fixed positions. This guide shows how to build the simple version, where it goes wrong, and when a PDF drawn at fixed size is the safer choice.

A note first: the sheets on this site are PDFs and there is no editable version of them today. Everything below is about building your own.

When a word-processor sheet is fine

A table-based sheet works well when the person marking it is a human:

  • Practice and low-stakes checks where nobody will scan anything.
  • Hand grading or a punched overlay, as long as the overlay is made from the same printed copy, not from a different file.
  • Small groups and short quizzes where you can look at every sheet.

If you plan to photograph or scan the sheets with software, read the section on what goes wrong before you start.

Build a simple answer sheet

Menu names differ between versions, so treat these as the idea rather than exact clicks.

  1. Set the page size and margins first. Choose US Letter or A4 to match your printer, and keep margins at about 10 mm (0.4 inch) or more so nothing falls in the area many printers cannot print.
  2. Add a header. A line each for name, date and class, above where the table will go.
  3. Insert a table. One column for the question number and one for each option (four for A to D), and one row per question. For a long test, make several narrower tables side by side, or use two tables in two text columns.
  4. Put a circle in each option cell. Use a circle character such as ○ and center it horizontally and vertically. Choose a font size large enough to fill comfortably, then use the same font for every cell.
  5. Label the columns. A row of A, B, C and D above the first question.
  6. Fix the row height. In Word, table properties let you set row height to an exact value. In Google Docs, as far as we know, you can set only a minimum row height; check your version. Exact heights keep the rows evenly spaced.
  7. Turn off automatic resizing of the table to its contents, so a font change does not move the grid.
  8. Export to PDF and print the PDF, not the document, at 100%.

What goes wrong

  • Fonts change the circles. The same circle character is a different size and weight in different fonts, and if a computer lacks your font it substitutes another. Exporting to PDF before you share the file helps, because a PDF embeds what it needs.
  • Rows drift. Without exact row heights, rows can grow or shrink with the content, and the grid no longer repeats evenly.
  • Page scale changes. A print dialog set to fit or shrink rescales everything. The printing guide covers the settings in the common programs.
  • There are no alignment marks. Software that reads the grid usually looks for corner marks or page edges. You can add small filled squares in the corners, but keeping them exactly square and evenly inset in a word processor takes care.
  • Circles are glyphs, not shapes. A glyph can sit slightly off-center inside a cell, and a grader that measures darkness at an expected position may be thrown off.

None of this stops a human reading the sheet. It is what makes a table sheet an unreliable input for software.

When to use a PDF instead

If a camera or scanner will read the sheet, use something drawn at a fixed size by a program that places every circle at a calculated position. That is what the ready-made sheets and the generator are: each page is built from one layout, and the build checks the positions and page size of every PDF. We have not tested them with any grading software, so a trial print is still the thing to do.

The generator lets you choose the question count, choices, columns and paper size, and print a heading of up to 60 characters at the top. It does not let you change the other wording, add a logo or edit the header labels. If you need those, the options are to build your own table as above, or to print one of the sheets and add what you need by hand, clear of the corner squares and the grid.

Privacy when you use an online word processor

A document in an online editor is stored in your account with that provider. Keep student names and numbers out of any template you keep there; a blank sheet is not student data, a filled-in roster is. The student data privacy guide goes through the questions to ask before you put anything about students into an online tool.

A checklist before a class set

  • Page size matches the printer’s paper (Letter or A4)
  • Rows evenly spaced, with exact heights where the program allows
  • Exported to PDF, and the PDF is what gets printed
  • Printed at 100% with fit and shrink options off
  • One copy printed and checked with a ruler, and graded with a known pattern
  • No student names or numbers left in the saved template

If you only need a plain, correctly spaced grid and have no special wording, it is usually quicker to download a ready-made sheet than to build one.

Keep reading