Can we Extract ZIP file via Excel Power Query.

[AJ_121]

Dear,
i have a file path which has .Zip file and When i open that .Zip inside that i got a .CSV file which data i need.
another i have a file path which has .CSV file and i need to combine both .Zip file CSV File and this one.

But i am stuck because i am unable to download that zip file via power query and when i try then it comes in different language/Format.



Kindly help to download the data of zip file..

Any help will be appreciated.

Thanks.

 

[AJ_121]

all is described under link post#2 . i can say nothing more except post image with steps order

Thank you dear.

 

[sandy666]

you are welcome

just in case

 

[AJ_121]

all is described under link post#2 . i can say nothing more except post image with steps order

Dear,
I have downloaded a dummy data file from internet and tried here in attached image to Unzip that dummy file but again failed.

Could you help?
and if i am doing any mistake please try to correct it.

Thanks.

 

[sandy666]

first check if zip file is blocked or no

unblock and try again

or try with my zip file: TinyUpload.com - best file hosting solution, with no limits, totaly free

 

[sandy666]

or even try with this excel file after you download DummyData.zip

s666-PQ-unzip file.xlsx

Microsoft Excel Workbook

1drv.ms

(excel file should be downloaded first and saved on your computer)
change path to the file in Source step of course