# Google Sheets

**Use Google Sheets as a data repository for your Miro data.** Work with separate worksheets for CSV file import or build a master worksheet by appending many CSV files with a shared format. You can, for example, build a master worksheet for all tasks in your project for an extended period of time, where you will always be able to find a particular task and go back to the original Miro board item by following the backlink.

<figure><img src="/files/NTtj2YVk9FCaw4gbxBOi" alt=""><figcaption></figcaption></figure>

1. Open Google Sheets and create a new, blank spreadsheet.
2. Click on *File* in the menu, and then choose *Import*.
3. In the *Import* window, select the *Upload* tab and select your file from your device
4. In the *Import file* settings dialog, choose *Insert new spreadsheet* or *Replace spreadsheet* under the *Import location* options, depending on your preference.
5. Leave Detect automatically as default  under *Separator type* which will  correctly identify the CSV format.
6. Click on the *Import data* button.&#x20;
7. You will notice a new *File imported successfully. Open now* option appear in the window. Click on *Open now t*o open the new data sheet.

### Freeze the header row

To make working with you data easier, we recommend freezing the first row of the sheet with the column titles.&#x20;

1. Select the first row&#x20;
2. Select View -> Freeze -> 1 row

### Appending CSV Data to an Existing Google Sheet table

1. Open a master table with existing data
2. Select *File* -> *Import*
3. Select the CSV file under the *Upload* tab
4. In the Import file window, under the Import location drop down menu, select *Append to current sheet*
5. Click on the Import data button


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://mappl-io.gitbook.io/mappl.io-docs/export/google-sheets.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.