Import Data from a PDF to Excel - My Online Training Hub
video description
Date: 2022-04-08
Related videos
Comments and reviews: 10
Megan
hi, great video! question for you MyOnlineTrainingHub -
I have several tables from PDF, they are basically one long table (22 tables in import) but only the first table has headers.
Excel doesnt recognize or understand that columns from each table are the same so it ends up staggering them over.
so if table 1 ends on column 10, then table 2 starts on column 11, table 3 on column 21, and so on.
how do you make excel recognize or understand that you want it to simply stack all the tables on top of each other and recognize headers from first table you pick?
reply
hi, great video! question for you MyOnlineTrainingHub -
I have several tables from PDF, they are basically one long table (22 tables in import) but only the first table has headers.
Excel doesnt recognize or understand that columns from each table are the same so it ends up staggering them over.
so if table 1 ends on column 10, then table 2 starts on column 11, table 3 on column 21, and so on.
how do you make excel recognize or understand that you want it to simply stack all the tables on top of each other and recognize headers from first table you pick?
reply
Phan
Hello, I'm not good with Computer so this is a bit hard to understand for me... Let say I have multiple pdf files ( or I can combine multiple pdf files into 1 big file, separate by each page) which have the same format. Now I want to extract some specific data from said files using the -Get data -> From PDF- function. The problem now is I'm having multiple pages extracted and don't know how to apply the same configuration to each page and then combine them into 1 table...
Can someone help me with this problem? Thank you so much in advance.
reply
Hello, I'm not good with Computer so this is a bit hard to understand for me... Let say I have multiple pdf files ( or I can combine multiple pdf files into 1 big file, separate by each page) which have the same format. Now I want to extract some specific data from said files using the -Get data -> From PDF- function. The problem now is I'm having multiple pages extracted and don't know how to apply the same configuration to each page and then combine them into 1 table...
Can someone help me with this problem? Thank you so much in advance.
reply
Altvel1
Hello. I'm wondering if Power Query can be used to import and process larger lists in pdf? F.ex. General Ledger or similar. Sometimes we get longer lists in that format and it would have been very useful to be able to edit them before they are taken over in excel. I have tried but unfortunately without success.
reply
Hello. I'm wondering if Power Query can be used to import and process larger lists in pdf? F.ex. General Ledger or similar. Sometimes we get longer lists in that format and it would have been very useful to be able to edit them before they are taken over in excel. I have tried but unfortunately without success.
reply
John
I'm a mailer and sometimes get address lists in pdf. I'm going to try this at work. Probably going to take a few tries but if I can get it to work I'll look like a stud. We usually have to have the client send us a xls or csv to get their addresses imported to our addressing machine.
reply
I'm a mailer and sometimes get address lists in pdf. I'm going to try this at work. Probably going to take a few tries but if I can get it to work I'll look like a stud. We usually have to have the client send us a xls or csv to get their addresses imported to our addressing machine.
reply
talredgc
Please, i have a question. After we import the PDF file via Power bi, how can i select all tables at the same time. when i importe a long PDF file, i get a hundreds tables that i cannot select one by one. that may takes a life time. thank you.
reply
Please, i have a question. After we import the PDF file via Power bi, how can i select all tables at the same time. when i importe a long PDF file, i get a hundreds tables that i cannot select one by one. that may takes a life time. thank you.
reply
KrazyMO
If you have a pdf that is always in the same format, is there a way to create a template so when you create an import button you don't have to do all the work every time? Is this too much for a macro to do?
reply
If you have a pdf that is always in the same format, is there a way to create a template so when you create an import button you don't have to do all the work every time? Is this too much for a macro to do?
reply
Sean
Is there a way to the import data and select all tables automatically? For example, you only have to specify the location with multiple PDFs and the automation does the loading + selecting all tables
reply
Is there a way to the import data and select all tables automatically? For example, you only have to specify the location with multiple PDFs and the automation does the loading + selecting all tables
reply
Big&Tall
Thank you Mynda for this valuable video. This really helps when you only a receive pdf file and prevents time zapping manual work. Your email tips & tricks and video demos are awesome!
reply
Thank you Mynda for this valuable video. This really helps when you only a receive pdf file and prevents time zapping manual work. Your email tips & tricks and video demos are awesome!
reply
suki9860
Thanks, Mynda! Quick question. Are we able to specify a conditional last page i.e. [StartPage = 3, If(condition, EndPage = 7, EndPage = 8] to cater for variable number of tables.
reply
Thanks, Mynda! Quick question. Are we able to specify a conditional last page i.e. [StartPage = 3, If(condition, EndPage = 7, EndPage = 8] to cater for variable number of tables.
reply
itech
What If you don-t have Excel 365? I have excel 2016. What would be the best solution in this case? I-ve tried several attempts starting from PDF but the results don-t always work.
reply
What If you don-t have Excel 365? I have excel 2016. What would be the best solution in this case? I-ve tried several attempts starting from PDF but the results don-t always work.
reply
Add a review, comment
Other channel videos
