07 - Import Data from an Another Excel Workbook using Power Query

[@timesavertricks]

Hello Sumit Sir, Can we use power Query to combine data either from several workbooks Or several sheets from several workbooks. Also the important scenario is all data Has no relation with each other's. Actually I'm looking to import data from a total of 5 workbooks and approx more than 30 sheets. If there is a way to connect with you I can explain the requirement in more detail

[@deepakbabu1987]

Where do i get free excel sheet to practice myself

[@bikashkumarparida7595]

sir then its better convert your sheet in tabular form and then pull it back to power query

[@swapna_learner]

hallo Sumit, thank you for specific videos for each option in power query. On Excel workbook, does it allow to upload all types of excels like xlsb, xlsm, xlxs, xls and so on.

[@trumpexcel]

Yes it will allow other Excel formats as well

[@killerkamatis2243]

I cannot save the Source data.. saying its a share violation. help please.

[@jameshopkins6168]

Same thing for me. Checked google and followed their recommendations but nothing works,

[@BhuvanaChandran-k9j]

Hi Brother thank you for sharing valuable knowledge. Recently I followed your channel I need one help bro regarding power query excel pls help this case

[@rakhipawar2620]

Hello very useful info.. I will buy you coffee.. Can you let me know how we can import only specific columns into another sheet specific columns,. eg. from Sheet1 I want columns C-E to be import in Sheet 2 column F-H

[@vuquangminh4891]

Man. I just love Indian people

[@rubenvaneupen7327]

Is your channel name a reference to Excel for Dummies, as in Trump = a dummy? Or just a reference to the general meaning of to trump?

[@roseparis8101]

i have a question,if we connected the way you connect and we close the first Excel file the source is it will say error or smth like that , which mean that the source has been colsed the the Excel will not provide you the data ,is it true?

[@trumpexcel]

It should work even if the other file is closed

[@MayurAgarwalmayuragr]

Appreciate your efforts and free sharing of such invaluable knowledge in a poper manner. Small suggestion, if the things didn't get repeated in consecutive videos..

[@DoubleASir]

when i cllick on data it shows from access, from web, from text, from other sources but does not show from file or from excel..

[@Gorman-84]

Excellent!. Especially the showing of the two different methods to get the same info. Needed the first example to see how to update/change a "bad" query. Thanks again.

[@Swizzletwice]

Excellent presentation. Organized, to the point, well-explained. Thank you.

[@samirhavaldar590]

Thanks for the video. I can see the "Delimeter" and "Data Type Detection" options in one file but can't see in another file while importing the data from txt file. How to resolve? Please help

[@ritumaurya1399]

It is not working for more than 1000 rows, what formula we can apply for more than 10k rows?

[@NumanDurmaz]

I want to import multiple excel workbooks to separate sheets. how can I do that?

[@sumeetjagtap7647]

Can you please make some videos on how to import data from pdf and multiple tables in pdf. Pleaseeeeeeeeeeeeeeeeeee

[@ezgidenlu3248]

thanks a lot for your efford but have a question for another case related to that one. So I have that Sales Data file which we pull the datas to the other sheet in the video,ok. But lets say I also have another file which I just only have SOME of those item's name in it, not all of them. Imagine, I only want to pull quantity and price colum of those Items that I have in my file .How can we do that? I hope you would record a video of that case too or guide me . Thanks.

[@soseofficial3923]

How to do it in excel 2010?? Please reply sir

[@elenitheodosiou9728]

how can i get a single value from a cell without transfering the "collumn" to the second spreadsheet?

[@shabbiransari7584]

How to load data from a sheet consisting two different tables?

[@nvsarathy]

How to load a power query on an existing workbook?

[@tammystucki3152]

Does the source file have to be open for the destination file to update?

[@bitcoinbunker]

Massively useful, thanks for taking the time to create this!

[@et.sachin]

is it possible to create a macro to do this task?

[@purushottamsapkota7696]

You are one of a kind Sumit. Thats'f for sure.

[@venkyr81]

1 steps: showing how to add from a worksheet (not a table) was very useful. Thanks for that information. This is very useful as not all the data we use are in table format. Thanks once again.

[@Dream-tc4zp]

Sir, please provide the workbooks for practice also. Thanks 🙏

[@audiovideophile5317]

They are provided. There is a link to the downloads in the video description above.

[@saylsalcan2610]

Can we import only selected columns

[@carlinguervil3516]

Is there a way to do this on a Mac?

[@margad-erdeneboldbaatar4704]

Thanks so much.

[@windywave6283]

Thanks. Very succinct explanation and useful to a current project I'm developing.

[@murtazakazmi3800]

excellent

[@mandeepmanbajimaya7442]

Hi Sir, Thank you for your efforts. One issue I saw is when you changed the data type as percentage, in excel it was still shown as decimal. Is that normal? Another issue is my system date is DDMMYYYY format but while pulling data from text, I saw the format changed to MMDDYYYY. How to resolve it sir?

[@FRANKWHITE1996]

Thanks

[@kamalgupta5831]

Thank you sir.

[@seneysean]

Hi sir. Let's say, I have to add additional column (Ex. Status) as text. Whenever there is a change to the source like insert new rows in the middle or at the end, it shift the status that make record is not correct. Can you suggest the approach to fix it?

[@RohitSingh-nu7ek]

I have alternative blank rows I'm not able to import entire data. Power query import only upto 3 rows

[@axleo472]

Just wondering why % data type was not taken after you load the query, thanks!

[@ilyas3816]

Can totals only be transferred to another sheet ?

[@robbysandhu4425]

How to fetch data from Google sheet using Power Query?

[@anon7355]

How to do that with macOS?

[@akashmon5065]

Thank you sir