To turn paper surveys into an Excel spreadsheet with PaperSurvey.io, create the questionnaire in PaperSurvey, print its generated forms, collect responses, then scan, review, and export them. Set this up before your next collection round so the printed pages contain the identifiers and answer positions the recognition system needs.
PaperSurvey only processes forms generated by PaperSurvey. If you have already collected responses on forms made in Word, another survey platform, or a Remark workflow, uploading those completed pages will not make them compatible. You will need a separate capture or data-entry workflow for that batch. See which forms PaperSurvey can process.
For a future round, you can import questions from a blank Word, PDF, or text questionnaire, check the imported questions and layout, and generate new printable forms. Importing the questions does not preserve an external form's recognition template or make old completed copies readable. If you are considering a change from Remark, our Remark Office OMR comparison explains the fit and switching considerations.
What "one row per response" actually looks like
A survey export has one row per response and columns for its answers. Some question types, such as multiple-choice questions with several selected options, can produce more than one column. Check a pilot export against the structure your analysis needs.
- Rows represent responses: page identifiers associate scanned pages with responses. Check for missing pages and duplicate submissions before analysis.
- Columns hold answers: choose answer labels or recoded values for closed questions, and keep write-in comments in text columns.
- Coding stays consistent: define the labels and numeric codes once, then check that the exported values match your codebook.
- Hybrid data shares one dataset: if some people answered on paper and others online, both sets land in the same dataset with the same columns. Check collection-mode labels and repeated submissions before analysis.
Inspect a sample spreadsheet before collecting responses
Download our Excel example or CSV example, with the matching codebook. The files contain 18 fictional training-feedback responses across three sessions and two trainers, illustrating ratings, multiple selections, comments, and missing answers. They are produced from seeded example records, not from recognized scans, and are not an accuracy benchmark.
The sample-data walkthrough also includes the intended answers and an illustrative review log. Use them to plan the structure your own pilot export needs.
Manual entry vs automated scanning
Manual data entry is the default because it needs no setup: you open the form, read the answer, type it into Excel, and repeat. For a handful of responses that is perfectly reasonable. The trouble comes with volume: the hours pile up, and each pass invites a typo that skews your results.
For PaperSurvey-generated forms, scanning reduces the amount of typing. You feed the forms through a scanner or capture suitable phone photos, and the software reads the answer fields:
- Time: measure scanning and correction time with a small test batch before estimating the effort for a full survey round.
- Accuracy: recognition can make mistakes. Compare results with the original scans, including a sample of answers the software accepted automatically.
- Consistency: software applies the same coding rules to every form, so you avoid the drift that creeps into a long manual pass.
- Auditability: scanned answers remain available for checking recognized values against the original pages.
For background on how the reading step works, see our guide to OCR survey software.
The step-by-step workflow
For your next survey round, test the whole route to Excel before printing the full batch.
- Prepare the questionnaire: build it in PaperSurvey or import questions from a blank Word, PDF, or text file. Check wording, options, and answer coding, then generate the printable PDF in PaperSurvey.
- Run a pilot: print a few generated copies, complete them with practice answers, and scan them with the equipment you intend to use. Include blanks, multiple selections, and handwriting so you can check how those appear in the review and export.
- Collect responses: hand out the forms, mail them, or leave them at a front desk. Respondents mark checkboxes and bubbles with a pen and write comments by hand.
- Capture the pages: run them through an office scanner, email them in, drop them in a shared folder, drag and drop a batch, or scan them with a phone's document scanner.
- Let the software read them: checkboxes are read by optical mark recognition, handwriting is read by AI, and numeric fields are parsed automatically.
- Review and correct: check flagged answers against their scan images and spot-check accepted answers. Flagging helps direct review; it does not guarantee that every error will be detected.
- Export to Excel or CSV: open Responses, choose Export, select Excel (.xlsx) or CSV, and choose the answer labels or codes you need. Check response counts, identifiers, missing answers, and any active filters before using the file.
You can use standard office printing and scanning equipment, provided the printed marks and scanned answers remain readable. See the export guide for formats and settings, and our overview of processing paper surveys with scanning for the capture step.
Handling handwriting, numbers, and messy marks
Real forms are not perfectly filled in. Someone circles instead of ticking, another writes in cursive, a third scrawls a number that trails outside the box. This is where reading quality matters.
- Checkboxes and bubbles: optical mark recognition reads the designated answer areas. Faint marks, corrections, and marks outside those areas may need manual interpretation.
- Handwriting: AI transcribes cursive and printed handwriting in supported languages. Check examples of your respondents' languages and handwriting during the pilot.
- Numbers: numeric field recognition reads ages, scores, and counts into number columns rather than free text. Check digits that run outside their boxes.
- Flag and confirm: each written question has a recognition setting. Good accuracy flags readings below 90% confidence, Verify always flags every response, and validation rules flag problems such as two ticks on a single-choice question. Confirm or correct the proposed values against the scanned images.
The amount of review depends on your forms, scan quality, and how the spreadsheet will be used. Before a total or chart goes into a report, open a handful of unflagged rows and compare them with their scans; for fields such as IDs or amounts, set them to Verify always.
Cleaning and coding before you analyze
Even after review, a little structure up front saves time later.
- Use consistent value labels: decide whether a rating is stored as 1 to 5 or as text, and keep it uniform across the column.
- Keep an ID column: the per-page identifier lets you match a row back to its original scan if a value looks off.
- Separate open text: keep write-in comments in their own columns so numeric analysis stays clean.
- Check before charting: confirm response counts and missing-value handling before building a pivot table or chart.
If your forms feed a larger operation, our piece on automated processing for paper forms covers batching and routing at volume.
From Excel to Google Sheets, Power BI, and beyond
Excel is often just the first stop. Once structured, the data flows anywhere your analysis lives.
- Spreadsheets: download Excel or CSV files, or use the Google Sheets integration to sync responses.
- Statistics packages: send the same dataset to SPSS or R when you need significance testing or modeling.
- Presentations: push clean charts to PowerPoint for reporting without rebuilding visuals by hand.
- BI dashboards: connect Power BI, Tableau, or Looker through Google Sheets or the REST API for live dashboards.
- Automation: use Zapier, webhooks, or the API to move results into your own systems. Check the plan features for the integrations your workflow needs.
For institutional projects, review the security statement and AI disclosure alongside your data-handling requirements. Check pricing for page limits, handwriting allowances, team access, and institutional payment options.
Try It Free
Bring one blank questionnaire for your next collection round. Start your free trial, create or import the questions, generate a few practice forms, and test scanning and review before distributing the full batch. The 14-day trial needs no credit card. Use the pilot to check the layout, correction effort, and spreadsheet structure your team will need.