Properly Convert PDF to Excel

Рет қаралды 1,014,273

Күн бұрын

Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
Are you looking for an effortless way to transfer data from PDFs to Excel? Say goodbye to complicated methods and hello to Power Query's new feature! In this video, we dive into how Power Query transforms the way you import data from PDF to Excel.
✨ Key Highlights:
▪️ Automatic Refresh Feature: Learn how to maintain dynamic links between your PDF documents and Excel data, ensuring that your information updates automatically.
▪️ Real-Life Examples: We walk you through three practical examples, including importing safety reports, financial data from Tesla's quarterly reports, and a manual's table of contents.
▪️ Step-by-Step Guide: Follow our simple, clear instructions on using Power Query, from selecting the right data to transforming and cleaning it for your Excel sheets.
▪️ Time-Saving Tips: Discover how to bypass traditional, time-consuming methods like copy-pasting and manual formatting.
In this video we will test the functionality with 3 different business cases. We will first test the automatic refresh in Excel when the content of the PDF changes. In the second example we will import a specific table from a PDF document (Tesla's quarterly financial report). And finally we'll get creative and import the table of contents from a PDF eBook into Excel.
The new PDF data connector is available as part of a Microsoft 365 subscription
⯆ Read the full blog post: www.xelplus.com/import-pdf-to...
Complete Excel Power Query playlist: • Excel Power Query (Get...
00:00 Import from PDF to Excel with Power Query
00:41 Automatic Refresh - Import from PDF to Excel with Power Query
03:36 Convert Financial Report from PDF to Excel with Power Query
07:10 Import Table of Contents from PDF to Excel with Power Query
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#excel #PowerQuery

Пікірлер: 1 100

@LeilaGharani 3 жыл бұрын

Stay up to date with the latest by signing up to my FREE XelPlus Weekly newsletter: www.xelplus.com/newsletter/ If you have an image that you'd like to import into a table in Excel or Word, check out this video: kzfaq.info/get/bejne/ga1kfd1hq7K9Zas.html

@MrDexter337 3 жыл бұрын

Hello, thank you for your videos! They are incredibly informative and present the information into an easily understandable way. I'm noticing that I don't have the PDF to Excel functionality. I have 365 business enterprise and just recently updated to the latest version, but still not there. Would you happen to know what I would need to do to get it?

@musingnature 3 жыл бұрын

Hey, Thanks for the tutorial! But I am not able to see the Import from PDF option. All other options available though in the Import from File option. Any idea, if I need to enable something?

@chandrashekar9672 3 жыл бұрын

@@musingnature @leila same issue ,

@ambrose.dota2 3 жыл бұрын

please reply us. We dont see any options PDF to Excel. Tq leila.

@alexkimanikihuna7215 3 жыл бұрын

Hello Leila, I too can't access the pdf option, how is what can I do to access it for easier importation of tables

@timmykk1 3 жыл бұрын

Hi Leila, For some time you have been my go-to tutorial source for Excel questions. Now I've discovered you post regularly and have become a regular. Today you hit a topic that I have wrestled with so many times in the past. Your special gift is clarity and relevancy. You also include the little details that novices like me really need in order to become proficient. Thank you so much!

@LeilaGharani 3 жыл бұрын

You're very welcome, Timothy!

@MogensBLaursen 3 жыл бұрын

This is just excellent - you really get around the real stuff (cleaning up real-world data sources) and saving lots of otherwise tedious work. Your solution to the problem with multiple tables is a real time saver. Thank you so much !

@AndreaUK1973 3 жыл бұрын

Awwww!! I’m gunna cry!! This is absolutely everything I was struggling with!! UNTIL now! Days of straggles are over! Thank you ! thank you ! thank you!!

@virtualpedia1330 Жыл бұрын

Leila, I cannot believe my eyes. You just cannot imagine what a lifesaver you have been. I saw many videos trying to explain importing PDFs to Excel. Unfortunately, none of those could solve my problem. I get Invoices in PDF format and need to convert those line items wise to Excel to maintain the material and quantity, rate and total amount. I had to spend hours converting each Invoice. Now I can very accurately convert those in a matter of minutes. In fact, before this comment, I managed to convert 23 invoices. Thank you very much!

@zahratorabi7638 3 жыл бұрын

Amazing, i was looking for an easy way to dowload the whole file, and now i know its just a right mouse-klick. You're my angel Leila joonam 👍🤗😘😍🌼☀️👏👏👏

@agermoune 3 жыл бұрын

excellent subject selection. Adobe is been giving us hard time converting table content into tables in excel. This is a great addition to power query and you just made it so sample. Thank you for all the time you invest to make a difference and you are succeeding. Great work!

@anferben 3 жыл бұрын

I've been doing this for months with a combination of those tools in the web (very messy results by the way) + fixing the data with PQ... but now this is a big AHHH. Thanks Leila, you're the best!🚀

@asdrugarcia1132 3 жыл бұрын

Thanks Leila!!! you had save me a ton of work! keep up the awesome work! for those who are having issues not finding the PDF option on your DATA tab, all you have to do is update your excel version if yuo have a subscription to Office 365 go to File>account>office updates>update now, save you work and allow 5 minutes for the update when the app restart you'll find the PDF option avaliable under the DATA tab.

@gv-k4f7g5b9 3 жыл бұрын

I've watched numerous videos by Leila and i am amazed by what can be done in excel. Compared to most people i know alot of functionality, however compared to Leila i know diddly squat!

@TSSC 3 жыл бұрын

For loading multiple files in one go, I tested Get Data > From File > From Folder, combined the files (Content column) … and it resulted in a query with the data from each of the files (same document structure). 👍💪 This could be quite convenient to process data in, say, monthly reports, bank statements, etc.

@es8560 3 жыл бұрын

This is awesome!!! Thank you Leila for sharing this video. 👍 I really like the way you presented it - slowly build up the momentum with different cases. It really helps me better understand the topic.👏

@miteshparmar1 3 жыл бұрын

Leila is the Excel guru! Superb video!!! I'd like to add that if you don't see this functionality in your Excel despite having the latest Office 365 it's because it's only supported in Windows 10. Hence if you're running any other version of Windows you'll need to upgrade to Windows 10 (if your running Windows 7 the upgrade is free). Once you've upgraded to Windows 10, you need to update your Excel version by: File --> Account --> Office Updates --> Update Now Now this functionality should exist.

@mattschoular8844 3 жыл бұрын

Thanks Leila...Importing pdfs had always been a challenge. Power Query should be helpful in many cases....

@LeilaGharani 3 жыл бұрын

It really is! Thanks Matt.

@leiterservices Жыл бұрын

Revisiting your Power Query videos - just shared this with my work group! Thanks for all the information! I watch your channel regularly- I've learned about a lot of tools that I didn't even know existed!

@johnborg5419 3 жыл бұрын

Thanks Leila. I had some PDF files before and had a hell of a time to convert to Excel. If I recall, I transferred to word first. This is Great!!!

@kpsrathore 3 жыл бұрын

Leila, You just cannot imagine what a life saver you have been. I saw many videos trying to explain importing PDF to Excel. Unfortunately, none of those could solve my problem. I get job cards in PDF format and need to convert those to Excel to maintain the material receipt. I had to spend hours converting each job card. Now I can very accurately convert those in a matter of minutes. In fact, before this comment, I managed to convert 10 job cards. Thanks a TON.

@LeilaGharani 3 жыл бұрын

YAY! I'm so glad this was helpful. Thank you so much for sharing.

@TekhXpert 3 жыл бұрын

@Leila Gharani Yes, you are helping a very big community. 😍

@rvgiri 3 жыл бұрын

Hi i am also having office 365, but under data still i didnot got data -> pdf, can you help how can i get that.

@TekhXpert 3 жыл бұрын

@@rvgiri I also have same problem

@rvgiri 3 жыл бұрын

@@TekhXpert might be it will come in next monthly update

@M.A.Sammani 3 жыл бұрын

She deserve a PhD . The world professor of EXCEL. Thank you.

@patrickdavid9823 3 жыл бұрын

She's interesting to watch also... unlike some videos with content but lacks spice

@SteveSwanson999 Жыл бұрын

Extracting the Table of Contents example was a big winner. Lots of info on combining multiple PDF's, next to nothing on this equally important use case...THANK YOU!

@LeilaGharani Жыл бұрын

Glad it was helpful, Steve!

@dodettesky2587 4 ай бұрын

Amazing! This is the only video I've seen that shows clearly how to extract multiple pages of a pdf with Power Query. Thank you so much, Leila! This video made me subscribe😃

@LeilaGharani 4 ай бұрын

Yay, welcome aboard!

@ThankYouAYODHYA 3 жыл бұрын

If I had seen this last week. It would saved me 8 hrs. I am on your proud PQ student.

@TylerStanczak 3 жыл бұрын

This is extremely helpful! Going to take this approach :)

@LeilaGharani 3 жыл бұрын

Glad to hear that :)

@navisalomi 3 жыл бұрын

Thanks Leila as always for bringing us up to speed with the latest Excel tricks and tips.

@husnainidreesia 3 жыл бұрын

You are helping thousands of computer operators God bless you Leila 🌹

@johndabbas2505 3 жыл бұрын

Leila you're a life saver. Love your articles and presentations. One minor comment though. I don't think report is commonly pronouced as ree-port but report as in resort. Keep up the good work.

@kiwiesp 2 жыл бұрын

Americans...

@chh8860 3 жыл бұрын

Coffee w/Leila continues … (Maryland - 5:15AM) Another disappointment … how Leila has not been awarded the Noble Prize in Education … for the content and clarity of her training videos … 😒 Once again … an effortless presentation of substantive content … which leads to several ideas popping in my head like fireworks. Thank you … thank you … thank you.

@LeilaGharani 3 жыл бұрын

Haha, you're too kind. Glad I could spark some ideas :)

@SLouadah 3 жыл бұрын

You are a god send Leila. If I knew this a year ago, I would have been muuch faster to gather data at my last internship. Thank you for sharing this. Keep up the great work!

@LeilaGharani 3 жыл бұрын

You're very welcome, Sofiane!

@al-aminmollah7650 3 жыл бұрын

Exactly what I am searching for long long days. I did this till today with a software then VB. Thanks a lot.!!!

@adij3224 3 жыл бұрын

People who have disliked this video, I wonder what’s going through their heads. This is a brilliant video...

@LeilaGharani 3 жыл бұрын

Thank you!

@GaneshKrupaDaamodaran 3 жыл бұрын

Seriously, even i wonder. What is there to dislike?

@user8ZAKC1X6KC 3 жыл бұрын

I suspect that it's because not everyone gets access to these features at the same time. So you watch the video and try to do it, but you can't and then you spend a bunch of time trying to figure out why, to find out that this feature just hasn't been rolled out to everyone yet. I think she is subscribed to the beta testers group, so she gets access to things before the rest of us. I think this is the third or fourth video that I have watched where my version of Excel doesn't have the functionality she is demonstrating. It would be helpful if at the beginning, where she says "this is where the feature is located" if she added something like, "This feature hasn't been added for all users of excel at this time, if you don't see it here, you can't do this yet and there is no way for you to add the feature." It's not a bad video, but people only have so much time, so knowing something like that upfront would be helpful for the less savvy excel users. Also some people just dislike stuff and I don't know why. 28 isn't really all that bad.

@Cysecsg 3 жыл бұрын

They are efficiency haters. They prefer to look and copy manually.

@apidraiceboy305 3 жыл бұрын

@@LeilaGharani Don't get offended ma'am. I think the dislike button was mistakenly identified by some as the download button. 😳 Maybe you can make a video for them to correct their mistake. 🤣

@omarathman42 2 жыл бұрын

Hi Leila...am following your tutorial. Am amazed by how you put the recipe together. Now, have checked in the power query "Get Data" I can't see where you can convert to PDF but the rest are there ie Folder etc. Does PDF need to be downloaded in the query or anything to do with administration control?? Am using Microsoft 365

@minalshetty5762 Жыл бұрын

I AM ALSO FACING THE SAME PROBLEM. It is not giving me an option to extract from 'PDF'! All other options are there except pdf.

@STLTHMC 11 ай бұрын

Same - on the Data Ribbon, I have all of the various file type option, but there is no Get Data Drop down, which is where one should find the PDF file type. I've looked all over MS help etc, to see why my Excel 2016 Professional does not have this feature enabled, but I cannot find anything to help fix or enable the Get Data drop down on the Data Ribbon.

@clarencestevens2462 3 жыл бұрын

Thank you!!! After years of trying different PDF to Excel converters for my Clients bank statements, this method works flawlessly! Another awesome video. Thank You!!!

@LeilaGharani 3 жыл бұрын

Glad it helped, Clarence!

@chriswall4795 3 жыл бұрын

Really useful. In the content list example, the section numbers in column one need to be text initially, not decimal. Acommon misconception as 2.9 needs to precede 2.10 so 2.1 to 2.9 need to become 2.01, 2.02 etc.

@deepaknarde 2 жыл бұрын

Thanks, Leila for the wonderful topic. As said by all the buddies it is a very important thing to get pdf table to excel. But when I tried with the function I didn't find the option of pdf in Get Data->From File-> "PDF" is not available in the list. Please help, how to get the same in the list 🙂

@sanjeevakumar5602 2 жыл бұрын

Same Problem for me

@jami677 2 жыл бұрын

For me....it was an add on....a PDF to Excel Converter Tool that I had to request access to thru my IT Dept at work. They said it requires a special license to give access to it, so not everyone in my department has it, and no one has it by default. Only those that request it can get it based on our departments budget and willingness to pay for it.

@gracemungkaje4333 2 жыл бұрын

I had the same problem because seems like both you and I have older versions of Excel. I believe this feature is available for Office 365 users. License is $99 USD/year.

@rohanshah3890 3 жыл бұрын

I don't have the "From PDF" option in my Get Data Tab

@jerry171460 3 жыл бұрын

Try from file then from PDF.

@guillermolagos2609 2 жыл бұрын

Dear Ms. Leila Thank you for your practical tips and educational videos. All the very best to you in 2022.

@Nagaraju-il9ed 2 жыл бұрын

I do trade documents checking...your vedios of converting pdf to word helpful to me..to do my job fast...usually documents checking done through taking print outs..its been difficult while working from home without printout....it helped me a lot

@anaana5688 3 жыл бұрын

It is a wonderful feature, I am trying hard to have in my Excel. While I am using Office 365 too - the latest version, I tried to uninstall and re-installed (today) - and repair , but I could not find this feature "File Import PDF' under DATA, Leila - any suggestion or advice , for me to get this feature? Thanks in Adv

@anaana5688 3 жыл бұрын

resolved with MS support help

@omarathman42 2 жыл бұрын

@@anaana5688 how did you do it with MS??

@nijuichi21 3 жыл бұрын

Hello Leila. I can't find the "from pdf" selection in the get data from data tab.

@mukeshkannan7837 3 жыл бұрын

i can't see it as well.

@alanmonaghan9194 3 жыл бұрын

I think it's only available in the 365 Insider version. At least, it is in mine.

@gregbernard7861 3 жыл бұрын

Same here - I don’t have insider version though.

@onkarshinde4424 3 жыл бұрын

This is available in excel 2019

@ricebowl8393 3 жыл бұрын

U need office 365

@vijaygusain119 3 жыл бұрын

You never fail to surprise me...One of the Dpts. is badly struggling with pdf files but now I am gonna be a hero for them💪

@LeilaGharani 3 жыл бұрын

YAY 🔥

@henriques.95 2 жыл бұрын

OMG. This is really a life safer. I did my work appending my queries, but this is so much easier and practical!

@IhabLotfi 3 жыл бұрын

Unfortunately, I do not find "import from PDF" option in my "Get Data from File" sub-menu

@andregv1993 3 жыл бұрын

Me neither

@Vincent_Koech 3 жыл бұрын

Me neither Excel 2019

@burningbush2322 3 жыл бұрын

I believe it was introduced in the latter part of 2020. Probably need the latest O365 version update.

@exhibitionlevel 3 жыл бұрын

Neither do I. But I found some kind of workaround that could work in some circumstances... open the PDF with Word, then select the table and copy/paste it into Excel.

@xubairaca 3 жыл бұрын

i have this , i am using excel 365

@MarcoTorres4given 3 жыл бұрын

Hi Leila when I try to get data I don’t see pdf as a source. Am I missing something

@ricebowl8393 3 жыл бұрын

Office365?

@onkarshinde4424 3 жыл бұрын

Download MS office 2019

@majidahmad1593 3 жыл бұрын

@@onkarshinde4424 I have office 2019 but PDF option is not available.. Any help?

@majidahmad1593 3 жыл бұрын

@@onkarshinde4424 PDF option is on Microsoft 365 not on Microsoft 2019

@wilidi4108 3 жыл бұрын

This presentation simplified Power Query. I love it. Thanks so much, Leila.

@LeilaGharani 3 жыл бұрын

You're so welcome!

@kishoremba5058 Жыл бұрын

She is my Guru.Thank you Leila Gharani for all the videos you post..

@areebasuhail3505 3 жыл бұрын

Hi, I am not getting “From Pdf” option. How do I enable that option? Please let me knkw

@alanmclean1399 3 жыл бұрын

You need to be logged in to your Office 365 subscription and open the desktop application (latest version) of MS Excel. Hope that helps

@richardcorel2471 3 жыл бұрын

@@alanmclean1399 I have the same problem. I have tried your suggestion, but it is still not giving me the PDF option. I am from the Netherlands. Could this be a regional thing?

@mlt3105 3 жыл бұрын

Same problem here, too.

@alanmclean1399 3 жыл бұрын

Richard, I’m in the U.K., so I presume I’d be the same region as you. I can only do it on my personal Office 365 account. My work Microsoft enterprise excel does not work, but the version on excel seems to be older. I don’t know if that is any help.

@richardcorel2471 3 жыл бұрын

@@alanmclean1399 Thanks

@hariomgupta4677 3 жыл бұрын

Hello ma'am my power query not show import pdf option I m using ms office 2019

@staypositive4358 3 жыл бұрын

Its probably only for 365 users. I don't have it either but its nice to know that its available in case I want to get it.

@nibalalshacker7488 3 жыл бұрын

@@staypositive4358 Hello, I have 365 but still It does not have this option. Can someone tells us how to add it? This is a huge time save. Thanks!

@staypositive4358 3 жыл бұрын

@@nibalalshacker7488 . That's weird. Good luck!

@owenw7178 3 жыл бұрын

@@nibalalshacker7488 Your company may not have this feature installed as part of its 365 updates roll-out. I don't have it on 365 either.

@Mabunana 3 жыл бұрын

I believe you don't have any idea what this has saved me, time! This is very incredible. Thank you so very much for this.

@LeilaGharani 3 жыл бұрын

You're very welcome!

@muhammadrashidkhan2332 Жыл бұрын

dear roses for you as token of honour u r my mentor since long and i recommend so many them that Leila style is very simple and focus no more unnecessary arguments, keep it up dear

@husammazahreh5133 3 жыл бұрын

Good day Leila; I do not have "from pdf" when I go to Data/from file/ is there addon to get from pdf? Your videos are great;thanks

@skysilva898 3 жыл бұрын

same, i don't have PDF option. Is it because of Excel version? or PDF must have special conversion access?

@s.y.daniel2137 3 жыл бұрын

same here, no such option from GETDATA

@lukebaker3164 3 жыл бұрын

me too

@babaktftf8925 3 жыл бұрын

me too

@giocarloaleta4199 3 жыл бұрын

Up for this no "get data " option for Excel 2013 ver

@Vgpratham 3 жыл бұрын

I could not find option to select PDF file in >Get Data>From File. I am using Excel 2016, however I do not find option for power query

@wardaddyB¹² 3 жыл бұрын

Same issue here

@MdAlAminosi 3 жыл бұрын

* import from PDF is only available in Microsoft 365 *

@STLTHMC 11 ай бұрын

@@MdAlAminosi ah, well there's the answer. Dang. I have 2016 and no desire for a subscription 365. Oh well, I have to find a different solution then. Thanks for the answer.

@Viazm 3 жыл бұрын

Fantastic video. Leila, THANKS a lot. You have a great talent for explaining. It is a great pleasure to watch your videos and listen to your explanations.

@LeilaGharani 3 жыл бұрын

Thank you, Oleg! 😃

@Islamicstudy325 3 жыл бұрын

Hello Leila. You explain excel better than anyone. It has made my work life easy. I hope that your You Tube channel gets more success which you really deserve.

@LeilaGharani 3 жыл бұрын

Wow, thank you!

@prashantrawat6738 3 жыл бұрын

How to import from PDF in old versions like 2016, 2019?

@staypositive4358 3 жыл бұрын

Buy Excel 365.

@glenroy1410 3 жыл бұрын

That is just great. I, only last month, was converting bank statements into excel using adobe. Sheer torture! Thank You.

@anasdabbar 3 жыл бұрын

excel is a really complicated piece of software, unlike most people who just put names and numbers think. thank you very much for the amount of effort you're putting into these videos.

@LeilaGharani 3 жыл бұрын

You're very welcome!

@JoshuaC0rbit 3 жыл бұрын

I love your videos. I had a project with some really oddly formatted reports in PDF that needed to be ingested into a data warehouse. There were TEAMS of people working on a solution. Very talented folks, after 2 years we gave up. I'm curious if you'd be stumped as we were. Edit: If you have multiple PDF reports with the same formatting you can use a tool like Nuance PDF converter which does a pretty decent job at converting to a spreadsheet or other office format. Good tool if you have a large batch to convert.

@TAHIRUDDIN21094 3 жыл бұрын

Nice to see you... All of the tips and tricks work efficiently. Thank you for your efforts.

@krn14242 3 жыл бұрын

Wow, great video Leila. Power Query is so flexible.

@realtoast7036 2 жыл бұрын

This is so good and useful. I find myself exporting PDF to Excel frequently - and almost always a mess with a ton of refinement work required. Thank you!

@LeilaGharani 2 жыл бұрын

Glad it was helpful!

@anurag8091 2 жыл бұрын

Which version office support get data option?

@jonasfermefors 3 жыл бұрын

A+ for this one. The table of contents example was superb in showing the power and possibilities and taught me things I can use in other PowerQuery imports.

@LeilaGharani 3 жыл бұрын

Thank you. I'm very happy to hear that!

@ammarqaqa3155 3 жыл бұрын

All these time i have seen this option only in PowerBI until you show this..This is awsome❤

@venkatiyer7459 3 жыл бұрын

Good addition to your Office 365 ...I thought you'll show the ways for my office 2019 .... anyways learnt an useful thing from you and that too updates dynamically ... thanks

@pankilpatel9244 3 жыл бұрын

Awesome....i mean i used powerquery for getting data from files, database etc but never observed there is option for pdf....its gonna help me a lot...thanks a ton

@vijayarjunwadkar 3 жыл бұрын

PDF = "Perfectly Demonstrated Feature" by Leila! 😁Yet another video with just the right examples and enough duration to get across the point! Especially liked the feature of appending tables by selecting the top folder in Navigator! Didn't knew that! Thanks! 😊👍

@georgepf4435 3 жыл бұрын

Thanks Leila🔥🎉, it's a superb tip. Never know this before. Thanks so much, this is going to help me and my team immensely

@LeilaGharani 3 жыл бұрын

You're so welcome!

@Kunalindia3 Жыл бұрын

Excellent explanation, as always! Simple, subtle & crisp!!

@matthewfagence9839 3 жыл бұрын

Fantastic, thanks heaps. Leila, you explain things so well! You are an amazing trainer 👍

@LeilaGharani 3 жыл бұрын

Thank you, Matthew! 😃

@gregoryjohnston4116 2 жыл бұрын

Thank you so much. You have literally saved me hours of work every month with this :) You deserve a trophy

@LeilaGharani 2 жыл бұрын

Great to hear, Gregory!

@omarfaruq3849 3 жыл бұрын

Most effective and efficient way which was unknown to me. I have learnt lot of things from your regular video. Thanks for sharing knowledge and help us to work smoothly. ❤️

@LeilaGharani 3 жыл бұрын

Glad it was helpful, Omar!

@pressurizer1 3 жыл бұрын

Bountiful thanks for making this video; it unshackled me from the burden of PDF-to-Excel conversion.

@LeilaGharani 3 жыл бұрын

Glad it was helpful!

@einyv 2 жыл бұрын

I can listen to you say "data" all day long! Another helpful video.

@simpleexcelexamples9619 2 жыл бұрын

Thank you so much! I had a student asking me a question about this but I could not answer because I had never done this before. Very useful 😊

@richardhay645 3 жыл бұрын

Great video. For me this vastly increases the usefulness of PQ. As I have said previously STICK TO EXCEL. Forget Sheets!

@zubayrbhyat8077 3 жыл бұрын

Love your passion for Excel. Good stuff, Leila.

@LeilaGharani 3 жыл бұрын

Thank you!

@tinako Жыл бұрын

Thank you girl you really saved me , appreciate you 🙌🙌🙌🙌 I was figuring out for a month how to transfer bank statement into excel from PDF

@Ajayuzi 3 жыл бұрын

Thank you for the video! My debt to you is growing. Particularly like the part where you clarified how you can combine multiple tables so you just have to do one query transform like you would look to do in combining multiple Excel files. Was running separate queries :/

@LeilaGharani 3 жыл бұрын

Glad it was helpful!

@prasannawarnasuriya969 3 жыл бұрын

thank you Leila for suggesting using Power Query to import from pdf..... I never would have thought of it....great advise..thank you. Prasanna

@LeilaGharani 3 жыл бұрын

Glad you like it!

@LOSURFNDANCE 2 жыл бұрын

Thank you Leila! This tutorial is very well explained and it will save me so much time at work! Thank you so much

@joelhodes1619 3 жыл бұрын

This is a very powerful feature, and very well explained. Thanks.

@orlan7290 2 жыл бұрын

Thanks a lot Leila. You're so kind and great for helping us to gain additional information...more power...

@lorenadenicolo7621 2 жыл бұрын

You’re a life saver! Thank you for being such a great teacher!

@emkar7 3 жыл бұрын

Great work! Leila. Keep going. I always find something new to learn.

@GeorgeKlucsarits 3 жыл бұрын

Great examples and very timely! Thanks.

@petermoorhouse5994 3 жыл бұрын

Very grateful for all your videos, fantastic work, looking forward to more

@LeilaGharani 3 жыл бұрын

So nice of you, Peter.

@MrSupernova111 2 жыл бұрын

Amazing! I don't know why I haven't been doing this all along! Thank you!!

@mmc9305 3 жыл бұрын

Brilliant! Thanks for sharing your knowledge.

@xiajunjim 3 жыл бұрын

Wow, this video is awesome! Never imagined PQ works on PDF as well! THANKS!

@LeilaGharani 3 жыл бұрын

My pleasure!

@Rosiechen2018 2 ай бұрын

This was exactly what I was looking for! You’re the best!

@LeilaGharani 2 ай бұрын

Happy to help!

@JaskyVerse 3 жыл бұрын

I don’t know how this randomly came to my KZfaq feed but this is a very useful video for me last year I needed to match invoices amount from my customer pdf file with the amounts in my excel and I had to use a pdf to text app which took a lot of time , thanks for this one I didn’t know this could also be done .

@LeilaGharani 3 жыл бұрын

Awesome! Thank you!

@kutzencop 3 жыл бұрын

Thanks, Leila for teaching how to use this functionality.. This is great. I have one question. I have a table in a PDF that has the headers spread over the first two rows. Is there any way to combine those first two rows so that the headers are in one row - say a two-line entry in each cell?

@marjovdn 2 жыл бұрын

Brilliant! I always use an online converter or use export to Excel from Adobe Acrobat DC but neither comes out right often and requires manipulation. I'll start with this straight away. Thanks you!

@felipelandim2881 3 жыл бұрын

Thank you very much! Every time I searched, it was a video showing a web PDF-to-excel converter.

@LeilaGharani 3 жыл бұрын

You're very welcome, Felipe!

@rashidfaridkhan2664 11 ай бұрын

Excellently Explained.. Thank you Leila..!

@partymaschine92 3 жыл бұрын

Thanks, Leila, for sharing this nice new feature from power query! Though a little hint: I would rather use another data type for the number column, because in this case 2.10 sticks to 2.10 and won‘t be transformed to 2.1. Or is there another cool way for a workaround?