Optical Character Recognition (OCR)

This feature is available to AppSheet Enterprise accounts only. See AppSheet pricing.

What is OCR?

OCR is a technology that allows you to access the text or writing that appears in an image. With AppSheet's OCR feature, you can speed up data entry by automatically filling out your forms from an image.

Watch a video to learn more about OCR.

AppSheet OCR

What kinds of images work with OCR?

AppSheet's OCR feature can be used when you need to scan multiple documents that all have a fixed layout. The image may contain printed text or handwriting. Some examples of this include:

  • A standardized paper form
  • USPS shipping labels
  • Invoices from a single company

Some cases where AppSheet's OCR feature will not work include:

  • Business cards (which do not adhere to a standard format)
  • Forms that use checkboxes
  • Apps that do not have an internet connection

How do I use OCR in my app?

AppSheet's OCR feature is currently in beta. You can access it in the AppSheet editor under Intelligence > OCR.

To get started with OCR, you will need between at least 4 and no more than 10 example images and the values that should be extracted from them. AppSheet will inspect the given examples and come up with a general template to match against new images.

Once you have your examples, you can create a new OCR model:

  1. Open your app in the editor.
  2. Go to Intelligence Intelligence icon.
    The Intelligence panel opens.
  3. Click + adjacent to the OCR Models heading.
     We've made some improvements to the app editor.
    You are opted in to the new editor by default, but you can switch back to the legacy editor at any time.

    If you are using the legacy navigation

    Go to the Intelligence > OCR Models pane and click + New OCR Model.
  4. Rename the OCR model by updating the name field.
  5. Select the table that contains the image examples in the Table drop-down.
  6. Choose the image column that has the examples inputs in the Image Column drop-down.
  7. Set the Output Columns to include the columns that contain the extracted data.
  8. Save the app by selecting one of the following options:
    • Save - Save the app.
    • Save & verify data - Save the app and verify that it is runnable based on external dependencies.

Once you save your changes, your custom OCR model will be created. AppSheet will show the patterns that were found in each example and inform you of any issues that happened along the way.

For example, let's say we're extracting information from pictures of a conference badge. We'll create a new OCR model that will operate on the Badges table, extracting from the Badge image column, and returning the First Name, Last Name, Organization, Twitter Handle, and Role from the image.

After the OCR model has finished training, it's available for use in your app. Your columns will automatically be initialized using the extracted values from the image. Behind the scenes, AppSheet has added special OCR formulas to initialize the values of your columns.

Was this helpful?

How can we improve it?

Need more help?

Try these next steps:

Clear search
Close search
Google apps
Main menu