Understanding Data Types
dataclean.to automatically detects 26 different data types with confidence scoring.
How Detection Works#
When you upload data, we sample up to 100 values per column and run pattern matching against our type definitions. The type with the highest match rate becomes the detected type.
1
Sample2
Match3
Score4
AssignBasic Types#
| Type | Example | Description |
|---|---|---|
text | Hello World | Plain text (fallback) |
number | 1,234.56 | Integers and decimals |
boolean | yes, true, 1 | Yes/No values |
percentage | 15.5% | Percentage values |
year | 2024 | 4-digit years (1900-2099) |
Contact Types#
emailuser@example.com
Email addresses
phone(555) 123-4567
Phone numbers
social_handle@username
Social media handles
Web Types#
urlhttps://example.com
URLs and web addresses
ip_address192.168.1.1
IPv4 and IPv6
uuid550e8400-e29b...
UUIDs/GUIDs
Confidence Scoring#
Each detection includes a confidence score (0-100%). We require at least 50% confidence to assign a specific type. Below that threshold, we default to text.
High
90%+
Medium
70-89%
Low
50-69%
Note
You can always override the detected type in the column configuration panel. Low-confidence detections are marked with a warning icon.