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
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!
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.
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.
Not with the Copilot in Bing. Power Query in Excel can certainly handle that though. Check out this video (ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-9ljqozOVEWY.html), importing data from multiple Excel files, and do that for PDF. Obviously, the specific transformations will be different.
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.
