Summary  
This chapter demonstrates how to programmatically load and parse CSV or spreadsheet data, group records by key fields, compute aggregates (sums, margins, averages), and extract actionable insights from the resulting patterns.

General domain of usage  
Business data analysis

Claude is also very useful for understanding data. You can hand it files full of numbers and it can extract insights, run calculations, and help you make sense of what's actually going on.

### Why This Matters

With just a couple of prompts, Marcus was able to analyse **eighteen months of data** and uncover **real, actionable insights**. He didn't need to build formulas, create pivot tables, or spend hours exploring the spreadsheet manually.

At its core, data analysis is often about **spotting patterns**, **finding outliers**, and **answering specific questions**. You don't necessarily need advanced technical skills. What matters most is asking a clear question.

Claude can work directly with **spreadsheets**, **CSV files**, **tables**, and **pasted data**, helping you identify trends, anomalies, and opportunities that might otherwise go unnoticed.

### Try It Yourself

Find a spreadsheet you've been meaning to review, such as your **spending**, **time tracking**, **sales pipeline**, or **work hours**. Upload it to Claude and ask a specific question, such as:

Which activity is making me the most money, costing me the most time, or surprising me the most?

Prompt

What is often the most important part of effective data analysis with Claude?

Learn how to get the most out of Claude for work, study, and everyday tasks. This course covers everything from writing better prompts and analysing documents to using advanced features such as Projects, Artifacts, Memory, Skills, and Connectors. You'll also explore how Claude integrates with tools like Chrome, Slack, Excel, PowerPoint, and mobile devices. By the end of the course, you'll be able to use Claude confidently to save time, improve productivity, and solve real-world problems more effectively.

Learn the fundamentals of Claude, including account setup, the interface, plans, and core capabilities.

Master practical prompting techniques that help you get more accurate, useful, and consistent results.

Explore how Claude can help with writing, summarisation, research, document analysis, and working with data.

Unlock advanced features such as Projects, Memory, Custom Instructions, Artifacts, and long-conversation management.

Connect Claude to the tools you already use, including Chrome, Slack, Microsoft 365, mobile apps, Skills, and Connectors.

Analysing CSV and Spreadsheet

Why This Matters

Try It Yourself