CSV
Converting CSV to an Excel Workbook With Formatting
Write a CSV to .xlsx with xlsxwriter: text zips, number formats, real dates and a frozen header. write() made =1+1 a formula; rows past 1,048,575 vanished.
8 min read
Library
Everything you need to level up your coding skills.
Excel
Dynamic Array Functions FILTER SORT and UNIQUE Explained
Learn the Excel dynamic array functions FILTER, SORT, SORTBY and UNIQUE: syntax, spill behavior, combining them, errors and what scripts see.
6 min read
Excel
XLOOKUP Examples That Replace VLOOKUP Pain for Good
Six XLOOKUP examples that fix VLOOKUP problems: lookups to the left, missing keys, two-way lookups, multiple columns, wildcards and nearest matches.
6 min read
ExcelGuide
Excel Formulas Data People Use Every Week Explained
The Excel formulas data people use every week: lookups, conditional sums, text and date cleanup, arrays, errors and LET, with their SQL equivalents.
19 min read
Excel
Differences Between Sheets and Excel Formulas to Know
How Google Sheets and Excel formulas differ: array handling, lookup and text functions, dates, locale, errors and what breaks when a file moves between them.
7 min read
CSVGuide
Converting CSV to JSON XML YAML and Excel in Practice
Convert one awkward CSV to JSON, JSON Lines, XML, YAML, Excel, Parquet, Markdown and SQL, read each back and see the cost on 193,708 rows.
22 min read
Excel
Sheets IMPORTDATA and Its Limits for Live Data Feeds
What Sheets IMPORTDATA can and cannot do as a live feed from a CSV URL: format, refresh, auth, size, parsing quirks and a way to measure it for your data.
7 min read
Excel
Publishing Database Results to a Sheet Automatically
Publish database results to a Google Sheet on a schedule: replace a range safely, mark it generated, stamp the update time and alert on failure.
8 min read
Excel
Query Function in Sheets Versus SQL and What Maps to What
Compare the Google Sheets QUERY function with SQL: select, where, group by, order by, label and limit side by side, what QUERY lacks, and when to use which.
7 min read
Excel
Using the Sheets API From Python to Read and Write Data
Use the Google Sheets API from Python: create a service account, share the sheet, read and write ranges in batches, set value options and handle quota errors.
7 min read
Excel
Importing Google Sheets Data Into a Database Reliably
Import Google Sheets data into a database reliably: read with a service account, pad rows, check the contract, load through staging and report rejected rows.
7 min read
ExcelGuide
Google Sheets Alongside Databases Without the Mess
Run Google Sheets beside a database without chaos: import and publish data, use the API, compare QUERY with SQL, respect limits, plan the exit.
17 min read
Get new articles by email
We send one email when a new article is published. No spam.