Enterprise

Dropbase can help turn your messy spreadsheet into queryable SQL database

Comment

Bluish tinted server room with data charts overlaying it.
Image Credits: Yuichiro Chino / Getty Images

It’s not unusual for a tech company to be born by accident. Famously, Slack was created as a byproduct of a now defunct gaming company. Similarly, when Dropbase founders Jimmy Chan and Ayazhan Zhakhan were in the Y Combinator Winter 20 batch, they were testing the product they had built at the time and accidentally stumbled upon the thing that would become Dropbase.

The two founders were struggling to move spreadsheet data into a SQL database where they could work with it. Even though they were technical people, they couldn’t get everything working without a lot of tinkering. They created a tool to make it easy to drag and drop a .csv file onto a Postgres database and start querying it.

Chan says it was kind of a eureka moment for them, as they realized that if they were having trouble doing this, a lot of other people would be too, and they shifted gears to create Dropbase.

“We were thinking that there should be an easier way to just do it. I just want to drag and drop a .csv file into a SQL database directly. And that’s when we came up with the name Dropbase, because you can drag it into a Postgres database, and we just give you credentials for the database and so you would just instantly have access to that .csv file in your hosted cloud database. So that’s how we started with this,” Chan told TechCrunch.

They had to overcome some big obstacles that anyone who works with data would be familiar with, such as reconciling differences in the same data that can confuse a conversion filter. “After you drag and drop a .csv file, there’s usually still a lot of issues with the file. Sometimes different parts of the world encode .csv files differently. For instance, in France, they use semicolons instead of commas. And so firstly, we do inference. We look at a sample of the data and we try to guess what’s the best way to open the file,” he said.

He said another issue is that the data isn’t always in the format you expect it to be in the table, so how do you get it consistent? They came up with the notion of checks to make sure that the data is in the right format to get past the conversion filters, but Chan says these go beyond simple syntactic checks.

Dropbase database table with checks showing email address in incorrect format.
Image Credits: Dropbase

“They’re actually semantic checks. So what I mean by that is that we’re not just checking whether your postal code is of a certain format, but we can check whether your dates are within a given range, or they’re after a certain time or before a certain time, or if your numbers should be a minimum of something. So it’s a little bit more [sophisticated] checking,” he explained.

He says that once they show the user the issues, they can clean up any remaining problems, and then load the database and it’s available for querying in SQL. “The advantages of having data in a SQL database is that you can quickly query it. That’s the first thing. The second thing is that you can connect it to a downstream tool like a BI tool or another data tool in a more easy way. And you can build more historical datasets over time,” he said.

More recent features in the product include a new tool called Dropmail, which enables users to email a .csv file to turn it into a SQL database, and the ability to host your own data with Snowflake integration.

The company has raised a $1.75 million pre-seed round so far led by Google’s Gradient Ventures, with participation from YC and others.

DigitalOcean launches its managed database service

More TechCrunch

Welcome back to TechCrunch’s Week in Review. This week had two major events from OpenAI and Google. OpenAI’s spring update event saw the reveal of its new model, GPT-4o, which…

OpenAI and Google lay out their competing AI visions

Expedia says Rathi Murthy and Sreenivas Rachamadugu, respectively its CTO and senior vice president of core services product & engineering, are no longer employed at the travel booking company. In…

Expedia says two execs dismissed after ‘violation of company policy’

When Jeffrey Wang posted to X asking if anyone wanted to go in on an order of fancy-but-affordable office nap pods, he didn’t expect the post to go viral.

With AI startups booming, nap pods and Silicon Valley hustle culture are back

OpenAI’s Superalignment team, responsible for developing ways to govern and steer “superintelligent” AI systems, was promised 20% of the company’s compute resources, according to a person from that team. But…

OpenAI created a team to control ‘superintelligent’ AI — then let it wither, source says

A new crop of early-stage startups — along with some recent VC investments — illustrates a niche emerging in the autonomous vehicle technology sector. Unlike the companies bringing robotaxis to…

VCs and the military are fueling self-driving startups that don’t need roads

When the founders of Sagetap, Sahil Khanna and Kevin Hughes, started working at early-stage enterprise software startups, they were surprised to find that the companies they worked at were trying…

Deal Dive: Sagetap looks to bring enterprise software sales into the 21st century

Keeping up with an industry as fast-moving as AI is a tall order. So until an AI can do it for you, here’s a handy roundup of recent stories in the world…

This Week in AI: OpenAI moves away from safety

After Apple loosened its App Store guidelines to permit game emulators, the retro game emulator Delta — an app 10 years in the making — hit the top of the…

Adobe comes after indie game emulator Delta for copying its logo

Meta is once again taking on its competitors by developing a feature that borrows concepts from others — in this case, BeReal and Snapchat. The company is developing a feature…

Meta’s latest experiment borrows from BeReal’s and Snapchat’s core ideas

Welcome to Startups Weekly! We’ve been drowning in AI news this week, with Google’s I/O setting the pace. And Elon Musk rages against the machine.

Startups Weekly: It’s the dawning of the age of AI — plus,  Musk is raging against the machine

IndieBio’s Bay Area incubator is about to debut its 15th cohort of biotech startups. We took special note of a few, which were making some major, bordering on ludicrous, claims…

IndieBio’s SF incubator lineup is making some wild biotech promises

YouTube TV has announced that its multiview feature for watching four streams at once is now available on Android phones and tablets. The Android launch comes two months after YouTube…

YouTube TV’s ‘multiview’ feature is now available on Android phones and tablets

Featured Article

Two Santa Cruz students uncover security bug that could let millions do their laundry for free

CSC ServiceWorks provides laundry machines to thousands of residential homes and universities, but the company ignored requests to fix a security bug.

2 days ago
Two Santa Cruz students uncover security bug that could let millions do their laundry for free

TechCrunch Disrupt 2024 is just around the corner, and the buzz is palpable. But what if we told you there’s a chance for you to not just attend, but also…

Harness the TechCrunch Effect: Host a Side Event at Disrupt 2024

Decks are all about telling a compelling story and Goodcarbon does a good job on that front. But there’s important information missing too.

Pitch Deck Teardown: Goodcarbon’s $5.5M seed deck

Slack is making it difficult for its customers if they want the company to stop using its data for model training.

Slack under attack over sneaky AI training policy

A Texas-based company that provides health insurance and benefit plans disclosed a data breach affecting almost 2.5 million people, some of whom had their Social Security number stolen. WebTPA said…

Healthcare company WebTPA discloses breach affecting 2.5 million people

Featured Article

Microsoft dodges UK antitrust scrutiny over its Mistral AI stake

Microsoft won’t be facing antitrust scrutiny in the U.K. over its recent investment into French AI startup Mistral AI.

2 days ago
Microsoft dodges UK antitrust scrutiny over its Mistral AI stake

Ember has partnered with HSBC in the U.K. so that the bank’s business customers can access Ember’s services from their online accounts.

Embedded finance is still trendy as accounting automation startup Ember partners with HSBC UK

Kudos uses AI to figure out consumer spending habits so it can then provide more personalized financial advice, like maximizing rewards and utilizing credit effectively.

Kudos lands $10M for an AI smart wallet that picks the best credit card for purchases

The EU’s warning comes after Microsoft failed to respond to a legally binding request for information that focused on its generative AI tools.

EU warns Microsoft it could be fined billions over missing GenAI risk info

The prospects for troubled banking-as-a-service startup Synapse have gone from bad to worse this week after a United States Trustee filed an emergency motion on Wednesday.  The trustee is asking…

A US Trustee wants troubled fintech Synapse to be liquidated via Chapter 7 bankruptcy, cites ‘gross mismanagement’

U.K.-based Seraphim Space is spinning up its 13th accelerator program, with nine participating companies working on a range of tech from propulsion to in-space manufacturing and space situational awareness. The…

Seraphim’s latest space accelerator welcomes nine companies

OpenAI has reached a deal with Reddit to use the social news site’s data for training AI models. In a blog post on OpenAI’s press relations site, the company said…

OpenAI inks deal to train AI on Reddit data

X users will now be able to discover posts from new Communities that are trending directly from an Explore tab within the section.

X pushes more users to Communities

For Mark Zuckerberg’s 40th birthday, his wife got him a photoshoot. Zuckerberg gives the camera a sly smile as he sits amid a carefully crafted re-creation of his childhood bedroom.…

Mark Zuckerberg’s makeover: Midlife crisis or carefully crafted rebrand?

Strava announced a slew of features, including AI to weed out leaderboard cheats, a new ‘family’ subscription plan, dark mode and more.

Strava taps AI to weed out leaderboard cheats, unveils ‘family’ plan, dark mode and more

We all fall down sometimes. Astronauts are no exception. You need to be in peak physical condition for space travel, but bulky space suits and lower gravity levels can be…

Astronauts fall over. Robotic limbs can help them back up.

Microsoft will launch its custom Cobalt 100 chips to customers as a public preview at its Build conference next week, TechCrunch has learned. In an analyst briefing ahead of Build,…

Microsoft’s custom Cobalt chips will come to Azure next week

What a wild week for transportation news! It was a smorgasbord of news that seemed to touch every sector and theme in transportation.

Tesla keeps cutting jobs and the feds probe Waymo