Library

Everything you need to level up your coding skills.

Flat illustration of a spreadsheet grid with a selected cell and a formula bar.

CSV

Opening a CSV With More Than a Million Rows in Excel

Excel stops at 1,048,576 rows and drops the rest if you save. Four ways to work with a bigger CSV: aggregate it, split it, use the Data Model or sample.

6 min read

CSV

Keeping Long Numbers Intact When Excel Opens a CSV

Excel keeps 15 significant digits, so a 19 digit ID loses its last four. Why it happens, how to import the column as text, and how to check a file for damage.

6 min read

Flat illustration of messy rows being swept into tidy ones.

Excel

Rejecting Files That Do Not Match the Template Cleanly

Reject Excel files that do not match the template in a way senders can act on: staged checks, stable codes, specific messages, quarantine and a retry path.

7 min read

CSV

Excel CSV UTF8 Versus CSV Comma Delimited Explained

Excel offers five CSV-like save formats. Here is what each writes, why plain CSV Comma Delimited loses characters, and which one to pick for each reader.

6 min read

Excel

Versioning Template Layouts So Old Files Still Import

Version Excel template layouts so the loader recognizes old files: a version cell, compatible changes, migration rules, a support window and a changelog.

8 min read

CSV

Importing a CSV Into Google Sheets With the Right Types

Import a CSV into Google Sheets without losing zeros or flipping dates: the import dialog, the locale, IMPORTDATA and an Apps Script that keeps text.

6 min read

Excel

Reserving Notes in a Separate Sheet of Import Templates

Give notes, comments and instructions their own place in an import template so the data sheet stays a clean table, and make the loader ignore strays.

7 min read

CSV

Saving an Excel Sheet as CSV Without the Extra Commas

Excel adds trailing commas and blank rows to a CSV when empty cells outside your data hold formatting. Find the used range, clear it and check the file.

7 min read