Python Spreadsheet

Open-source Python projects categorized as Spreadsheet
Edit details
Topics: Python CSV XLSX Excel google-sheets
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.
www.influxdata.com
Sponsored

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

  • 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.

    InfluxDB logo

  • 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: Baserow – Self Hosted Airtable Alternative Launches No-Code Application Builder | news.ycombinator.com | 2024-03-13

    Hey, I'm one of the founders of Baserow. We launched the beta of our application builder last week. It allows you to build database-driven websites, web applications, and portals. It's in the same product as our database module, and will work seamlessly together with it. More information can be found in the release blog post linked to this post, and in this video https://www.youtube.com/watch?v=yjE7gxkPlDs. Even though it's in an early state, it's already possible to try it out on https://baserow.io or by self-hosting the latest version. Happy to answer all the questions you might have.

  • pygsheets

    Google Sheets Python API v4

  • ipysheet

    Jupyter handsontable integration

  • sheet2dict

    Simple XLSX and CSV to dictionary converter

  • WorkOS

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

    WorkOS logo

  • 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

  • plotrock

    3D Graphing Addon for Blender

  • xlsx_copycull

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

  • 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.).

  • 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.

  • SaaSHub

    SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

    SaaSHub logo
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-03-13.

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,388
2 gspread 6,849
3 XlsxWriter 3,487
4 baserow 2,047
5 pygsheets 1,483
6 ipysheet 536
7 sheet2dict 218
8 blender_spreadsheet_import 72
9 Robinhood-1099-Parser 64
10 convey 17
11 alfred-file-explorer 16
12 plotrock 10
13 xlsx_copycull 5
14 prgs-docs-spreadsheetkvc 1
15 diablo4-gear-affixes 1

Sponsored
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com