How to import a data table from a webpage into a spreadsheet

--

  1. 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.

--

--

Natalya Bakhshetyan
Natalya Bakhshetyan

Written by Natalya Bakhshetyan

Data Analyst. Biology, Anatomy and Health Enthusiast. Creating data based stories about my favorite topics.

No responses yet