(Un)Perplexed Spready v1.2.X — A New Chapter in AI-Powered Spreadsheets

Introduction

(Un)Perplexed Spready is a spreadsheet application that combines the power of traditional spreadsheets with advanced artificial intelligence capabilities. Version 1.2.X represents the biggest leap in the application's history, bringing a range of features that elevate data work to an entirely new level.

This version introduces four major improvement areas: Web Search, Vision & Document Processing, SQL Query, and Advanced Statistics.
Best of all, SQL Query and Advanced Statistics functions are completely free! If you are looking for a free statistical software, you are on the right page!

What's New in v1.2.X?

1. Web Search — Search and Process Information from the Internet

(Un)Perplexed Spready already had capability to utilize external web search tools being integrated via Open WebUI endpoints. However, now we are introducing web search functionality in the (Un)Perplexed Spready itself, which does not require any external dependency!

The new Web Search functionality allows you to search the internet directly from spreadsheet cells and process results using AI models. Three formula families are available:

WEBSEARCH() — Executes web search and sends results to local LLM for summarization
ASK_LOCAL_WEB() — Local AI decides whether to search the web or answer from knowledge
ASK_REMOTE_WEB() — Same as ASK_LOCAL_WEB, but uses a remote server

Supported search engines: SearXNG, DuckDuckGo, Mojeek, Startpage, Wikipedia, Wikidata, Brave, Google, Bing.

See the separate article on Web Search functionality for details.

2. Vision — Bring Images into AI Context

You can now use images as input for AI formulas! Supported formats include:

Local images: JPG, JPEG, PNG, WebP, GIF, BMP
Online images: HTTP/HTTPS URLs

Example usage:

=ASK_LOCAL1("IMAGE:/path/to/chart.png", "Analyze this chart and describe trends")

This opens possibilities for analyzing charts, tables, receipts, documents, and other visual content directly from the spreadsheet.

See the separate article on Vision functionality for details.

3. Document — Process Documents Without Leaving the Application

The new Document functionality allows loading various document formats into AI context:

Text formats: TXT, MD, CSV, TSV, SQL, YAML, PY, JS, PAS, SH
Web formats: HTML, HTM, XHTML
Documents: PDF, DOCX, DOC, RTF, ODT, EPUB
Spreadsheets: XLSX, XLSM, XLS, ODS
Presentations: PPTX, PPT
Data formats: XML, JSON, GEOJSON

Example:

=ASK_LOCAL1("DOC:/path/to/report.pdf", "Summarize the main points of this document")

See the separate article on Document functionality for details.

4. SQL Query — Database in Your Spreadsheet

FREE — forever!

Every sheet in your workbook becomes a SQL table. You can write SQL queries to:

Join data from multiple sheets (JOIN)
Filter and sort data
Calculate aggregates (GROUP BY, SUM, COUNT, AVG)
Create new sheets with results

SQL Query is based on the janSQL engine (by Jan Verhoeven) and ZMSQL package available in CodeTyphon.

See the separate article on SQL Query functionality for details.

5. Advanced Statistics — TyphonStats Integration

FREE — forever!

We integrated TyphonStats (based on LazStats by William G. Miller), a complete statistical package including:

Descriptive statistics: Mean, median, standard deviation, quartiles
T-tests: One-sample, paired, independent samples
Non-parametric tests: Mann-Whitney U, Wilcoxon signed-rank
Chi-square tests: Goodness of fit, test of independence
Correlation: Pearson, Spearman
And much more: ANOVA, regression, factor analysis...

All statistical analyses work directly on data from your sheets — no need to export to CSV or other formats.

See the separate article on Statistical functionality for details.

6. Other Goodies and Improvements

There are many other small improvements making work with Spready easier and more productive:

Exporting to spreadsheet formats: In previous versions calculated of AI-formulas could be exported as CSV files only. Now you can export it directly into a spreadsheet format, like xlsx.
Partial recalculation: Now you can trigger partial recalculation of only cells for which AI formula failed i.e. raised an error or returned 'N/A'. This is especially handy when calculating huge spreadsheets.

Free vs. Premium Features

Feature	Status	Note
SQL Query	FREE	Free forever
Statistics (TyphonStats)	FREE	Free forever
Vision (images)	PREMIUM	Requires AI model
Document (documents)	PREMIUM	Requires AI model
Web Search	PREMIUM	Requires AI model
AI formulas	PREMIUM	Requires AI model

Note: Premium features work with local AI models (Ollama) at no additional cost, or with cloud services (Perplexity, OpenAI) at their prices.

Architecture — Self-Sufficiency and Privacy

(Un)Perplexed Spready v1.2.X is designed for self-sufficiency:

Only external dependency: Ollama (local AI models)
No need for Open WebUI or other external services
Privacy first — data stays on your computer
Works offline (except Web Search functions)

Your data never leaves your computer when using local AI models. If you choose cloud services, you always have control over what you send.

System Requirements

Operating System: Windows, Linux, macOS
RAM: 4 GB minimum (8 GB recommended)
Disk: 500 MB for application + space for AI models
AI Models: Ollama with supported models (llama3.1, qwen2.5, mistral-nemo, etc.)

Conclusion

Version 1.2.X brings revolutionary improvements that make (Un)Perplexed Spready a unique tool on the market — a spreadsheet that is simultaneously:

AI-powered — local AI models for data processing
Web-connected — search and process information from the internet
SQL-capable — every sheet is a database
Statistically powerful — complete statistical package included
Vision-aware — analyze images and documents
Private — your data stays on your computer

Download (Un)Perplexed Spready v1.2.X and try the new features!

Credits:
TyphonStats/LazStats — William G. Miller
janSQL engine — Jan Verhoeven
ZMSQL — CodeTyphon community

Home