Impler

Customer spreadsheets arrive in every shape imaginable, and the usual answer is a hand rolled upload page with parsing, validation and error reporting behind it. Impler replaces that work with an embeddable import widget, so onboarding somebody else's data stops being a project of its own.

Columns are defined in a web portal against a project and a template, and the widget then opens either from the portal or from inside your own application. The React package comes from npm, an embed script goes in before the closing body tag, and a hook returns a function that shows the widget for a given template, project and access token.

The flow covers the parts that are tedious to build twice.

• Guided widget: a responsive step by step interface walks the user through the upload.
• Validation: static and dynamic rules check incoming data, with matching validations written into a generated Excel template.
• Cleaning: invalid rows are corrected during the import instead of rejected wholesale.
• Webhooks: imported data is delivered to your application once it passes.
• Schema control: columns can be fixed defaults or supplied dynamically per import.
• Event hooks: your code reacts to widget status and reformats the data it receives.

Impler is MIT licensed, with a hosted portal, a Gitpod workspace for contributors and documentation for running it locally. It suits a product whose customers show up with existing data and expect to bring it along on day one.