Upload an Excel file
Choose an XLSX or XLSM workbook on your device.
EXCEL TOOLS
Remove Data Validation in Excel
Remove unwanted Excel drop-down lists, input restrictions, and validation rules without changing the spreadsheet data.
✓ Free to use ✓ No sign-up✓ Browser processing
Choose an Excel workbook to find validation rules.
WORKBOOK LOADED
Workbook
Validation rules
Remove selected rules
Select the rules you want to delete. Unselected rules stay in your workbook.
HOW IT WORKS
How to Use Motricialy Remove Data Validation in Excel
Clear input restrictions and unwanted Excel drop-downs without editing individual cells.
Review validation rules
See each rule's sheet, cell range and validation type, then choose which ones to remove.
Remove and download
Download a new Excel workbook without the selected validation rules.
KEY FEATURES
Key Features
Remove drop-down lists
Clear validation lists without deleting the values in cells.
Review cell ranges
See where each Excel validation rule applies.
Select individual rules
Keep the restrictions you still need.
Multi-sheet support
Clean validation across multiple worksheets.
Preserve workbook parts
Only selected worksheet validation definitions are changed.
Private browser processing
Files stay in the browser and are not uploaded to a server.
EXCEL GUIDANCE
About Excel Data Validation Rules
Excel Data Validation controls what users may enter in particular cells. Rules can restrict values to lists, numbers, dates, time, text length, or custom formulas. Removing a rule makes those cells accept entries without that specific check.
Removing a drop-down list does not delete data already stored in the cell, and it does not delete the original list items stored elsewhere in your workbook. If the workbook has unrelated hyperlink cleanup needs, use Remove Hyperlinks from Excel. To clean formulas separately, try Remove Formulas from Excel.
Workbooks may include newer Microsoft 365 extension-based validation rules. This tool refuses to edit a sheet if it detects validation structures it cannot safely process. Protected sheets may need to be unprotected in Excel before editing.
FREQUENT QUESTIONS
Remove Data Validation in Excel FAQ
Does it delete the text or numbers in the cells?
No. Deleting a data validation rule changes input restrictions, not existing cell contents.
Can I remove Excel drop-down lists only?
Yes. Use “Select drop-down lists” to select standard list-type validation rules and leave other validation types unchanged.
Will formulas and formatting be preserved?
The tool modifies validation definition elements in selected worksheet XML. It leaves cell formulas and direct formatting unchanged.
Can I choose which worksheets are cleaned?
Yes. Individual rules show the worksheet and cell range, so you can choose only the rules you want removed.
Are newer Excel validation types supported?
Standard OOXML validation rules are supported. If a sheet uses unsupported extension-based rules, the tool warns you rather than silently exporting incomplete changes.
Is my workbook uploaded?
No. The workbook is processed locally in your browser; you download a separate edited copy.
RELATED TOOLS
Related Tools for Excel
Continue preparing and cleaning your spreadsheets.