Skip to main content

Simple commandline utility to convert excel filesto searchable and sortable HTML table.

Project description


Simple command-line utility to convert csv, xls, xlsx, ods files to searchable and sortable HTML table. Supports large datasets and horizontal scrolling for large number of columns.

It is a variant of csvtotable.


Here is a demo of sample ods file converted to HTML table with charts.


pip install --upgrade excel2table

Get started

excel2table --help

Convert data.ods file to data.html file

excel2table data.ods data.html

Open output file in a web browser instead of writing to a file

excel2table data.ods --serve


-c,  --caption          Table caption
-d,  --delimiter        CSV delimiter. Defaults to ','
    -e,  --encoding         CSV encoding. Defaults to 'utf-8'.
-q,  --quotechar        Quote chracter. Defaults to '"'
-dl, --display-length   Number of rows to show by default. Defaults to -1 (show all rows)
-o,  --overwrite        Overwrite the output file if exists. Defaults to false.
-s,  --serve            Open html output in a web browser.
-h,  --height           Table height in px or in %. Default is 75% of the page.
-p,  --pagination       Enable/disable pagination. Enabled by default.
-vs, --virtual-scroll   Number of rows after which virtual scroll is enabled. Default is set to 1000 rows.
                        Set it to -1 to disable and 0 to always enable.
-nh, --no-header        Show default headers instead of picking first row as header. Disabled by default.
-e,  --export           Enable filtered rows export options.
-eo, --export-options   Enable specific export options. By default shows all.
                        For multiple options use -eo flag multiple times. For ex. -eo json -eo csv



Change log

2.3.2 - 16.03.2019

  1. add tests in tar ball

2.3.0 - 15.03.2019


  1. added this file into sour tar ball.
  2. fix problems with pyexcel-sortable & python3 PR17

2.2.1 - 21.02.2017


  1. Visualize stock data with candlestick, bar and line csvtotable PR 24


  1. Update baseline of csvtotable to 2.1.1

Project details

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for excel2table, version 2.3.2
Filename, size File type Python version Upload date Hashes
Filename, size excel2table-2.3.2.tar.gz (301.5 kB) File type Source Python version None Upload date Hashes View

Supported by

Pingdom Pingdom Monitoring Google Google Object Storage and Download Analytics Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page