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.
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.
@@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
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 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
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
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.
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
among the 12 file that you have given to extract in excel , only the first file is being extracted and all the rest are showing errors, i mean null. What is the solution?
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
@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.
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
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?
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
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
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 mere pass Hindi me MCQ double column pdf hai jise Excel me type karna hai, wo pdf me saare book ke questions ki photo khichi Hui hai.... How can I convert that pdf into Excel??? Please reply it's urgent
sir ye baao mere pass ek combiend file hai 60 pages ki "AYUSHMAN BHARAT " ka ek big data ki alag alg 20 files hai har fle ke andar kam se kam 60 pages hai to kya apka ye formula apply hoga
sir mujhe excel to aata hai lakhin jo aapne eshe video me bataya hai wo power query hai jo mujhe nhi pta hai please mujhe eshke liye koe video ka link de
Sir aap Excell ka konsa software use karte hai, hamare me 'Get data' ka option nahi hai usme to 'Acces form' wala option hai sir bataye kon sa year version Kiya àapne
Bhai jab mein je sab krta hu to je masge screen par Ata hai ,we dint recognize the format of ur first book pdf ,please filter the list so it contains only support types, tex CSV, EXCEL WORKBOOKS Jab mein filter krta hu tab b vahi msge Ata hai plz guide kro
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.
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
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
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".
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?
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
Here is the link to join my free webinar: event.webinarjam.com/register/13/m4851s2 Here you will get in-depth idea of basic to advanced level Excel course
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 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.
Allah SWT bless you and your beloved ones materially and spiritually Ameen
Thank you so much for your blessing.
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
apki videos se bht jayada help milegi aab mujhe family financial support mai or apke webinar se bhi
Www Ooooloooooo9osoooooooooooooooooooooololsoooooooo9lspooooooooo9ooo9oooplo😊olooooo😊ooo😊#😊#sspol9s#
Pesa kmae ns kmae lekin tricks sikhne ko kmal k milte hai💪😎👌
Take love from Bangladesh ❤❤❤❤
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
How to select
@@Mistermac880 same problem
Which office version supports this function, i have 2016 in which PDF option is not available
I'm your new subscriber and I got a lot of knowledge
Thanks for subbing
thank you sir apki video dekh kar ab main monthly 20000 se 30000 hazar rupe kama raha hu
How bro please explain it
How bro?
Which version of excel you used for this work.
Office 365
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.
Same problem
Before convert , kindly show pdf file what type of data u have table data only convert pdf to excel in this pattern..
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
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 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
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.
Hello Lokesh,
how can I use this trick in windows 10, or higher version? Please suggest
Sir Ek video Clients se conversation ka information ka banaye Please?😢
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 1 video freelance pr profile banane ka banaiye
Please......
Great viedo love from Pakistan🇵🇰
Thank you for your comment.
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.
Hey, Tauseef you can get the Solution
Thank you very much for sharing very useful and informative
Sir ap kon se excel use karta hai
Sir I have watched your this and other informative videos
And
Subscribed your channel for live class on 20-3-24 .
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
Thanks sir very useful, informative and explained very nicely once again thanks
Thank you so much for your comment.
What if the columns of files are not equal? We will have to use the power query in detail then?
Apka learning platform pe hindi me hota to bahut achha hota hai
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
kon si generation excel download kare sir
among the 12 file that you have given to extract in excel , only the first file is being extracted and all the rest are showing errors, i mean null.
What is the solution?
sir app ki video se aacha anubhav milta he par job ka bhi setting karao sir
freelancing ka liya excel ka premium lena zaroori ha kiya🤔🤔
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!
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
@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.
sir mere pass office 2016 isme ye feature nahi araha hai ...aap konsa version use karte ho?
Sir power bi tool excel ke konse version me work karta hai aur ise ham free download kaha se kare ispe bhi video banaye
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 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
ms excel 2013 not supporting combine and transpose of pdfs. Any solutions?
Sir mere Excel 2019 me combine n transform ka option nahi hai
Sir how I can update power BI and power query in my get data tab
Kiya ye work Google sheet ke through ho sakta hai ?
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 maine apke webinar ke liye registration kiya hai aaj rat 8 baje ke liye
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
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
Thanks a lot Sir .new subscriber
excel ka kaunsa version hai yeh, mere pass office 2010 hai, usme ye option get data ka nahi aa raha hai.
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
Ye ab client ko kese snd kre ?
Reply please.
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
Ee video dekh k aab company wala ee sab aab khud hi kar liyoo ga
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
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.
help full your all videos
Love you bhaiya ❤
Sir mere pass Hindi me MCQ double column pdf hai jise Excel me type karna hai, wo pdf me saare book ke questions ki photo khichi Hui hai.... How can I convert that pdf into Excel??? Please reply it's urgent
I tried this, the pdfs should be very clear or else it will not detect the table
sir ye baao mere pass ek combiend file hai 60 pages ki "AYUSHMAN BHARAT " ka ek big data ki alag alg 20 files hai har fle ke andar kam se kam 60 pages hai to kya apka ye formula apply hoga
sir mujh sy Ms excel ki orignel file install nhi ho rahi hai plz help kr dy
Sir ji मेरे में Get Data ka options nahi A Raha Hai,kaise laye ? office 365me or speedsheet me or WPS office me.Help Sir Quik
Great 👍🏻👍🏻👍🏻👍🏻👍🏻
sir mujhe excel to aata hai lakhin jo aapne eshe video me bataya hai wo power query hai jo mujhe nhi pta hai please mujhe eshke liye koe video ka link de
Sir aap Excell ka konsa software use karte hai, hamare me 'Get data' ka option nahi hai usme to 'Acces form' wala option hai sir bataye kon sa year version Kiya àapne
MS Office 365
Bhai jab mein je sab krta hu to je masge screen par Ata hai ,we dint recognize the format of ur first book pdf ,please filter the list so it contains only support types, tex CSV, EXCEL WORKBOOKS
Jab mein filter krta hu tab b vahi msge Ata hai plz guide kro
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.
Amazing videos❤❤
Glad you like them!
Background mein telescope kaun sa hain?
Thanks for power query knowledge.
It's my pleasure
I cannot import pdf files into power query could you please assist
Hello Sir, Please address the ways to approach small businesses as you described in this video in LinkedIn?
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
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
Payment kese recieve hoga account me aur pta kese chalega ki kaam aaya h es related video bnayo aur account kese bnaye
Kya ye google sheets par bhi kaam karega?
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".
ap kon saversion use kar rhay ha ms office ka
I am using MS Office 365
@@learnwithlokeshlalwani ya option free ma kasay milay ga
Sir mera combine file diler box open nhi hora 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?
Hey sir , how u copied pdfs into the excel
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
It is very important to earning online monet
Sir How to Mony windrow please send video
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
we didn't recognize file format error aa jata hy. please help to resolve
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
Sir can I use this function in Excel 2007 version
Sir please ek advance Excel course laiyee
Here is the link to join my free webinar: event.webinarjam.com/register/13/m4851s2
Here you will get in-depth idea of basic to advanced level Excel course
You are amazing Sir.
Did anyone address you by R Madhavan.?
You look similar to him❤
Mashallah, Tabarakallah
Sir ji ye sab mobile pe ho sakhta hye kya hamare pass laptop nahi hye
Sir me fiverr pe ac kaise banau muje kuch samaj me nahi aa raha he or koi help bhi nahi mil rahi he kahi se bhi
Sir ye trika excel 2007 me kaam kregi ya ni .... please btaye ...