Training In a Minute - Using AI to Make a Data Table from a Screenshot

This is a scenario you may have experienced before:

There is a table of data that you want to use in an application like Microsoft Excel.

However, that data is "trapped" or formatted in a way that you can't easily grab.

You copy and paste, but the data doesn't look right. You try to convert the page to excel, but the columns are scrambled. You know you can manually fix it, but that's going to take too much time.

What if there was a way to grab the data you needed in just a few seconds?

Turns out, there is a way! And it's pretty darn cool!

How to use a screenshot to make a data table with AI

For our example, we are going to use Microsoft Business friendly AI, Copilot. However, this method will work with most AI tools. (Protect your data: Do not use free/personal AI for work purposes)

In this scenario, I want to make a table from a "Top 10 Movies of All Time" list that I found online:

1. Create a screenshot or copy the image

2. Open Copilot

3. 

   Paste your Screenshot

4. Type in "Turn the data in this screenshot into a data table"

   1. There are many prompts you can use, experiment by being more specific with what you want

5. 

   From there, you can tell Copilot to export the table into Excel (or a CSV if you prefer)

6. 

   End result

   1. 

7. That's it!

Wrap-Up

Pretty cool right? This works with all sorts of data in many different formats and structures. It's something that can save a lot of time and is easy to learn and utilize!

Like with anything AI, always double check the output for accuracy. Make sure you are using a business approved AI tool that is designed to protect your data and privacy.

Don't have a proper AI tool in place for you and your Staff? Here's a company that can help you implement one!

Interested in having a conversation about technology in your business? 

Send in a contact request or email info@aevotec.com.