how small businesses use claude for analytics and reporting: the honest version.
a small business uses claude for analytics and reporting by uploading the export (csv, tsv or xlsx), asking the business question rather than for a chart, and taking the answer back as a spreadsheet, a png chart or a short written brief that claude writes with python in a sandbox. that is the capability as anthropic documents it, read 11 november 2026, not a promise. here is what it does, where it stops, and the weekly routine that works at a company with one person doing the numbers.
what claude can do with your numbers, from the docs
anthropic's help centre says claude "can perform sophisticated data analysis and data science work": it writes python scripts for analysis, processes csv and tsv files, creates data visualisations as image files such as png, and builds machine learning models if you ask. it creates "excel spreadsheets (.xlsx), powerpoint presentations (.pptx), word documents (.docx), and pdf files." the capability is "available to all claude users (free, pro, max, ultra, team, and enterprise)" once the setting is on: settings > capabilities for individual plans (the updated layout calls it "create and edit files"), organisation settings > capabilities for team and enterprise. files are capped at 30 mb each way, and creating files uses more of your usage limit than a normal chat. for a connected source rather than an upload, anthropic's small business plugin runs the /monday-brief workflow from the tools it is connected to, and amplitude is named as a connector on the cowork page.
the weekly routine
- monday, 20 minutes: export last week from the system of record (the crm, the accounting tool, the store). one csv per system. upload all of them to a project called weekly numbers that already holds a one-page note of what each column means and what "good" looks like.
- ask the question, not the chart: "which three customers' spend fell most versus the prior four weeks, and what did they buy before?" beats "make a chart of revenue by customer". claude writes the python, runs it, and shows the table. ask for the chart only once the question is answered.
- take the output as a file: "put that in an xlsx with one tab per system and a summary tab" or "a png of the four-week trend". the file lands in the artifacts tab and goes to the partner or the bookkeeper as is.
- the brief: "write the monday brief: five lines, each a number with its change and the one action." paste it where the team reads. with the plugin connected, /monday-brief does this step from the live tools.
the three rules that keep the numbers right
- claude never sees the source of truth unless you give it to it. upload the export or connect the tool; never ask claude what your revenue was. it does not know.
- ask it to show the working. "show the rows you used and the formula" catches the wrong column before the brief does. when to trust ai with numbers covers the failure modes.
- one definition per metric, written down in the project. "active customer" means the same thing every monday because the note says so, not because claude remembered.
spreadsheet mechanics (what to name columns, why csv beats xlsx as an input, when to use claude in excel instead) are in how to analyze a spreadsheet with claude and csv vs excel for ai.
where it stops
claude is not a dashboard. it does not watch your data between conversations, it does not alert you, and a chart it made last monday is a file, not a live view. if you need a number on a screen that updates itself, that is a reporting tool; claude is the analyst who reads the export and writes the brief. for most businesses under twenty people, the analyst is what was missing.
questions people ask
can claude analyze a csv for a small business?
yes. anthropic's help centre says claude writes python scripts for data analysis, processes csv and tsv files and creates png visualisations, on every plan once "create and edit files" is on, with a 30 mb limit per file.
can claude make an excel report?
yes. claude creates .xlsx, .pptx, .docx and .pdf files, saved in the artifacts tab. ask for the business question first and the file second.
does claude replace a dashboard?
no. claude does not watch data between conversations or alert you; it reads the export you give it and writes the analysis. for a live number on a screen you need a reporting tool, for the analyst you need claude.
want the weekly numbers routine installed, with the exports connected?
the monday brief from your real tools, definitions written down, nothing sent without you.
see the small business installrelated: how to analyze a spreadsheet with claude · use claude with spreadsheets · claude for operations managers
claude by role: closers · sales teams · sales managers · customer success managers · customer support teams · account managers · recruiters · hr teams · project managers · accountants and bookkeepers · marketing managers · marketing agency owners · insurance agents · real estate agents · small law firms · e-commerce store owners · therapists in private practice · consultants and coaches · restaurant operators · operations managers · grant and nonprofit teams · business owners · ugc creators. running a small business? start with claude for small business: what it means or see ai implementation for small business.
sources, read 11 november 2026: support.claude.com, "create and edit files with claude" (python data analysis, csv and tsv, png visualisations, xlsx, pptx, docx and pdf creation, all plans, setting names and locations, 30 mb per file, usage cost, sandbox limits) · claude.com/plugins/small-business (/monday-brief among the named workflows; read 9 november 2026) · claude.com/product/cowork (amplitude named as a connector; read 9 november 2026). no vendor survey was used; the routine is practice, not a statistic.