#Shorts

[@shabadke]

Wow
Excellent
Very useful one. Just now I used it in office. Otherwise i would have to type a whole sheet to excel.
Thanks bhaijaan.

[@GyanOnTube]

Great work...keep learning keep sharing..👍👍

[@avinashtumbade428]

@@GyanOnTubegood trick👍

[@GyanOnTube]

Thank you so much

[@khalidalisubhanallah2947]

Bundle of thanks Sir ❤️

[@GyanOnTube]

Thank you so much

[@Ram-dd8zr]

​@@GyanOnTubemere system me *from pdf* kyu nhi show kr rha Bhai

[@javaranjeet]

🙏🙏Thans sir, ऐसा ही और वीडियो बनाइये 🙏🙏

[@GyanOnTube]

Thank you so much..do not forget to share this video

[@y2nsamy2nsam3]

Wow.. i wish we had all these type of information platforms years ago

[@GyanOnTube]

Yes very true

[@tulssolanki4136]

Thank you 👍🙏

[@GyanOnTube]

Thank you so much

[@ranaabduljabbar6058]

Sir, excel ki 2 sheets ka deta kese match krte hen please mention

[@GyanOnTube]

Use Vlookup or match function

[@vishaltanwar8318]

Excellent sir
Sir please make video on this
Jaise hum kis data main serial number delete karte hai to number automatically set ho jaye or hume number type karne ki jarurat dobara jarurat na pade

[@GyanOnTube]

Thank you..iske liye mene already video bana rakhi hai aap mere channel mein dekh sakte hai

[@KaifiyaKazi-xq3ej]

Thank u sir bahot helpful hai 🥰👏👏👏

[@GyanOnTube]

Thank you so much 👍

[@puspenderkumardubey1732]

बेहतरीन साहब

[@GyanOnTube]

Thank you so much

[@pashashaik8535]

Wow excellent

[@GyanOnTube]

Thank you so much

[@azadsingh4895]

Very nice trick

[@GyanOnTube]

Thank you so much

[@sumitpundeer7291]

I realy like the video. It will save my time. Just one question, If I need all the pages of such pdf in excel. How I am supposed to do that?

[@GyanOnTube]

You need to follow the same process..copy and drop your all pfd will be exported

[@RahulKumar-ly6ly]

Thanks sir

[@GyanOnTube]

Thank you

[@falaknazzcreation4083]

Superb
Sir ek hafte pehle aapse qes. Kiya tha google sheet me mecro record karke advance filter kaise lagaye
Sir is queries ka koi solutions huaa

[@GyanOnTube]

Nhi abhi nhi mila..

[@GyanOnTube]

Hello, i am getting more then 100 request in a day..so mein aapse request karunga ki aap logo bar bar ye mat bolo ki mene pehele bhi comment kiya tha aur mene video nhi banya....agar mene sabke liye ek ek video banane lag gaya to not sure kab kitni video bannai hogi..hope you understand

[@vimalkmr951]

@@GyanOnTube Agree 👍

[@krunalraipure8235]

Which version of excel u r using..... In 2010 its not working.. Im not getting option of get data or import

[@GyanOnTube]

You need to upgrade your excel to offer 365

[@swapnaallenki4936]

Now how to download converted and edited excel. Please reply as soon as possible.
Thanks in advance..

[@GyanOnTube]

Download...??? Its your excel just save it

[@swapnaallenki4936]

@@GyanOnTube
I can't able to find save option

[@GyanOnTube]

Press f12

[@shashankda2002]

Thank you

[@GyanOnTube]

Thank you so much..do not forget to share this video

[@perwezshaik578]

Thank you for this information

[@GyanOnTube]

Thank you so much

[@AbdulKhalique-fd9ui]

Good

[@GyanOnTube]

Thanks

[@vittalkumbar6912]

Thank you bhaiya ❤❤

[@GyanOnTube]

Thank you so much

[@pranayabankar2354]

Thank you so much you helped me alot

[@GyanOnTube]

Thank you so much

[@vanshikaudhani7549]

Filter kaise legate hai bataye pls

[@GyanOnTube]

Excel mein filter..??

[@arghya_2010]

Wow

[@GyanOnTube]

Thank you so much

[@allsubjestformetters7324]

Yes

[@GyanOnTube]

Thank you so much

[@bijaytanty8434]

Thanks

[@GyanOnTube]

Thank you

[@MDIrfan-zp5xq]

Thank you so much

[@GyanOnTube]

Thank you so much

[@vivekagrawal6917]

But sir what if there are no tables in the PDF. Please reply.

[@GyanOnTube]

Then you will get all data in one cell

[@VIJAYKUMAR-jr6nt]

Please provide download option... It was really amazing

[@GyanOnTube]

Download option means

[@VIJAYKUMAR-jr6nt]

@@GyanOnTube
I mean provide download the video option likewise... Like comment etc at the bottom

[@GyanOnTube]

Unable to understand sorry

[@pragatigaikwad4654]

He want to download the video .how to download the video

[@GyanOnTube]

You can download video from RUclips only..

[@mohammedifteqarali608]

can it work in 2013

[@silpakalpa]

in excel 2016 which you have shown excel open and get data . but it is not shown in 2016 pdf file

[@GyanOnTube]

You can upgrade your Microsoft office then it will work..

[@claudiooseraphino6954]

kindly mention the software version of excel
as the pdf option in available in excel 2016

[@GyanOnTube]

Its office 365

[@arunmaurya4208]

Apka bill scanned tha ya originally download kiya tha

[@GyanOnTube]

Original download kiya tha

[@hasithanuwan8928]

Thank you so mucj

[@GyanOnTube]

Thank you so much

[@golmaal935]

Superb 👏👏👏

[@GyanOnTube]

Thank you so much 🙏

[@mdumar9628]

#Ye jo green color se highlight ho rha h ye waise hi rahega Kya aur column 1,2 v waise hi rhega ???
Kya ye print Karne par v highlight honge ya normal rahenge ??

[@GyanOnTube]

Agar aap print colour mein lete ho to bilkul vesa rahega

[@vrkravi6099]

I want Multiple item conversation as u selected one file

[@GyanOnTube]

Means

[@manojshrestha1022]

Good 👍

[@GyanOnTube]

Thank you so much 😊

[@habibch6763]

Nice boss

[@GyanOnTube]

Thank you

[@Saimawrites6820]

Excel ka version knsa ha??? 2016 or 2019 or other?

[@GyanOnTube]

Office 365 mein

[@Altaf_Alam]

I don't have pdf option in ms office 2021 version... How can i get it?

[@GyanOnTube]

Yes you need to upgrade your excel version

[@amitkumar-pw6jr]

Aowsome bro!

[@GyanOnTube]

Thank you so much

[@vinithag993]

I have only 2010 Excel so I don't have this option, tell me how to do

[@GyanOnTube]

Please upgrade your Microsoft office

[@musick6257]

Mene shloka ka ek pdf file ko excel main convert karne ki koshish ki. Only English words came. Hindi Sanskrit words were all Greek and Latin

[@GyanOnTube]

Hanji wo nhi aate

[@mghosh1578]

Sir i have excel 2019, will this trick could work on it???

[@GyanOnTube]

This will only work on office 365

[@baker_rossee562]

In my excel it does not give option to convert into pdf.

[@GyanOnTube]

Which excel version are you using..ita only available in office 365 as of now

[@spvlog9087]

I'm using 365 but I can't get the PDF file opinion on the from file menu

[@GyanOnTube]

You need yo upgrade

[@sanjaypawar6005]

How to do on excel 2010

[@GyanOnTube]

As of now its only available in office 365

[@pankajsaini50]

This Function is not available in Office 2016

[@GyanOnTube]

As of now these functions are only available in office 365

[@adminswain]

In my excel there is no option of from pdf under get data menu, what's the needful action

[@GyanOnTube]

You need to upgrade your office to Microsoft office 365

[@letestcrick]

Bro image pdf h usme work ni kr rha kya kru plz suggest already using 365

[@GyanOnTube]

Please upgrade it

[@dineshpandiya671]

Which excel version show get data

[@GyanOnTube]

I am using office 365

[@ShubhenduSShukla]

PDF option is not available in Get data

[@GyanOnTube]

Which version of excel you are using

[@jatinrajput6389]

​@@GyanOnTube 2019 Ms excel

[@abhiraj___kashyap]

Mera pass 2016 version ha usne kese kare yahi trick batao

[@GyanOnTube]

Aapko aapna office upgrade hi karna hoga

[@md.mahtabuddin2247]

Mere pas 2007 ka software hay. Waha pe get data nehi ata. Now what to do???

[@GyanOnTube]

Uske liye aapko aapna excel ko update karna hoga

[@Dipakchavan007]

can we do in windows xp

[@GyanOnTube]

No, you meed to upgrade your system

[@kuntalkesh4801]

Thanks 🙏

[@GyanOnTube]

Thank you so much

[@hinduhistoryandculture6903]

Bhai bank statement ko Karo
Ya option to hare old version ma nahi h

[@GyanOnTube]

Iske liye aapko aapna office update karna hoga

[@bijaytanty8434]

Thanks 👍

[@GyanOnTube]

Np thank you

[@ajinkyapatil6652]

Sir mere Excel mein Get data ke options me - From PDF ka option nahi dikha raha hai ? What to do now?

[@GyanOnTube]

Iske liye aapko latest version of excel install karna hai

[@krishnatamrakar2524]

no not in office 2016 too. office 2021 or 365@@GyanOnTube

[@GyanOnTube]

365

[@anusuyarawat9753]

I have not get data option

[@masid3895]

Bhai itna aachaa nhi aataa data jitna acchaa dikha rha h tu😊

[@GyanOnTube]

At the end result you are getting

[@ranjeet68706]

Bhai Jaan.. Excel 2007 mai agar humko pivot table mai .. Unique text kaise count karenge..like bahut saari city hai unko kaise count karege pivot mai

[@GyanOnTube]

City ko uthake value mein dal do aur unka count ke lo

[@ranjeet68706]

@@GyanOnTube nahi bhai.. Suppose ek hi naam ki multiple citi hai.. But mujhe unique count karni hai.. Agar delhi 10 baat aa raha ho to 1 count kare

[@GyanOnTube]

Ha to aap pivot mein lagaoge to yehi aage

[@karishmapatel6768]

Sir mera HP ka leptop h par usme offline Excel ni chal raha h to offline Excel m kese update kre

[@GyanOnTube]

Kya aapne excel install kiya hua hai

[@karishmapatel6768]

@@GyanOnTube nahi sir phle se hi hai

[@allsubjestformetters7324]

I Love you sir

[@GyanOnTube]

thank you so much, do not forget to share this video

[@RahulKumar-ly6ly]

Sir excel me show margne vala option ko clicks karka manual margne set kaise karta ha sir margne vali line ko aaga piche kichker es topic par ek video pĺease sir mena pahle bhi comments kara tha sir es video ke liye sir

[@GyanOnTube]

Hello Rahul, i am getting more then 100 request in a day..so mein aapse request karunga ki aap logo bar bar ye mat bolo ki mene pehele bhi comment kiya tha aur mene video nhi banya....agar mene sabke liye ek ek video banane lag gaya to not sure kab kitni video bannai hogi..hope you understand

[@ihgamingfun6295]

Nyc..👍👍

[@GyanOnTube]

Thank you so much

[@ApexKaran97]

mere excel me toh get data ka option hi ni hai, me kese krun??

[@GyanOnTube]

Kaunsa excel version hai aapke pass..

[@ApexKaran97]

@@GyanOnTube 2007 and 2016, in dono me try kia

[@GyanOnTube]

Ye 2019 mein milega aapko

[@ApexKaran97]

@@GyanOnTube okay sir, Thanks a lot.. I'll upgrade to newer version

[@vijay4157]

Thanks, very useful

[@GyanOnTube]

Thank you so much

[@nitinpawar1181]

sir phone ke whatsApp group me aai xlsx extention ki pdf ko pc ke excel me kese open karenge? sir please bataie

[@GyanOnTube]

Sire let me create a video on that topic

[@yasintisha]

Love 💕💕💕💕

[@GyanOnTube]

Thank you so much..do not forget to share this video

[@brijeshtaksali1989]

How to import password protected PDF in power query Sir?

[@GyanOnTube]

We need to break the password first else you will get get ready the pdf

[@brijeshtaksali1989]

@@GyanOnTube Sir May I request you to make a video on this topic?

[@GyanOnTube]

Sure will do

[@amandev7371]

sir mai power query series dekh raha tha ye video ka usse koi relation nai hai shayd? ye video us series me hai.

[@GyanOnTube]

Oo really .thanks for informing..we move it..thank you again

[@JachHash]

Sir screen recorder konsa use kiya hai?😵

[@GyanOnTube]

Mein 3 screen recorder use karta hu

[@JachHash]

@@GyanOnTube Please aap bata sakta hai konse konse screen recording aap use karte ho?🙏🏻

[@GyanOnTube]

Koi bhi kar lo..obs ya kich bhi

[@JachHash]

@@GyanOnTube OBS se itni acchi quality nahi aati sir that's why. aap aur konse software/app use karte ho please let me know It'll be very helpful ❤️

[@GyanOnTube]

Hahaha...mein obs hi use karta hu

[@chouhansushil]

Sir how to convert form like bank RTGS FORM

[@GyanOnTube]

Can you convert rtgs to pdf if you can then apply same step for pdf

[@kamlesh6138]

Wonderful

[@GyanOnTube]

Thank you so much

[@zkinggamer1687]

Ms Excel which year

[@GyanOnTube]

Office 365 as of now

[@pradeepkumar-sx1ty]

will it work on scanned pdf document? will it be able to import from a scanned document?

[@GyanOnTube]

Yes it can work on any kind of pdf

[@alamzebkhan8328]

2019 version mai pdf wala option hi show nhi hota ...to kaise karen ?❤

[@GyanOnTube]

Uske liye aapko aapna Microsoft office ko update karna hoga

[@user-hz7qx2ns5w]

Amazing

[@GyanOnTube]

Thank you so much

[@shaheerali1275]

Which version?

[@GyanOnTube]

Office 365

[@prashantk.a.6849]

Ye kis version me hai. Free ya paid

[@GyanOnTube]

Ye paid hai

[@rajatdeep7192]

Kaya ye same process doc file pe bhi applicable hai

[@GyanOnTube]

Doc file to already editable format mein hota hai..

[@pravinsalunkhe9038]

Hi Sir, windows 7 pe ye nahi kar sakte hain kya?

[@GyanOnTube]

Nhi ..you need to upgrade

[@pet154]

Sir in the from file from pdf option is not there in my system, can you please help me?

[@GyanOnTube]

Which version of excel you are using..coz its only available in office 365 as of now.

[@pet154]

@@GyanOnTube win 10 11th gen

[@pet154]

Also i am not able to take print like pdf print

[@GyanOnTube]

Without looking at your system i will not be able to give you the solution

[@pet154]

@@GyanOnTube Can you please access my system?

[@sijangurung1936]

Is possible in exell 2013

[@GyanOnTube]

This feature is only available in office 365 as of now

[@Whirling1Dervish]

@@GyanOnTube Not available on Office 365 which opens on browser.

[@dipendrashrestha5353]

This feature is not available on 2013??

[@GyanOnTube]

It is only available in office 365 as of now

[@shekar9783]

Get data is not available in my pc

[@GyanOnTube]

This is only available in office 365

[@souravdamani3664]

Sir, will PDF option show in Office 365 online.

[@GyanOnTube]

Yes it will

[@goviral4016]

Is This truck work on word document

[@GyanOnTube]

Yes it works give a try with office 365

[@abhishekchourasiya3632]

Sir ....PDF me Data almost 1 lakh ka h ...to wo excel me convert nhi ho raha...kese kar skte h convert excel me pdf file ko... without spoiled data .. please tell me...

[@GyanOnTube]

Kya aap office 365 use kar rahe hai

[@abhishekchourasiya3632]

@@GyanOnTube haan sir..lekin usse b data proper way me nahi aa raha...spoiled ho raha h pura data.... almost 1lakh ka data h

[@GyanOnTube]

Try query editor in excel

[@abhishekchourasiya3632]

@@GyanOnTube Sir how can I use query in Excel plz tell..

[@GyanOnTube]

Through power query

[@motimeghrishi3265]

Excel 2007 mein kaise convert kr skte hein?

[@GyanOnTube]

Ye possible nhi hai 2007 mein

[@motimeghrishi3265]

@@GyanOnTube 2013 mein bhi kuch function activate nhi ho rhe hein

[@GyanOnTube]

Iske liye aapko aana office update karna hoga

[@karansadotra6388]

Bhai kha the abhi tk app...
apki JAI ho.... ere office ma rooz mujhe 25-30 PDF files convert krni hoti ha.. kuch ho jaati ha kuch nai.. sbme table ha

[@GyanOnTube]

Hanji sab pdf mein table hona chaiye

[@karansadotra6388]

@@GyanOnTube Thanks bhai... kuch Chahiye ho btana...

[@GyanOnTube]

👍👍

[@venkataramesh2346]

Pdf option not there in the tab

[@GyanOnTube]

Which version you are using

[@prathamsapna]

Hi any possibility to convert Html file in Excel

[@GyanOnTube]

Yes we do have that option as well but in multiple ways

[@krushnakhetre2545]

From pdf option is not available in my Excel 2016

[@GyanOnTube]

As of now its only available in office 365

[@riturajkumar9882]

Kaha aa rha hai...Get data ka option

[@GyanOnTube]

Which version of excel do you have

[@RoshanKumar-uv2ml]

Window 7, iss Excel me get data options nhi aare sir. Only kuch files aa rhe h, text file, web file, From Acess. Bus itne hi aa rhe h. Pdf file nhi aarha. Online convert krna pdta h

[@GyanOnTube]

Ye abhi sirf office 365 mein hi available hai

[@RoshanKumar-uv2ml]

@@GyanOnTube hmm mujhe laga hi tha. Vese..✌️😂😂mene cmnt isliy kiya q ki mene dekha sbke reply de rhe ho aap to, syd mere bhi de do. Vrna koi nhi deta.. ty sir ✌️. Aap pivot table ko achese smjha skte ho sir. Mene kayi videos dekhe par. Clear nhi hoti sari chije

[@GyanOnTube]

Mein har ek comment ka reply deta hu dont worry on that..aur rahi bat pivot table ki mene uske uper ek puri series bana rakhi hai aap wo jaake dekh sakte ho..

[@simitmishra4981]

Super

[@GyanOnTube]

Thank you so much

[@thameemabdul9176]

Can we make this in excel2010

[@GyanOnTube]

Abhi ye office 365 mein hi available hai

[@shubhamchourey4427]

Sir size ko lekar help chahiy

[@GyanOnTube]

Hanji please bataoo

[@mdimtiazkhan1812]

sir not show get data option in window 10

[@GyanOnTube]

Which office do you have