1. Find a web page which has tables in a web page which you would like to import in excel
2. Open up excel
3. Copy your url
4. Now go to excel and Data and from web
5. Remove any previous address in the excel url bar
6. Click on go and you will see your web page with your table loaded in excel
7. Click on import
8. Go to the exact column where you want to web table to be imported into
9. Finally Click on OK
10.Edit or format your table data easily as you see fit

Click here to watch the video on how to save time and import web tables into excel fast.