01 / Google Sheets
Paste one formula into A1.
This formula imports Brazil's trailing 12-month IPCA history since 2020. Headers and provenance travel with the values.
=IMPORTDATA("https://open-economics-data.knbf982hkn.chatgpt.site/api/v1/indicators/br-ipca-12m/observations?start=2020-01-01&order=asc&format=csv")Spreadsheet localeThis formula has one argument, so it works whether your spreadsheet normally separates function arguments with commas or semicolons.
02 / Microsoft Excel
Use Data → From Web.
- Copy one of the CSV URLs below.
- In Excel, open Data → Get Data → From Web.
- Paste the URL, confirm comma as the delimiter, and load the table.
- Use Refresh All whenever you want the latest official release.
03 / Ready-made series
Choose the data and copy its URL.
- IPCA · monthly change
https://open-economics-data.knbf982hkn.chatgpt.site/api/v1/indicators/br-ipca-monthly/observations?start=2020-01-01&order=asc&format=csv- IPCA · trailing 12 months
https://open-economics-data.knbf982hkn.chatgpt.site/api/v1/indicators/br-ipca-12m/observations?start=2020-01-01&order=asc&format=csv- Selic · accumulated in month
https://open-economics-data.knbf982hkn.chatgpt.site/api/v1/indicators/br-selic-monthly/observations?start=2020-01-01&order=asc&format=csv- Selic · Copom target
https://open-economics-data.knbf982hkn.chatgpt.site/api/v1/indicators/br-selic-target/observations?start=2025-01-01&order=asc&format=csv- USD/BRL · daily selling rate
https://open-economics-data.knbf982hkn.chatgpt.site/api/v1/indicators/br-usd-brl/observations?start=2026-01-01&order=asc&format=csv
04 / What you receive
Values that remain verifiable outside the API.
Every row includes date, period, value, raw_value, status, indicator_id, source_id, source_url, and upstream_url, so the official reference is preserved after the data enters your spreadsheet.
Download the IPCA CSV now↓