Import customer CSV data 10x faster
Start new thread
Michael Seibel

OneSchema Workspaces - Import customer CSV data 10x faster

by
Cargo
β€’
OneSchema is a super simple spreadsheet UI for detecting and correcting errors in CSV data. You can use it when you repeatedly need to upload data to a system with a known schema (like setting up new customers in a SaaS product, uploading a catalog monthly)

Add a comment

Replies

Best
Ryan Hoover
Can you please apply this to my Google Contacts. I can't be the only one with numerous contact entries for the same person (with different emails). πŸ˜…
Christina Gilbert
Maker
@rrhoover advanced de-dupe is our specialty - we deal with a lot of CRM data. huge problem across lots of industries!
Marcus Hoang

@rrhooverΒ  Ha, the Google Contacts duplicate problem is so universal. I literally have 4 versions of the same person because they changed email addresses over the years. The messy data problem isn't just a B2B thing, it's everywhere. Makes you wonder why there isn't a better consumer-facing solution for personal data cleanup.

Max Greenwald
Been a happy OneSchema customer at @warmlycomma - we save HOURS each week avoiding manual data adjustment from gross CSVs coming from customers. Congrats on launch!
Andrew Luo
Maker
@warmlycomma @max_greenwald So happy to have you as an early customer. Thanks for all the awesome feedback!
Dennis Xu
Congrats on the launch, can't wait to use this!
Christina Gilbert
Maker
@dennishxu Thanks Dennis, we'll set you up soon!
Mark Brandon
Hey, very much needed problem. Can you comment on the pricing and the tiers? I hate getting attached to products only to discover that we can not get budget for something. Generally, I've learned that when pricing isn't public, it's usually eye-wateringly expensive.
Marcus Hoang

@mark_brandon1Β  This is one of the biggest pain points in the dev tools space right now. You evaluate, integrate, get your team onboarded... and then the pricing conversation kills it. I've seen teams rip out tools they loved because the jump from free tier to paid was absurd. Transparent pricing from day one should really be the default.

Lawrence Lin Murata
Great product and congrats on the launch team!! Ran into this issue a lot in my previous company, since we were working with partners from old school industries
Christina Gilbert
Maker
@lawlm Thanks Lawrence :) it's always surprising to us how common this problem is!
Timothy Luong
This looks slick, wish we had it at my last company. Congrats to the team!
Christina Gilbert
Maker
@timothy_luong Would love to chat offline about your team's workflows!
Jovian Chen
This looks amazing! Having done many data imports in the past as a CSM (late nights, painful hours), I love how this speeds up the validation process and is less prone to human error. Much faster than CTRL+FIND+Replace in Excel ;) Can't wait to try it out :)
Michael Zhao
Maker
@jovian_chen Thanks so much for the support! Let's tackle this problem together so that no one else has to suffer like you did ever again :D
Michelle Lu
Impressive product and team. Congrats on the launch!
Andrew Luo
Maker
@michlu2 Thanks so much!!
Alice Hau
I know a lot of people who who need and will love this product.. excited to see someone's built it!
Christina Gilbert
Maker
@alice_hau Thanks Alice - lots of new features coming too 😎
Yoav Taieb
Hey, I don't understand, how are you able to know that FirstName need a capital letter?or that "market size" should be less than 1k? Do I need to manually write a regex for each column?
Michael Zhao
Maker
@yoav_taieb No manual regex writing necessary! We have a library of validations that you can choose from as well as the ability to incorporate custom validations.
Yoav Taieb
Ok but how do I had custom validation? With regex?
Marcus Hoang

@yoav_taiebΒ  Cross-column validation is where things get really interesting, and honestly where most tools fall short. Simple stuff like "if country is US, zip code must be 5 digits" sounds easy but gets complex fast when you have dozens of rules interacting. Have you found anything that handles this well without requiring you to write raw regex for everything?

Michael Zhao
Maker
@yoav_taieb Our pre-built library is extremely flexible and can handle most cases (including First Name capitalization and cross-column relationships). If you have some data that is hyper specific to your business, you can also add a custom regex validator.
123
β€’β€’β€’
Next
Last