CSVtoTable

Simple command-line utility to convert CSV files to searchable and sortable HTML table. Supports large datasets and horizontal scrolling for large number of columns.

DISCLAIMER: This is NOT an official version, nor am I affiliated with the original creator Vivek R @vividvilla https://github.com/vividvilla (Upstream Author) This version is mostly for me, if you wanna use it too go ahead but I give no promises of function. If you notice any errors or issues please tell me!

Demo

Here is a demo of sample csv file converted to HTML table.

(You can use https://NanashiTheNameless.github.io/csvtotable/sample/index.html to see all the example HTML pages.)

Installation

Get the Latest

pipx install --force 'CSVtoTableNameless @ git+https://github.com/NanashiTheNameless/csvtotable@master'

Or get from PyPi (not recommended, may be out of date)

Get started

csvtotable --help

Convert data.csv file to data.html file

csvtotable data.csv data.html

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

csvtotable data.csv --serve

Options

csvtotable [OPTIONS] input_file [output_file]

CSVtoTable: Convert CSV files into searchable, sortable HTML tables.

Options:
  -h, --help            show this help message and exit
  --version             Show detailed version and metadata about the tool (alias for 'python3 -m pip show CSVtoTableNameless').
  input_file            Path to the input CSV file.
  output_file           Path to the output HTML file (optional if --serve is used).
  -c CAPTION, -t CAPTION, --caption CAPTION, --title CAPTION
                        Table caption and HTML title.
  -d DELIMITER, --delimiter DELIMITER
                        CSV delimiter (default: ',').
  -q QUOTECHAR, --quotechar QUOTECHAR
                        String used to quote fields containing special characters (default: '"').
  -dl DISPLAY_LENGTH, --display-length DISPLAY_LENGTH
                        Number of rows to show by default. Defaults to -1 (show all rows).
  -o, --overwrite       Overwrite the output file if it exists.
  -s, --serve           Open output HTML in a browser instead of writing to a file.
  -H HEIGHT, --height HEIGHT
                        Table height in px or as a percentage (e.g., 50%).
  -p, --pagination      Enable table pagination (enabled by default unless virtual scroll is active).
  -vs VIRTUAL_SCROLL, --virtual-scroll VIRTUAL_SCROLL
                        Enable virtual scroll for tables with more than the specified number of rows. Set to -1 to disable and 0 to always enable.
  -nh, --no-header      Disable displaying the first row as headers.
  -e, --disable-export  Disable export options for the table.
  -eo {copy,csv,json,print} [{copy,csv,json,print} ...], --export-options {copy,csv,json,print} [{copy,csv,json,print} ...]
                        Specify export options (default: all). For multiple options, use: -eo json csv.
  -ps, --preserve-sort  Preserve the default sorting order.
  --debug               Enable debug mode to show full tracebacks and advanced info with --help.

Credits

All Major Contributors

All Other Contributors

External HTML Libraries used

Datatables

jQuery

JSZip

PDFMake

External Python Libraries used

argparse

colorama

hatchling

jinja2

logging

packaging

six

unicodecsv

uuid

wheel

Other Misc Used Stuffs

jburkardt's CSV Files