xleda

Logo

xleda is a Python/Excel powered EDA tool that creates workbooks from dataframes or data files that are highly optimized to explore, define, and document data sets.

Works on Windows or MacOS as a Python package, a CLI, or as a service that lets you create workbooks by right-clicking supported files.
There are some amazing EDA tools available to data professionals. You shouldn't have to start from scratch to include Microsoft Excel among them.

Example Top View
Top view of a Field Analysis worksheet.

xleda Components

Field Analysis

Anatomy of a Field Analysis Worksheet

Field Analysis Anatomy

Field Analysis Anatomy

Overview

Anatomy of an Overview Worksheet

Overview Anatomy

Overview Worksheet with Multiple Dataframes

Basic Usage

Use wb() to quickly create an xleda workbook from a dataframe, a dictionary of dataframes, or a supported data file.

From a Dataframe

from xleda import wb
import seaborn as sns

# < your dataframe goes here >
df = sns.load_dataset("titanic")

# Creates xleda.xlsm in the current directory
wb(df)

From a Dictionary of Dataframes

from xleda import wb
import seaborn as sns

# < your dataframes go here >
df1 = sns.load_dataset("titanic")
df2 = sns.load_dataset("penguins")

# Creates Titanic.xlsm in the current directory
wb({"Titanic": df1,
    "Penguins": df2})

From a File

from xleda import wb
from pathlib import Path

# < your data file goes here >
duckdb_file = "https://github.com/InfoDesigner/xleda/raw/refs/heads/main/examples/data/duckdb.duckdb"

# Creates duckdb.xlsm in the current directory
# Includes data from all tables in the db file
wb(duckdb_file)

From the CLI

# Creates 'userdata.xlsm' in the current directory
xleda wb 'https://github.com/InfoDesigner/xleda/raw/refs/heads/main/examples/data/userdata.parquet'

# Shows the help command
xleda --help

# Shows the wb help command
xleda wb --help

From Right-Clicking | After running xleda install

Windows	MacOS

Compatibility

Desktop Excel

Requires the full version of Microsoft Excel (2016+) on either MacOS or Windows to create workbooks

See the MacOS Support section of the docs for details on MacOS usage.

Supported Data

Supports pandas dataframes, CSV, DuckDB, SQLite, Feather, Parquet, Pickle, Excel, RData, JSON, and XML

Metadata

Release files for xleda 0.9.27

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for xleda 0.9.27
File	Size	Uploaded
xleda-0.9.27.tar.gz	434.7 kB	Sep 17, 2026	Details

Built distribution (wheel)

Table of built distributions (wheels) for xleda 0.9.27
File	Interpreter	ABI	Platform	Reset
xleda-0.9.27-py3-none-any.whl 434.6 kB Sep 17, 2026	Python 3	none	any	Details

Total release size: 869.3 kB

Release files / xleda-0.9.27.tar.gz

Download URL	xleda-0.9.27.tar.gz
Size	434.7 kB
Tags	Source
SHA-256 checksum How to use checksums	`8844d82fcaf3fcd106e3e82c528d56a928f33aae6ef5ca9e4a50f15a443c5f13`
BLAKE2b-256 checksum How to use checksums	`43b88d90112f76130cf93c297da02457995920e237183a438bbf874eaf08b917`
Upload date	Sep 17, 2026
Uploaded using Trusted Publishing? What is trusted publishing?	Yes
Uploaded via	`uv/0.12.15 {"installer":{"name":"uv","version":"0.12.15","subcommand":["publish"]},"python":null,"implementation":{"name":null,"version":null},"distro":{"name":"Ubuntu","version":"24.04","id":"noble","libc":null},"system":{"name":null,"release":null},"cpu":null,"openssl_version":null,"setuptools_version":null,"rustc_version":null,"ci":true}`

Release files / xleda-0.9.27-py3-none-any.whl

Download URL	xleda-0.9.27-py3-none-any.whl
Size	434.6 kB
Tags	Python 3
SHA-256 checksum How to use checksums	`bdc8650db2c42097ac6b33da2d833e94b5ef9621c8305c5f3d286e17d966d1ad`
BLAKE2b-256 checksum How to use checksums	`e9bb97780d9e902cb5787416e83fdf695c9e5e50216713804ecaf127cd796f6c`
Upload date	Sep 17, 2026
Uploaded using Trusted Publishing? What is trusted publishing?	Yes
Uploaded via	`uv/0.12.15 {"installer":{"name":"uv","version":"0.12.15","subcommand":["publish"]},"python":null,"implementation":{"name":null,"version":null},"distro":{"name":"Ubuntu","version":"24.04","id":"noble","libc":null},"system":{"name":null,"release":null},"cpu":null,"openssl_version":null,"setuptools_version":null,"rustc_version":null,"ci":true}`