Ivandt Importer
Modern data onboarding SDK for importing, validating, and transforming structured data
What is Ivandt Importer?
Ivandt Importer is a modern, high-performance, embeddable data onboarding SDK that enables businesses to import, validate, transform, and deliver structured data directly inside their applications. It replaces messy, error-prone spreadsheet uploads with a controlled pipeline that ensures every record matches your business expectations before it hits your backend systems.
At its core, the Importer is a web component that works in any framework — React, Angular, Vue, Svelte, or vanilla JavaScript. It handles file parsing, intelligent column mapping, real-time validation, data transformation, and provides an Excel-like review interface for users to fix errors before submission.
Import workflows
Ivandt supports two distinct workflows to match your use case:
Schema-based imports are ideal for production environments where you define your data structure upfront. You specify fields, validation rules, and transformations in a reusable schema. This approach provides maximum control and is perfect for repeated imports with consistent data structures.
Schema-less imports require no upfront configuration. Users upload files and map columns to field types on-the-fly, with each field type bringing built-in validation and formatting. This workflow excels at ad-hoc data cleanup, format conversion, and one-time imports where the data structure isn't known in advance.
Both workflows leverage the same powerful validation engine, transformation capabilities, and Excel-like review interface.
Schema-based import flow
When using a predefined schema, the import process follows these steps:
Upload
User uploads Excel, CSV, TSV, or JSON file. Ivandt supports multiple file formats and handles large files efficiently.
Parse
Ivandt parses the file using web workers for performance. This keeps the UI responsive even with massive datasets (500k+ rows).
Map headers
AI-powered column mapping automatically matches spreadsheet headers to your schema fields. Users can manually adjust mappings if needed.
Validate
Every cell is validated against your rules in real-time. Validation runs in parallel across multiple web workers for speed.
Transform
Data is cleaned and transformed according to your configuration. Transformers run automatically or can be triggered by users.
Review
User sees an Excel-like interface to review and fix any errors. Inline feedback, smart fix suggestions, and bulk correction tools make fixing errors fast.
Submit
Clean JSON is generated and sent to your onSubmit handler. You receive validated, transformed data ready for your database.
Schema-less import flow
When no schema is defined, users map columns to field types dynamically:
Upload
User uploads Excel, CSV, TSV, or JSON file without any predefined schema requirements.
Parse
File is parsed using web workers, maintaining performance even with large datasets.
Map field types
User selects a field type (text, numeric, monetary, phone, date, time, password, checkbox) for each column. Each field type brings built-in validation and formatting rules.
Validate
Cells are validated based on the selected field types. Auto-clean features format data automatically where enabled.
Transform
Users can apply AI-powered transformers for additional data manipulation (uppercase, regex replace, rounding, etc.).
Review
Same Excel-like interface with inline error feedback and smart fix suggestions.
Export
Clean data is exported in the desired format (Excel, CSV, or JSON) or sent to your onSubmit handler.