DingdangBox

How to Copy a Website Table into Google Sheets

Need to copy a table from a website into Google Sheets? Whether you're collecting research data, comparing product prices, or organizing information for a report, transferring a web table into a spreadsheet can save a lot of manual work.

For a small table, you can often select the cells on the webpage and paste them directly into Google Sheets. But this approach is not always reliable. Some websites use complex table layouts, and selecting a large table cell by cell can be frustrating.

This guide covers three practical ways to copy a website table into Google Sheets, including how to use TableCopy to extract the table as CSV.

Method 1: Copy and Paste the Table Manually

If the website contains a standard HTML table and allows text selection, you may not need an additional tool.

Follow these steps:

  1. Open the webpage containing the table.
  2. Move your cursor to the first cell you want to copy.
  3. Select the table content by dragging across the rows and columns.
  4. Press Ctrl + C on Windows or Cmd + C on Mac.
  5. Open Google Sheets and create a blank spreadsheet.
  6. Select cell A1.
  7. Press Ctrl + V or Cmd + V to paste the copied content.

The data should appear in the spreadsheet, with values arranged into rows and columns.

When this method works well:

  • The table is relatively small.
  • The webpage allows text selection.
  • You only need a few rows or columns.
  • The table uses a standard layout.

Limitations:

Manual copying becomes inconvenient when a table contains hundreds of rows. It can also be difficult when the website uses a custom layout, prevents normal text selection, or displays data through a JavaScript-based table component.

If the table is difficult to select, try the next method.

Method 2: Use TableCopy to Copy a Website Table as CSV

TableCopy is a browser extension designed to detect and extract tables from webpages. Instead of selecting individual cells, you can use it to copy the table data in a structured format.

One useful option is CSV, which can be pasted into Google Sheets or imported as a file.

Step 1: Install TableCopy

Open the TableCopy page in the Chrome Web Store and install the extension.

After installation, open the webpage containing the table you want to copy.

Step 2: Detect the Website Table

Click the TableCopy extension icon in your browser.

Use its table detection and extraction features to find the table on the current webpage. Select the table you want to work with.

TableCopy supports several table implementations, including:

  • Standard HTML tables
  • DIV-based tables
  • AG Grid
  • React data grids
  • Material UI data grids
  • Handsontable
  • Tabulator

Detection results depend on how the website implements its table. Not every website or dynamically rendered table is guaranteed to work.

Step 3: Copy the Table as CSV

After selecting the table, choose the CSV copy option.

CSV (Comma-Separated Values) is a common format for spreadsheet data. It stores values in rows and separates columns with delimiters.

For example, a product table might look like this:

Product,Price,Rating
Wireless Mouse,19.99,4.5
Mechanical Keyboard,79.99,4.8
USB-C Hub,29.99,4.3

This structure is suitable for importing into Google Sheets.

Step 4: Paste the Data into Google Sheets

  1. Open Google Sheets.
  2. Create a new spreadsheet.
  3. Select cell A1.
  4. Paste the CSV data you copied with TableCopy.
  5. Check that the values appear in the expected rows and columns.

If the pasted content appears in a single column instead of being separated into multiple columns, use the CSV import method below.

Step 5: Check the Imported Data

Before using the spreadsheet, review the results:

  • Check that the column headers are in the correct positions.
  • Confirm that numbers and prices have not been truncated.
  • Look for missing rows or empty cells.
  • Check whether special characters display correctly.

This is particularly important when copying financial data, product listings, or research results.

Method 3: Download a CSV File and Import It into Google Sheets

If you prefer working with a file instead of copying directly to the clipboard, you can download the table as CSV and import it into Google Sheets.

TableCopy supports CSV downloads in its Free version.

Step 1: Extract the Table with TableCopy

Open the webpage, click the TableCopy extension icon, and select the table you want to extract.

Step 2: Download the Table as CSV

Choose the CSV download option and save the file to your computer.

The downloaded file contains the extracted table data in CSV format.

Step 3: Import the CSV File into Google Sheets

  1. Open Google Sheets.
  2. Create a new spreadsheet.
  3. Open the File menu.
  4. Select Import.
  5. Choose the Upload tab.
  6. Select the CSV file you downloaded.
  7. Review the import options and complete the import.

Google Sheets will load the CSV data into the spreadsheet.

This method is useful when you want to keep the downloaded CSV file as a separate copy or when direct clipboard pasting does not produce the expected column layout.

Which Method Should You Use?

The best approach depends on the table size and how the website displays its data.

MethodBest forMain limitation
Manual copy and pasteSmall, selectable tablesDifficult with large or complex tables
TableCopy CSV copyTables that are difficult to select manuallyDetection depends on the website
TableCopy CSV download and importLarger tables or file-based workflowsRequires an additional import step

For a small table, manual copying is usually enough. If you regularly collect data from websites, using TableCopy can reduce the amount of repetitive selection and copying.

What If the Website Table Has Multiple Pages?

Some websites split their data across multiple pages. For example, a product listing might show 20 items per page, while the complete dataset contains hundreds of items.

Copying each page manually and combining the results in Google Sheets takes time and can introduce mistakes.

TableCopy supports pagination extraction, allowing users to collect table data across multiple pages and combine the extracted rows into one dataset.

Its Free version supports up to 3 pages per table. Pro removes this page limit.

If you frequently work with paginated tables, see How to Scrape Paginated Tables Without Coding for a more detailed guide.

TableCopy Free vs. Pro

You can use TableCopy's CSV features without a Pro subscription.

Here is a quick comparison of the relevant features:

FeatureFreePro
Standard table recognitionYesYes
Copy as CSVYesYes
Download as CSVYesYes
Maximum rows per table200Unlimited
Pagination extractionUp to 3 pagesUnlimited
Advanced recognition for complex tables—Yes
Excel export—Yes

For the Google Sheets workflow in this article, CSV copy or CSV download is sufficient. You do not need the Pro-only Excel export feature just to import table data into Google Sheets.

You can learn more on the TableCopy product page.

Frequently Asked Questions

1. Can I copy a table from any website into Google Sheets?

Not necessarily. Standard HTML tables are often straightforward to copy, but some websites use custom JavaScript components, virtual scrolling, or other rendering techniques that make extraction more difficult.

TableCopy supports several common table implementations, but results depend on the website's structure and how its data is displayed.

2. Can I copy a website table into Google Sheets without Excel?

Yes. You do not need Microsoft Excel.

You can copy table data as CSV with TableCopy and paste it into Google Sheets. Alternatively, download the CSV file and import it directly into Google Sheets.

3. Is TableCopy's CSV export free?

Yes. TableCopy's Free version supports copying table data as CSV and downloading tables as CSV files.

The Free version has a limit of 200 rows per table. Pro supports unlimited table rows.

4. How do I copy a large website table with hundreds of rows?

First, try extracting the table with TableCopy and copying or downloading it as CSV.

Keep the Free version's 200-row limit in mind. If the table contains more rows, TableCopy Pro supports unlimited rows.

5. Can I copy a table that spans multiple website pages?

TableCopy supports pagination extraction for collecting rows across multiple pages.

The Free version supports up to 3 pages per table, while Pro supports unlimited pagination extraction. Whether extraction works depends on the website's pagination implementation.

Final Thoughts

Copying a website table into Google Sheets does not have to involve selecting every cell manually.

For small tables, ordinary copy and paste may be all you need. For larger or more difficult tables, you can use TableCopy to extract the data as CSV, then paste it into Google Sheets or import the downloaded file.

If you often move online tables into spreadsheets for research, reporting, or data analysis, give TableCopy a try.