S2PSheets2Pandas Pro
DocumentationLast updated 2025

Everything you need for the Google Sheet to Pandas workflow

Follow the quick-start guide below to install the add-on, connect Google Drive, and generate typed Pandas snippets from any sheet with a reliable Google Sheet to Pandas process.

Documentation preview

Install & setup

Sheets2Pandas Pro installs directly from Google Workspace Marketplace. No manual Apps Script changes are required, but advanced users can explore the repository for reference.

Prerequisites

  • A Google account with access to Google Sheets and Apps Script.
  • A spreadsheet to test the sidebar. Existing data is optional but helpful.
  • Ability to enable the Drive advanced service (one-time action for the add-on).

Installation steps

  1. Visit the Sheets2Pandas Pro listing and click Install.
  2. Approve the requested scopes. The add-on now uses the minimal drive.file scope plus Google Picker so you choose which spreadsheet permissions we can inspect.
  3. Open a spreadsheet, go to Extensions → Sheets2Pandas Pro → Open Sidebar.
  4. Enable the Drive advanced service when prompted. The add-on guides you through the two-step enablement.
  5. Click Confirm access in the sidebar to open Google Picker and select the current spreadsheet. This one-time action lets Sheets2Pandas Pro read only that file’s sharing settings.

Using the export wizard

The sidebar walks through access, source selection, preview, snippet, and settings. Each step is designed to keep you informed before generating code.

Selecting ranges

  • Entire sheet: Exports the active tab with headers.
  • Current selection: Mirrors the user’s highlighted range exactly.
  • Named range: Choose from any saved ranges in the workbook.
  • Custom A1: Type or paste an A1 notation to lock onto a specific block.
  • All sheets: Batch mode that bundles several sheets into a Python module.

Previewing data

The preview screen displays display values, raw values, and number formats. It also highlights inferred types (string, number, date) and identifier hints.

  • Adjust the preview row limit up to 50 for deeper checks.
  • Toggle between display/raw to diagnose formatting issues.
  • Look for identifier badges on columns that will stay as strings.

Generated Python snippets

Sheets2Pandas Pro produces ready-to-run Pandas code. Whenever possible we add guardrails such as retries, decimal separators, and type casting.

CSV (zero config)

  • Requests session with retry policy for flaky networks.
  • Automatic encoding fallback (utf-8, utf-8-sig, latin-1).
  • Decimal separator detection with optional comma normalization.
  • Identifier detection to avoid stripping leading zeros on IDs or account numbers.

XLSX

  • Direct download from Google’s XLSX export endpoint.
  • Leverages openpyxl for compatibility with large sheets.
  • Reuses identifier and date inference to cast columns accurately once loaded.

Google Colab

  • Authenticates with Google credentials (ideal for Colab or service accounts).
  • Uses Google Colab dataframe helpers to convert worksheets into DataFrames with full formula evaluation.
  • Cleans empty rows and applies the same type inference as other modes.

Activating batch mode builds a Python module with dedicated read_* functions and a ready-made requirements.txt.

User preferences

The settings tab stores preferences in user properties so each teammate can tailor defaults without affecting others.

  • Default snippet mode: Choose CSV, Google Colab, or XLSX.
  • Preview row limit: Set a preferred window up to 50.
  • Metadata comments: Toggle snippet headers that document the sheet, range, and timestamp.
  • Timezone: The script timezone captured for logging.

Admins using Enterprise controls can enforce defaults while still allowing end users to override specific settings when needed.

FAQ & troubleshooting

The sidebar is asking for Drive permissions.

Enable the Drive advanced service inside the Apps Script project. This is required to detect sharing settings and access export endpoints securely.

Exports show unfamiliar characters.

Toggle the decimal separator detection or try switching to XLSX mode. The CSV snippet automatically attempts multiple encodings, but locale-specific formats may still require a different mode.

I ran into a quota error.

Google enforces quotas on Apps Script triggers and Drive API calls. Review the Apps Script dashboard to see remaining quota or upgrade to a workspace plan with higher limits.