Click "OK" to run the macro. Excel imports the spreadsheet data into the table. Advertisement. Article continues below this ad. ... right-click your table and select "Open" to refresh its view.