Extract all tables separately from PDF into Excel with column names using Power Automate Desktop
(Need Feb 2022 update)
Step 8: %ExtractedPDFTables[TableNumber].datatable.ColumnHeadersRow%
Please help me to help other people just like you by subscribing to my channel and like the video if you think it’s helpful.
You can donate to support my channel here (No refunds):- …(read more)
Convert Word 2 PDF: Word to PDF Converter
Convert PowerPoint 2 PDF: PPT to PDF Converter
Convert Excel 2 PDF: Excel to PDF Converter
Convert an Image 2 PDF: Image to PDF Converter
Convert HTML 2 PDF: HTML to PDF Converter
More Tools: PDF Converter
Please subscribe. We need to get 1000 subscribers :). Thank you!
my pdf file table runs to next pages but without headers. the headers are only present in first page of the table
I have tried your video, it creates additional worksheet for each page even though the table is same. Could you please help
how to create this by using cloud? is it just only for the desktop version?
Very good video, very clear! I have a problem, though. I can't extract the data form the PDF, it does the whole process and give me values like "[image]" instead of numbers and strings. Do you know how to solve it? Thank you very much!
Hi I am getting an error ‘failed writting into the excel..’. I have copied the above flow. Also the document is getting saved into the word file in my folder. Want to extract pdf tables. Every time I run this its giving me this error
Hi, Thanks for the video.. I also have a PDF with maximum of 6 pages. I need to extract the table(not in table format, looks like text with rows and columns) under the specific header.
Sample content – Here the header is Holiday
Holiday : Year:2022
S.No Holidays occurring on weekends Date Day
1 New Year 1-Jan-2022 Saturday
2 Makara Sankranti ( for Karnataka) 15-Jan-2022 Saturday
3 Ugadi/Gudi Padwa 2-Apr-2022 Saturday
4 May day 1-May-2022 Sunday
5 Mother's day 8-May-2022 Sunday
Unwanted text to ignore Unwanted text to ignore
Unwanted text to ignore Unwanted text to ignore
Holiday : Year:2022
S.No Holidays occurring on weekends Date Day
8 Parents day 24-Jul-2022 Sunday
9 Maha Saptami /Gandhi Jayanti 2-Oct-2022 Sunday
10 Valmiki Jayanthi / Milad-un-Nabi (Bday of Prophet Muahhamed) 9-Oct-2022 Sunday
11 Men's day 19-Nov-2022 Saturday
12 Disability Day 3-Dec-2022 Saturday
13 Christmas 25-Dec-2022 Sunday
Unwanted text to ignore Unwanted text to ignore
Unwanted text to ignore Unwanted text to ignore
"Could you please check this".. Thanks in Advance
Congratulations. Amazing video. I have PDF files that contains more than 5.000 Pages of tables. What do you recomend in this case?
Hi , i don't have extract tables from pdf option in power automate. Where did u get it