HI! Looking for a no-code SaaS solution with really good UI for a non-technical person to upload a file and extract structured data. The files are likely to be in TXT, CSV, or Excel format. Files will yield multiple rows of data, so the UI should make it relatively easy to identify the pattern/structure of fields, and then allow the user execute parsing, compare the resulting structured data against what the user sees, and iterate until it's solid.<p>I swear in the last month or so that such a product appeared on HN, but I've spent an hour combing thru browser history and searching HN, with no luck. I think I saw it on my phone using one of the popular HN apps that uses an embedded web browser, so there is no "history" feature.
PowerQuery in Excel is basically free and extremely powerful. Give it a shot.<p><a href="https://support.microsoft.com/en-us/office/import-data-from-data-sources-power-query-be4330b3-5356-486c-a168-b68e9e616f5a" rel="nofollow">https://support.microsoft.com/en-us/office/import-data-from-...</a>
You might have seen my post for <a href="https://hub.liquidaty.com/playground/" rel="nofollow">https://hub.liquidaty.com/playground/</a> (make sure to include the trailing slash), which I posted a couple months ago with temporary public access (I am one of its founders). I'm not very good at the art of hackernews posts so not surprised if it got lost.<p>Anyway, from that site, you can:<p>- upload CSV, TXT, XLSX in local browser
- run SQL queries on one or more files
- run validation reports (like, <i>real</i> validation reports, with drill-down, breakouts, etc, not the BS ones that most products tout but are just an SQL query with a where clause)
- convert data to JSON, sqlite3, etc
- create and share your own domains that allow collaboration and reuse of common business processes, and also enable trainable smart mapping to whatever dictionary you define (e.g. map "Name, First" to "First Name"), automated rescaling (e.g. detect if percentages are x100 and automatically divide by 100 if so), automated derivations (e.g. A + B = C, my validation tests C. System figures out how to get C, regardless of whether data contains C, or only contains A and B). Automatically convert your data into schema Y. Etc.<p>It is now in private beta but from the website, you'll see a link to request access (by emailing support@liquidaty.com) and we'll give you a free beta account (you must have a legit linked-in account for federated login). Or feel free to send regular questions to that email address