# dfinke/ImportExcel

PowerShell module to import/export Excel spreadsheets, without Excel

Repository: https://github.com/dfinke/ImportExcel
Canonical: https://ross.abutalabs.com/products/importexcel
Homepage: https://www.powershellgallery.com/packages/ImportExcel/
Language: PowerShell
License: Apache-2.0
License Family: permissive
Topics: powershell, excel
Last push: 2026-08-22T00:21:14+00:00

## Health v2 (maintenance only)
Score: 67/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 98, release rhythm 8, longevity 100
- inputs: {"age_days": 4177, "days_push": 12, "days_rel": 681, "gap_med": null, "n_releases_24m": 1}
- flags: none
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 2733, forks 415 (observed 2026-08-28T04:07:16.210019+00:00)

## What it is
A PowerShell module for importing and exporting Excel spreadsheets without requiring Excel to be installed. It supports creating tables, pivot tables, charts, conditional formatting, and querying spreadsheet data across Windows, Linux, and macOS.

## Use cases
- export csv data to an xlsx file from powershell
- read excel spreadsheet data into powershell objects
- generate excel reports with charts and pivot tables automatically
- convert excel sheets to sql insert statements
- compare two excel worksheets for differences
- automate excel report generation on a linux server without office

## When to choose
- you need to automate Excel file creation or reading in PowerShell scripts
- you want to generate reports with charts, tables, and pivot tables without installing Microsoft Excel
- you need cross-platform Excel automation on Windows, Linux, or macOS

## When to avoid
- you need to manipulate complex Excel macros or VBA projects
- you work primarily in Python or another language rather than PowerShell
- you need pixel-perfect manual control over Excel's UI-driven features

## Facets
- artifact type: library
- maturity: active
- function: developer-tools, data-science, etl, charts, workflow-automation
- domain: developer-tools, data-science, spreadsheets, cross-platform
- platform: windows, cross-platform, cli
- tags: powershell, excel, xlsx, epplus, pivot-tables, spreadsheets, no-excel-required, automation, linux, macos

## Member repositories
- dfinke/ImportExcel (main) score 67

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:07:16.210019+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-30T02:14:29.663138+00:00, confidence not recorded.
  - readme: https://github.com/dfinke/ImportExcel (fetched 2026-08-28T04:07:16.210019+00:00, sha 9168fe7625ff)
  - homepage: https://www.powershellgallery.com/packages/ImportExcel/ (fetched 2026-08-29T09:57:35.837318+00:00, sha 57ba12df7f89)
  - site_page: https://www.powershellgallery.com/packages/ImportExcel/7.8.10/Content/Examples%5COpenExcelPackage%5CEnableFeatures.ps1 (fetched 2026-08-29T09:57:35.846989+00:00, sha 10e909fbc9d3)
- Data as of 2026-08-30T08:39:29.467469+00:00.
