Tag Archives: Excel

Do yourself a favor: learn Markdown

I wrote a series on my Biochem Blog with this title: “Do yourself a favor: learn Markdown” At the moment there are 4 episodes, but more might be coming. Rather than retype things here I’ll just post the links: Summary list Do yourself a favor: learn Markdown – Episode 4. Reproducible reports Do yourself a… Read More »

in2csv: the Excel killer is part of csvkit the command-line spreadsheet

Summary csvkit is a suite of command-line tools for converting to and working with CSV, the king of tabular file formats. (csvkit can convert XLSX files to CSV.) A good docker container for csvkit: thomasleplus/csv Inspiration: stack overflow article: convert-xlsx-file-to-csv-using-batch Note: I wrote a different version of this on this post elsewhere: csvkit command-line spreadsheet can convert and… Read More »

TableConvert.com – free tabular data formats converter

This is a repost of my post on the Biochemistry department: tableconvert-com-free-tabular-data-formats-converter Tabular formats When I first came to Madison in 1986 as a postdoc with Biochemistry professor Paul Kaesberg to learn cloning and sequencing, I was surprised when he said that the most important program to work with sequences was the (now defunct GCG) program… Read More »