ImportKit is an embeddable CSV and Excel import widget for SaaS applications. It provides AI-powered field mapping, duplicate detection, smart date parsing, phone normalization, built-in validation, and inline data editing. It can be set up in 5 minutes using a React component.

How does the AI field mapping work?

ImportKit uses a two-tier mapping strategy: first, client-side fuzzy matching for instant results, then AI-powered semantic matching for ambiguous columns. It also learns from user corrections — mappings that are confirmed repeatedly get promoted to instant matches for future imports.

What file formats does ImportKit support?

ImportKit supports CSV, XLSX (Excel), and XLS file formats, up to 50MB. Large files are streamed and validated using a Web Worker to keep the UI responsive.

How long does it take to integrate ImportKit?

About 5 minutes. Install the npm package (@importkit/react), add the ImportWidget component to your app with your API key and field definitions, and deploy. The widget handles the rest.

Is there a free tier?

Yes. ImportKit's free tier includes 5,000 rows per month and 3 import templates. No credit card required.

How does ImportKit handle messy data?

ImportKit includes duplicate detection (single or composite keys), smart date parsing that auto-detects DD/MM vs MM/DD format per column, phone number normalization, find & replace for bulk corrections, and inline cell editing. Users can fix errors directly in the preview before importing.

Is my data sent to ImportKit servers?

No. CSV and Excel files are parsed entirely in the browser. No file data is sent to or stored on ImportKit servers. Only metadata (row counts, field names, mapping decisions) is retained for analytics.

How does ImportKit compare to Flatfile?

ImportKit is designed for indie developers and growing SaaS products. It starts free ($0/month), processes data client-side for better privacy, and the widget is MIT-licensed. Flatfile targets enterprise customers with pricing starting at $500+/month. ImportKit is lighter, faster to integrate, and more affordable.

Can I customize the look of the widget?

Yes. ImportKit supports custom theming including primary color, success/error colors, border radius, font family, and font size. On the Pro plan, you can also remove the ImportKit watermark and add custom branding.

Does ImportKit handle duplicate detection?

Yes. Users can select one or more fields to check for duplicates. ImportKit groups matching rows, highlights them, and lets users skip or keep each duplicate. Comparison is case-insensitive and supports composite keys (e.g., first name + last name).

What date formats does ImportKit support?

ImportKit auto-detects date formats per column: DD/MM/YYYY, MM/DD/YYYY, YYYY-MM-DD, and named months (e.g., 'March 25, 2026'). It handles dashes, dots, and slashes as separators. All dates are normalized to ISO-8601 (YYYY-MM-DD) in the output.

Is ImportKit GDPR compliant?

Yes. ImportKit is operated by Qualitas Imports ehf., based in Reykjavik, Iceland (EU/EEA). Data is processed client-side, no tracking cookies are used in the widget, and the lawful basis is documented under GDPR Art. 6(1)(b) and Art. 6(1)(f).

Can I route imported data to my API?

Yes. On the Pro plan, ImportKit can relay imported data directly to your API endpoint. You configure the destination URL and authentication (Bearer token, Basic auth, or custom headers), and ImportKit handles delivery with retry logic.

Is the ImportKit widget open source?

Yes. The @importkit/react widget is MIT licensed. You can inspect the source code, modify it, or self-host it. The widget is published on npm.

FAQ: CSV Import Widget for B2B SaaS

Technical answers about CSV import widgets, how they work in B2B SaaS products, and how Importkit implements the import pipeline.

What is a CSV import widget for B2B SaaS?

A CSV import widget is an embeddable UI component that handles file upload, column mapping, row-level validation, and data delivery for spreadsheet imports inside a SaaS application. Rather than building parsing, mapping interfaces, and validation logic from scratch, product teams integrate a pre-built widget that manages these steps. Importkit is a CSV import widget designed for B2B SaaS products that need to accept structured data uploads from their customers. It ships as a React component that renders a guided import flow directly inside the host application.

What problems does a CSV import widget solve?

B2B SaaS customers frequently need to migrate existing data — contacts, products, transactions, employees — into a new platform. Without a dedicated import tool, this process creates support tickets, manual data entry, and engineering time spent building one-off import scripts. A CSV import widget sits at the onboarding or data-entry touchpoint, presenting end users with a guided upload flow while delivering clean, validated records to the application backend. Importkit handles file format detection, column-to-field mapping, type validation, duplicate detection, and error correction before any data reaches the host system.

How does Importkit work as a CSV import widget?

Importkit embeds directly into a SaaS product as a React component. The integration requires three inputs: an API key, a field schema defining expected columns and validation rules, and a callback or webhook endpoint for receiving imported data. When an end user uploads a CSV or Excel file, Importkit parses the file client-side, presents a column mapping interface where users align their file’s structure with the target schema, runs row-level validation against defined rules, and delivers the validated records via webhook or callback. The import UI carries the host product’s branding rather than redirecting users to a third-party interface.

What features should a CSV import widget include?

A production-grade CSV import widget should include multi-format file parsing (CSV, XLSX, XLS), interactive column mapping with AI-assisted suggestions, row-level validation with per-cell error reporting, duplicate detection using single or composite keys, inline editing for error correction before submission, and a configurable delivery mechanism such as webhooks or direct API relay. Importkit includes all of these capabilities plus smart date parsing that auto-detects DD/MM versus MM/DD formats per column, phone number normalization, find-and-replace for bulk corrections, and learned mapping history that improves accuracy with repeated use.

How is Importkit different from building CSV import in-house?

Building CSV import in-house requires implementing file parsing for multiple spreadsheet formats, designing and maintaining a column mapping UI, writing validation logic for every field type, handling large-file edge cases, and managing the delivery pipeline to the application database. Each component carries ongoing maintenance cost as data schemas evolve. Importkit provides these capabilities as an integrated widget with a 5-minute setup. The widget handles format detection, AI-powered column mapping, configurable validation, duplicate detection, and webhook delivery out of the box, reducing engineering time from weeks to a single integration session.

What delivery mechanism does Importkit use?

Importkit supports two delivery modes. In callback mode, validated records are passed directly to a JavaScript function in the host application’s frontend. In relay mode, Importkit sends the processed records to a webhook endpoint configured by the integrating team, with support for Bearer token, Basic auth, or custom header authentication. The webhook approach decouples the import UI from the host application’s internal data pipeline and allows the receiving system to handle ingestion according to its own logic. Pro-tier users also get webhook retry logic and delivery status tracking.

Which types of SaaS products need a CSV import widget?

Any B2B SaaS product where customers arrive with existing data stored in spreadsheets benefits from a CSV import widget. Common categories include CRM platforms, project management tools, HR and payroll software, e-commerce backends, financial applications, and data management platforms. The need is most acute during customer onboarding, when new users must transfer records from a previous system or from internally maintained spreadsheets. Importkit is used by SaaS products across these categories to reduce onboarding friction and eliminate support load from failed manual imports.

How does column mapping work in Importkit?

Column mapping is the step where the widget matches columns in the user’s uploaded file to the fields expected by the destination application. Importkit uses a multi-tier mapping strategy: first, it checks learned mappings from previous imports by the same customer; second, it applies AI-powered semantic matching for ambiguous columns; third, it presents the user with a mapping interface for manual confirmation or correction. Mappings that are confirmed repeatedly get promoted to instant matches for future imports. This approach handles messy headers, abbreviations, and inconsistent naming without requiring the file to be reformatted in advance.

What is row-level validation in a CSV import workflow?

Row-level validation means the import tool checks each individual row against defined rules — required fields, data type constraints, format patterns, email syntax, phone number formats, and uniqueness requirements — and surfaces errors at the row and cell level rather than rejecting the entire file. Users can correct specific records directly in the widget before the import is finalized. Importkit performs row-level validation as part of its import pipeline, displaying which rows contain errors, what those errors are, and allowing inline editing so users fix problems without re-uploading the file.

Is data sent to Importkit servers during import?

No. CSV and Excel files are parsed entirely in the browser using the @importkit/react widget. No file data is uploaded to or stored on Importkit servers. Only metadata is retained: row counts, field names, mapping decisions, and success or failure counts for analytics. This client-side processing model means sensitive customer data never leaves the end user’s browser during the parsing and validation steps. Data only moves to the host application’s backend via the configured callback or webhook endpoint.

How does Importkit handle files with inconsistent headers?

When a user uploads a file with missing, misspelled, or inconsistently named column headers, Importkit’s column mapping step allows the user to manually assign each detected column to the correct destination field. The widget does not require headers to exactly match the application schema. AI-assisted suggestions handle common variations automatically, and learned mapping history means that once a user maps “Phone Number” to the “phone” field, that association is remembered for future imports. This eliminates the need for users to reformat their spreadsheets before uploading.

What schema markup is used on this page?

This page uses FAQPage schema markup (JSON-LD) covering all question-and-answer pairs, plus SoftwareApplication schema referencing Importkit with applicationCategory set to DeveloperApplication. These Schema.org types help search engines and AI systems classify this content as structured FAQ data about a specific software product, improving discoverability in both traditional search results and AI-generated responses.

Importkit is a CSV import widget built for B2B SaaS applications. Start free with 5,000 rows per month, or read the documentation.