Extract from PDF to Excel with Copilot 😲 (So EASY)

Use Copilot in Microsoft Edge to extract from PDF to Excel easily.

In this video, we want to extract specific data from a PDF to Excel. By using Copilot in Edge and specifying the data we need. The data was ready to copy to Excel.

⌚ Timestamps
00:00 - Introduction
00:31 - Use Copilot with Microsoft Edge
01:53 - Use Copilot to extract from PDF
03:25 - Paste from Copilot to Excel

👩🏻‍🤝‍👨🏿Connect with us!

#excel #copilot #ai

[Computergaga]

Don't get left behind. Learn how to use these tools with Excel.

[sandiptemkar]

OMG: Thank yo so much, I was struggling since few months, but your method solve the problem in few seconds, truly amazing!

[IvanCortinas_ES]

Thank you for this video Alan. A powerful tool, without doubt.

[PHWiest]

"Now, anything seems somewhat optimistic." That's the quotation of the day, Alan!😀

[harkiratbedi]

I wasnt able to get success with this. can you help me with a prompt that can get me data on an excel when there are records on each page, just like date, course, venue company etc on multiple pages, to be brought into excel rows.

[AccessAnalytic]

Oddly when I try the Ask Co-Pilot button ( or the top right) it does not recognise the pdf exists in the side panel

[katieg.]

Thanks for the video! Is there a way to extract information from a scanned pdf?

[cd]

Great work! Any direction to point me do the same for multiple PDF files?

[mustavogaia]

If possible, test it with a larger document and asking to copy or summarizing an especifi paga or paragraph. Thanks.

[elhakimy]

Helo, i just try that for 31 pages. But the copilot just give me the data for page 1-9. Any solution?

[barttitulaerexcelbart]

Well done Alan, together with copilot ! The next step would be that co pilot delivers 2 tables (norrmalized...)....😉

[fazwanzainuddin]

hi there,
i still unable to extract the date can you help me?

[sparrowsdream]

Alan, nice. I love AI, but sometimes it simply fails. ChatGPT could not do this, so I gave Copilot a whirl. It very politely told me...

I apologize if my previous responses caused any inconvenience. Unfortunately, I cannot directly extract data from a PDF and create a table for export to Excel. Feel free to ask if you have any other requests or need assistance with a different task. Thank you! 🙏

Here's my prompt. Perhaps it was not clear enough?

Extract the data from this paystub PDF file and convert into a table the CURRENT > AMOUNT column for each Pay Date (top right of the paystub titled Pay Date:) and for each of the ROWS:
Earnings
Regular
Overtime Hours
Sick Hours
Holiday Hours
Health Welfare
Regular Retro
Pre-Tax Deductions
403B %
Taxes
Fed W/H
FICA EE
Fed MWT EE
CA W/H
CA DT EE
Post-Tax Deductions
Roth
Net Pay

[ianl]

Can't wait to give this a try with my downloaded bank statements. I tried doing it through Power Query and failed miserably. I ended up with debits in the credits column and vice versa. What a mess!

[rcsshah]

am i missing somthing - copilot asks me to upload file