Excel FLATTEN Function – Google Sheets Alternative | ComTools

Learn Excel FLATTEN: what it does, Google Sheets support (Supported), alternatives (—), and convert formulas online.

What is Excel FLATTEN?

Flattens nested ranges into one column (Sheets).

Google Sheets compatibility

On Google Sheets, FLATTEN is marked as Supported. Excel 365: TOCOL. Older Excel needs helper formulas.

Convert with ComTools

Paste a formula that uses FLATTEN into /excel-formula-converter, choose Google Sheets or Excel as the target, and get support status plus suggested rewrites.

FAQ

QDoes Google Sheets support FLATTEN?

Status: Supported. Check the suggestion text on this page.

QCan ComTools rewrite my formula automatically?

Simple renames (e.g. TEXTAFTER→REGEXEXTRACT, TEXTSPLIT→SPLIT) and simple LET expansions are attempted; complex formulas get guidance.