Built-in rules to validate import data
Validation rules ensure that imported data meets your requirements before it's accepted. Each column can have multiple validation rules applied. When data fails validation, users see clear error messages and can correct the issues before completing the import.
minLengthMust be at least {value} charactersConfiguration
minLength: 3Valid
"John"Invalid
"Jo"maxLengthMust be at most {value} charactersConfiguration
maxLength: 50Valid
"Short text"Invalid
"A very long text that exceeds the maximum..."minMust be at least {value}Configuration
min: 0Valid
5, 100, 0Invalid
-1, -100maxMust be at most {value}Configuration
max: 1000Valid
500, 1000Invalid
1001, 5000regexMust match pattern: {value}Configuration
regex: "^SKU-\d{5}$"Valid
"SKU-12345"Invalid
"SKU-1234", "ABC-12345"enumMust be one of: {value}Configuration
enum: ["active", "inactive", "pending"]Valid
"active", "inactive"Invalid
"suspended", "deleted"uniqueDuplicate value foundConfiguration
unique: trueValid
All different valuesInvalid
Duplicate values in different rowsEach validation rule can have a custom error message. This allows you to provide context-specific feedback to users when their data doesn't meet requirements.
{
"type": "regex",
"value": "^SKU-\\d{5}$",
"message": "Product code must be in format SKU-XXXXX (e.g., SKU-12345)"
}