Supabind

File Validation

Learn how Supabind validates uploaded datasets before they are imported and processed.

Overview

The File Validation feature automatically checks every uploaded dataset before it is imported into your workspace.

Validation helps identify missing headers, unsupported file formats, invalid structures, duplicate columns, and other issues that may prevent successful data transformation.

Files that successfully pass validation become immediately available for transformation, workflow automation, and analysis.

Why File Validation?

Validating files before processing reduces import failures, improves data quality, and ensures transformations run successfully.

Validation Process

Every uploaded dataset is automatically validated before it is imported into your workspace. During this process, Supabind checks the file format, structure, headers, and data quality to ensure the dataset is suitable for transformation and workflow execution.

Validation Workflow

  1. The uploaded file is received.
  2. The file format is verified.
  3. The file size is checked.
  4. The dataset structure is analyzed.
  5. Column headers are validated.
  6. Rows and columns are inspected.
  7. Supported data types are verified.
  8. Validation results are generated.
  9. If validation succeeds, the dataset becomes available for transformation.

Validation Rules

Supabind performs multiple validation checks to ensure uploaded datasets meet the required standards before processing begins.

Supported File Formats

Only supported file formats can be imported.

• Microsoft Excel (.xlsx)
• Microsoft Excel (.xls)
• CSV (.csv)
• TXT (.txt)
• XML (.xml)

File Size Validation

Every uploaded dataset is checked against the maximum upload size before processing begins.

Current Upload Limit
  • • Maximum file size: 50 MB
  • • Multiple uploads are supported.
  • • Files exceeding the limit are rejected.

Column Header Validation

Column headers are required for successful mapping and transformation.

  • • The first row must contain column headers.
  • • Header names cannot be empty.
  • • Duplicate column names are detected.
  • • Unsupported header structures generate validation errors.

Dataset Structure Validation

Supabind validates the overall structure of every uploaded dataset.

  • • Consistent number of columns.
  • • Proper row formatting.
  • • Empty rows detection.
  • • Corrupted file detection.
  • • Unsupported formatting.

Data Type Validation

Supabind checks whether values within each column are consistent and can be processed correctly.

  • • Text values
  • • Numeric values
  • • Date values
  • • Boolean values
  • • Empty or null values

Common Validation Errors

If a dataset does not meet the required validation rules, Supabind displays a validation error describing the issue. Review the error details, correct the dataset, and upload the file again.

Unsupported File Format

The uploaded file format is not supported by Supabind.

Resolution
  • • Upload CSV, XLSX, XLS, TXT or XML files.
  • • Verify the file extension before uploading.

Missing Column Headers

The first row does not contain valid column headers.

Resolution
  • • Add column names to the first row.
  • • Ensure every column has a unique header.

Duplicate Column Names

Two or more columns contain identical header names.

Resolution
  • • Rename duplicate columns.
  • • Ensure every column name is unique.

File Size Exceeded

The uploaded file exceeds the maximum allowed upload size.

Resolution
  • • Reduce the dataset size.
  • • Split large datasets into multiple files.

Corrupted or Invalid File

Supabind could not read the uploaded file because it is corrupted or has an invalid structure.

Resolution
  • • Open the file locally and save it again.
  • • Verify the file contains valid data.

Empty Dataset

The uploaded file does not contain any data rows.

Resolution
  • • Verify the dataset contains records.
  • • Upload a file with valid data.

Validation Results

After validation completes, Supabind displays the validation status to indicate whether the uploaded dataset is ready for processing or requires attention.

✅ Validation Passed

The uploaded dataset meets all validation requirements and is ready for transformation, workflow execution, and analysis.

⚠ Validation Warning

Minor issues were detected, but the dataset can still be imported.

  • • Empty cells
  • • Mixed data types
  • • Blank rows
  • • Optional fields missing

❌ Validation Failed

Critical validation errors prevent the dataset from being imported.

  • • Unsupported file format
  • • Missing column headers
  • • Duplicate column names
  • • Invalid file structure
  • • Corrupted file

Best Practices

Following these recommendations helps reduce validation errors and ensures your datasets are ready for transformation, workflow automation, and analysis.

File Preparation

  • • Use supported file formats (.xlsx, .xls, .csv, .txt, .xml).
  • • Keep files below the maximum upload limit.
  • • Save files using UTF-8 encoding when possible.
  • • Remove unnecessary formatting before uploading.
  • • Verify the file opens correctly before import.

Dataset Structure

  • • Include column headers in the first row.
  • • Use unique and descriptive column names.
  • • Keep the same number of columns in every row.
  • • Avoid merged cells.
  • • Remove empty rows and unnecessary columns.

Data Quality

  • • Remove duplicate records before uploading.
  • • Keep data types consistent within each column.
  • • Verify date formats are consistent.
  • • Fill required values whenever possible.
  • • Correct invalid or incomplete records.

Before Uploading

  • • Review your dataset before importing.
  • • Confirm the correct file has been selected.
  • • Check file size and format.
  • • Resolve validation warnings whenever possible.
  • • Keep a backup copy of your original dataset.

Need More Help?

If your dataset continues to fail validation, review the validation messages to identify the reported issues. Correct the dataset and upload it again. If the problem persists, contact the Supabind Support team for further assistance.

Contact Support