Relationship sample light theme resized
previous arrowprevious arrow
next arrownext arrow
Shadow

Excel Data Entry and Management made easy!

Automated User Forms for Excel. Create data entry forms, search tools, filters, and reports—instantly.  A simple but powerful database-like tool for Excel!

Windows and Mac versions.
Download a Full-featured version now.

Free Download

AutoExcelForms is now available for instant download — no password, no signup, no credit card required.

Try the full-featured demo for 14 days. After that, it becomes the permanently usable 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.

Effortless Excel Data Table Management

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 and Data Management User Forms for Excel (Mac and Windows).
  • Build an “app” around your Exel data tables in a few clicks.  Use existing data or start from scratch.
  • Add, Edit, Find, Filter, and Report your data effortlessly.
  • Work with related data with ease — parent and child records appear in live, auto-updating forms.
  • Boost productivity and accuracy of data entry and management in Excel.
  • 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.
  • Use the browse/Find form or build 1-Click reports using columns from both the active table and any related (parent) tables. — no VLOOKUPs or XLOOKUPS, no Power Query, and no macros required.

(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!!

Provide All of the Auto Excelforms add-in functionality in freely distributable workbooks.

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.

  1. Mac users: Excel doesn’t include a built-in data form. Auto ExcelForms fills that gap completely.
  2. Windows users: The built-in Excel data form is extremely limited — no dropdowns, no syncing, no customization, no referential integrity. 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:

  • Date field detection places a date-picker icon with a pop-up calendar on the form
  • Wide data columns generate multi-line entry-fields on the form
  • A column with a reference to an image (.jpg .bmp .gif etc.) generates a clickable picture icon for image management (1 per table)
  • Data validation dropdown lists on the worksheet result in equivalent combobox dropdown lists on the form.
  • Any comma-separated Pair such as Yes,No or Complete,Incomplete used as data validation for a column can automatically generate a checkbox instead of a text box, for quicker data entry

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