If you have Office/Microsoft 365 and don't see the PDF connector then you need to update Office. Find out how to get the latest updates here: support.microsoft.com/office/da36192c-58b9-4bc9-8d51-bb6eed468516
@AbidAli-sc1lm4 жыл бұрын
in my office 365 i dont have option of get data from pdf. please help :(
@Viazm4 жыл бұрын
@@AbidAli-sc1lm try to install all of upgrades of your windows 10.
@Viazm4 жыл бұрын
@@AbidAli-sc1lm and next install all of upgrades of your Office 365
@georgeschmidt82284 жыл бұрын
I'm running Version 2002 Office 365 ProPlus Build 12527.20988 and I am not seeing a PDF option under Get Data under Data. It does say that I am up to date as of 9/3/2020. Any additional thoughts?
@Viazm4 жыл бұрын
George Schmidt and your windows? is it up to date?
@JohnOvens4 жыл бұрын
Thanks, Myanda, this is an excellent video. I completed your Power Query Course in 2016. I am now fully retired but have maintained an interest in EXCEL and each week I receive a PDF file from a data provider that I need to put into a data table for my SMSF. I developed a VBA program to analyse the data once I have placed the data in a Table. I will try and use Power Query to do this step as it could be a time saver. Thanks again. The course was excellent and I would recommend it as it is the future direction being taken by Microsoft.
@MyOnlineTrainingHub4 жыл бұрын
Thanks so much, John! It's lovely to hear that you found my course valuable. Enjoy your retirement :-)
@TheKnowledgeable4 жыл бұрын
I think if I watch your videos daily I will become a native English speaker 👌and thanks again for the upload
@MyOnlineTrainingHub4 жыл бұрын
:-) and good at Excel!
@excel-businessinexcel51814 жыл бұрын
What a nice woman! Very homely, cozy. I think you're a good mom. The children were very lucky. I wish you happiness! Oh, Yes, we talked about Excel...
@MyOnlineTrainingHub4 жыл бұрын
Thank you so much!
@bigtall81994 жыл бұрын
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!
@MyOnlineTrainingHub4 жыл бұрын
Great to hear, Stephen :-)
@CeliaBabayalo5 ай бұрын
Thank you so much, the technique will help me so much. I did not know Power Query would be able to identify pages with tables and separate them from pages with text. super-amazing👏👏
@MyOnlineTrainingHub5 ай бұрын
Glad it was helpful!
@NelCapeTown2 жыл бұрын
Thank you very much for a clear and concise tutorial. I'm going to try it myself now with a bank statement.
@MyOnlineTrainingHub2 жыл бұрын
Great to hear!
@Salriaraj202 жыл бұрын
Thanks for the nice presentation, in case the excel navigator is showing pages on left and on Right hand side it shows page is empty? any Advise. Thanks
@MyOnlineTrainingHub2 жыл бұрын
Not sure what you mean by navigator showing pages on left and right is empty. Please post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum
@OwMyHip4 жыл бұрын
Thank you so much for this video! I have needed this so many times and it'll be so nice to actually have a solution for the next time I need it.
@MyOnlineTrainingHub4 жыл бұрын
So pleased you can make use of it!
@wayneedmondson10654 жыл бұрын
Hi Mynda.. great tutorial. Glad to see this functionality now included within Excel. Thanks for the lesson. Thumbs up!
@MyOnlineTrainingHub4 жыл бұрын
Thanks for watching, Wayne!
@nazarkamal883110 ай бұрын
Not only getting idea for importing pdf n also to work in PQ in another dimension thanks 👍
@MyOnlineTrainingHub10 ай бұрын
Awesome to hear!
2 жыл бұрын
Thanks, very much, I have this issue, I have different pdf files, these have different pages and tables, it may be possible to get the names of the queries so my query does not fail, since the files differ in pages and tables and my query fails
@MyOnlineTrainingHub2 жыл бұрын
Hi Jose, I think you'll need to create a separate query for each PDF and then append the queries together to make one table.
@hrushikeshumalkar18304 жыл бұрын
Mind-blowing and amazing tricks you have👏. Loved to watch this 😁😀😀
@MyOnlineTrainingHub4 жыл бұрын
Glad you liked it :-)
@monte49554 жыл бұрын
Thanks Mynda. So much flexibility with power query. Never thought of doing this with pdf. Appreciate you sharing. 👍
@MyOnlineTrainingHub4 жыл бұрын
Glad you found it interesting, Monte :-)
@DougHExcel4 жыл бұрын
Glad MSFT finally GA'd this feature, thanks for the video!
@MyOnlineTrainingHub4 жыл бұрын
Me too :-)
@1566154 жыл бұрын
Minda, do you have a power Query Power BI "101" --> video , I am a complete beginner on these two.
@MyOnlineTrainingHub4 жыл бұрын
Hi Amrish, I have a Power BI video here: kzbin.info/www/bejne/eKS7nZx-l7R5eq8 and here: kzbin.info/www/bejne/hZeVfn9sic-ed6s You might also be interested in my courses: www.myonlinetraininghub.com/power-bi-course and www.myonlinetraininghub.com/excel-power-query-course
@IvanCortinas_ES4 жыл бұрын
Powerful!!! Thank you for the video. The same option extrapolated from Power BI to Excel. Thank you Mynda!
@MyOnlineTrainingHub4 жыл бұрын
Yes, Excel eventually gets everything Power Query in Power BI has!
@Fal011004 жыл бұрын
Thanks fr much needed video👍👍👍
@MyOnlineTrainingHub4 жыл бұрын
You're most welcome, Mobi 😊
@shakiraasfoor75994 жыл бұрын
Well Done Mynda All Your Videos Are Useful
@MyOnlineTrainingHub4 жыл бұрын
Thank you! 😃
@mic093013245923 жыл бұрын
What Excel version is this? There's not Get Data tab on Excel 2016. It only shows From Access, From Web, and From Text.
@MyOnlineTrainingHub3 жыл бұрын
This is Microsoft 365. You won't have From PDF in Excel 2016, sorry.
@19LloydG4 жыл бұрын
Another brilliant presentation, thanks. The functionality of Excel is very impressive! Wow!
@MyOnlineTrainingHub4 жыл бұрын
Glad you liked it, Lloyd!
@jaehochoi80624 жыл бұрын
Super great amazing tutorial! I spent hours on getting data from pdf last week with csv things.
@MyOnlineTrainingHub4 жыл бұрын
Glad you'll be able to use it, Jaeho!
4 жыл бұрын
Great lesson. Clean and straight forward. All in all good quality as always. Thank you for sharing your content.
@MyOnlineTrainingHub4 жыл бұрын
Thanks for the compliment, Philipp!
@the_starlinkway78213 жыл бұрын
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?
@Lotus03057 ай бұрын
How could I select and append different tables from different files at the same time? Scenario: Select Tables 4, 13, 16 and 19 from pdf.files 1,3,5,7?
@peterhkoller Жыл бұрын
Thanks for the video, why can I not reformat the cells i.e. insert currency symbol and insert formulars to add up columns etc.
@MyOnlineTrainingHub Жыл бұрын
My pleasure, Peter. Sounds like the data is formatted as text and not a number. Please post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum
@chrism90374 жыл бұрын
Very useful, thanks Mynda!
@MyOnlineTrainingHub4 жыл бұрын
Cheers, Chris!
@alexsonga47424 жыл бұрын
Very insightful.Thank you
@MyOnlineTrainingHub4 жыл бұрын
Cheers, Alex!
@davegoodo36034 жыл бұрын
This is an interesting video for me, PDFs and Excel have been a nightmare in the past. Power Query is the answer, and it is a feature I’ll need to get a lot more comfortable with, thanks for the presentation Mynda, really good.
@MyOnlineTrainingHub4 жыл бұрын
Glad to hear you're liking Power Query more and more these days, Dave :-)
@mrprakashraobs Жыл бұрын
Madam, I am re-framing my question I have Multiple PDF file in one folder, in some PDF when I see in Power Query it shows as Table 3 and for some PDF it shows the same content in Table 4. so importing becomes problem if I select the sample from table 3 then only data from all pdf from table 3 will be considered for processing. one common thing I have is table has one column Name as " LineNO". First I should find if PDF has a table having the column as LineNO if Yes then consider that as the table to process and move to next PDF and do the same process So Importing of Table having Column Name as "LineNo" is the condition that to be passed before Transform.
@MyOnlineTrainingHub Жыл бұрын
Please post your question and sample Excel file on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum
@claudiosilva76974 жыл бұрын
Very nice tip and Excellent explanation. Thanks a lot.
@MyOnlineTrainingHub4 жыл бұрын
So nice of you, Claudio!
@seanvb932 жыл бұрын
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
@MyOnlineTrainingHub2 жыл бұрын
Hi Sean, I haven't tried multiple tables from multiple PDFs, but I know you can get multiple PDFs that all have the same structure with one table from a folder. You'd have to test it for multiple tables, but I would have thought so.
@Horseinacorset Жыл бұрын
So I've set up a Power Query from a PDF, which involved quite a lot of tidying! We have an old system that provides messy PDF outputs for data, and I'd like to add new PDFs and get Power Query to do the same applied steps every time, so I can feed it new PDFs and get clean outputted data as separate tables. Is this possible?
@MyOnlineTrainingHub Жыл бұрын
Great to hear. You can copy the query and edit the file name it’s referencing to the new file.
@chandanthesingh34 жыл бұрын
hi there... great video... But is the option of get data rom pdf available only in O365 or is it possible in older versions too.. pls advice how to do it... thanks
@MyOnlineTrainingHub4 жыл бұрын
Only available in O365.
@suki98602 жыл бұрын
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.
@MyOnlineTrainingHub2 жыл бұрын
Yes, you'd be able to extract that data and then feed it into the Pdf.Tables formula. I don't have any examples of this I can point you to though.
@suki98602 жыл бұрын
@@MyOnlineTrainingHub Thanks, Mynda!
@lillithdv84 жыл бұрын
Hi, I use Excel on a Mac, do you know the nuances regarding Excel PC vs Mac? Like the shortcuts? Thank you (your channel is super instructive and easy to follow)
@MyOnlineTrainingHub4 жыл бұрын
I don't have a Mac, so I'm not up to speed on all the shortcuts, sorry.
@lillithdv84 жыл бұрын
@@MyOnlineTrainingHub Oh, well that's ok. Thank you for replying
@KrazyMO2 жыл бұрын
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?
@MyOnlineTrainingHub2 жыл бұрын
You can just copy the Excel file containing the query and change the PDF file it's pointing to.
@Lotus03057 ай бұрын
Hi, Excellent video. However, I was wondering how to append pages that are not continuous?
@MyOnlineTrainingHub7 ай бұрын
In the Navigator dialog box, check the option to select multiple tables and then select the pages or tables you want.
@Lotus03057 ай бұрын
@@MyOnlineTrainingHub Thanks! I appreciate your reply.
@leorc5643 жыл бұрын
Another excellent video, nice voice and volume yo explain Power Query, muy claro con tus vídeos Mynda, congratulations! I am learning good!
@MyOnlineTrainingHub3 жыл бұрын
Thank you! 😃
@talredgc98093 жыл бұрын
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.
@MyOnlineTrainingHub3 жыл бұрын
Upon connecting to the PDF there should be a setting to automatically selected related tables, or something to that effect.
@johnrschmidt23 жыл бұрын
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.
@MyOnlineTrainingHub3 жыл бұрын
Hope it works out, John!
@calvinc8514 жыл бұрын
Fantastic video! Great Transformation!
@MyOnlineTrainingHub4 жыл бұрын
Thanks so much, Calvin!
@sauravkragrawal7 ай бұрын
In my PDF, I have 14 columns and 47 rows. I want to show each row in a single cell of power query so that the trailing spaces are not lost. Pls advise.
@MyOnlineTrainingHub7 ай бұрын
Please post your question and sample file on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum
@KM-co5mx3 жыл бұрын
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.
@MyOnlineTrainingHub3 жыл бұрын
There's not really a workaround. Might be best to look at some 3rd party software that converts PDFs to Excel.
@thebig_steel4 жыл бұрын
Omg, my team is going to make extremely good use out of this function. Thanks for bringing it to attention!
@MyOnlineTrainingHub4 жыл бұрын
So pleased to hear that, Jared!
@johnborg54194 жыл бұрын
Thanks Mynda. Very Helpful. : )
@MyOnlineTrainingHub4 жыл бұрын
Thanks for watching, John!
@habibsicttutorials66844 жыл бұрын
Fantastic information. I've enjoyed watching your informative video.
@MyOnlineTrainingHub4 жыл бұрын
Glad you enjoyed it!
@Sal_A4 жыл бұрын
The page range [PageStart=7, PageEnd=8] must be exactly in that format (with parenthesis, camel case followed by comma)? Is PageStart and PageEnd variables or built-in within PQ? Can I use something like [Pages=7-8]?
@MyOnlineTrainingHub4 жыл бұрын
Hi Sal, no, you must enter the page range in exactly that format. Power Query functions are case sensitive.
@basselzaki Жыл бұрын
the function "get data " is not appearing in my excel version . please advice
@MyOnlineTrainingHub Жыл бұрын
Check here for where to find Power Query in your version of Excel: support.microsoft.com/en-us/office/where-is-get-transform-power-query-e9332067-8e49-46fc-97ff-f2e1bfa0cb16
@namoranto2034 жыл бұрын
Thank you for this new added new learning.
@MyOnlineTrainingHub4 жыл бұрын
You're very welcome, Nestor!
@gyozakeynsianism4 жыл бұрын
This is great! What about OCR? Can Excel handle PDF documents that are scans?
@MyOnlineTrainingHub4 жыл бұрын
Excel Mobile has OCR for images. support.microsoft.com/en-us/office/insert-data-from-picture-3c1bb58d-2c59-4bc0-b04a-a671a6868fd7
@MissionHealth083 жыл бұрын
Yes ...I will try this in my job 👍
@MyOnlineTrainingHub3 жыл бұрын
Awesome 😊
@rezazadeh14224 жыл бұрын
Hi Mynda, the option for import from PDF is missing, I am using the 365 version of Excel do you have an idea why this is happening? TIA
@MyOnlineTrainingHub4 жыл бұрын
You just need to update Excel.
@youpedia96174 жыл бұрын
@@MyOnlineTrainingHub my 2016 excel is up to date and still not have the option ! what to do next ?
@Altvel13 жыл бұрын
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.
@MyOnlineTrainingHub3 жыл бұрын
Yes, Power Query can handle pdfs of multiple pages.
@anthonyaroni55304 жыл бұрын
Awesome. I've been exporting my PDFs to text and the connecting to Power Query. This should be better. I don't see this update on my work account. Is this only for personal accounts?
@MyOnlineTrainingHub4 жыл бұрын
All Office and Microsoft 365 license get this update. You probably need to run the update.
@oscar986532104 жыл бұрын
Nice tutorial!! If You Need some Quick solution without a connection with the PDF file, You can import the PDF file in Word and there there are all the tables that You Need! After that You only Need to Copy and paste on Excel and edit what You want!!
@MyOnlineTrainingHub4 жыл бұрын
Thanks, Oscar! The word method is a workaround for those without Office 365.
@signalmas56734 жыл бұрын
This will be very useful one day. . Thank you.
@MyOnlineTrainingHub4 жыл бұрын
Great to hear!
@countduckula99772 жыл бұрын
Hi, I just got a recent update Nov 2021 of O365 & sadly it seems that the option for getting data from PDF is no longer available. Do you know a workaround?
@MyOnlineTrainingHub2 жыл бұрын
It is still available, but perhaps you need to run an update on your installation and you probably need to be on the Current Channel.
@countduckula99772 жыл бұрын
@@MyOnlineTrainingHub I have Excel 2019 at home & the latest version of O365 Excel at work both have been updated within November 2021. Strangely both versions look the same when you go to the get data [option wise]. I hope Microsoft haven't withdrawn this PDF option. Thanks for the reply.
@pookieburntear2 жыл бұрын
My PDF is a scan of a table and the Power Query just says "no data in table". Thinking the quality of the scan isn't good enough for the software to recognize. Any way around this?
@MyOnlineTrainingHub2 жыл бұрын
Hi Carrie, Power Query can't read images in PDFs. You can try using Excel's new import data from a picture: kzbin.info/www/bejne/nGqXe32Ci8eNnrc Or if you don't have that version of Excel, you can try the free mobile app: kzbin.info/www/bejne/pJewp5Kuq7KGbac
@darrylmorgan4 жыл бұрын
Hi Mynda!Really Helpful Tutorial,It's Really Great We Can Now Import PDF Data Into Excel Using POWER QUERY..Thank You :)
@MyOnlineTrainingHub4 жыл бұрын
Thanks for watching, Darryl :-)
@shabinnazeer74124 жыл бұрын
Hi Mynda, I could not find from pdf option under from file, how to add that option there
@MyOnlineTrainingHub4 жыл бұрын
You need Excel for Microsoft 365 to have this feature, or Power BI.
@shakthiatukorala5954 жыл бұрын
My office version is office 365 proplus.but I don't have this option under get and transfrom..could you help me solve this..? Or why was it..
@MyOnlineTrainingHub4 жыл бұрын
Hi Shakthi, sounds like you need to update your version of Office/Microsoft 365: support.microsoft.com/en-us/office/when-do-i-get-the-newest-features-for-microsoft-365-da36192c-58b9-4bc9-8d51-bb6eed468516?ui=en-US&rs=en-US&ad=US
@Sai-jh5ti3 жыл бұрын
I am using Excel 2019 application in windows 10 I don't have option to get data from pdf . Can you please tell me how can I get that option?
@MyOnlineTrainingHub3 жыл бұрын
It's only available in Microsoft 365/Office 365.
@Russels_Viper2 жыл бұрын
I'm using this method to import data , but when i'm trying to refresh using a diff pdf having similar data , i'm getting errors as Power Query picks up diff tables than i want , kindly help. I liked and subbed by the way , excellent video.
@MyOnlineTrainingHub2 жыл бұрын
Power Query hard keys parameters based on the original PDF you import. If your new PDF has different tables and column headers, then you need to edit the M code accordingly.
@naseershaikh24144 жыл бұрын
I have installed Office365 but import PDF option it doesn't show kindly help me in this regard,thanks
@MyOnlineTrainingHub4 жыл бұрын
Hi Naseer, this feature is still in preview and only available on the Insiders channel: insider.office.com/join
@TheJoshtheboss4 жыл бұрын
Can we import data from MS Word doc too?
@MyOnlineTrainingHub4 жыл бұрын
Not yet, but you could save the Word doc as a PDF and then import it!
@TheJoshtheboss4 жыл бұрын
@@MyOnlineTrainingHub Of course 🤦♂️, should have thought of that 😁.
@mohdakber99303 жыл бұрын
Would be able to convert multiple pdf to one Excel sheet
@MyOnlineTrainingHub3 жыл бұрын
Yes, but it would need to be imported with a separate query for each PDF. You could then append/merge the queries if required before loading to Excel.
@swethetpaing45742 жыл бұрын
Can i use in Microsoft Excel 2019? I can't see From PDF in Get Data.
@MyOnlineTrainingHub2 жыл бұрын
No, it's only available in 365 and possibly 2021.
@boee20104 жыл бұрын
Thanks, al lot for your valuable information. Can you tell me, How I can add this option in office 2019?
@MyOnlineTrainingHub4 жыл бұрын
This feature is only available in Microsoft/Office 365 licences. It's not something you can add to Office 2019, sorry.
@boee20104 жыл бұрын
@@MyOnlineTrainingHub Thanks alot for your fast response
@mrprakashraobs Жыл бұрын
I have multiple excel in some excel data is available in table 3 and in some excel same data is available in table 4 . So how to transform both table? Pl support me
@MyOnlineTrainingHub Жыл бұрын
Difficult to answer without seeing the file, but can't you simply get all the tables and then filter out what you don't need.
@maxbernacchi4 жыл бұрын
I cannot see the command getdata from file->pdf.I have Office 365 of course. do you know why?
@MyOnlineTrainingHub4 жыл бұрын
You need to update the installation of Office to get the new PDF connector.
@shaikhdildarahmed7544 жыл бұрын
HI Mynda, I'm your silent follower and really like what you do. Power query is not been able to retrieve data from password protected PDF file. It is not getting forward; can you help me out please
@MyOnlineTrainingHub4 жыл бұрын
No, it can't open the file if it's password protected.
@benjaminplucker39084 жыл бұрын
i was wondering, where can i get one of those green excel notebooks?
@MyOnlineTrainingHub4 жыл бұрын
Not sure, Benjamin. It was a gift from the Excel team to us MVPs at the last Microsoft MVP summit.
@mehmetlok4 жыл бұрын
there's not pdf option in my ribbon.
@MyOnlineTrainingHub4 жыл бұрын
You need to update your installation of Office to get the new PDF connector.
@entertainmentwithkingshah9832 Жыл бұрын
hi maam i have question in my data option from file from pdf option is not coming
@MyOnlineTrainingHub Жыл бұрын
Sounds like you have an earlier version of Excel that doesn't have this connector. You'd have to upgrade to get it.
@johndurran6144 жыл бұрын
Another excellent video. Could you do an example where you transform financial statements from a set of published accounts?
@MyOnlineTrainingHub4 жыл бұрын
If you have some sample data I can use I'll add it to my list. You can email it to website at MyOnlineTrainingHub.com
@andrearaijin3 жыл бұрын
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.
@MyOnlineTrainingHub3 жыл бұрын
You can specify the tables you want to import from the PDF, or import them separately and then append the tables. If you get stuck, please post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum
@bobmartin74092 жыл бұрын
Darn, do not have the get data, rom file option??
@MyOnlineTrainingHub2 жыл бұрын
Bummer.
@adriennepierre77413 жыл бұрын
What version of excel are you using?????
@MyOnlineTrainingHub3 жыл бұрын
Hi Adrienne, Microsoft 365.
@dmk81563 жыл бұрын
Will this work with the on line version of excell?
@MyOnlineTrainingHub3 жыл бұрын
No, it's only available on the desktop as far as I know.
@chalkie2472 жыл бұрын
Why do I get "Table is Empty" error? Is it because the data was scanned to pdf?
@MyOnlineTrainingHub2 жыл бұрын
Scanned PDFs aren't true PDFs, they're images. You can use Import Data From a Picture instead: kzbin.info/www/bejne/pJewp5Kuq7KGbac
@rezayoun65714 жыл бұрын
hi tanks for this nice tutorial
@MyOnlineTrainingHub4 жыл бұрын
My pleasure, Reza!
@181hafsa3 жыл бұрын
I don't have pdf option!!! How do I get it there?
@MyOnlineTrainingHub3 жыл бұрын
You need 365 for this feature.
@abibeniam84254 жыл бұрын
What version of excel do you need to access this feature
@MyOnlineTrainingHub4 жыл бұрын
Hi Ben, you need Office 365 or Microsoft 365. I did say this at the beginning of the video :-)
@gopalashetty35923 жыл бұрын
the Get Data option is not there in my excel-2016.
@MyOnlineTrainingHub3 жыл бұрын
No, Gopala, it's only available in 365 versions of Excel.
@skvalparn4 жыл бұрын
This was great. Althogh could you make a video Where u do this with a financial report?
@MyOnlineTrainingHub4 жыл бұрын
Please share an example file you'd like imported with Power Query via our website.
@sheerazshafi86793 жыл бұрын
Plz help me, i have latest ms 365 but pdf import option r not showing🙄
@MyOnlineTrainingHub3 жыл бұрын
If you don't see it then you'll need to update Office. You may be on the semi-annual channel which only gets updates once per year. If so, you'll need to speak to your IT people. More on the different update channels here: docs.microsoft.com/en-us/deployoffice/overview-update-channels
@statisticalfish4 жыл бұрын
Can you help me to sort variable in a customised order.
@MyOnlineTrainingHub4 жыл бұрын
Please post your question and Excel sample file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum
@rashidfaridkhan2664 Жыл бұрын
Excellent 👍
@MyOnlineTrainingHub Жыл бұрын
Many thanks!
@clairezhang73514 жыл бұрын
Thanks for sharing. However it seems my office 365 does not have the function to get data from pdf😕. I can only choose from workbook, txt, xml etc
@mml80064 жыл бұрын
I also do not have the PDF selection available - I believe this feature is available only for Office 365 Premium
@MyOnlineTrainingHub4 жыл бұрын
@M ML, it's not tied to a license level. You just need to update Office. Find out how to update Office/Microsoft 365 here: support.microsoft.com/office/da36192c-58b9-4bc9-8d51-bb6eed468516
@MyOnlineTrainingHub4 жыл бұрын
@Claire Zhang, You just need to update your Office installation to get the new connector. Find out how to update Office/Microsoft 365 here: support.microsoft.com/office/da36192c-58b9-4bc9-8d51-bb6eed468516
@clairezhang73514 жыл бұрын
@@MyOnlineTrainingHub thank you Mynda. Unfortunately I have tried but still can't update my office 365. It says the update is managed by the company. I think I have to contact IT department. But thank you for the link.
@MyOnlineTrainingHub4 жыл бұрын
Yes, IT will have to do the update.
@sandyshum6287 Жыл бұрын
what if i only want page 7 and page 9, skipping page 8?
@MyOnlineTrainingHub Жыл бұрын
You can filter them out in the query editor.
@merbouni4 жыл бұрын
Hi Mynda, how can I extract words one by one without spaces for a specific text from cell to others? please, i found a solution but it's complicated, sure you have something better
@MyOnlineTrainingHub4 жыл бұрын
Hi Reda, I'm not sure what you mean. Please post your Excel question and sample file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum
@mosixtasalaouitas3376 ай бұрын
I manually imported tons of tables from pdf files in my work in the last 2 weeks and my boss found that I was taking too long to do the task. This evening I started to think there must be a solution to do this tedious task automatically and quickly, so I found out that Microsoft Office 365 can do this. I feel stupid for not having known this before.
@MyOnlineTrainingHub6 ай бұрын
Better late than never.
@alokscreation.923 жыл бұрын
PDF option not show in my excel
@MyOnlineTrainingHub3 жыл бұрын
It's only available in later versions of Excel.
@ayetinners4 жыл бұрын
Thanks, very useful
@MyOnlineTrainingHub4 жыл бұрын
Glad it was helpful!
@lakshanfernando66113 жыл бұрын
How can we convert 100 pages pdf. Pls send the email I'll send the document.. I have tried but not happen.
@MyOnlineTrainingHub3 жыл бұрын
I'm not aware of any limits to the number of pages so in theory it should work. Maybe test it on a smaller PDF containing the same data to see if it's the data that's the problem rather than the number of pages.
@lakshanfernando66113 жыл бұрын
@@MyOnlineTrainingHub hi madam can u send me the email address. I ll send that pdf to u... 😊
@aspect_ratio2 жыл бұрын
It's only available for Office 365 users. Yes. I save your time, you can now go look for different methods.
@MyOnlineTrainingHub2 жыл бұрын
It may also be in Excel 2021, but otherwise definitely not Excel 2019 or earlier.
@heikoheimrath75144 жыл бұрын
Great video 👏
@MyOnlineTrainingHub4 жыл бұрын
Cheers, Heiko!
@elhacenezekri71434 жыл бұрын
I have not this option in my office 2019
@MyOnlineTrainingHub4 жыл бұрын
No, it's only available in Microsoft 365 licenses.
@elhacenezekri71434 жыл бұрын
@@MyOnlineTrainingHub oh ok your are a you are a such nice person thank's