Venture Lab How to analyze an Azure cost export CSV and find what drives the bill
Azure Cost Management can export every line of your bill as a CSV. This guide shows how to get that file, which columns matter, and how to turn it into a short list of things to check.
1. Export the cost details
In the Azure portal, open Cost Management and go to Exports. Microsoft documents these export types for cost and usage details: actual, amortized, FOCUS, and usage only. Each can run once, daily (month-to-date) or monthly (last month). Exports are written to a storage account you choose, as CSV or Parquet. CSV can be gzip-compressed.
For a quick look, Cost analysis → Download also gives you a file. For a review you will repeat every month, a scheduled export is easier to work with.
- Actual cost shows charges as they were billed. A reservation purchase appears on the day you bought it.
- Amortized cost spreads reservation and savings plan purchases over the days they cover. Use it to see what each workload really costs per day.
- FOCUS is the open FinOps cost format. Microsoft says it combines actual and amortized costs in one dataset.
Export partitioning is on by default, so a large export can arrive as several files. Analyze one file at a time, or combine them first.
2. Know the columns that matter
Microsoft's field reference lists the cost details columns by account type. These are the ones a first review needs:
| Column | What it holds |
|---|---|
CostInBillingCurrency (EA, MCA) or Cost / PreTaxCost (EA, pay-as-you-go) | Cost of the line before credits or taxes |
BillingCurrency / BillingCurrencyCode | Currency of that cost |
MeterCategory | Service category, for example Networking |
Date | Usage or purchase date |
ResourceId, ResourceName, ResourceGroup | Which resource or group the charge belongs to |
ChargeType | Usage, Purchase or Refund |
PricingModel | OnDemand, Reservation, Spot or SavingsPlan |
Microsoft notes that field names can differ in casing and spacing between account types. Check your header row before you build formulas on it.
3. Ask four questions of the file
- Where is the money? Group by
MeterCategoryand sort by total. Start your review with the biggest group. - Did anything jump? Compare each service's busiest day with its typical day. A sudden jump usually has a cause you can find: a deployment, a load test, a backup job or a misconfiguration.
- What never changes? A resource that costs exactly the same every day may be steady, legitimate use. It may also be an idle VM, an unattached disk or a forgotten gateway. Check it before you act.
- What is growing? Compare the average daily cost of each service month over month.
Keep currencies apart. If the file contains more than one billing currency, total each currency on its own instead of adding them together.
4. Do it in your browser, without uploading the file
The free BillPrism cloud bill analyzer runs these checks for you. Pick the CSV file or paste it in, and the tool shows:
- top services and totals per currency;
- daily spend;
- spikes, where a day is at least twice the typical (median) day;
- flat always-on costs, where a resource varies by less than 2% a day for at least 7 days;
- services whose average daily cost grew by 25% or more between months.
The file is read on your device and never uploaded. Files up to 20,000 rows are supported.
These results are leads to check, not proof of waste, and no savings are promised.
Try it free: Free cloud bill analyzer (CSV)
Drop in a cost export and see top services, totals per currency, daily spend, spikes, flat always-on costs and fast-growing services. No signup.
Open the free tool →About the product: BillPrism
The tool runs in your browser: your data stays on your device. No signup.
Sources
Venture Lab 10 is independent. Other product and service names are used only to describe compatibility or for comparison, and are trademarks of their owners.