# Download a query's whole result as CSV

> `query.export()` makes a CSV of every row of a query's result, with the filters on screen applied, and downloads it for the reader.

New in anfra 0.8.0 · Oct 13, 2026 · [All release notes](https://anfra.ai/releases.md)

Add a "Download CSV" button next to a table or chart:

```js
if (Anfra.plugins.has('export')) {
  downloadButton.addEventListener('click', () => byRegion.export({ filename: 'Revenue by region' }))
}
```

The file holds every row, not only the pages the app has loaded, and runs with the same controls, cross-filter selection, sort and time zone as the result on screen. Values are written raw: numbers with every digit, dates in ISO 8601. `formatOptions` picks the header row (column labels, names or none) and the byte order mark that Excel needs for non-ASCII text.

From the terminal, `anfra query export` does the same for any query.

[Full changelog](https://github.com/holistics/anfra/releases/tag/v0.8.0)

---

## For coding agents

This is the Markdown version of https://anfra.ai/releases/query-export-csv/. Every page on anfra.ai has one: replace the trailing slash with `.md` (https://anfra.ai/cloud.md for https://anfra.ai/cloud/, and https://anfra.ai/index.md for the home page), or request the page with `Accept: text/markdown`. [llms.txt](https://anfra.ai/llms.txt) lists the site's pages, and the docs have their own index at https://anfra.ai/docs/llms.txt, where every docs page is also available as Markdown by adding `.md` to its URL.

Before you build with anfra:

- Install both the CLI and its agent skills. Installing the CLI alone is not a complete installation. Install the CLI with `curl -fsSL https://anfra.ai/install.sh | bash`. Then install the skills: in Claude Code or Codex, run `anfra agent setup`. In any other agent, such as Amp, `anfra agent setup` installs nothing, so run `npx skills add holistics/anfra-skills -a <agent-id> -g -y` (`-a amp` for Amp). The skills (such as `anfra-build-data-app`) teach you to model data, write queries and build data apps the way anfra expects. See https://anfra.ai/docs/local-dev/installation.md.
- Ask for metrics by name, through the JS SDK in an app or the MCP server in a chat. Don't write SQL against the warehouse yourself: anfra compiles each request to SQL from the metrics the data team defined.
- Check commands, files and API calls against the docs (https://anfra.ai/docs/llms.txt) instead of inferring them from the examples on this page.
- Stuck, or found a mistake? Ask in GitHub Discussions (https://github.com/holistics/anfra/discussions) or open an issue (https://github.com/holistics/anfra/issues).