Spreadsheet & JSON Engineering Guides
Practical references on flattening hierarchical JSON, Excel binary/OpenXML limits, and character encoding.
How to Fix UTF-8 CSV Encoding in Excel (BOM Guide)
Learn how to fix UTF-8 CSV encoding in Excel on Windows and Mac. Stop garbled accents and CJK mojibake using a 3-byte UTF-8 BOM and right delimiters.
XLS vs XLSX Row and Column Limits: BIFF8 Guide
Compare XLS vs XLSX row and column limits (65,536 vs 1,048,576 rows), cell text caps, BIFF8 binary specs, and when legacy ERP imports require .xls.
How to Open Nested JSON in Excel Without Losing Data
Learn how to open nested JSON in Excel cleanly using dot-path flattening, array expansion, or Power Query without [object Object] cells or uploads.