5 ms·

Ask HN: Looking for a spreadsheet importer wizard with validation

1 points by thedangler 4y ago

Hello, I'm looking for a spreadsheet importer with validation that can be used in house as data being uploaded is sensitive. I looked and found https://www.pulter.co/ which seems to do the trick but we can't let someone else process the data. Looking for a wizard type UI that kinds the user through the import, assign columns to our columns, then validates data before final import. Thanks

crsn 4y ago
What about Dromo? https://www.dromo.io https://www.dromo.io
PaulHoule 4y ago
For a web site?
- thedangler 4y ago
  Yes
thedangler 4y ago
This is for an internal website that admins use but external users upload the spreadsheets. Before external users would upload the documents and it would try and validate and insert into tables and the end users just walked away. If data was bad we are left fixing it. Therefor, having an upload wizard that validates data before inserts would be amazing like how pulter does it.
_kvoh 4y ago
So you say you need an on premise solution as you don't want to trust a SaaS?
- thedangler 4y ago
  yes
  - _kvoh 4y ago
    Please let us know if you find a solution that fulfills the on premise requirement.