csv2html

This command line utility converts CSV files to HTML tables and complete HTML documents. It requires Rust 1.43 or later to build and Python 3.5 or later to test. By default it uses the first row of the CSV file as the header of the HTML table.

The older Python version is preserved in the branch python.

Installation

Prebuilt Linux and Windows binaries are available. They are attached to releases on the Releases page.

Building on Debian and Ubuntu

Follow the instructions to build a static Linux binary of csv2html from source on recent Debian and Ubuntu.

1. Install Rustup. Through Rustup add the stable MUSL target for your CPU.

sh rustup target add x86_64-unknown-linux-musl

2. Install the build and testing dependencies.

sh sudo apt install build-essential musl-tools python3

3. Clone this repository. Build and install the binary.

git clone https://github.com/dbohdan/csv2html
cd csv2html
cargo build --release

Cross-compiling for Windows

Follow the instructions to build a 32-bit Windows binary of csv2html on recent Debian and Ubuntu.

1. Install Rustup. Through Rustup add the i686 GNU ABI Windows target.

sh rustup target add i686-pc-windows-gnu

2. Install the build dependencies.

sh sudo apt install build-essential mingw-w64

3. Configure Cargo for cross-compilation. Put the following in ~/.cargo/config.

toml [target.i686-pc-windows-gnu] linker = "/usr/bin/i686-w64-mingw32-gcc"

4. Clone this repository. Build the binary.

git clone https://github.com/dbohdan/csv2html
cd csv2html
cargo build --release --target i686-pc-windows-gnu

Command line arguments

```none csv2html 3.0.0 Convert CSV files to HTML tables

USAGE: csv2html [FLAGS] [OPTIONS] [input]

FLAGS: -c, --complete-document Output a complete HTML document instead of only a table -h, --help Prints help information -n, --no-header Do not use the first row of the input as the header -r, --renumber Replace the first column with row numbers -V, --version Prints version information

OPTIONS: -d, --delimiter Field delimiter character for CSV (',' by default) -o, --output Output file -s, --start Skip the first N-1 rows; start at row N --table HTML attributes for the tag

(e.g., --table 'foo="bar" baz' results in the output

...

); it is up to the user to ensure the result is valid HTML --td Attributes for --th Attributes for -t, --title HTML document title --tr <ATTRS> Attributes for <tr></p> <p>ARGS: <input> Input file ```</p> <h2>Use examples</h2> <p>The following command reads the data from <code>test/test.csv</code> and writes the corresponding HTML table to <code>test.html</code>:</p> <pre><code>csv2html -o test.html tests/test.csv </code></pre> <p>The next command takes semicolon-delimited data from <code>pub.csv</code>, starting with row 267. The first column of the table is replaced with the row number starting at 1 (except in the header row, which is untouched). The output is redirected to the file <code>pub.html</code>.</p> <pre><code>csv2html pub.csv -d \; -r -s 267 > pub.html </code></pre> <p>Same as above, but this time the output is a full HTML document instead of just the markup for the table:</p> <pre><code>csv2html pub.csv -d \; -r -s 267 -c > pub.html </code></pre> <p>If the input file is tab-delimited, you need to pass a literal tab character as the delimiter. In a POSIX-compatible shell you can do it like this:</p> <pre><code>csv2html --delimiter "$(printf '\t')" tests/test.tsv </code></pre> <p>In the Command Prompt and batch files on Windows you will need to set <a href="https://stackoverflow.com/questions/10878138/how-to-create-tab-in-cmd"><code>%tab%</code> to the tab character</a>. <code>tab.cmd</code> is included in this repository.</p> <pre><code>call tab.cmd csv2html-win32.exe --delimiter "%tab%" tests/test.tsv </code></pre> <h2>License</h2> <p>Three-clause ("new" or "revised") BSD. See the file <code>LICENSE</code>.</p> </body></html>