> For the complete documentation index, see [llms.txt](https://pathta.gitbook.io/pathta-docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://pathta.gitbook.io/pathta-docs/reporting/see-your-data-on-excel-with-the-pathta-addin.md).

# See your data on Excel with the Pathta Addin

{% hint style="info" %}
The Pathta Excel add-in lets you retrieve your data into Excel tables in just a few clicks. \
Data refresh can be scheduled to display dynamic dashboards.
{% endhint %}

{% stepper %}
{% step %}

### <mark style="color:red;">STEP 1</mark>

Create one reporting Path and copy the token from reporting Path checking tab
{% endstep %}

{% step %}

### <mark style="color:red;">STEP 2</mark>

Open Pathta Excel Addin and paste the token to sign in
{% endstep %}

{% step %}

### <mark style="color:red;">STEP 3</mark>

Select one or more paths and click on Import
{% endstep %}
{% endstepper %}

## 1. Create a reporting path and copy the token

See [here ](/pathta-docs/reporting/create-a-reporting-path.md)how to create a reporting Path.\
Copy the token started with PAT

## 2. Open Pathta Excel Addin

Open Pathta Excel Addin and paste the token to sign in.

<figure><img src="https://1039087027-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FKMgBZ3wq0SUPGSqOmR9C%2Fuploads%2FILXY7iBTZhNHY1gwEXTI%2Fimage.png?alt=media&amp;token=0cde3036-02cd-4044-8696-55af6174496b" alt=""><figcaption></figcaption></figure>

## 3. Select one or more paths and click on Import

Select one or more paths corresponding to the data you want to retrieve.\
You will see in the the list all your reporting path.

Click on Import to get data. You can check Auto-refresh if you want to refresh all your data automatically.

<figure><img src="https://1039087027-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FKMgBZ3wq0SUPGSqOmR9C%2Fuploads%2FjuRR1zQhCPQan0Q0XNxG%2Fimage.png?alt=media&amp;token=39ac7c58-8e84-4761-bff7-8cf66005c0ca" alt=""><figcaption></figcaption></figure>

{% hint style="info" %}
A tab is created containing a table for each selected path. \
All tables will be cleared during the next refresh/Import
{% endhint %}