Excel Data Entry, Navigation, and Form Management made easy!
Automated User Forms for Excel. Create Data Forms, Search Tools, Filters, Reports, and enforce Referential Integrity—with just a click or two.
Windows and Mac versions.
Download AutoExcelForms —no credit card required.
After 14 days, the evaluation version becomes the fully functional Free Edition.
(See version Differences)
Dynamic Forms
Professional, Dynamic, Resizable Userforms to Manage your Excel data in a Single click – No coding required
Smart Search
An automatically generated Browse and Find Form with dynamic search to find anything
Instant Filters
An easy to use, but powerful filter form that instantly generates Autofilters or advanced Filters
Quick Reports
A simple single-click report generator. Optionally select columns and column order for report output.
Organize your Data, Manage linked records, Keep Track of Anything!
Simple, Powerful, and Code-Free.
With AutoExcelForms (Free or Standard versions) you can:
- Create Fully Automated Data Entry User Forms for Excel (Mac and Windows).
- Add, Edit, Find, Filter, and Report your data effortlessly.
- Manage related data records visually — view parents and children at a glance.
- Boost productivity and accuracy of data entry and management in Excel.
- Start with your existing tables or build an “app” around new data.
- Enjoy dynamic, professional forms, easily-customized interfaces for data table navigation and management.
Manage Linked Records Easily!
- View Parent Records related to your active record with a single click.
- Browse all Child Records related to a master entry — instantly searchable.
- Automatic data validation: ensure related records match, and protect data integrity.
(Available on Windows and Mac — whether you use Excel’s Data Model or AutoExcelForms’ built-in Relationship Manager.)
For Developers or Excel power users:
With Auto Excelforms (Professional version) you can also save time or earn easy income and instantly create modifiable forms in the Visual Basic Editor. No coding required!
Generate userforms and deliver freely distributable data management workbooks in seconds instead of days!!
Includes a password to access all the userform program code.
Use Cases
For end-users
- You’re a small business, club, or individual who wants to “keep track of things.” It might be a customer list, jobs to be done, movie titles, assets, survey results — anything!
- You have rows and rows of data in Excel and need a convenient way to view, edit, search, or add records one at a time. Endless scrolling leads to inefficiency and errors — you’re looking for something better.
- You simply want an easier way to view and work with your tabular data.
Auto ExcelForms gives you all of this, and much more — instantly and effortlessly.
- Mac users: Excel doesn’t include a built-in data form. Auto ExcelForms fills that gap completely.
- Windows users: The built-in Excel data form is extremely limited — no dropdowns, no syncing, no customization. Auto ExcelForms fixes all of this and much more.
Despite not being a database management platform, many people use Excel that way. But it lacks several key features you’d expect from even a basic database solution — like a user-friendly, robust front-end for fast, accurate data entry and management, and built-in support for referential integrity to maintain consistency across related tables.
Save time and money — download a free copy of Auto ExcelForms. With just one click, generate professional, easy-to-use data forms that help you maintain, search, and navigate your Excel data.
For Excel Developers and Experts
You build Excel-based solutions and need userforms — but building and coding them from scratch is time-consuming.
AutoExcelForms Professional creates full-featured userforms and carries over all supporting functionality into the workbook — including search, filter, reports, relationships, and customizations.
No add-in needed at runtime: the workbook runs standalone with everything embedded.
Generate polished, ready-to-go forms for Windows or Mac, and customize them as needed. You’ll dramatically reduce dev time while delivering a robust, professional front-end.
Intelligent Defaults
Effortlessly create Data entry userforms in a single click with intelligent defaults that can be overridden:
Easy No-code Customization
Enhance your Excel data management with customizable themes, colors, fonts, and behavior settings. Effortlessly specify mandatory fields, auto-increment values, and validation rules to boost productivity and accuracy. Enjoy a personalized, intuitive interface designed to meet your unique needs.
Customize Appearance
- Application Theme color
- Default Picture/Logo (Windows version only)
- Frame and Label Colors
- Label Fonts
- Entry field Colors
- Entry Field Fonts
- Full screen zoom level
- Popup Calendar Size, Calendar First Day of Week
- Theme colors in Forms, Tables, Both or none
- Standard Message Boxes or Theme Colored
- Command Button placement, label Placement and more
Customize Behavior
- Specify Mandatory fields (Users warned and prevented from saving empty Entry fields)
- Specify Number-only fields, Read-only fields
- Specify a Pop-up table Lookup that can be accessed by click of a lookup Icon
- Auto-Generate validation lists and rules from existing table data
- Specify Column as Primary (Enforces Unique non-blank) value
- Specify Primary column as Auto-increment – The application will increment the primary key for new data entries
- Auto increment a user-definable Numeric e.g. (1 -> 2) or Alphanumeric e.g. (ID0001 -> ID0002) key
- Confirmation Prompt before Saving/Submitting data or not
- Auto commit changes on navigating to new record or not
- New blank form after each new addition or not
- Specify Default values for new records (constants or formulas) for any column
Data Forms Plus
Easy Filter - Filter by form
- Easy to use interface for selecting data
- Autogenerated Filter forms
- Simplify the most complex filters
- Choose AutoFilter or Advanced filter output
- AND or OR criteria
- Type in one or more criteria in boxes that represent
the data columns and Easy Filter will do the filtering. - Advanced Filter formula mode for complex filters
Browse/Find Window
- Navigate your data effortlessly
- Dynamic Search
- Select Columns and Column order
- Respects any Filter in effect
Simple Report Generator
- Select Columns and Column order
- Respects any Filter in effect
- Output to Formatted table
- Handles Page setup, Headers and Totals
