Importing CSV file from a website url

[mukuljain99]

Hello,

I'm trying to import a csv file from a website url, I tried using data ribbon > From web and it opens a pop up to open or save the csv file.

Is there a way to import the csv details to workbook instead of open/saving it from the download popup.


This is the link I'm trying to download the csv file from: https://www1.nseindia.com/products/c...vdata_full.csv


EDIT: I want the data to refresh when I do refresh all as that csv file updates daily.

[Olly]

You can use Power Query:

Please Login or Register  to view this content.

[Marc L]

Is there a way to import the csv details to workbook instead of open/saving it from the download popup.

Hi, as a reminder : directly like when you open a local workbook ‼

[mukuljain99]

You can use Power Query:

The code worked, thank you so much!

EDIT:
One more question:
Will the data refresh when I refresh the worksheet tomorrow? the file in the url is dynamic and changes daily.

[Olly]

Yes, the data will update whenever that query is refreshed (including Refresh All)