Excel and Google Sheets are the most used software tools in Indian offices — from CAs filing GST returns to HR managers processing salary sheets to small business owners tracking inventory. Yet most Indian professionals use less than 10% of what spreadsheets can do. AI changes that completely. You no longer need to memorize VLOOKUP syntax or struggle with pivot tables. Just describe what you want in plain English, and AI writes the formula for you.
Using ChatGPT for Excel Formulas
The simplest way to use AI with Excel is to ask ChatGPT or Claude for formulas. This works right now, for free, and requires no add-ons or plugins.
How to Ask for Formulas
The key is being specific about your data layout. Here is the formula for effective prompts:
"I have an Excel sheet where Column A has employee names, Column B has their department, Column C has basic salary, Column D has HRA, Column E has special allowance. I need a formula in Column F that calculates gross salary (C+D+E) only for employees in the 'Sales' department. For other departments, show 0."
ChatGPT will give you: =IF(B2="Sales", C2+D2+E2, 0)
But it goes much further. Here are real India-specific formula requests that Indian professionals commonly need:
India-Specific Formula Examples
| Task | Prompt to Use | Formula AI Gives You |
|---|---|---|
| GST Calculation (18%) | "Calculate 18% GST on amount in A2, show CGST and SGST separately" | =A2*9/100 (for each) |
| TDS Calculation | "Calculate TDS at 10% on professional fees in B2 if amount exceeds 30000" | =IF(B2>30000, B2*10%, 0) |
| Indian Number Format | "Convert number in A2 to Indian lakhs/crores format" | Custom TEXT formula with Indian grouping |
| PF Calculation | "Calculate 12% PF on basic salary in C2, capped at 15000 basic" | =MIN(C2,15000)*12% |
| Financial Year | "Determine Indian financial year for date in A2" | =IF(MONTH(A2)>=4, YEAR(A2)&"-"&YEAR(A2)+1, YEAR(A2)-1&"-"&YEAR(A2)) |
AI-Powered Excel and Sheets Add-ons
Beyond using ChatGPT separately, several tools bring AI directly into your spreadsheet:
1. Microsoft Copilot in Excel
If your company has Microsoft 365 Copilot (available in India at approximately 2,250 INR/user/month on top of regular M365), you get AI built directly into Excel.
- Natural language formulas: Type "Show me monthly sales trend for Mumbai region" and Copilot creates the formula and chart
- Pivot tables in seconds: "Create a pivot table showing department-wise salary expenditure by quarter"
- Data insights: "What are the key trends in this sales data?" — Copilot analyzes your data and provides written insights
- Format and clean data: "Standardize all phone numbers in column D to +91 format"
2. SheetAI (Google Sheets Add-on)
SheetAI is a popular Google Sheets add-on that adds AI functions directly as spreadsheet formulas:
- =SHEETAI("classify this expense: Zomato order") — automatically categorizes expenses
- =SHEETAI("translate to Hindi: " & A2) — translate content within your sheet
- =SHEETAI("summarize this feedback: " & B2) — summarize customer feedback
- Price: Free tier (100 calls/month), paid at approximately 800 INR/month
3. Numerous.ai
Numerous.ai specializes in bulk AI operations within spreadsheets — ideal for Indian businesses processing large datasets:
- Categorize 1,000 product descriptions automatically
- Extract city names from 5,000 addresses
- Sentiment analysis on customer reviews in bulk
- Generate SEO descriptions for product catalogs
4. Google Sheets Built-in AI (Gemini)
Google has integrated Gemini AI directly into Google Sheets for Workspace subscribers. Available in India with Google Workspace plans starting at approximately 136 INR/user/month:
- "Help me organize" — AI suggests how to structure your data
- "Create a chart" — describe what you want to visualize
- "Generate a table" — create tables from descriptions
| Tool | Platform | Price (INR/month) | Best For |
|---|---|---|---|
| Copilot in Excel | Microsoft 365 | ~2,250 | Enterprise, complex analysis |
| SheetAI | Google Sheets | Free-800 | AI formulas in cells |
| Numerous.ai | Both | ~1,500 | Bulk AI operations |
| Gemini in Sheets | Google Sheets | ~136 (Workspace) | Built-in, easy to start |
| ChatGPT (separate) | Any spreadsheet | Free-1,700 | Formula generation, learning |
India-Specific Use Cases
1. GST Return Preparation
Indian businesses file GST returns monthly or quarterly. AI can automate much of the preparation:
- Invoice categorization: Use AI to classify invoices as B2B, B2C, exports, or exempt supplies
- HSN code matching: "Match these product descriptions to their correct HSN codes for GST filing"
- GSTR-1 summary: AI can create the summary tables needed for GSTR-1 from your sales data
- ITC reconciliation: Compare your purchase register with GSTR-2A data to identify mismatches
"I have a sales register with columns: Invoice Number, Date, Customer GSTIN, Taxable Value, GST Rate. Create formulas to calculate CGST, SGST, IGST (based on whether customer GSTIN state code matches my state code 27 for Maharashtra), and generate a GSTR-1 summary table."
2. Salary Sheet Automation
Every Indian company processes monthly salary sheets. Here is how AI helps:
- CTC to take-home calculation: Ask AI to build a complete salary structure from CTC — basic (40-50% of CTC), HRA, special allowance, PF, ESI, professional tax, income tax
- Professional tax by state: Different Indian states have different PT rates. AI can create a lookup formula that applies the correct PT based on the employee's work state
- Leave encashment: Calculate leave encashment based on basic salary and unused leave days
- Arrears calculation: When salary revisions happen mid-year, AI can calculate arrears across multiple months
3. Business MIS Reports
Indian managers spend hours creating MIS (Management Information System) reports. AI can automate this:
- Daily sales dashboard: "Create formulas that automatically calculate today's sales, MTD, QTD, and YTD from my transaction data"
- Region-wise analysis: "I have sales data with city names. Create a pivot-style summary showing North, South, East, West zone totals with % contribution"
- Variance analysis: "Compare actual vs budget for each department and highlight items with more than 10% negative variance"
4. Inventory Management for Small Businesses
Lakhs of Indian small businesses manage inventory in Excel. AI can upgrade basic sheets into powerful tracking systems:
- Automatic reorder alerts when stock falls below minimum levels
- FIFO/LIFO cost calculation for inventory valuation
- Expiry date tracking with conditional formatting for near-expiry items
- Supplier payment tracking with due date reminders
Data Analysis Prompts That Save Hours
Beyond formulas, AI excels at helping you analyze data. Copy your data into ChatGPT (or describe its structure) and use these prompts:
Sales Analysis
- "Analyze this sales data and identify the top 3 trends I should report to my manager"
- "Which products have declining sales over the last 3 months? Suggest possible reasons."
- "Create a formula to calculate the moving average of sales over 7 days"
Financial Analysis
- "Calculate the compound annual growth rate (CAGR) of revenue from FY2022 to FY2026"
- "Create an EMI calculator in Excel for a home loan of 50 lakhs at 8.5% for 20 years"
- "Build an SIP return calculator that accounts for step-up SIP (10% annual increase)"
HR Analytics
- "Calculate attrition rate by department from this employee data (join date and last working day columns)"
- "What is the average tenure of employees who left vs those who stayed?"
- "Create a headcount trend chart formula showing month-wise active employees"
Automating Reports with AI + Macros
For recurring reports, combine AI with Excel macros (VBA) or Google Apps Script for full automation:
Step-by-Step: Automate Your Monthly Report
- Describe your report to AI: "I need a VBA macro that takes raw sales data from Sheet1, creates a pivot summary in Sheet2 with region-wise and product-wise totals, formats it with borders and headers, and saves the file with today's date in the filename."
- AI generates the code: ChatGPT will write complete VBA or Apps Script code
- Paste and run: In Excel, press Alt+F11 to open VBA editor, paste the code, and run. In Google Sheets, go to Extensions > Apps Script.
- Schedule it: In Google Sheets, use triggers to run automatically. In Excel, use Windows Task Scheduler with a VBScript wrapper.
Getting Started: Zero to AI-Powered Spreadsheets in 30 Minutes
- Minute 0-5: Open ChatGPT (free) and your current Excel/Sheets file side by side
- Minute 5-10: Describe your most time-consuming formula task to ChatGPT. Get the formula.
- Minute 10-15: Test the formula in your spreadsheet. If it gives an error, paste the error back to ChatGPT.
- Minute 15-20: Ask for your second most common task's formula.
- Minute 20-25: Ask ChatGPT to create a data validation and conditional formatting rule for your sheet.
- Minute 25-30: Ask for a chart recommendation based on your data type and create it.
After this 30-minute session, you will have saved more time than you invested. Repeat daily for a week and you will wonder how you ever used Excel without AI.