Excel – Open a .csv file in Excel and have it update whenever .csv file changes

csvmicrosoft excel

Hi I'm working with some web scrapping and the data on my csv files will be constantly changing. I want to open these files on Excel to view and also have it refresh whenever the csv source changes too.

Is this possible?

I have the 2013 Excel version.

Best Answer

Here are the steps to get an automatic refresh from the csv file:

  • From a blank work select "From Text" in the "Get External Data" section of the Data tab
  • Use the Text Import Wizard to set how your csv file will be imported.
  • After you select Finish to exit the Import Wizard, a dialog box titled Import Text will come up.
  • Select the Properties button on this dialog box.
  • An External Data Range Properties box will come up.
  • In the Refresh Control section of the box, you should uncheck the "Prompt for file name on refresh" selection, set the frequency of refresh in minutes, and make sure there will be a refresh when you open the workbook.

You can return to the Properties box anytime by either right-clicking on the imported data in the worksheet or selecting "Connections" from the Data tab.