Learn how Ramp switched from a homegrown CSV import solution to OneSchema and increased the strategic value of their platform.
Ramp is a financial operations platform designed to save businesses time and money by simplifying how companies manage expenses, travel, bill payments, vendor relationships, accounting, and more. These different products are connected together with data. The more that Ramp understands how their customers are spending time and money across their operations, the better Ramp can help them control their spend and automate tedious tasks.
Ingesting that data can sometimes be tricky. Previously, Ramp had a homegrown CSV parser, built as a way for customers to perform bulk uploads of users. The parser only took CSVs, required a very specific template, and returned a generic “something is wrong” error message when it couldn’t correctly parse the input. Customers often were stuck making tweaks, uploading, and hoping that it worked. On top of that, the homegrown parser lacked data validations, which meant that it was possible for files with incorrect values to be successfully uploaded. This would create inconsistencies in the system that needed to be manually reconciled, such as employee card spend being attributed to the wrong organization. That pain was exacerbated if the customer had bulk uploaded hundreds of different employees and now needed to individually fix each one.
With no good way to iterate and resolve errors, this would often lead to extended back-and-forth cycles with Ramp’s support team to resolve CSV import issues.
{{quote-1}}
Ramp’s team ultimately decided their homegrown importer didn’t fall in line with their ethos: delivering their customers a great experience that automates as much work for them as possible and saves them time. An ideal solution would minimize the amount of work that their customers needed to do, as well as eliminate potential downstream errors from using an importer without proper validations.
When Ramp evaluated different vendors, their first priority was around user experience. Being that Ramp has an extremely high bar for their front end user experience, they wanted a product that could fit in seamlessly with the platform.
They found that in OneSchema. Not only did OneSchema’s CSV importer save weeks of in-house engineering work on functionality like bulk-editing errors inside the browser and in-line validations, it also simply felt like something that could live inside of a Ramp product.
{{quote-2}}
With OneSchema, Ramp built a CSV import experience that guided users when manual intervention was needed, helped them easily fix errors in a single click, had a native theme and feel, and seamlessly embedded inside the Ramp platform itself.
For Ramp, partnering with OneSchema has become about more than just providing a good user experience – it’s about delivering a competitive product that can win over customers who were migrating from legacy providers.
{{quote-3}}
One such example is their Bill Pay vertical, which automates their customers’ accounts payable workflows. To increase adoption, Ramp needed to make migrations from legacy workflows easy. OneSchema’s robust and simple to use importer helped unblock that migration path, especially for customers who had a high number of bills that they needed to bring over from previous systems.
On a more strategic level, Ramp’s value proposition of saving time and money for their customers becomes stronger as they reduce the friction of customers uploading data onto the Ramp platform. And a seamless CSV import is one of the biggest unlocks for that data transfer.
{{quote-4}}
On a more tactical level, Ramp can now point at OneSchema whenever their teams need a solution for CSV imports. Not only is there both internal and external documentation, any questions that come up are answered through dedicated support that was described as, “That level of support, super appreciated. Especially coming from a co-founder, it’s just nice to see that level of engagement. It lines up with how Ramp likes to act, too.” The Ramp team can now implement an importer in less time, with more functionality, and that maintains Ramp’s high user experience bar.
Today, Ramp uses OneSchema’s CSV importer across three different teams and products, and is actively evaluating OneSchema for additional products.
{{blog-content-cta}}
Ramp is a financial operations platform designed to save businesses time and money by simplifying how companies manage expenses, travel, bill payments, vendor relationships, accounting, and more. These different products are connected together with data. The more that Ramp understands how their customers are spending time and money across their operations, the better Ramp can help them control their spend and automate tedious tasks.
Ingesting that data can sometimes be tricky. Previously, Ramp had a homegrown CSV parser, built as a way for customers to perform bulk uploads of users. The parser only took CSVs, required a very specific template, and returned a generic “something is wrong” error message when it couldn’t correctly parse the input. Customers often were stuck making tweaks, uploading, and hoping that it worked. On top of that, the homegrown parser lacked data validations, which meant that it was possible for files with incorrect values to be successfully uploaded. This would create inconsistencies in the system that needed to be manually reconciled, such as employee card spend being attributed to the wrong organization. That pain was exacerbated if the customer had bulk uploaded hundreds of different employees and now needed to individually fix each one.
With no good way to iterate and resolve errors, this would often lead to extended back-and-forth cycles with Ramp’s support team to resolve CSV import issues.
{{quote-1}}
Ramp’s team ultimately decided their homegrown importer didn’t fall in line with their ethos: delivering their customers a great experience that automates as much work for them as possible and saves them time. An ideal solution would minimize the amount of work that their customers needed to do, as well as eliminate potential downstream errors from using an importer without proper validations.
When Ramp evaluated different vendors, their first priority was around user experience. Being that Ramp has an extremely high bar for their front end user experience, they wanted a product that could fit in seamlessly with the platform.
They found that in OneSchema. Not only did OneSchema’s CSV importer save weeks of in-house engineering work on functionality like bulk-editing errors inside the browser and in-line validations, it also simply felt like something that could live inside of a Ramp product.
{{quote-2}}
With OneSchema, Ramp built a CSV import experience that guided users when manual intervention was needed, helped them easily fix errors in a single click, had a native theme and feel, and seamlessly embedded inside the Ramp platform itself.
For Ramp, partnering with OneSchema has become about more than just providing a good user experience – it’s about delivering a competitive product that can win over customers who were migrating from legacy providers.
{{quote-3}}
One such example is their Bill Pay vertical, which automates their customers’ accounts payable workflows. To increase adoption, Ramp needed to make migrations from legacy workflows easy. OneSchema’s robust and simple to use importer helped unblock that migration path, especially for customers who had a high number of bills that they needed to bring over from previous systems.
On a more strategic level, Ramp’s value proposition of saving time and money for their customers becomes stronger as they reduce the friction of customers uploading data onto the Ramp platform. And a seamless CSV import is one of the biggest unlocks for that data transfer.
{{quote-4}}
On a more tactical level, Ramp can now point at OneSchema whenever their teams need a solution for CSV imports. Not only is there both internal and external documentation, any questions that come up are answered through dedicated support that was described as, “That level of support, super appreciated. Especially coming from a co-founder, it’s just nice to see that level of engagement. It lines up with how Ramp likes to act, too.” The Ramp team can now implement an importer in less time, with more functionality, and that maintains Ramp’s high user experience bar.
Today, Ramp uses OneSchema’s CSV importer across three different teams and products, and is actively evaluating OneSchema for additional products.
{{blog-content-cta}}
