---
title: "How to Use a Google Sheet with Multiple Tabs in wpDataTables"
description: "Connecting a Separate Table from Each Google Sheet Tab"
url: https://help.wpdatatables.com/en/articles/46-how-to-use-a-google-sheet-with-multiple-tabs-in-wpdatatables
collection: "Technical issues"
updated: 2026-07-29
language: en
---

# How to Use a Google Sheet with Multiple Tabs in wpDataTables

Connecting a Separate Table from Each Google Sheet Tab

If you're working with a Google Sheet that has multiple tabs (worksheets), wpDataTables allows you to create a separate table from each tab — but **only** if the data is stored in a **Google Sheet** (not Excel or CSV).

Each tab in a Google Sheet has a **unique URL**, which you can use as the data source for a table. This means you can connect one wpDataTable per tab by using the direct URL from your browser’s address bar when viewing that specific tab.

➡ See this [guide](https://wpdatatables.com/documentation/creating-wpdatatables/creating-wpdatatables-from-google-spreadsheets/) for full steps on how to use Google Sheets with wpDataTables.

**Important:**  
To use the link from the browser’s address bar, you must first connect your **Google API service account** in the plugin settings.

![](https://staticfiles.gleap.io/ghelparticle/l2iyif8yJ2ZxNtxQWi4ANTOeQn5FI8Oaq4BQCnRyerMex8JLvYr3ARGUVLZ3smwDTF6NjX1hkQ7.webp)

Follow the steps in [**this guide**](https://wpdatatables.com/documentation/connect-wordpress-tables-with-google-sheets-api/) to set it up.

If you have any questions, don’t hesitate to reach out to our Support team!