ExcelGuide
Reading and Writing Excel From JavaScript Java and C Sharp
Cross language reference for reading and writing xlsx in JavaScript, Java, C Sharp, PHP, R, Go, Ruby and Rust: libraries, types, dates, memory and security.
17 min read
Topic
Scripting
Shell one-liners and small scripts that turn your repeated database chores into a single command.
CSV
Reading and Writing CSV in Go With encoding csv and Streams
Read and write CSV in Go with encoding/csv: quoting, field-count errors, LazyQuotes, the BOM it leaves in, ReuseRecord and 2,000,000 rows in 7 MB.
9 min read
Editor's pick
CSVGuide
Reading CSV Files in Go Java R Rust and C Sharp Compared
Ten languages read the same awkward CSV files: speed on 2,000,000 rows, BOM, bad quotes, ragged rows, leading zeros and defaults that bite, plus a test list.
18 min read
CSV
Fixing Garbled Characters in a Downloaded CSV From a Web App
A CSV from your web app opens as Zoë in Excel. Check the bytes, the charset header and the BOM the server sends, then fix Express, Blobs and file names.
8 min read
CSV
Writing CSV From an Array of Objects in JavaScript
Turn an array of objects into CSV in JavaScript by hand or with csv-stringify: quoting, dates, booleans, formulas, BOM and a streaming writer.
9 min read
CSV
Streaming a Huge CSV Into a Database From Node the Fast Way
Load 2,000,000 CSV rows into PostgreSQL and SQLite from Node and compare per-row inserts, batches, transactions and COPY, with timings and failure behavior.
10 min read
CSV
Converting CSV to JSON in Node With a Few Lines of Code
Convert a CSV to JSON or NDJSON in Node with csv-parse, keep ZIP codes as text, and stream 2,000,000 rows at 120 MB instead of 1.6 GB.
8 min read
CSV
Why Splitting CSV by Comma in JavaScript Goes Wrong
line.split(',') breaks on quoted commas, quotes, line breaks and CRLF. See the failures, why the regex fix is slow, and a 30 line parser that works.
7 min read
CSV
Generating a CSV Download From JavaScript in the Browser
Build a CSV string, wrap it in a Blob and trigger a download with an object URL. Covers escaping, the Excel BOM, formula guards and how 1,000,000 rows behave.
9 min read
CSV
Parsing CSV in the Browser With Papa Parse Without Blocking
Parse an uploaded CSV in the browser with Papa Parse: typing traps, error objects, encodings, and chunks and workers measured on 500,000 rows.
11 min read
CSV
Using csv parse in Node for Large Files Without Surprises
The csv-parse options that matter on big files in Node: columns, cast, on_record, relax_quotes and max_record_size, timed on 2,000,000 rows.
8 min read
CSV
Reading a CSV File in Node With Streams and Backpressure
Read a large CSV in Node with fs.createReadStream and csv-parse, filter with pipeline, stop early, and handle errors, BOMs and Windows-1252 files.
9 min read
Get new articles by email
We send one email when a new article is published. No spam.