Python Spreadsheet

Open-source Python projects categorized as Spreadsheet

Top 15 Python Spreadsheet Projects

  • visidata

    A terminal spreadsheet multitool for discovering and arranging data

    Project mention: Fx – Terminal JSON Viewer | news.ycombinator.com | 2023-09-19

    [4] "Is it possible to "flatten" structured data (like JSON?)": https://github.com/saulpw/visidata/discussions/1605

  • gspread

    Google Sheets Python API

  • LearnThisRepo.com

    Learn 300+ open source libraries for free using AI. LearnThisRepo lets you learn 300+ open source repos including Postgres, Langchain, VS Code, and more by chatting with them using AI!

  • XlsxWriter

    A Python module for creating Excel XLSX files.

  • baserow

    The official repository is hosted on https://gitlab.com/bramw/baserow. Baserow is an open source no-code database tool and Airtable alternative.

    Project mention: Ask HN: Spreadsheets like Google Sheets but not from Google? | news.ycombinator.com | 2024-01-27
  • pygsheets

    Google Sheets Python API v4

    Project mention: Ask HN: Who wants to be hired? (March 2023) | news.ycombinator.com | 2023-03-01

    I have few open source projects: https://github.com/nithinmurali/pygsheets

  • ipysheet

    Jupyter handsontable integration

    Project mention: Using spreadsheet widgets in Jupyter notebooks | /r/Jupyter | 2023-03-24

    There are a bunch of projects which seem to offer spreadsheet-style widgets for editing and presenting CSV and similar data in Jupyter: mitosheet, qgrid (abandoned?), jupyterlab-spreadsheet-editor, ipysheet (deprecated?), ipydatagrid, and ipyaggrid (and maybe others?). So far, mitosheet looks like the most flexible, featureful and up-to-date. Has anyone used these and can compare how useful they've been in practice? Or does anyone have some I've missed and should check out?

  • sheet2dict

    Simple XLSX and CSV to dictionary converter

  • InfluxDB

    Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  • blender_spreadsheet_import

    Blender add-on to import Spreadsheet data from CSV or JSON files. The data can then be used with geometry nodes.

    Project mention: All registered flight path from OpenFlights belonging to the top 15 airlines. Made with Geometry Nodes. | /r/blender | 2023-04-21
  • Robinhood-1099-Parser

    Parse Robinhood 1099 Tax Document from PDF into CSV

  • convey

    CSV processing and web related data types mutual conversion (by CZ-NIC)

  • alfred-file-explorer

    🔍 Explore your file system through a Spreadsheet

    Project mention: Friend gave me disc of Naruto (original series) but all files are not in seasons, just episode number 1-220. Is there a way to make this work in Plex without rename every effing file to the correct season and episode number? | /r/PleX | 2023-04-07

    If you’re an Alfred user I recommend this tool I made to rename an very large amount of files through any spreadsheet supporting xlsx 😉 https://github.com/BenjaminOddou/alfred-file-explorer

  • plotrock

    3D Graphing Addon for Blender

  • xlsx_copycull

    A tool for streamlined copying of Microsoft Excel spreadsheets and conditionally deleting certain rows

  • diablo4-gear-affixes

    Diablo 4 Gear Affixes

    Project mention: [Spreadsheet] Gear Affixes grouped by slots+class and slots per affix | /r/diablo4 | 2023-06-28

    I wrote some scripts to extract that data and transform it into the two table formats. You can find it here (https://github.com/Toxe/diablo4-gear-affixes) if you want to do something with it.

  • prgs-docs-spreadsheetkvc

    A simple commandline spreadsheet based on curses and python, with support for authenticated encryption based csv files.

    Project mention: Managing simple tabular data with something else than typical spreadsheet | /r/linuxquestions | 2023-06-10

    There are some esoteric curses based spreadsheets which likely solve the want-it-in-a-terminal problem w/o any coding (e.g., hanishkvc/prgs-docs-spreadsheetkvc: A simple commandline spreadsheet based on curses and python, with support for authenticated encryption based csv files.).

  • WorkOS

    The modern API for authentication & user identity. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

NOTE: The open source projects on this list are ordered by number of github stars. The number of mentions indicates repo mentiontions in the last 12 Months or since we started tracking (Dec 2020). The latest post mention was on 2024-01-27.

Python Spreadsheet related posts

Index

What are some of the best open-source Spreadsheet projects in Python? This list will help you:

Project Stars
1 visidata 7,265
2 gspread 6,767
3 XlsxWriter 3,433
4 baserow 1,932
5 pygsheets 1,475
6 ipysheet 532
7 sheet2dict 219
8 blender_spreadsheet_import 61
9 Robinhood-1099-Parser 61
10 convey 17
11 alfred-file-explorer 15
12 plotrock 10
13 xlsx_copycull 5
14 diablo4-gear-affixes 1
15 prgs-docs-spreadsheetkvc 1
The modern API for authentication & user identity.
The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.
workos.com