CSV
Reading a CSV File in PHP With fgetcsv and SplFileObject
Read CSV in PHP 8.5 with fgetcsv and SplFileObject: the $escape deprecation, a backslash that swallows the file, str_getcsv traps and the BOM.
10 min read
Library
Everything you need to level up your coding skills.
CSV
Reading a CSV File in C Sharp With CsvHelper Correctly
Read CSV in C# with CsvHelper 33: case-sensitive headers, typed ZIP codes, silent ragged rows, and a de-DE culture that made a total 91 times too big.
10 min read
Excel
Converting Excel to CSV for Every Sheet in a Workbook
Export every sheet of an Excel workbook to its own CSV with pandas, openpyxl or LibreOffice, with safe file names, UTF-8, ISO dates and a manifest.
8 min read
CSV
Parsing CSV in Rust With the csv Crate and Serde Types
Parse CSV in Rust with the csv crate: StringRecord, ByteRecord and serde, UnequalLengths errors, typed ZIP codes and an unclosed quote it accepts.
9 min read
CSV
Reading CSV Files in R With readr and fread Safely
Compare read_csv, fread and base read.csv on the same files: type guessing and ZIP codes, ragged rows, bad quotes, the BOM, and speed on 2,000,000 rows.
10 min read
ExcelGuide
Converting Excel to CSV JSON XML and YAML in Practice
Convert Excel workbooks to CSV, JSON, XML and YAML without losing data: choose a format, read types, dates and headers, then verify with counts and schemas.
17 min read
CSV
Reading a CSV File in Java With OpenCSV and Commons CSV
Read CSV in Java with OpenCSV and Commons CSV: a backslash escape that breaks paths, ints that turn blanks into 0, and a writer that quotes everything.
10 min read
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
Get new articles by email
We send one email when a new article is published. No spam.