Free Excel Data Entry Form Builder.
No Code, No VBA
Build custom data entry forms for Excel in seconds. Drag and drop fields like text inputs, dropdowns, dates, and checkboxes. Generate a ready-to-use form that saves directly to your Excel file. No VBA, no macros, no coding.
Current form fields
- Build Custom Excel Data Forms
- Simplify Excel Data Collection
- No VBA, no coding, no sign-up required
See How It Works
Where Your Entries Go
Switch on one, two or all three. Every entry you add, edit or delete goes to each destination that is on, so an Excel file on your PC and a shared Google Sheet can fill up side by side.
Excel file on your PC
The form connects to a workbook on your PC and rewrites its Entries sheet after every change. Nothing leaves your computer. Chrome and Edge. Excel for the web cannot be written to directly, see the FAQ.
Google Sheet
Paste one script into your own sheet and every entry lands there as a row, edits and deletions included. Works in every browser, and everyone you share the form with fills the same sheet.
Webhook
Each entry is posted as JSON to a URL you choose, ready for Zapier, Make, Pabbly Connect, n8n or your own server.
How Does It Compare?
| Feature | VBA UserForms | Microsoft Forms | This Tool |
|---|---|---|---|
| Coding Required | Yes (VBA) | No | No |
| Custom Field Types | Full control | Yes | 11 types |
| Dropdowns | Yes (manual) | Yes | Yes |
| Conditional Logic | Yes (manual) | Yes (branching) | Yes |
| Data Validation | Yes (manual) | Basic | Basic (email, number, required) |
| Saves to Excel | Yes (same workbook) | Export only | Yes (local file), plus Google Sheets or a webhook |
| Works Offline | Yes | No | Yes |
| Search Records | Yes (manual) | Yes | Yes (built-in search) |
| Edit / Delete Records | Yes (manual) | Yes | Yes |
| Shareable | Within workbook | Link sharing | Share the HTML file, collect in one Google Sheet |
| Setup Time | Hours | Minutes | Seconds |
| Cost | Free (DIY) | Free (Microsoft account) | Free |
TL;DR: VBA UserForms give you full control but require coding knowledge and hours of setup. Microsoft Forms is great for teams and collaboration but needs a Microsoft account and cannot save directly to a local Excel file. This tool sits in the middle: custom forms with dropdowns, conditional logic, search, and edit/delete built in. No coding required, and the data goes straight into your Excel spreadsheet, a Google Sheet, or both.
Frequently asked questions
Excel's built-in form (Alt+D+O) only shows your existing column headers as fields. You cannot add dropdowns, conditional logic, or custom validation. This builder lets you design the form from scratch with 11 field types including dropdowns, radio buttons, checkboxes, and conditional fields.
For most use cases, yes. This tool gives you a visual builder with dropdowns, conditional fields, validation, and built-in search, edit, and delete. The trade-off is that VBA UserForms offer deeper customization for complex workflows. For standard data entry, this tool gets you there in seconds instead of hours.
Yes. You can add Select (dropdown) fields with custom options. Each option has a label (what the user sees) and a value (what gets saved to Excel).
No. Just open the page, design your form, and download the generated HTML file. The downloaded form also works without any installation.
Your form and your entries stay in the browser. Only the link to the Excel file is dropped, which browsers do for security, so the form shows a Reconnect button: one click and it saves to the same file again.
Saving straight into an Excel file needs the File System Access API, which only Chrome and Edge have. In Firefox and Safari the form still works: entries stay in the browser, you can download them as .xlsx at any time, and sending them to a Google Sheet or a webhook works everywhere.
Not directly. The form writes to a file on your computer, and Excel for the web has no way to let a page write into a workbook. What does work: keep the workbook in a OneDrive or SharePoint folder that is synced to your PC, connect that local copy, and OneDrive carries every change up, so the online copy shows the new rows a moment later. Close the workbook in the browser while you are entering data, otherwise OneDrive may create a conflict copy. If you want the data online without a PC in the loop at all, use the Google Sheet destination instead.
Yes. The tool is completely free. No sign-up, no credit card, no hidden fees. If you find it useful, you can buy me a coffee to support future development.
Your form design is sent to my server once to build the file. The entries people type into your form never reach me: they go only to your own Excel file, Google Sheet or webhook.
Yes. If you already have an Excel sheet, you can copy and paste your data into it. The form will pick it up automatically once connected.
Yes. The generated form includes a data table with edit and delete buttons for each entry. You can also search through your entries using the built-in search bar.
Yes. The generated form is a single HTML file. You can share it with anyone by sending the file. Each person will have their own local data storage. The form does not support multiple users writing to the same Excel file simultaneously. To collect everyone's entries in one place, connect the form to a Google Sheet before you download it: every copy then writes to the same sheet.
Through a small script you paste into your own sheet (Extensions, then Apps Script) and deploy as a web app. The form posts each entry to that web app, and edits and deletions follow, so the sheet mirrors the form. Nothing passes through my server. The script and the steps are under Where Your Entries Go above, in the download dialog, and inside every downloaded form under Destinations.
Yes. In the download dialog, under Where entries go, untick Excel file and tick Google Sheet or Webhook. The form then never asks for a file; every entry goes straight to the destinations you set. Any mix works: Excel only, Sheet only, webhook only, or all three at once. The same switch sits inside every downloaded form under Destinations.
Yes. Click Load a downloaded form in the builder and pick the HTML file you saved. The fields come back exactly as they were, ready to change and download again. The form file is the save file, so nothing else to keep.
Yes, the form is one HTML file, so any static host works. The quickest: rename the file to index.html, put it in an empty folder, and drag that folder onto app.netlify.com/drop. You get a public link in seconds on Netlify's free plan. On GitHub, create a repository, upload the file as index.html, and switch on Pages under Settings. Both are free. Tick Google Sheet or Webhook before you download, because an online form is usually filled by people who do not share your Excel file. There is no one-click publish from this builder on purpose: it would need a Netlify or GitHub login inside the tool.
Yes, a few:
- Cell formatting (colors, fonts, borders) is not preserved when saving to Excel
- Formulas are converted to their calculated values
- Charts and images are not preserved
Workaround: Keep your formatted reports in a separate Excel file that references the data file using formulas like =[data.xlsx]Entries!A1. The form only updates the raw data, and your formatted file stays intact.
Honest Feedback from Real Users
Responsive and open to feedback
“Impressed with both the products and the support. Very responsive to questions and open to improvement suggestions. I've purchased several tools and been happy with all of them.”
Fantastic support
“Had a question and got a helpful reply within hours. Really solid support. Highly recommend.”
An awesome program and creator
“Not only does the developer respond directly to your questions, he actually acts on them. I made a feature request and it was implemented the next day. That kind of dedication is rare.”
Changelog
Looking for Full Coding Control?
If you need advanced customization beyond what this visual builder offers, the Python-based version gives you complete control over form logic, validation, and data handling.
Check out the free Python VersionConnect your Google Sheet
About two minutes, once. The form then posts every entry to your sheet through a small web app that runs in your own Google account. Nothing passes through my server.
- Open the Google Sheet the entries should land in, or make a new one at sheets.new. Give it a name, for example
Staff Intake. - In the sheet's menu click Extensions, then Apps Script. A code editor opens in a new tab with a file called
Code.gs. - Select everything in that editor (Ctrl+A), paste the script below over it, and press Ctrl+S. You can name the project anything, for example
Form bridge. - Click the blue Deploy button top right, then New deployment. Next to "Select type" click the gear and choose Web app.
- Set Execute as to Me (your email) and Who has access to Anyone. Not "Anyone with Google account": the form posts without a login. Click Deploy.
- Click Authorize access and pick your Google account. Google warns that it has not verified the app, which is expected for a script you just wrote yourself: click Advanced, then Go to Form bridge (unsafe), then Allow.
- Copy the Web app URL. It looks like
https://script.google.com/macros/s/AKfycbzQ9x...7Fw/execand always ends in/exec. Paste it into the Google Sheet box in the download dialog. - Add an entry in the downloaded form. A header row and your entry appear in a sheet tab called
Entries, with the same columns as the Excel file plus anEntry IDcolumn that lets edits and deletions find their row.
"Anyone" means anyone who has the URL can add rows, so treat it like a password. If you change the script later, deploy a new version: Deploy, Manage deployments, pencil, Version: New, Deploy. Saving alone does not update a live web app. Google's own reference: Apps Script web apps.
Preview
This is the form exactly as it downloads. Try it: fill it in, add entries, open Destinations. Nothing is saved here.
Building the preview…
Your Form is Ready!
Where entries go
Tick as many as you like. Every entry is saved to each one.
Need this URL? . You paste one script into your sheet and copy the link Google gives you. Keep that link private: anyone who has it can add rows to your sheet.
In Zapier, Make or Pabbly Connect, create a webhook trigger ("Catch Hook") and paste its URL here. The form sends a test when you first add an entry, and the tool shows the fields to map.
Everyone who opens the downloaded form uses these settings, and can change them inside the form under Destinations.