Array Assistant

What Array Assistant is

An add-on for spreadsheets, this generates formulas from a description, tidies data, and condenses text — all without leaving the workbook.

Natural language comes into the spreadsheet, meaning a calculation can be described in words instead of assembled function by function. A sourcing note: the vendor's own site failed to load when checked, so this account rests on secondary material rather than anything the vendor published. Regular spreadsheet users who would rather not memorise every function are the target.

What you can do with it

Say what you want and a formula appears — covering the usual case of knowing the outcome but not the syntax.

Cleaning functions standardise values, formats, and text inside the sheet rather than demanding manual fixes. Summarising pulls compact versions of long text into the workbook, and the helpers arrive as separate tools rather than one unified assistant.

Text summarising lands directly in cells, so long sources become usable inputs without copy-paste.

Text summarising lands directly in cells, so long sources become usable inputs without copy-paste.

Who it is for

Spreadsheet users handling data day to day, and finance, operations, and marketing roles assembling reports by hand.

Users on uncommon spreadsheet platforms should check compatibility first.

Operations staff standardising messy exports gain most, since cleaning is where the hours go.

Marketing teams merging campaign exports gain most, since cleaning happens before analysis begins.

Anyone inheriting someone else's workbook gains most, since describing the needed change beats reverse-engineering formulas.

Anyone learning spreadsheet functions gains most, since described formulas double as worked examples.

What to watch out for

A generated formula can fail invisibly: it may hand back a plausible number while mishandling edge cases, and in a spreadsheet those mistakes spread quietly into every figure downstream — run the logic on a small sample before extending it down a column.

Whatever the add-on sends to a service leaves your machine: workbooks routinely contain client lists, salaries, and financial figures — find out what leaves before aiming it at a real workbook. With the site unreachable, verify it exists and is maintained before depending on it — and verify it supports the spreadsheet version you actually use. Syntax differs across platforms and versions, and a formula working in one may need rework in another: treat this as a convenience, and keep understanding the reasoning whenever the result matters.