How to Populate a Website From an Excel Database. Microsoft Excel worksheets are convenient places to store limited amounts of data. Excel is a spreadsheet application, but an Excel file can also ...

Click the "Macro Name" drop-down menu and select the macro you created. Click "OK" to run the macro. Excel imports the spreadsheet data into the table.