I convert PDF files to Excel individually and organize them in a designated folder. I carefully execute each step and verify the source name in the first column. Although all twelve Excel files appear, only one book is populated with data. The remaining eleven books are blank. Kindly advise on a solution to this issue or provide a step-by-step resolution if anyone has previously resolved a similar power query.
A small correction. After you combine file and transform, in your 'sample file', select some other file other than 'first file', it is not showing data after book1. Select book 10 as it has 2 pages in pdf.
When I click on the link for practice file, I don't fiind the "File" option anywhere. In a box on the right side, it says "you don't have permission to view sharing information for this item".
convert PDF files to Excel individually and organize them in a designated folder. I carefully execute each step and verify the source name in the first column. Although all twelve Excel files appear, only one book is populated with data. The remaining eleven books are blank. Kindly advise on a solution to this issue or provide a step-by-step resolution if anyone has previously resolved a similar power query.
I tried with voters I'd list. Didn't work properly. Can you please do video on how to convert pdf voter list to Excel properly please this will be very good learning video us
@learnwithlokeshlalwani what if PDFs are not sorted? Data are printed ups and downs then what??😮 I haven't downloaded your given PDFs. It's just my random question.
I get this message "We didn't recognise the format of your first file. please filter the list of files so it contains only supported files" when converting. Yes excel 2024
@@learnwithlokeshlalwaniSir meri aik problem hai because I'm from Pakistan so jo log peopleperhour pai account banate hain but Pakistan se banaye gaye account accept nahi hote Sir why? Please help me
hi Lokesh, thank you for sharing your expertise and helping us.. One request i am new to fiverr but have 20 years of work experience and i have some experience with excel. how would buyers choose me me as a seller as i don't have any work on fiverr to show.
Dear sir, this trick is not completely working. When we are selecting first pdf file as sample file, then it is only fetching data of first pdf with headers. When we tried to select 10th pdf, that's working pretty good. All data is loading properly from all pdfs but from first page only and not from the second page and so on and also header of first pdf file is not there but that's not the issue. The main concern is to fetch data properly from all pdfs from each page. Please create a revised video for this. Well video is amazing..Thanks
Sir, Good afternoon. I'm from Bangladesh. After watch this video i have done my practice but only first page is ok other all pages Showed but place of data its shows "nulll". Will you please help me on it?
Sir freelancer se kuch question leke plesse uske answer de dijiye.. Clients ko kya chahiye Jisse project rejects na ho Data entry, copy paste se related
@@learnwithlokeshlalwanisir will you like to send me a excel sheet of a strong room of a bank where cash available of different denominations on a 14 cupboards. To balance withdrawal and deposit of daily cash
Sir, it is showing an error, & asking to provide the file in CSV, or in text, as pdf is not supported, I am using Mircosoft Excel 2019, so can you please help me.
Hello sir mein odisha se hun aur mein jobless hun bohat jaga try ki kuch nahin Mila aur apka video dekh kar kush ho gayi sir mujhe v online paisa kamana he Longo ko dikhana hai apse request hai ki aap mujhe sikha kar skill excel ka ta ki mein online earning karsaku sir plz
hello sir, 2021 excel 365 version , but i have still problem in power query , when i want to convert file's folder from pdf into Excel following your process i found "NULL" some rows, may you solve this problem through you video? thank you
Sir,infect,all data are not comming in the the new sheet only page 1 data are comming according the process you have explained in the video but rest of all files showing null ,sir what is the problem I am facing to extract all files dara
When I click on "Combine & Transform Data," I receive the following error message. Please advise, Sir. We were unable to recognize the format of your file (Book1.pdf). Please filter the list of files so that it only contains supported types such as Text, CSV, Excel workbook, etc., and try again. After removing file (Book1.pdf), the same error occurs with file (Book10.pdf). Sir, please provide a solution to this error.
Sir mere excel 2019 me PDF file ka option nhi dikh raha hai or support ek sath sab , even ki me from web wala option use kiya but ek file se jada nhi ho raha hai
Dear Sir, I working as a accountant in automobile industryand i have been seeing your videos for so many months. Request you to kindly suggest me to earn money as a second salary.
I'm glad to hear that you've been finding value in my videos. Leveraging Excel skills for extra income is a great idea. Consider offering freelance services like financial analysis, data entry, or creating customized Excel templates. Online platforms can connect you with clients seeking your expertise. You could also provide Excel training to individuals or groups. Best of luck in boosting your earnings!
I don't know about excel ...how and mostly which excel part i need to know so that i start earning money in 2,3 month.... And mostly where i learn excel
Join my free webinar. Here you will get in depth information about freelancing. And all your queries will be answered also. Here is the link: event.webinarjam.com/register/13/m4851s2
A. O a sir i am from pakistan I also wana following you step by step but When I click on the link for practice file, I don't fiind the "File" option anywhere. In a box on the right side, it says "you don't have permission to view sharing information for this item".
i am unbale to understand that which version of ms excel is best for meeting all day by day requirements. Kindly suggest best and latest version MS Office. waiting for your kind reply.
Sirr kindleyy I Need ur help when im doing combine&transform data its showing error **we didnt recognize the format of your first file (book 1.pdf) please filter the list of files so it contains only supported types(Text .csv. Excel workbooks, stc ) and try again . idk how to solv it can u please gide me Thank U
hello sir i am using excel 2016 under data menu i am getting PDF file through new query . problem is there is no option combine and transform or transform. i tried different options but success get data in proper excel.plz guid
Aaj kal kisi ko kuchh nhi aata to wo CZcams ki video dekhkr seekh leta hai kyuki CZcams pr har tarha ka video available hai To clients bhi apki video dekhkr seekh lega usko kisi ko kaam dena hi nhi padega to isse ham kaise paise earn kr payenge
Clients often choose to work with freelancers for various reasons, even for seemingly simple tasks. Freelancers offer a flexible and cost-effective solution that can be tailored to the specific needs of the project. They bring specialized skills and expertise, ensuring high-quality work. Additionally, freelancers can often deliver quicker turnaround times due to their focused dedication on the project at hand.
Sir ek baat samajhme nahi aarahi ke jab ye kaam aadhe ghante me hi sakta hai to phir kaam karne wala one hour ka charge 861 aur delivery in 2 days kyun daalte hain. Pls samjhaiye
Hi sir i tried doing the excel practice file unfortunately there is an error in book 1 , book 11 and book 12. I could not go ahead with the practice. Can you please help me out here?
Sir, i have tried as you explained in the video but when I click on combine and transform it shows-we did not recognize the format of your first file. please guide
I do have a course on Power Bi. Join my free webinar. Here all your doubts will be cleared and your questions will be answered. Here is the link to register: event.webinarjam.com/register/14/691x7b2
FREE Live Masterclass. Register Now. 🔥🔥
event.webinarjam.com/register/13/m4851s2
Sir
Future
Sir please tell me your inst id
Good
I wants to register but register now is not active after enter data
I convert PDF files to Excel individually and organize them in a designated folder. I carefully execute each step and verify the source name in the first column. Although all twelve Excel files appear, only one book is populated with data. The remaining eleven books are blank. Kindly advise on a solution to this issue or provide a step-by-step resolution if anyone has previously resolved a similar power query.
Bhi tuu kama Raha hai kya ye kar ke😊
A small correction. After you combine file and transform, in your 'sample file', select some other file other than 'first file', it is not showing data after book1. Select book 10 as it has 2 pages in pdf.
It worked after selecting book 10.
can you tell me how it worked I have also selected all the files but getting the same error, kindly can you brief. @@shubhammeshram8504
yes sir , mne bi prectice kri h and book 1 k baad baki PDF ka data show nhi ho rha h
Allah SWT bless you and your beloved ones materially and spiritually Ameen
Thank you so much for your blessing.
I am pakistani, MashaAhlla best techer in youtube
Thank you so much for your comment.
Hello Lokesh, This is Shahid from Pakistan, a big fan of u and u r a true excel guru. From now on, you are my guru jee.
Thank you so much for your comment.
When I click on the link for practice file, I don't fiind the "File" option anywhere. In a box on the right side, it says "you don't have permission to view sharing information for this item".
Which office version supports this function, i have 2016 in which PDF option is not available
I am from pakistan and much appreciated this effort
Thank you.
Sir, apki videos sai knowledge bohat milta hai. Thanks
Most welcome
Sir aap kanha se hai@@learnwithlokeshlalwani
I tried, but it is extracting data from Book 1 only. Though other book nmEA re ahowing in 1st column, their respective data are not combined.
convert PDF files to Excel individually and organize them in a designated folder. I carefully execute each step and verify the source name in the first column. Although all twelve Excel files appear, only one book is populated with data. The remaining eleven books are blank. Kindly advise on a solution to this issue or provide a step-by-step resolution if anyone has previously resolved a similar power query.
Thanks sir very useful, informative and explained very nicely once again thanks
Thank you so much for your comment.
I'm your new subscriber and I got a lot of knowledge
Thanks for subbing
I tried with voters I'd list. Didn't work properly. Can you please do video on how to convert pdf voter list to Excel properly please this will be very good learning video us
Thank you very much for sharing very useful and informative
One video on CSV file cleaning
Sure, will make a video in future.
Shukria sir ❤ mn ny ab tk jitny b excel or tips or tricks seekhany waly youtubers dekhy hn ap un sb sy best hn
Before convert , kindly show pdf file what type of data u have table data only convert pdf to excel in this pattern..
apki videos se bht jayada help milegi aab mujhe family financial support mai or apke webinar se bhi
Www Ooooloooooo9osoooooooooooooooooooooololsoooooooo9lspooooooooo9ooo9oooplo😊olooooo😊ooo😊#😊#sspol9s#
@learnwithlokeshlalwani what if PDFs are not sorted? Data are printed ups and downs then what??😮 I haven't downloaded your given PDFs. It's just my random question.
*Real life jobs itne asaan nahi hote!*
Sahi😂
Hello Lokesh,
how can I use this trick in windows 10, or higher version? Please suggest
I get this message "We didn't recognise the format of your first file. please filter the list of files so it contains only supported files" when converting. Yes excel 2024
What if the columns of files are not equal? We will have to use the power query in detail then?
Hello Sir, Please address the ways to approach small businesses as you described in this video in LinkedIn?
Which version of excel you used for this work.
Office 365
Sir I have watched your this and other informative videos
And
Subscribed your channel for live class on 20-3-24 .
Sir ap boht ache se explain krte hn thank you so much first time comment kr rhi ho
Thank you so much for your comment.
@@learnwithlokeshlalwaniSir meri aik problem hai because I'm from Pakistan so jo log peopleperhour pai account banate hain but Pakistan se banaye gaye account accept nahi hote Sir why? Please help me
Sir / bhaiya bohot bohot achhe tarike se samjhate ho aap thank you so much ❤ i hope aapki videos ki wajah se mai earn kar paungi
Thank you so much for your comment. Keep watching!
Superb Its really Smart work. 👏
Many many thanks
hi Lokesh, thank you for sharing your expertise and helping us.. One request i am new to fiverr but have 20 years of work experience and i have some experience with excel. how would buyers choose me me as a seller as i don't have any work on fiverr to show.
Thanks Mr. Lokesh, God bless you for helping us
Request for you ebooks on Excel.
Regards
Sir Ek video Clients se conversation ka information ka banaye Please?😢
thank you sir apki video dekh kar ab main monthly 20000 se 30000 hazar rupe kama raha hu
How bro please explain it
Dear sir, this trick is not completely working. When we are selecting first pdf file as sample file, then it is only fetching data of first pdf with headers. When we tried to select 10th pdf, that's working pretty good. All data is loading properly from all pdfs but from first page only and not from the second page and so on and also header of first pdf file is not there but that's not the issue. The main concern is to fetch data properly from all pdfs from each page. Please create a revised video for this. Well video is amazing..Thanks
Make a video of the steps you are doing and send it to ask@nurturetechacademy.in
Pesa kmae ns kmae lekin tricks sikhne ko kmal k milte hai💪😎👌
Take love from Bangladesh ❤❤❤❤
Sir 1 video freelance pr profile banane ka banaiye
Please......
Sir, Good afternoon. I'm from Bangladesh. After watch this video i have done my practice but only first page is ok other all pages Showed but place of data its shows "nulll". Will you please help me on it?
Sir how I can update power BI and power query in my get data tab
Sir Iam very much inspired nd getting very good knowledge from ur videos ,i want to know how I contact u
Thank you so much for your comment. Please email at ask@nurturetechacademy.in
Sir freelancer se kuch question leke plesse uske answer de dijiye.. Clients ko kya chahiye
Jisse project rejects na ho
Data entry, copy paste se related
You are amazing Sir.
Did anyone address you by R Madhavan.?
You look similar to him❤
Wooow so so good trick I learnt first time this one
Super excited to try this one 🎉
Great 👍
Hi
App ka link kaha pa ha????
did you get work tell m
if yes so reply
Amazing video sir. Thank you so much sir for this video❤
Keep watching
@@learnwithlokeshlalwanisir will you like to send me a excel sheet of a strong room of a bank where cash available of different denominations on a 14 cupboards.
To balance withdrawal and deposit of daily cash
excel sheet can not seeing to (get data option) button. I don't know why it's not showing the tab.please tell me how can solve
Sir, it is showing an error, & asking to provide the file in CSV, or in text, as pdf is not supported, I am using Mircosoft Excel 2019, so can you please help me.
same problem... did u find any solution
Hello sir mein odisha se hun aur mein jobless hun bohat jaga try ki kuch nahin Mila aur apka video dekh kar kush ho gayi sir mujhe v online paisa kamana he Longo ko dikhana hai apse request hai ki aap mujhe sikha kar skill excel ka ta ki mein online earning karsaku sir plz
Join my free webinar. Here all your doubts will be cleared. Here is the link: event.webinarjam.com/register/13/m4851s2
hello sir, 2021 excel 365 version , but i have still problem in power query , when i want to convert file's folder from pdf into Excel following your process i found "NULL" some rows, may you solve this problem through you video? thank you
Sir g Amazing Trick❤❤❤ but guide us in which Excel version (year)???? Thanxxxx
Thank you so much for your comment. Its MS Office 365
Thanxxxxx A lot
Sir,infect,all data are not comming in the the new sheet only page 1 data are comming according the process you have explained in the video but rest of all files showing null ,sir what is the problem I am facing to extract all files dara
Combine & transform data kar raha hu to combine files problem aa raha ahe please solution 🙌🏻🙇🏻♂️😇
Great viedo love from Pakistan🇵🇰
Thank you for your comment.
Thanks a lot Sir .new subscriber
Sir, whatever skill you tell about work, is this work possible with smart phone? please reply
I'm member your you tube channel
not possible
When I click on "Combine & Transform Data," I receive the following error message. Please advise, Sir.
We were unable to recognize the format of your file (Book1.pdf). Please filter the list of files so that it only contains supported types such as Text, CSV, Excel workbook, etc., and try again. After removing file (Book1.pdf), the same error occurs with file (Book10.pdf).
Sir, please provide a solution to this error.
I also faced same issue, then i google that issue. PDF option is only available in Office 365 version. You and me are using simple office versions.
Sir mere excel 2019 me PDF file ka option nhi dikh raha hai or support ek sath sab , even ki me from web wala option use kiya but ek file se jada nhi ho raha hai
I wish I can earn money with your idea in fucher 😂.
Lol😂
Not possible 😂
Not Possible
😂 HAHAHA....INFUTURE....
Why we are not getting work after Watching your video
Dear Sir,
I working as a accountant in automobile industryand i have been seeing your videos for so many months.
Request you to kindly suggest me to earn money as a second salary.
I'm glad to hear that you've been finding value in my videos. Leveraging Excel skills for extra income is a great idea. Consider offering freelance services like financial analysis, data entry, or creating customized Excel templates. Online platforms can connect you with clients seeking your expertise. You could also provide Excel training to individuals or groups. Best of luck in boosting your earnings!
Subscribed sir
Thank you for valuable information
Thanks and welcome
ms excel 2013 not supporting combine and transpose of pdfs. Any solutions?
How to communicate International clients sir
How to transfer data from printed excel data to system ?
I don't know about excel ...how and mostly which excel part i need to know so that i start earning money in 2,3 month.... And mostly where i learn excel
Join my free webinar. Here all your doubts will be cleared. Here is the link to register: event.webinarjam.com/register/13/m4851s2
Sir power bi tool excel ke konse version me work karta hai aur ise ham free download kaha se kare ispe bhi video banaye
Sir how to start freelancing plz make video for beginners plzzzzzzzzzzzzzz
Join my free webinar. Here you will get in depth information about freelancing. And all your queries will be answered also. Here is the link: event.webinarjam.com/register/13/m4851s2
Sir which Excel version has this get file from pdf function.
A. O a sir i am from pakistan
I also wana following you step by step but
When I click on the link for practice file, I don't fiind the "File" option anywhere. In a box on the right side, it says "you don't have permission to view sharing information for this item".
Thanks a lot for valuable information.
Glad it was helpful!
sir maine apke webinar ke liye registration kiya hai aaj rat 8 baje ke liye
Love you bhaiya ❤
we didn't recognize file format error aa jata hy. please help to resolve
i am unbale to understand that which version of ms excel is best for meeting all day by day requirements.
Kindly suggest best and latest version MS Office.
waiting for your kind reply.
Use Office 365 so that you can use the latest functions.
Hii brother, I'm not getting transform and load options in excel 2016 how can i do this work in excel 2016
Please help me
I tried this, the pdfs should be very clear or else it will not detect the table
how to scanned copy there in folder convert to excel
Not working one pdf split into many tables it takes very much time to make it meaningful
sir app ki video se aacha anubhav milta he par job ka bhi setting karao sir
Salam bhai apsy pochna tha ka ap onlin clasis kub start karengy dosra kya hum different subject pa kitny different gig banasakty hy. Plz reply me
Thanks for power query knowledge.
It's my pleasure
Thanku so much for ur information sir
Most welcome
i've developed the tool for the same. that took less than 10 sec to convert any pdf to excel.
Detail about tool plese
in my excel there is no option of *get data from*
Sir mere Excel 2019 me combine n transform ka option nahi hai
im getting NULL value in every colum other than BOOK1 why?
Is it working on version 2016 or not...
Please confirm, sir...
BTW, it was very informative video
Thank you
Not working in 2016 PDF option Hi nahi he isme
Sir...super video...excited about your masterclass but am not able to register as the link is not opening ...please guide me. Thank you
Here is the link to register: event.webinarjam.com/register/13/m4851s2
Sirr kindleyy I Need ur help when im doing combine&transform data its showing error **we didnt recognize the format of your first file (book 1.pdf) please filter the list of files so it contains only supported types(Text .csv. Excel workbooks, stc ) and try again . idk how to solv it can u please gide me Thank U
hello sir i am using excel 2016 under data menu i am getting PDF file through new query . problem is there is no option combine and transform or transform. i tried different options but success get data in proper excel.plz guid
Aaj kal kisi ko kuchh nhi aata to wo CZcams ki video dekhkr seekh leta hai kyuki CZcams pr har tarha ka video available hai
To clients bhi apki video dekhkr seekh lega usko kisi ko kaam dena hi nhi padega to isse ham kaise paise earn kr payenge
Clients often choose to work with freelancers for various reasons, even for seemingly simple tasks. Freelancers offer a flexible and cost-effective solution that can be tailored to the specific needs of the project. They bring specialized skills and expertise, ensuring high-quality work. Additionally, freelancers can often deliver quicker turnaround times due to their focused dedication on the project at hand.
Sir ek baat samajhme nahi aarahi ke jab ye kaam aadhe ghante me hi sakta hai to phir kaam karne wala one hour ka charge 861 aur delivery in 2 days kyun daalte hain.
Pls samjhaiye
Transfer data option not shown Excel 2016 version
It shows edit option
Sir ap kon se excel use karta hai
Hi sir i tried doing the excel practice file unfortunately there is an error in book 1 , book 11 and book 12. I could not go ahead with the practice. Can you please help me out here?
Sir, i have tried as you explained in the video but when I click on combine and transform it shows-we did not recognize the format of your first file. please guide
Same here bro
Thanks
Welcome
Which Excel version you are using please, because in data, i did not find get data option like you are showing, please guide me
I am using MS Office 365
sir my laptop has office 2019 but is failed when given "combine & Transform". it says the pdf file is not recognised.
help me please sir.
Hello Pawan ji, can you please teach us POWER QUERY & POWER BI courses.
I do have a course on Power Bi. Join my free webinar. Here all your doubts will be cleared and your questions will be answered. Here is the link to register: event.webinarjam.com/register/14/691x7b2
Amazing videos❤❤
Glad you like them!
freelancing ka liya excel ka premium lena zaroori ha kiya🤔🤔
When power query editor is opened the pdf m converting has multiple tables which tarnsforms into multiple sheets inwant to do it in one sheet