CSV
How to Import a CSV Into Excel With Power Query Reliably
Import a CSV into Excel with Power Query so encoding, delimiter and column types are set once, and a refresh loads next week's file the same way.
7 min read
Library
Everything you need to level up your coding skills.
Excel
Naming Sheets and Columns for Machines in Excel Templates
Name sheets and columns in Excel templates so code and databases can use them: lowercase snake case, no punctuation, stable keys, label mapping.
7 min read
JSON
Converting JSON to CSV With Python and pandas Safely
Convert JSON to CSV with pandas and the csv module, and avoid the traps: Python repr in cells, True and False, ragged keys, Excel encoding and formula cells.
8 min read
CSV
Opening a Semicolon Separated CSV in Excel Without Mess
A semicolon CSV lands in one column when Excel expects commas. Five ways to open it correctly, and how to convert the file when decimal commas are involved.
7 min read
XML
Extracting Values With xmlstarlet From the Shell Fast
Select values, make delimited lines, count nodes, list element paths and sort with xmlstarlet sel, and avoid the escaped ampersand in its default text output.
6 min read
Excel
One Header Row and No Merged Cells in Import Templates
Why import templates need one header row and no merged cells, how to detect both in code, and how to repair files that arrive with titles and merged headings.
7 min read
CSV
Stopping Excel From Turning Gene Names and IDs Into Dates
Excel reads SEPT2 as 2-Sep and MARCH1 as 1-Mar, and saving makes the change permanent. Here is how to import, detect and recover gene names and similar IDs.
8 min read
YAML
Documenting Datasets in YAML and Catching Schema Drift
Describe a dataset in YAML, render a Markdown table from it and compare it with the live table to catch columns added or dropped without a doc.
6 min read
JSONGuide
Converting JSON to CSV XML YAML and Excel Without Surprises
A working guide to converting JSON to CSV, XML, YAML, Excel, SQL and Markdown and back: what each format cannot hold, a 23 field round trip test, and checks.
18 min read
ExcelGuide
Building Excel Templates That Import Cleanly Every Time
Design Excel templates that load into a database without cleanup: one header row, machine names, typed columns, a notes sheet, versions and rejection rules.
17 min read
CSV
Why Excel Drops Leading Zeros When You Open a CSV File
Why Excel turns 00123 into 123 when you double-click a CSV, what is lost on save, and how to keep zeros with the import wizard, Power Query or text columns.
6 min read
XML
Formatting XML With xmllint for Readable Diffs and Reviews
Pretty-print one-line XML with xmllint, set the indent, strip blank text for stable diffs, get canonical form and change encoding, and see what it alters.
7 min read
Get new articles by email
We send one email when a new article is published. No spam.