p/oneschema
Import customer CSV data 10x faster
Michael Seibel

OneSchema Workspaces — Import customer CSV data 10x faster

Featured
155
•
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)
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
@rrhoover advanced de-dupe is our specialty - we deal with a lot of CRM data. huge problem across lots of industries!
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
@warmlycomma @max_greenwald So happy to have you as an early customer. Thanks for all the awesome feedback!
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
@lawlm Thanks Lawrence :) it's always surprising to us how common this problem is!
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
@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?
Michael Zhao
@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.
Melissa Du
Congrats team, so excited to see this launch!! CSV cleanup is super annoying and I'm truly glad you guys are fixing it
Michael Zhao
@coffeestacker Thanks for the support! We're working hard to make sure CSV cleanup doesn't cause any more headaches!
Nikhil Buduma
Might be super useful for us in validating spreadsheets produced by our ops workflows — QA can be pretty rough, and we often have to do it while debugging why a script randomly breaks
Andrew Luo
@nkbuduma Thanks Nikhil! We'd love to see how OneSchema could help you out with those workflows :)
Akash Bansal
@christina_gilbert this is a much needed service. Any time there are data migrations, its a pain and each company is building spreadsheet uploaders and translators in house. In my previous startup, we had a person specifically tasked with data migrations.
Theodora Chu
congrats on the launch! csv files are so painful to parse - so exciting that this problem is being solved.
Michael Zhao
@theodorachu Thanks! We are also very excited! We are looking forward to getting to a place where CSV data import is as easy as the click of a single button :D
Rishab Hegde
Looks super cool and will be helpful the next time I need to clean up a spreadsheet! Congrats on the launch :)
Jeremy Tsui
Awesome launch and love the product! Are there there types of financial or transactional data that you all most commonly handle?
Andrew Luo
@jeremytsui Thanks Jeremy! Our product really shines with higher dimensional financial data like exports from NetSuite or metadata around contracts. We work with a lot of B2B marketplaces and procurement platforms!
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.
Karanveer Mohan
Congrats on the launch! Solid product that looks simple to use, but I know is very powerful behind the scenes :)
Michael Zhao
@karanveerm Haha yes! As one of the engineers working on this project many problems have definitely been non-trival. We're continuing to work on being able to support even more complex validations / cross column checks!
David Ongchoco
Awesome product! Can definitely see how this would be useful for all sorts of companies dealing with CSV / excel data! Great job Christina and team!
Andrew Luo
@david_ongchoco1 Thank you so much David!!
Chris Warner
I can see how this could be useful for us. We constantly clean product catalog files for import into our database. Looks super slick and easy to use.
Erik
Congratulations on the launch and what a great UI!! This is going to make onboarding so much easier :D
Christina Gilbert
@enilsen16 Looking forward to getting you guys set up
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
@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
Vicente Zavarce
Wish this existed when we were manually uploading CSVs for every merchant we added to our marketplace. Looks awesome! 🔥
Michael Zhao
@vicentezavarce Oh dear that sounds really painful D: Hopefully no one will suffer as you did after our launch!
Scott Ames-Messinger
Looks interesting! How is this different from flatfile? Also, what does the pricing look like?
Andrew Luo
@scott_ames_messinger Our product handles much higher data complexity than Flatfile out of the box with our data validation and transformation rules. We charge with a row-based pricing model.
Andrew Luo
@scott_ames_messinger If you're interested in more details, we'd love to chat! Reach out at founders@oneschema.co
Vineet Jammalamadaka
Congrats on the launch! Can confirm that data uploads are extremely frustrating 😅 super excited to see an intuitive solution to this problem
Michael Zhao
@vineet1_ Thanks for the words of affirmation! We too have strong conviction in the space :D Here's to making the world of CSV importing faster and easier!
Tanay Padhi
Fantastic idea solving a real problem, and a very strong founding team that will continue to execute as well as anybody else I know
Michael Zhao
@tanaypadhi Thank you so much for the kind words! We are committed and have high conviction in this space! Looking forward to sharing our progress