{"data":{"slug":"data-analysis","name":"Analyse data and spreadsheets","category":"data","description":"Clean, summarise, pivot and find insights in tabular data, including ad-hoc questions in plain English.","synonyms":["analyze data","spreadsheet analysis","pivot table","excel analysis","csv analysis","data cleanup","insights"],"links":{"page":"/capabilities/data-analysis","api":"/api/v1/capabilities/data-analysis"},"outcomes":["analyse my sales spreadsheet"],"keyDimensions":["quality","precision"],"related":["dashboards","database-spreadsheet"],"solutions":[{"tool":"tableau","toolName":"Tableau","fit":"native","scores":{"quality":5,"ease":2,"precision":5,"batch":3,"collaboration":4,"reliability":5},"skill":"technical","availableOnPlans":"all","cheapestQualifyingPlan":{"id":"public","name":"Tableau Public","monthlyUSD":0,"unit":"account","evidenceStatus":"verified"},"limitations":["Creator licence needed for most data preparation and authoring"],"evidence":{"status":"editorial","sources":[{"url":"https://www.tableau.com/pricing/cloud","title":"Tableau Cloud pricing","accessedAt":"2026-10-13","note":"Per-role prices listed in the page's pricing FAQ."}],"notes":"Feature existence checked on the cited vendor page; scores are editorial judgement."}},{"tool":"chatgpt","toolName":"ChatGPT","fit":"strong","scores":{"quality":4,"ease":5,"precision":3,"reliability":3},"skill":"none","availableOnPlans":"all","cheapestQualifyingPlan":{"id":"free","name":"Free","monthlyUSD":0,"unit":"account","evidenceStatus":"verified"},"limitations":["Upload limits are tighter on Free and Go","Not a live connection to your database; results are one-off","Check numbers before using them in decisions"],"evidence":{"status":"editorial","sources":[]}},{"tool":"claude","toolName":"Claude","fit":"strong","scores":{"quality":4,"ease":4,"precision":3,"reliability":3},"skill":"none","availableOnPlans":"all","cheapestQualifyingPlan":{"id":"free","name":"Free","monthlyUSD":0,"unit":"account","evidenceStatus":"verified"},"limitations":["One-off analysis, not a live data connection","Large files may hit limits"],"evidence":{"status":"editorial","sources":[{"url":"https://claude.com/pricing","title":"Claude pricing","accessedAt":"2026-10-13","note":"Free plan lists 'run code' and file creation."}]}},{"tool":"google-workspace","toolName":"Google Workspace","fit":"strong","scores":{"quality":4,"ease":4,"precision":4,"batch":3,"collaboration":5,"reliability":4},"skill":"basic","availableOnPlans":"all","cheapestQualifyingPlan":{"id":"business-starter","name":"Business Starter","monthlyUSD":7,"unit":"seat","evidenceStatus":"verified"},"limitations":["Gemini in Sheets needs Business Standard or above","Slows down on very large datasets"],"evidence":{"status":"editorial","sources":[{"url":"https://workspace.google.com/pricing?hl=en","title":"Google Workspace pricing","accessedAt":"2026-10-13","note":"Feature comparison used; prices on this page were geo-served in THB for our location, so USD prices come from the Admin Help page."}],"notes":"Feature existence checked on the cited vendor page; scores are editorial judgement. Gemini in Sheets is not on Business Starter."}},{"tool":"microsoft-365","toolName":"Microsoft 365","fit":"strong","scores":{"quality":5,"ease":3,"precision":5,"batch":4,"collaboration":4,"reliability":5},"skill":"basic","availableOnPlans":"all","cheapestQualifyingPlan":{"id":"business-basic","name":"Business Basic","monthlyUSD":7,"unit":"seat","evidenceStatus":"verified"},"limitations":["Desktop Excel (best for analysis) needs Business Standard or above","Copilot inside Excel needs the paid Copilot add-on"],"evidence":{"status":"editorial","sources":[{"url":"https://www.microsoft.com/en-us/microsoft-365/business/compare-all-microsoft-365-business-products","title":"Compare all Microsoft 365 business plans","accessedAt":"2026-10-13"},{"url":"https://www.microsoft.com/en-us/microsoft-365/business/microsoft-365-business-standard","title":"Microsoft 365 Business Standard","accessedAt":"2026-10-13"}],"notes":"Feature existence checked on the cited vendor page; scores are editorial judgement."}},{"tool":"microsoft-365-copilot","toolName":"Microsoft 365 Copilot","fit":"strong","scores":{"quality":4,"ease":4,"precision":3,"reliability":3},"skill":"none","availableOnPlans":["copilot-business","business-standard-copilot","microsoft-365-copilot","premium"],"cheapestQualifyingPlan":{"id":"premium","name":"Microsoft 365 Premium (consumer)","monthlyUSD":19.99,"unit":"account","evidenceStatus":"verified"},"limitations":["Works best on clean, well-structured tables","Verify formulas before relying on results"],"evidence":{"status":"editorial","sources":[{"url":"https://www.microsoft.com/en-us/microsoft-365/copilot/enterprise","title":"Microsoft 365 Copilot for enterprise","accessedAt":"2026-10-13"}]}},{"tool":"airtable","toolName":"Airtable","fit":"partial","scores":{"quality":3,"ease":3,"precision":3},"skill":"basic","availableOnPlans":"all","cheapestQualifyingPlan":{"id":"free","name":"Free","monthlyUSD":0,"unit":"seat","evidenceStatus":"verified"},"limitations":["No pivot tables comparable to spreadsheets","Not built for ad-hoc analysis of large datasets"],"evidence":{"status":"editorial","sources":[{"url":"https://airtable.com/pricing","title":"Airtable pricing","accessedAt":"2026-10-13","note":"Monthly prices and plan limits read from the page's plan data."}],"notes":"Editorial judgement."}},{"tool":"gemini","toolName":"Google Gemini","fit":"partial","scores":{"quality":4,"ease":4,"reliability":3},"skill":"none","availableOnPlans":"all","cheapestQualifyingPlan":{"id":"free","name":"Free","monthlyUSD":0,"unit":"account","evidenceStatus":"verified"},"limitations":["One-off analysis","Check figures before relying on them"],"evidence":{"status":"editorial","sources":[]}},{"tool":"looker-studio","toolName":"Looker Studio","fit":"partial","scores":{"quality":3,"ease":4,"precision":2},"skill":"basic","availableOnPlans":"all","cheapestQualifyingPlan":{"id":"free","name":"Data Studio (self-service)","monthlyUSD":0,"unit":"account","evidenceStatus":"verified"},"limitations":["Not built for ad-hoc data cleaning or modelling"],"evidence":{"status":"editorial","sources":[{"url":"https://cloud.google.com/data-studio","title":"Data Studio (formerly Looker Studio) – Google Cloud","accessedAt":"2026-10-13","note":"cloud.google.com/looker-studio redirects here; page includes pricing section."}],"notes":"Editorial judgement."}},{"tool":"perplexity","toolName":"Perplexity","fit":"partial","scores":{"quality":3,"ease":4},"skill":"none","availableOnPlans":["pro","max","enterprise-pro","enterprise-max"],"cheapestQualifyingPlan":{"id":"pro","name":"Pro","monthlyUSD":17,"unit":"account","evidenceStatus":"verified"},"limitations":["Not a dedicated spreadsheet analysis tool","Upload limits vary by plan"],"evidence":{"status":"editorial","sources":[]}}],"workflows":[{"slug":"dashboards-from-spreadsheets","title":"Replace Tableau Creator seats with Data Studio (Looker Studio) dashboards on Google Sheets","page":"/workflows/dashboards-from-spreadsheets","api":"/api/v1/workflows/dashboards-from-spreadsheets"}]},"meta":{"apiVersion":"v1","dataVersion":"0bc3fed5c4bf","dataGeneratedAt":"2026-10-13T14:25:53.236Z","docs":"/docs/api","evidenceLegend":"/docs/data-model#evidence","disclaimer":"Prices and capabilities change. Check each item's evidence status and verification date. Savings are estimates, not guarantees."}}