How to write spreadsheet formulas with AI
Use the AI formula assistant to turn plain language into calculations, explain complex logic, and master your data instantly.
WPS Spreadsheet,
Reinvented.
Create spreadsheets, write formulas, analyze data, build charts, and collaborate online — all in one powerful spreadsheet.
WPS AIQ4_Performance.xlsx
Sum Q4 revenue for EMEA, excluding trial accounts.
AI
Done. I inserted
=SUMIFS into cell D7. EMEA paid total is $1.40M (+22.7%).Now show this as a chart.
AI
Built a comparison chart — Q4 vs Q3 by region. Polished defaults applied.
Forecast Q1 based on the trend.
AI
Projected Q1:
$1.52M (+8.7%). Confidence band shown — assumes seasonality stays consistent.Sum Q4 revenue for EMEA, excluding trials…
A
B
C
D
E
F
1
Region
Product
Q3
Q4
YoY
Status
2
EMEA
Office Pro
$842K
$986K
+17.1%
● On track
3
APAC
Office Pro
$1.20M
$1.40M
+16.1%
● On track
4
AMER
Office Pro
$2.11M
$2.04M
−3.2%
● Watch
5
EMEA
PDF Suite
$298K
$413K
+38.4%
● Strong
6
APAC
PDF Suite
$387K
$471K
+21.9%
● Strong
7
EMEA
Total
$1.14M
$1.40M
+22.7%
Q4 Revenue · Regions
Total
$5.31M +14.8%
↗ Q1 Forecast
Projected revenue
$1.52M (+8.7%). Confidence: ±4.2% based on 8 quarters of data.AI for formulas,
data analysis,
and spreadsheet work.
WPS AI helps you write formulas, analyze data, create tables, generate content, classify information, and turn spreadsheet data into charts and conclusions.
AI Formula WriterWrite any formula,
Write any formula,
in any language.
Describe the calculation you need, and WPS AI helps generate a spreadsheet formula for the selected cell. Use it to calculate totals, compare values, filter data, and work faster with formulas.
- Generate formulas from natural-language prompts
- Apply formulas to selected spreadsheet data
- Understand what a formula does before using it
Q4_Performance.xlsx Ask AI
"Sum Q4 revenue for EMEA, excluding AI add-on."
A
B
C
D
E
F
1
Region
Product
Q3
Q4
YoY
Account Type
2
EMEA
Office Pro
$842K
$986K
+17.1%
Paid
3
APAC
Office Pro
$1.20M
$1.40M
+16.1%
Paid
4
EMEA
PDF Suite
$298K
$413K
+38.4%
Paid
5
APAC
PDF Suite
$387K
$471K
+21.9%
Paid
6
EMEA
AI add-on
$0
$54K
new
Trial
7
EMEA
Total
$1.14M
$1.40M
+22.7%
✓Inserted into D7 · explained in chat
AI Data Analysis
Ask questions and understand your data.
Use WPS AI to ask questions about spreadsheet data, check information, find patterns, analyze trends, and generate charts with clear conclusions.
- Ask questions about selected spreadsheet data
- Find trends, changes, and possible relationships
- Generate charts and summaries from your data
Q4_Performance.xlsx · analyzing AI Analysis
Selected data · A1:E5
A
B
C
D
1
Region
Q3
Q4
YoY
2
EMEA
$1.14M
$1.40M
+22.7%
3
APAC
$1.59M
$1.87M
+17.9%
4
AMER
$2.11M
$2.04M
−3.2%
5
Total
$4.84M
$5.31M
+9.7%
Q3 vs Q4 · by region
Q3 Q4
Why is AMER revenue down?
AMER dropped −3.2% — the only declining region. Likely due to delayed enterprise renewals in NA.
AMER Q3$2.11M
AMER Q4$2.04M
Change−3.2%
EMEA (ref)+22.7%
APAC (ref)+17.9%
✓ Analysis complete · 3 regions
AI Spreadsheet Assistant
Build and operate sheets with AI.
Create tables, ask quick questions, analyze spreadsheet data, and handle repeated spreadsheet tasks with simple instructions.
- Create tables from simple instructions
- Ask quick questions about spreadsheet content
- Use AI to assist with repeated spreadsheet tasks
New_Sheet.xlsx · building AI Assistant
Create a sales tracking table for regions, products, revenue, and status.
Done! I've created a structured table with your requested fields:
Region
Product
Revenue
Status
EMEA
Office Pro
$986K
● Active
APAC
PDF Suite
$471K
● Active
AMER
Office Pro
$2.04M
● Review
EMEA
AI add-on
$54K
● New
Now add a "YoY Change" column.
AI Functions
Use AI directly in spreadsheet functions.
Use AI-powered spreadsheet functions to generate or classify content inside cells, so repetitive text and categorization work can move faster.
- Generate content inside spreadsheet cells
- Classify text or data with AI functions
- Use AI for repeatable spreadsheet workflows
Feedback_Survey.xlsx · classifying AI Function
A
B
C
1
ID
Feedback
Sentiment
2
1001
Love the new pivot feature!
✓ Positive
3
1002
Export is okay, nothing special.
● Neutral
4
1003
Crashed twice during import.
▼ Negative
5
1004
Charts look great, very intuitive.
✓ Positive
6
1005
Formatting options are limited.
▼ Negative
7
1006
Works as expected, no issues.
● Neutral
✓Classified 6 rows · 3 categories applied
Edit together.
From anywhere.
Share spreadsheets, co-edit with teammates, leave comments, manage permissions, and keep work organized with version history.
01Co-edit in real timeWork with teammates in the same spreadsheet across desktop and web.
02Comment and discussAdd comments, mention teammates, and keep decisions close to the data.
03Share with controlSet viewing, editing, or commenting permissions and use version history to review earlier changes.
Saved · just now
A
B
C
D
E
1
Quarter
Plan
Actual
Δ
Notes
2
Q1
$2.1M
$2.3M
+9%
Strong APAC
3
Q2
$2.4M
$2.6M
+8%
4
Q3
$2.8M
$2.9M
+4%
5
Q4
$3.4M
$3.7M
+9%
6
FY
$10.7M
$11.5M
+7.5%
Riley
Mei
Sora
MMei · just now
Should we reflect the new APAC contract here?
RRiley · 1m
Updated Q4 actual — confirmed with finance.
Charts and
Spreadsheet Resources.
Turn spreadsheet data into clear charts, tables, and reports with built-in chart resources and table styles.
Proportion
Donut Chart
★ 4.8 · 380K
Sales 30%
Marketing 25%
R&D 20%
Ops 15%
Correlation
Scatter Plot
★ 4.7 · 210K
2040Q1Q2
Compare categories
Trend
Line Chart
★ 4.9 · 480K
255075JanAprJul
Track trends over time
Finance
Candlestick
★ 4.8 · 190K
$120$140$160MonWedFri
BullishBearish
Distribution
Pie Chart
★ 4.9 · 610K
Tech 35%
Health 28%
Finance 22%
Energy 15%
Multi-axis
Radar Chart
★ 4.7 · 150K
Team A
Team B
Volume
Area Chart
★ 4.8 · 290K
5K10K15KW1W2W3
Visualize growth
Proportion
Donut Chart
★ 4.8 · 380K
Sales 30%
Marketing 25%
R&D 20%
Ops 15%
Correlation
Scatter Plot
★ 4.7 · 210K
2040Q1Q2
Compare categories
Trend
Line Chart
★ 4.9 · 480K
255075JanAprJul
Track trends over time
Finance
Candlestick
★ 4.8 · 190K
$120$140$160MonWedFri
BullishBearish
Distribution
Pie Chart
★ 4.9 · 610K
Tech 35%
Health 28%
Finance 22%
Energy 15%
Multi-axis
Radar Chart
★ 4.7 · 150K
Team A
Team B
Ranking
Column Chart
★ 4.8 · 340K
102030MonWedFri
Daily Sales
Share
Pie Chart
★ 4.9 · 610K
Tech 35%
Health 28%
Finance 22%
Energy 15%
Growth
Stacked Area
★ 4.8 · 290K
1K2KQ1Q2Q3
OrganicPaid
Performance
Radar Chart
★ 4.7 · 150K
v2.0
v1.0
Distribution
Bubble Chart
★ 4.6 · 120K
LowHighSML
Visualize growth
Comparison
Multi-Line
★ 4.9 · 410K
JanJunDec
Product AProduct BProduct C
Progress
Ring Gauge
★ 4.7 · 180K
Complete
Remaining
Ranking
Column Chart
★ 4.8 · 340K
102030MonWedFri
Daily Sales
Share
Pie Chart
★ 4.9 · 610K
Tech 35%
Health 28%
Finance 22%
Energy 15%
Growth
Stacked Area
★ 4.8 · 290K
1K2KQ1Q2Q3
OrganicPaid
Performance
Radar Chart
★ 4.7 · 150K
v2.0
v1.0
Distribution
Bubble Chart
★ 4.6 · 120K
LowHighSML
Visualize growth
Comparison
Multi-Line
★ 4.9 · 410K
JanJunDec
Product AProduct BProduct C
Progress
Ring Gauge
★ 4.7 · 180K
Complete
Remaining
Spreadsheet tools for
everyday data work.
Use WPS Spreadsheet to convert files, ask AI about your data, create tables, generate content, and prepare spreadsheets for sharing.
Convert
PDF to Excel
Extract tables from PDFs into editable spreadsheets while keeping rows and columns organized.
Q
Plan
Actual
Q1
$2.1M
$2.3M
Q2
$2.4M
$2.6M
Q3
$2.8M
$2.9M
Q4
$3.4M
$3.7M
WPS AI
Ask questions about your sheet.
Use AI to understand spreadsheet data, summarize changes, find trends, and generate useful conclusions.
What was Q4 EMEA growth?
AI+22.7% YoY — driven mostly by PDF Suite (+38%).D7:F7
Flag accounts at risk for Q1.
Create
Create tables faster.
Describe the table you need, and WPS AI helps create a structured spreadsheet for your workflow.
✦Monthly budget tracker with categories…
Category
Budget
Actual
Rent
$1,200
$1,200
Food
$400
$385
Transport
$150
$162
Utilities
$90
$87
Batch work
Generate and classify content in bulk.
Apply AI to hundreds of rows at once — classify feedback, generate descriptions, or tag entries automatically.
01 "Great product!" → Positive
02 "Needs improvement" → Neutral
03 "Very disappointed" → Negative
AI Functions
Use AI functions for repeated cell tasks.
GenerateClassifySummarizeExtract
=AI.CLASSIFY(B2, "Positive, Negative")
Positive
All in one officeOne workspace for
One workspace for
Sheets, Docs, Slides,
and PDFs.
Move from data analysis to reports, presentations, and PDFs without switching between disconnected tools.
All in one, not all over the place
WPS OfficeSpreadsheet is part of WPS Office, a connected workspace for everyday productivity.
Writer
Turn sheet insights into polished reports, contracts, and proposals.
Spreadsheet
Analyze data, automate formulas, and collaborate in real time.
Presentation
Bring charts and tables into decks without rebuilding the story.
Convert, edit, compress, sign, and share documents from the same suite.
Online toolsQuick jobs,
Quick jobs,
right in the browser.
Use online tools for common file tasks like PDF to Excel, Excel to PDF, and Image to Excel — then continue editing in WPS Spreadsheet when you need the full workspace.
Why WPS Spreadsheet
Built for everyday spreadsheet work.
Real feedback from real users — on app stores, review sites, and communities worldwide.
4.8App Store average
500M+Downloads worldwide
4.6G2 rating · 300+ reviews
4.5Capterra rating
"Switched from Excel and never looked back. The AI features save me hours every week on financial reports. Formulas, charts, pivot tables — everything just works."
"Best free spreadsheet app on mobile, hands down. I manage my entire small business inventory from my phone. The cross-platform sync is flawless."
"Our team of 40 uses WPS for real-time collaboration on budgets and project trackers. The commenting and version history rival paid tools at a fraction of the cost."
"I teach data science and recommend WPS to all my students. 100% compatible with .xlsx, the PDF export is clean, and the built-in templates are a huge time saver."
"The PDF to Excel conversion alone is worth it. I process dozens of invoices daily and WPS handles complex table layouts better than any tool I've tried."
"Lightweight, fast, and opens huge files without crashing. I work with 200k+ row datasets and WPS handles them smoothly on my mid-range laptop."
Articles and answers
for smarter sheets.
=SUM(B2:B10)
=VLOOKUP(A2, Data!$A:$C, 3)
Guide
Workflow
How to analyze spreadsheet data with AI
Ask questions, find trends, generate charts, and summarize key insights from your data.
ABC1RegionQ3Q42East$42K$51K3West$38K$45K
Templates
How to build a clear spreadsheet report
Use charts, tables, and spreadsheet resources to turn raw data into a readable report.
Can I open Excel files in WPS Spreadsheet?
Yes. WPS Spreadsheet supports common spreadsheet file formats such as .xlsx, .xls, and .csv for everyday editing and sharing.
Does WPS Spreadsheet include AI features?
Yes. WPS AI can help with formula writing, data analysis, AI functions, table creation, quick questions, and batch spreadsheet tasks.
Can I analyze spreadsheet data with AI?
Yes. You can ask questions about your data, check information, find insights, analyze trends, and generate charts with conclusions.
Can teams collaborate on the same sheet?
Teams can share spreadsheets, co-edit online, leave comments, manage permissions, and use version history.
Are all AI spreadsheet features available on every device?
Feature availability may vary by platform. Some advanced spreadsheet AI features are available on Windows first and may differ on Mac.
Foundations100% Excel compatible.
100% Excel compatible.
Every device, every format.
Open and save .xlsx, .xls, .csv with full fidelity. 500+ functions including XLOOKUP, LAMBDA, dynamic arrays.
.xlsx · .xls · .csv
500+ functions
Pivots & charts
Win · Mac · Linux
iOS · Android
Web · No install
Your spreadsheet,
just smarter.
Free forever. 100% Excel compatible. Built for 600M+ people.