Formula Bot began as a formula generator for Excel and Google Sheets: you write "compare column A with column B and flag duplicates" and get the formula. It has grown into a data-analysis tool too, giving tables, charts and summaries from plain-language questions. It helps if you don't know formula syntax or don't have time to look it up.
What is Formula Bot good for?#
- Building formulas from a description: for example looking up a product's price from another table or conditional sums of sales per city.
- Explaining an old formula: reads a complicated formula a former colleague wrote and explains it simply.
- Fixing errors: paste a formula that returns an error and get a suggested fix.
- Data analysis: upload a spreadsheet and ask "which product sold the most?"
- Related code: for repetitive tasks it can also produce short SQL or macro code.
Strengths and weaknesses#
Strengths:
- Cuts the time spent hunting for formula syntax.
- You learn from the explanation that accompanies the formula.
- Supports Excel and Google Sheets.
- Data analysis without programming.
Weaknesses:
- Complex or ambiguous formulas are sometimes wrong and must be tested.
- Clear support for non-English descriptions is not stated.
- More advanced features and higher volume are paid.
- Uploading sensitive files to an external service calls for caution.
Free version and pricing#
The general pattern is a limited free plan and a paid subscription for heavier use. See the official site for current prices and limits.
Language support#
Official support for non-English requests is unclear; simple English descriptions are usually safer. Note that regional settings can make argument separators commas or semicolons, so a formula may not work unchanged.
Formula Bot alternatives#
- Numerous.ai: bulk text processing inside the cells themselves.
- Julius: data analysis and charts through chat on tabular files.
- ChatGPT: for building and explaining formulas in a general-purpose chat.
