# Export your data

Most tables in Semactic can be downloaded as **Excel** (.xlsx), **PDF** or **CSV**, to share them, rework them in a spreadsheet or add them to a report. This page lists what you can export, where the button is and what the file contains.

> [!INFO]
> **On this page:** a summary of the exports, what is taken into account (filters, period, columns), the details page by page, then automatic export through Looker Studio, the API and the MCP server.

## Summary

| Page | What you export | Formats |
|------|-----------------|---------|
| [Visibility](visibility) · SEO | The keywords table, the URLs table, the history of a SERP feature | Excel, PDF · CSV for SERP features |
| [Visibility](visibility) · GEO | The prompts table for the selected AI engine | Excel, PDF |
| [Dashboard](dashboard) · SEO | **Label breakdown**, **Keyword tracking**, **Performance by site** | Excel, PDF |
| All charts | The image or the values of a chart | PNG, SVG, CSV |
| [Tasks](tasks) | The sub-tasks of a task | CSV |
| [Technical](technical) | The pages affected by an issue | CSV |
| [Content Studio](articles) | An article | HTML, Markdown |
| [Account](account) · agencies | The list of your projects | Excel |
| End of a market setup | The SEO or GEO starter report | PDF |

To get your data without going through the interface, use [Looker Studio, the API or the MCP server](#export-automatically-api-and-mcp).

## What an export takes into account

- **The market and the period** selected at the top of the page.
- **The page filters** (label, keyword, URL, competitor…) and the search bar: only matching rows are exported.
- **All rows**, not just the page of the table you are looking at. Exception: **Performance by site** (see below).

The table's **sorting**, **column filters** and **visible columns** do not apply to the file: it always contains the columns planned for the export, in their default order. Sort and filter afterwards in your spreadsheet.

The file is generated in your browser and saved to your downloads folder. Its name usually includes the project, the content and today's date, for example `my project - keywords - google-serp - 2026-11-20.xlsx`.

> [!TIP]
> To rework a table, choose **Excel**: numbers stay numbers. **PDF** is for sharing a fixed view, for example in a client report.

## SEO visibility

In **Visibility**, SEO tab, the **Google rankings** table has two tabs. The **Download PDF** and **Download Excel** buttons are in its toolbar.

| Tab | File content |
|-----|--------------|
| **Keywords** | All tracked keywords matching your filters, with their labels, volume, positions and metrics, including the columns hidden by default. |
| **URLs** | For each URL of your site: the number of ranking keywords, the best position and the total volume. With an active filter, these figures are recalculated on the filtered keywords. |

In a keyword's detail window, the **SERP features** history has its own **Export CSV** button: it downloads the history of the selected SERP feature (date, rank, title, domain, URL…).

## GEO visibility

In **Visibility**, GEO tab, the prompts table can be exported to PDF or Excel from its toolbar. The file covers the **selected AI engine** (ChatGPT, AI Overview, AI Mode, Perplexity…): switch engine and export again to get the others.

For each prompt matching your filters, it contains: the prompt, its labels, its volume, your position, one column per competitor, the brands mentioned, the sources cited and the URLs the AI looked at. For ChatGPT, two extra columns list the searches the model ran to answer.

> [!WARNING]
> Deleting a prompt permanently erases its history (positions, mentions, sources and AI answers). Export the table first if you want to keep a record.

## SEO dashboard

Three blocks of the SEO dashboard have **Download PDF** and **Download Excel** buttons:

| Block | Tab | File content |
|-------|-----|--------------|
| **Label breakdown** | Overview | Per label: volume, estimated traffic, share of voice, with their change since the start of the period, then coverage, keywords in the top 10 and total keywords. |
| **Keyword tracking** | Connected Data | For each query: Semactic position, Search Console position, impressions and clicks, with their change. The current period, search and sorting are applied, up to 5,000 rows. |
| **Performance by site** | Connected Data | Per category or per URL: impressions, clicks and sessions, with their change. **Only the page displayed (25 rows) is exported**: move to the next page to export the rest. |

The other dashboard blocks, including the whole GEO dashboard, are exported chart by chart (see below).

## Charts

**Right-click** a chart to open its menu, then choose:

- **Download PNG** or **Download SVG** for an image to paste into a presentation;
- **Download CSV** for the values displayed.

Some charts have no menu, and several GEO charts only offer images (no CSV). For GEO values, export the prompts table of the Visibility page instead.

## Competitor benchmark (Market Explorer)

If the competitor benchmark is enabled on your market, it opens from **Market Explorer**, in **Advanced mode**. The **Export** menu in its filter bar offers **PDF** or **Excel**:

- the **Excel** file has one sheet per section: summary, performance, overlap, coverage by topic and keyword detail;
- the **PDF** contains the same sections with the chart;
- the current filters are applied, and the detail is limited to the first 100 keywords.

## Tasks

Open a task from **Tasks**. In the **Tasks management** section, click **Advanced Options** then **Export**. You get a `tasks.csv` file with, for each sub-task: priority, description, deadline (DD/MM/YYYY), assignee and status.

Export works task by task: the **List** view of **Tasks** has no export button.

## Technical analysis

In **Technical**, open an issue and show the list of affected pages. **Export as CSV** downloads all rows (up to 5,000), with columns that depend on the type of issue.

The file uses a semicolon as separator, which opens directly in Excel with European regional settings. Issues related to the robots.txt file have no export.

## Content Studio

In the article editor, the **Publish** step offers:

- **Download HTML**: the full page, ready to add to your CMS;
- **Download the .md**: the article in Markdown;
- **Copy the Markdown** and **Copy text**: the content goes to your clipboard.

See [Content Studio](articles).

## Project list (agency accounts)

On the **Account** page, agency accounts have an **Export Excel** button. It downloads `projects_export.xlsx` with all the account's projects, whichever tab is displayed: brand name, URL, plan and price, creation date, number of markets, whether the project is paused, total number of keywords and prompts.

Your **invoices** are downloaded from the **Customer portal**: see [Billing & subscription](billing).

## Setup report

At the end of a new market's setup, the summary offers **Download PDF**: an SEO or GEO report, depending on the tab displayed, with the market's first results.

## Export automatically: API and MCP

Exports from the interface suit one-off needs. To feed a BI tool, a recurring report or a script, get your data directly:

- **Looker Studio**: the Semactic connector feeds reports that you customise and share, next to your other sources. See [Google Looker Studio](https://docs.semactic.com/integrations/looker-studio).
- **The REST API** returns your projects, keywords and positions, recommendations, GEO prompts, their history and their sources as JSON. See [Overview & Authentication](https://docs.semactic.com/api/authentication).
- **The MCP server** lets an AI assistant (Claude, ChatGPT, Copilot…) read your data and format it for you, for example "export all the market's keywords with their labels". See [Connect Semactic to an agent](https://docs.semactic.com/mcp/connect-agent) and the [`list_market_keywords`](https://docs.semactic.com/mcp-tools/list_market_keywords) tool.

All three use your API key, available on the **Integration** page: see [Semactic API and MCP server](https://docs.semactic.com/integrations/semactic-api). The MCP server requires the **MCP** add-on.

> [!NOTE]
> There is no one-click export of all the data in an account. If you need one (end of contract, migration), contact your account manager.
