Python Excel

Open-source Python projects categorized as Excel
Edit details
Topics: Python CSV XLSX Python3 Spreadsheet
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 23 Python Excel Projects

  • xlwings

    xlwings is a Python library that makes it easy to call Python from Excel and vice versa. It works with Excel on Windows and macOS as well as with Google Sheets and Excel on the web.

    • Project mention: Python in Excel: Combining the Power of Python and the Flexibility of Excel | news.ycombinator.com | 2023-08-23

    Reading the headline, I initially thought that Microsoft bought the company behind XLWings [1], which also enables you to use Excel directly within Excel, even locally. Not affiliated in any kind to that company, just used it in the past.

    [1] https://www.xlwings.org/

  • python-o365

    A simple python library to interact with Microsoft Graph and Office 365 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

  • pyexcel

    Single API for reading, manipulating and writing data in csv, ods, xls, xlsx and xlsm files

    • Project mention: Advice on ETL and Data Sharing work process | /r/ETL | 2023-11-07

    You could try and write some simple python using the pyexcel and pandas libraries. I created a tool as a consultant with these packages that parsed spreadsheets with data from factories from all around the world. They did not lock down the Excel files used to submit data and it made it so much harder. If you go this route, I would recommend starting by putting your data into a SQLite database. Once you have your data in a database, you unlock the power of SQL for pulling reports. Also, you can port the data into a proper database if you ever need to. ChatGPT can probably get you a good chunk of the way there.

  • rows

    A common, beautiful interface to tabular data, no matter the format

  • pytablewriter

    pytablewriter is a Python library to write a table in various formats: AsciiDoc / CSV / Elasticsearch / HTML / JavaScript / JSON / LaTeX / LDJSON / LTSV / Markdown / MediaWiki / NumPy / Excel / Pandas / Python / reStructuredText / SQLite / TOML / TSV.

  • git-xl

    Git extension: Makes git-diff work for VBA in Excel workbooks (xls* file types)

  • sterraxcyl

    Instagram OSINT tool to export and analyse followers | following with their details

    • Project mention: Tool to see mutual followers of several Instagram pages? | /r/OSINT | 2023-11-17

  • 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

  • ScareCrow-CobaltStrike

    Cobalt Strike script for ScareCrow payloads intergration (EDR/AV evasion)

  • django-data-wizard

    🧙⚙️ Import structured data (e.g. Excel, CSV, XML, JSON) into one or more Django models via an interactive web-based wizard

  • pylightxl

    A light weight, zero dependency, minimal functionality excel read/writer python library

  • sheet2dict

    Simple XLSX and CSV to dictionary converter

  • openvasreporting

    OpenVAS Reporting: Convert OpenVAS XML report files to reports

  • Robinhood-1099-Parser

    Parse Robinhood 1099 Tax Document from PDF into CSV

  • dbd

    dbd is a database prototyping tool that enables data analysts and engineers to quickly load and transform data in SQL databases.

  • ExcelToDatabase

    Automated tool for bulk importing Excel into the database

    • Project mention: Merging data from multiple Excel files | dev.to | 2024-03-28

    ExcelToDatabase - Automation tool for batch importing Excel files into MySQL/Oracle/SQL Server/PostgreSQL/Access/Hive/SQLite/Dameng database

  • essstat

    TP-Link Easy Smart Switch port statistics

  • pycel

    A library for compiling excel spreadsheets to python code & visualizing them as a graph (by stephenrauch)

  • pentest2xlsx

    Excel parser for various pentesting tools.

  • django-import

    Customizable and extendable import for any django model from the admin and any API

  • RC522-Attendance

    Raspberry Pi based RFID Attendance System

  • gia-api

    :mag_right: UI и парсер таблиц Excel с сайта РЦОИ г. Москвы со списками работников пунктов проведения экзаменов (ППЭ) ГИА, ОГЭ, ЕГЭ.

  • PapersCited

    List all unique citations in your document

  • plotrock

    3D Graphing Addon for Blender

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

Python Excel related posts

Index

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

Project Stars
1 xlwings 2,834
2 python-o365 1,555
3 pyexcel 1,173
4 rows 860
5 pytablewriter 593
6 git-xl 536
7 sterraxcyl 484
8 ScareCrow-CobaltStrike 447
9 django-data-wizard 330
10 pylightxl 285
11 sheet2dict 218
12 openvasreporting 114
13 Robinhood-1099-Parser 64
14 dbd 55
15 ExcelToDatabase 46
16 essstat 45
17 pycel 27
18 pentest2xlsx 27
19 django-import 13
20 RC522-Attendance 12
21 gia-api 11
22 PapersCited 10
23 plotrock 10

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