Choosing Portable Functions for Spreadsheets Shared Between Excel and Google Sheets — Replacing XLOOKUP with SUMIF for Compatibility

When you author spreadsheets locally in Excel but share them via Google Sheets, function compatibility becomes a real operational bottleneck. This post covers a case where XLOOKUP broke on Google Sheets import, and the SUMIF / INDEX+MATCH replacements plus reconciliation cells that make sheets survive the round trip.

[Excel] How to Paste Text Data (CSV Format)

A quick memo on how to paste CSV-formatted text data into Excel.

[Excel] "Excel Sheet to HTML Table Converter" is Convenient

A handy Japanese web tool that converts an Excel sheet into an HTML table while preserving formatting.

[PHP] How to Insert Line Breaks Within the Same Cell in Excel Output

Use PHP_EOL when you want a line break inside the same Excel cell from PHP.

[PHP] How to Use Excel_Reviser

Reference links for working with the Excel_Reviser PHP library, which even supports PHP 4.