Catch Excel and CSV errors before your next import.
Upload or create a file, set your rules, then check, fix and reshape it on screen before it goes into your ERP, CRM, or database.
Define the rules.
Brutus checks every row.
Upload or create a file, set each column's type and rules, and run the check. Brutus shows what failed and why, and you fix it on screen.
Upload or create
Upload an Excel or CSV file, or create a new sheet.
Check, fix & reshape
Set each column's type and rules, then fix and reshape the sheet on screen.
Download
Download your corrected file and the reports.
Validate each type of data with the rules that matter.
Assign a validation type to each column, then choose the rules Brutus should use.
TEXT · 10 TYPES
- Email, phone, URL, postal code
- Identifier, IP address, UUID
- JSON and custom patterns
- Length, case, allowed characters
NUMBER · 8 TYPES
- Integer, decimal, percentage
- Currency and accounting
- Scientific and fractions
- Value ranges
DATE & TIME · 3 TYPES
- Date, date & time, time
- Date layouts
- Date ranges
BOOLEAN
- True/False, Yes/No, Y/N, 1/0
- Choose the accepted pairs
- Allow other answers (N/A)
Finding common errors shouldn't be this difficult.
Apply rules for required values, whitespaces, duplicates, and other common data problems.
No missing values
Flag blanks where downstream systems require a value.
Clean boundaries
Find leading or trailing whitespace that can break matching and imports.
No duplicates
Detect repeated values within a column when uniqueness matters.
Explicit domains
Limit values to an approved list your target system accepts.
Match values exactly
Choose whether validation should treat uppercase and lowercase values as different.
More ways to validate
We're continuously adding new validation rules to give you more ways to check your data.
Fix and reshape without leaving Brutus.
Fix errors on screen, reshape the sheet, and download your corrected file.
Fix on screen
Accept a suggestion, type a new value, or fix every match at once.
Your file, back
Download your own file with your fixes in it.
See what's odd
Empty cells, placeholders and hidden characters, before any rule.
Column tools
Split, extract, merge, calculate, fill down and replace values.
Row tools
Sort, filter, remove duplicates or empty rows, split into rows.
File tools
Compare, look up and stack sheets, or split one file into many.
Find the failures before the import does.
Upload your Excel or CSV file, define your validation rules, and see what Brutus finds.
TRY BRUTUS FREE