From paper form to spreadsheet

Every Bacaform project moves through the same four stops. The first one takes some care. After that, the work is mostly uploading and downloading.

  1. Set up

  2. Upload

  3. Review

  4. Download

Before you start

Find two or three copies of your form that people have already filled in. Scans and phone photos are both fine. Your first project comes with 20 free pages and 10 set-up pages, so you can try everything on this page without paying.

1. Create a project

On My projects, press Start a new project, give it a name and press Create. A project holds one form and everything you collect with it, so give it a name you will recognise, for example “Baking class feedback, December”.

2. Set up the form

You land on Form set-up, which has five short steps.

  • Upload examples. Add your filled-in copies. Bacaform studies them for about a minute.
  • Review layout. Your form appears with a box around each place where someone writes an answer. Click a box to rename or adjust it. If an answer has no box, drag on the page to draw one.
  • Questions. You may get a few Yes or No questions about the form, such as whether a group of rows is one table.
  • Test. Pick an example and compare what was detected with the paper. Correct anything that is off, then press This looks right.
  • Ready. Look over the summary and press Start collecting.

You do this once for each form.

3. Upload your forms

The Upload page opens by itself. Drop your files in, or press Choose files. On a phone, Take a photo opens the camera. If you scanned fifty forms into a single PDF, upload it as it is: Bacaform separates it into fifty entries. Press Upload. You can close the page while the reading carries on.

4. Review what needs a second look

Most entries are accepted by themselves. When the handwriting leaves room for doubt, the entry waits under Review, and a number beside that word in the menu shows how many are waiting. Press Start reviewing. Each answer is shown beside the handwriting it came from. Press Yes, that is right to confirm it, or enter the correct answer and press Save this instead. When nothing is left, the page says “All caught up”.

5. Download your spreadsheet

Open Data, then the Download tab. Choose Excel or CSV and press Prepare download. When the file is ready, it appears under Downloads with its own Download button. The Excel file has two sheets: Data holds the answers, and Column guide explains each column. You don't have to wait until the last form is in. Download whenever you want to see the data so far.

Where to go next

All guidesSet up a form