How to import a data table from a webpage into a spreadsheet
Dec 18, 2020
- Right click the webpage, where you have the data table and save the page as an html file.
2. Go to google sheets. Create a new spreadsheet. Click on the File tab and then click Import.
3. Select the saved html file, which you downloaded in step 1.
4. Choose how you want to import the data and proceed with import.
5. You should see all the webpage data imported into the sheet. Remove all the accessory rows and columns and you will be left with the table, which you wanted to import.