Features
Importer features
CSV, XLSX, TSV, and pipe files
Detect format by filename and parse in the browser. Auto-detect comma, semicolon, tab, or pipe. Multi-sheet Excel workbooks include a sheet picker.
DetailsDownload template.csv
On the upload step, once local or hosted fields are known, customers can download template.csv generated in the browser. Headers use field labels, falling back to keys. One example row is derived from field type. Bootstrapware does not store the file.
DetailsColumn mapping
Auto-map headers with aliases, strongest match first. Users remapping a header clear it from other fields. Preview stays blocked until required fields are mapped.
DetailsTyped validation
string, number, date, email, enum, boolean, url, required, and field-level unique. Currency, EU decimals, percentages as fractions (50% → 0.5), mailto emails, and MDY/DMY date order.
DetailsLocales that match the file
numberLocale us/eu/auto (semicolon CSVs prefer EU). dateOrder MDY or DMY. dir ltr or rtl for the widget chrome.
DetailsPreview
Counts reflect the full file. The preview table shows the first 100 rows so problems are visible before submit.
DetailsDuplicate detection
Configure duplicateKey and/or unique fields for in-file repeats (case-insensitive). Database uniqueness stays on your backend.
DetailsFailed-row export
Download import-errors.csv with field columns plus an Errors column so customers can fix and re-upload.
DetailsLocal or hosted schema
Pass fields in code for development, or publish a revision and load it with importerId plus a publishable key.
DetailsConfiguration revisions
Edit a draft without changing what live clients load until you publish a revision.
DetailsTest and live environments
bsw_test_* and bsw_live_* keys. Live hosted configuration requires a paid Importer entitlement.
DetailsOperational sessions
Hosted mode can report session metadata such as counts and file type. Never file bytes or row payloads.
DetailsWebhooks
import.completed deliveries with HMAC signing. Metadata only. No spreadsheet contents in the payload.
DetailsBrowser-side processing
Parsing, mapping, validation, and normalization run on the customer's device. onComplete is your data path.
Details