Can I scan in this table of numbers and get excel to open it in a table?

FrankFalcon

Hi all

i enjoy playing with statistics etc, and also enjoy a bet on the races. As you can see in the image, this is a table of stats, which I think is self explanatory. So, you can see that the column where I’ve written the letter ‘A’ in Red shows the percentage of wins from runs. For some reason, this newspaper doesn’t give you the percentage figures for columns B, C & D. I would like to do that! Yes, I know I can easily just type all the figures into excel myself and create the formula myself, but I don’t want to type all those numbers in for 5 race cards. So, I guess my question is…
is there an app, a way, a method of scanning that newspaper table and getting it to open up in an excel spreadsheet? 

Thanks all. 

HappyHarry

Try ChatGPT or similar.

FrankFalcon

Thanks mate, but…

It seems like I can’t do more advanced data analysis right now. Please try again later.

Newcad

Excel can do it:

https://www.youtube.com/watch?v=PZuYOmIfOQc

(It seems that Softmaker Office paid version can also do it).

Otherwise you could scan it, use an OCR app to change it to text, copy/paste the text into the spreadsheet.

Heedtheadvice

As above ^

Note you need to have webview2 runtime for Microsoft Edge installed ( https://developer.microsoft.com/en-us/Microsoft-edge/webview2/?form=MA13LH ) and once imported to a spreadsheet would will need to check for errors ( possibly hand amending) and do some reformatting so that you can then do some percentage calculations. you may have to have a current/recent version of Excel ( and enable the correct ribbon button icons for importing a picture into data option or maybe it is already available in the 365/online version.

Also see https://answers.microsoft.com/en-us/msoffice/forum/all/missing-insert-data-from-picture/a2031bac-ba48-46a3-9d1c-158970f680b2.

For reformatting it could be easier and more automated to save the imported data as a csv file and then to reimport that csv into a spreadsheet setting up unusual delimiters such as "-" as well as comma to hp cope with the 40-80 type of data though you can use internal formulas but they may be a bit more messy.

I thing Google sheets can also do this type of import.

Vitor

For the best chance flatten the paper and take the image square on in good light.

GDB2222

I don't understand what you asked ChatGPT to do, and why that failed. It did a lovely job of extracting the data from the table, and then it offered to export that in a variety of formats, including Excel.

"Would you like the full dataset exported in one of the following formats?

• CSV

• Excel (.xlsx)

• JSON

• Markdown

• SQL table insert statements

Let me know your preferred format and whether you’d like all rows included."