Packages
gspread provides a Python interface to read, write, format, and manage Google Sheets via the Google Sheets API v4, supporting operations like opening spreadsheets by title or URL, updating cell ranges, and controlling sharing permissions.
Install it if you need to read, write, or manage Google Sheets programmatically.
Streamlit transforms Python scripts into interactive web applications with minimal code, enabling rapid development of data dashboards, reports, and chat interfaces without requiring web development expertise.
Generates Microsoft Excel 97–2003 XLS spreadsheet files from Python code with no external dependencies.
Dash is a Python framework for building interactive web applications with reactive UI elements like dropdowns and graphs tied directly to analytical code, using Flask and Plotly for rendering.
Install it if you need to turn analytical Python code into interactive dashboards or data apps.
Provides elementary financial functions (IRR, NPV, PMT, and others) that were deprecated and removed from NumPy, offering a dedicated replacement for financial calculations.
However, given the aging status (no releases since 2019) and unclear compatibility with modern Python and recent numpy versions, verify that it works with your target…
Converts between Google Sheets worksheets and pandas DataFrames, allowing bidirectional data transfer via the gspread library.
However, verify compatibility with your specific gspread and pandas versions, and be aware that the last release was 793 days ago—consider this if you need active bug…
pygsheets provides a Python interface to Google Sheets via the Google Sheets API v4, letting you open, create, modify, and share spreadsheets programmatically with intuitive cell, worksheet, and spreadsheet objects.
However, be aware that updates are infrequent (last release 2022); if Google's API changes significantly or you need cutting-edge features, you may need to fork or…
A Python client library for the Smartsheet API that lets you programmatically read, write, and manage sheets, rows, columns, and other Smartsheet resources from Python applications.
Install it if you need to programmatically interact with Smartsheet from Python; the only prerequisite is a valid Smartsheet API token.
Read, edit, and write Apple Numbers spreadsheet files (.numbers) from Python, with support for cells, rows, tables, sheets, and styling.
Adds complete cell formatting support to gspread, enabling you to style Google Sheets cells with colors, fonts, alignment, and conditional formatting, plus control frozen rows/columns and data validation.
xlutils provides utilities for reading, writing, copying, and filtering Excel files by bridging xlrd and xlwt packages.
No—not for new projects.
Weave is a toolkit for tracing, logging, and evaluating generative AI applications, letting you instrument functions to capture inputs, outputs, and execution traces for debugging and analysis.
xlwings lets you call Python from Excel and vice versa, automating Excel workbooks with Python code instead of VBA, and writing Python-based user-defined functions for spreadsheets.
Install it if you need to automate Excel from Python or replace VBA macros; skip it only if you don't use Excel or prefer server-based alternatives.
Bridges Google Sheets and pandas DataFrames, letting you read spreadsheets into DataFrames and write DataFrames back to sheets with automatic header handling, type inference, and layout detection.
Install it if you regularly move data between Google Sheets and pandas.
Detects and returns the active theme (light or dark) of a running Streamlit app, updating dynamically when the user changes the theme.
However, the 833-day maintenance gap means no recent bug fixes or Streamlit version updates—verify compatibility with your Streamlit version before relying on it in…
Extracts data from Microsoft Excel spreadsheet files (.xls format) for Python 3.7 and newer, addressing the incompatibility of the original xlrd library with Python 3.9+.
However, maintenance is abandoned (last release July 2023, 1133 days ago), so it will not receive bug fixes or feature updates.
Reads MS Excel files and translates Excel formulas into Python code for evaluation, allowing spreadsheet calculations to run without Excel.
However, high install friction and the gap since the last release warrant checking that your target Excel functions are supported and testing numeric precision on…
gsheets provides a Python wrapper around the Google Sheets API v4 to read spreadsheet data, access cells by coordinate or position, and export worksheets to CSV or pandas DataFrames.
However, note that oauth2client is deprecated and the latest release is from 2022; verify compatibility with your Google account setup and current API versions before…
Adds HTTP Basic Authentication and OpenID Connect (OIDC) login to Dash applications, with support for public routes, user groups, and protected callbacks.