1. Open your new excel sheet
2. Open any website from where you want to copy the table
3. Copy the website link
4. Return to your excel sheet and click on Data
5.click on " From web "
6. Paste the website link and click on OK
7. Select your table and click on Load