In this article:

How to Create a Fillable Form in Google Sheets (2024 Guide)

May 8, 2024

How to Make a Fillable Form in Google Sheets

Below we have outlined the steps on how you can make a fillable form in Google Sheets:

Step 1: Create Your Data Entry Fields

Think about the information you want to collect. For example, if you're collecting feedback, you might want fields for Name, Date, Feedback, and Rating. In the first row of your sheet, type these field names into the cells to serve as headers. This row will help keep your data organized.

how to create a fillable form in google sheets

Make your headers stand out by formatting them. You can bold the text, change its color, or fill the cell background with a color. Use the formatting tools in the toolbar above the spreadsheet.

how do i create a fillable form in google sheets

Step 2: Format Your Data

Click on the column letter or cell where you want to add validation. For example, if you want all entries in the "Date" column to be a date, click the column letter at the top.

how to make a fillable form in google sheets

Go to Format > Number then click "Date".

create a fillable form in google sheets

Below is the default format for dates in Google Sheets:

google sheets fillable form

Step 3: Add Data Validation (Optional)

To ensure data consistency and prevent errors, you can use data validation for certain fields.

Go to Data > Data validation from the top menu.

fillable form in google sheets

Click "Add rule". Click on the dropdown menu under Criteria and choose "Is valid date".

fillable form google sheets

For some types, you can specify further conditions (e.g., a date must be after a certain date).

If you want a dropdown list (useful for ratings or yes/no questions), select "Dropdown" and enter the options.

fillable form for google sheets

Click "Done" at the bottom right corner of the screen to apply your data validation rules.

Step 4: Share Your Spreadsheet for Data Entry

Click the Share Button located in the top-right corner of the screen.

make a fillable form in google sheets

You can enter the email addresses of people you want to share the spreadsheet with and select whether they can view, comment, or edit.

Alternatively, you can get a shareable link by choosing "Anyone with the link" under General access and selecting "Editor" then clicking "Copy link."

Tip: To prevent accidental changes to your headers or formulas, you can protect these cells. Right-click the cell or range, then select Protect range.

create a fillable form google sheets

We hope that this article has helped you and given you a better understanding of how to create a fillable form in Google Sheets. If you enjoyed this article, you might also like our articles on how to use the DGET function in Google Sheets and how to create a content calendar in Google Sheets.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->