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.
I'm doing lots of testing with these tools at the moment, and they're only getting better. As long as there is a way of identifying the paragraph, I'm quite confident it will extract it.
@@Computergaga In my line of work (legal) the process is somewhat like that - getting an multiple espefic paragraphs from different pages - sometimes from different documents - and aggregating them on a single document
Sure! That would be a PDF task ideally I think. AI could probably help write the M. But if you connect to a folder containing multiple consistently structured PDFs, Power Query can bring them all in.
If it is a PDF then the same approach would be used but it may struggle to detect data structure on the scanned image. If it is an image format, there is a From Picture option on the Data tab. Again, it is not perfect will depend on the structure of the data in the image (is it tabular, clear spaces between words and borders, clear fonts.
Not with the Copilot in Bing. Power Query in Excel can certainly handle that though. Check out this video (ruclips.net/video/9ljqozOVEWY/видео.html), importing data from multiple Excel files, and do that for PDF. Obviously, the specific transformations will be different.
Nice video but you've taken an easy document. Most files contain records. E.g 1, Date, Item description, Quantity, Cost, 2, Date, Item description, Quantity, Cost, 3, Date, Item description, Quantity, Cost etc ... How would you extract just Item description and Cost from this?
Sure! If we prompt for what we need, and based on the quality of the PDF, we will get our results. This video showed Copilot as I was impressed at the simplicity. ChatGPT will comfortably do this.
Will need to give it a try. I guess it depends on quality and do not see why not. As long as it can detect the parts of the page, so tabular structures are ideal.
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
Yes AI just simply fail sometimes. I have a few examples of scraping data from PDFs and getting Excel files to download that I do in my courses (both in-person and online). It is generally very good. ChatGPT is far superior to Copilot (certainly at the moment). This video came about as I tried it and was surprised it worked myself in Bing.
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!
ChatGPT and AI for Excel bit.ly/3NkJyJ8
Don't get left behind. Learn how to use these tools with Excel.
Oddly when I try the Ask Co-Pilot button ( or the top right) it does not recognise the pdf exists in the side panel
Ah the joys of cutting edge tech. ChatGPT will take care of it 😂😊
Good stuff Alan!
Thanks!
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.
If possible, test it with a larger document and asking to copy or summarizing an especifi paga or paragraph. Thanks.
I'm doing lots of testing with these tools at the moment, and they're only getting better. As long as there is a way of identifying the paragraph, I'm quite confident it will extract it.
@@Computergaga In my line of work (legal) the process is somewhat like that - getting an multiple espefic paragraphs from different pages - sometimes from different documents - and aggregating them on a single document
Thank u Alan for this nice video 📹 👍
You're welcome, Nader 👍
Great work! Any direction to point me do the same for multiple PDF files?
Sure! That would be a PDF task ideally I think. AI could probably help write the M. But if you connect to a folder containing multiple consistently structured PDFs, Power Query can bring them all in.
Thanks for the video! Is there a way to extract information from a scanned pdf?
If it is a PDF then the same approach would be used but it may struggle to detect data structure on the scanned image.
If it is an image format, there is a From Picture option on the Data tab. Again, it is not perfect will depend on the structure of the data in the image (is it tabular, clear spaces between words and borders, clear fonts.
Thank you for this video Alan. A powerful tool, without doubt.
You're very welcome, Ivan. Thank you.
Can we do this with multiple PDFs?
Not with the Copilot in Bing.
Power Query in Excel can certainly handle that though. Check out this video (ruclips.net/video/9ljqozOVEWY/видео.html), importing data from multiple Excel files, and do that for PDF. Obviously, the specific transformations will be different.
Helo, i just try that for 31 pages. But the copilot just give me the data for page 1-9. Any solution?
hi there,
i still unable to extract the date can you help me?
Nice video but you've taken an easy document. Most files contain records. E.g 1, Date, Item description, Quantity, Cost, 2, Date, Item description, Quantity, Cost, 3, Date, Item description, Quantity, Cost etc ... How would you extract just Item description and Cost from this?
Sure! If we prompt for what we need, and based on the quality of the PDF, we will get our results.
This video showed Copilot as I was impressed at the simplicity. ChatGPT will comfortably do this.
OMG: Thank yo so much, I was struggling since few months, but your method solve the problem in few seconds, truly amazing!
That is so awesome to hear. Well done! 👍🏼
Will it work on scanned PDF?
Will need to give it a try. I guess it depends on quality and do not see why not. As long as it can detect the parts of the page, so tabular structures are ideal.
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
Yes AI just simply fail sometimes.
I have a few examples of scraping data from PDFs and getting Excel files to download that I do in my courses (both in-person and online). It is generally very good.
ChatGPT is far superior to Copilot (certainly at the moment). This video came about as I tried it and was surprised it worked myself in Bing.
Agreed! Amazing stuff! The future is bright.
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!
Ah! I hope it works out well. ChatGPT is fantastic at transforming PDF files too. Just so you know in-case Copilot fails.
@@Computergaga
Thanks for the tip.
"Now, anything seems somewhat optimistic." That's the quotation of the day, Alan!😀
Well done Alan, together with copilot ! The next step would be that co pilot delivers 2 tables (norrmalized...)....😉
Thanks, Bart 😊
am i missing somthing - copilot asks me to upload file
Things are evolving so fast, this will be due to updates with Copilot. The video is months old.
@@Computergaga so you are saying that the shown technique does not work anymore - why leave this online then?