Required fields, date formats, numeric ranges, value lists, duplicate detection, regex patterns, and more — all run locally. No uploads. No spreadsheet formulas.
TangoCheck available on Solo & Team plans from $7.50/mo. TangoSense and Format Values free on all plans.
Open your CSV or Excel file in TangoText. TangoSense immediately scans for obvious data issues and PII columns — before you've written a single rule.
Use TangoCheck's 30 rule types to set required fields, allowed value lists, date formats, numeric ranges, regex patterns, duplicate combination checks, and more.
Every problem is listed by row, field and value. Fix the source data, let Format Values correct formatting issues, or leave those rows out of your export. You can also download the list of violations as a CSV.
TangoSense looks through the file you loaded, right in your browser, and points out what is worth a closer look. Nothing is uploaded.
Automatically spots columns that may contain personal data: email addresses, phone numbers, SSN/SIN numbers, and credit card numbers.
Flags columns where dates appear in multiple formats — 2024-03-25 mixed with Mar 25, 2024 — a common source of downstream errors.
Surfaces repeated values in ID or key columns that should be unique — catching issues before they reach your database or ERP.
Points out unexpected blank cells and likely typos (values that appear only once and look similar to a more common value).
Each TangoSense suggestion applies with a single click and can be undone just as easily. No scripting required.
TangoSense runs entirely in your browser. Nothing is uploaded. Your data never leaves your machine.
TangoCheck goes deeper than TangoSense — you define the rules, it enforces them against every row. Available on Solo & Team plans.
Mark any column as required — TangoCheck flags every row where that field is blank or missing.
Check a column against a specific date format (e.g., YYYY-MM-DD) or accept any common format, and test whether dates fall before, after or on a date you choose.
Set minimum and maximum values for numeric columns. Out-of-range rows are flagged for review.
Define allowed values for a column (e.g., status codes, country codes). Any value not on the list is an error.
Catch duplicate combinations across multiple columns — not just single-field duplicates.
Validate fields against any regular expression — postal codes, order numbers, custom identifiers.
Plus 24 more rule types including valid email and URL, string length, starts with / ends with / contains, date before or after, and inconsistent field counts. 30 rule types total.
Once TangoSense or TangoCheck finds a formatting problem, Format Values lets you fix it in bulk before export. Available free on all plans.
Convert mixed date formats to one consistent output. Mar 25, 2024 and 2024/03/25 both become 2024-03-25.
Set decimal places, add or remove thousands separators, strip or add currency symbols, handle negatives and percentages, or add zero-padding.
Title case, uppercase, or lowercase. Trim spaces, remove unwanted characters. Available on all plans including Free.
Phone numbers → (416) 555-1234. SSN/SIN → 123-45-6789. Postal codes to their canonical forms.
TangoSense scans automatically. TangoCheck enforces your rules. Your data never leaves your machine.
Start validating free →TangoCheck on Solo & Team plans from $7.50/mo. TangoSense and Format Values free on all plans.