Extracting Data From Images

Say goodbye to tedious data entry and hello to efficient workflows.

Extracting Data from Images

Insight from Makerpad

Earlier this week, a member of The Bottleneck team sent me a screenshot of our newsletter analytics before heading out for vacation.

There was a ton of interesting data on what readers like you are enjoying and engaging with.

There was one problem though: all of that juicy data was trapped in a PNG.

I couldn’t analyze it without manually (🤮)  re-entering all of the numbers in a spreadsheet. I was doomed to a soul-crushing 45 minutes of monotonous data entry.

Or so I thought.

I did some digging and found a workflow that saved me all of the hassle, so I thought I’d surface it for you.

The tool I used is Instabase Converse.

Here’s how it works:

  1. Create a free account.

  2. Upload your image.

  3. In the bottom right corner, type in the text box that you want it to “extract the data and format it as a table.”

  4. Click to download the new table as a CSV file.

  5. Open the file in Excel or Google Sheets to do what you do with your data.

Voilà 🎉 Don’t say I never showed you anything useful.

P.S: If you’re uploading images with sensitive information, make sure whatever tool you use doesn’t train their model with your data and keeps your content confidential. We did the homework on this one for you. Instabase Converse app’s Privacy Policy is a good one.   

Reply

or to participate.