Excel Formula Generator

Q: Does the AI-generated formula run automatically?

No. Candidates are shown as text, checked by the local parser, and copied only after you select a formula that passed validation.

Q: Can the generator use semicolons instead of commas?

Yes. Select the semicolon separator for Excel locales that use semicolons between function arguments.

Q: What formula risks are blocked?

The validator blocks malformed formulas, external workbook references, DDE-style executable payloads, broken references, unknown functions, and unsupported names. Volatile functions are warned or blocked by the supported subset.

Q: Will a formula that passes validation always be correct?

No. Validation confirms supported syntax and safety boundaries, not your business intent. Review the references and test the formula with representative spreadsheet rows.

Describe the Excel result you need, add the known columns or cells, and let the shared local AI propose structured formula candidates. Every candidate is parsed and checked locally before you can copy it.

Saved sessions

Formula requirement

Known columns, cells, or worksheet context

Examples or extra constraints

Comma argument separatorSemicolon argument separator

Local AI runtime

Checking this device

BackendWASM

Device profile—

Adaptive limits—

Writing model

Qwen 0.5B · standard

Transcription model

Whisper Tiny · fast

Files, prompts, and results stay in this browser. Browser storage can still be cleared by you, private mode, or browser cleanup.

Formula context stays in your browser

Requirements, column context, model output, validation results, and sessions are processed locally. They are not sent to a server or included in analytics.

Current limitations

The validator supports an explicit safe subset of common Excel functions and blocks unknown or external workbook references.
A valid formula can still express the wrong business rule, so you must review cell references and test it on representative rows.
Named ranges, macros, dynamic arrays, locale-specific function names, and several advanced Excel functions are outside the current subset.
The local model may need a one-time versioned download; weights are normally reused after refresh while browser storage remains available.

How the Excel formula generator works

Describe the requirement

Provide the desired result, exact column or cell context, argument separator, and any important examples.

Generate structured candidates

The global local model returns a small JSON candidate list rather than unrestricted text or executable code.

Validate before copying

The deterministic parser blocks malformed, unsupported, external, or DDE-style formulas and displays every warning.