Data Import Wizard PROCustomers and suppliers arrive with their own spreadsheets. Help them map the columns, fix the mistakes and hand your application records it can work with.
For web apps and OutSystems
| Product | Price | Stock |
|---|---|---|
| Ecuador · whole bean | 18.50 | 120 |
| House blend · whole bean | 16.00 | check Enter a whole number |
| Decaf · whole bean | 17.50 | 80 |
A supplier sends a coffee catalogue with “Unit price” and “In stock” columns. Your app expects Price and Stock—and one stock cell says “check”. The operations team needs to fix the data without starting over.
Choose the CSV and map its headings to the fields in your catalogue. Required fields and sample values give the coordinator enough context to choose the right column.
The review step flags the stock cell. Correct it to a whole number in place, then review the remaining rows without rebuilding the file.
A whole number is required.
Ready for your import.
Send the corrected rows to your service. Run business checks and store the records there. Return success—or row-level errors the coordinator can act on.
Download the sample CSV, choose it below, map the columns and correct the stock value marked “check”. Then finish the sample import.
Loading the example… Open the component playground.
Demo data stays in memory on this page. Reloading the browser resets it. No database writes or shared collaboration.
A new customer exports equipment from a spreadsheet. Map serial numbers and locations, catch duplicate keys within the file, then send valid rows to your service.
An administrator maps names, departments and session dates from a CSV. Required fields and date checks catch incomplete records before application validation.
A coordinator maps supplier codes and decimal prices, corrects malformed amounts, then submits the rows. Your service checks product matches and permission to update.
Define the destination fields, then handle ImportRequested with your own server-side validation and storage. Return the matching request ID, success or failure, and optional row errors. This component imports CSV; your app owns the database transaction.
View accessibility status