Skip to main content

Working with Tabs

By default, every request operates on the first tab of your sheet. To target a different tab, prefix the operation path with /tabs/<TabName>.

This works for every operation: reads, writes, filters, queries, and pagination.

Read from a tab​

curl 'https://api.sheetbest.com/sheets/<api-id>/tabs/Admin'

Write to a tab​

curl 'https://api.sheetbest.com/sheets/<api-id>/tabs/Admin' \
  -H 'Content-Type: application/json' \
  -d '[{"Name": "Jack Doe", "Age": 97}]'

The same prefix applies to PATCH, PUT, and DELETE.

Combine tabs with filters and queries​

Tab paths chain naturally with filter and query suffixes. Place /tabs/<TabName> immediately after the sheet ID:

# Filter the Admin tab by Name containing "Arthur"
curl 'https://api.sheetbest.com/sheets/<api-id>/tabs/Admin/Name/*Arthur*'

# Multi-column search inside the Admin tab
curl 'https://api.sheetbest.com/sheets/<api-id>/tabs/Admin/search?Age=21&Name=*Mick*'

See Filtering Data and Advanced Querying for the available operators.

Tab names with spaces​

URL-encode tab names that contain spaces or special characters. For example, a tab named Sales 2024 is reached via /tabs/Sales%202024.