> For the complete documentation index, see [llms.txt](https://docs.roivenue.com/roivenue-resources/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.roivenue.com/roivenue-resources/roivenue-training/data-exports/export-to-google-sheet.md).

# Export to a Google Sheet

## Step 1: **Google Sheet Preparation**

In the first step you need to create a Google Sheet document to store the exported data.

1\. Create a new Google Sheet, name it and click on the Share button.

![](/files/-MKQogv9SYSXwDAWkWqt)

2\. Change the type of sheet sharing.

![](/files/-MiHr5yMpiItGP2eInjG)

3\. Choose the sharing option: anyone with the link.

![](/files/-MKQpPlR15h8LBUAlBUw)

4\. Click on the "Viewer" selection on the right and choose the "Editor" role.

![](/files/-MSYzDEtCMI7UIDx1iO-)

## Step 2: Paste the Google Document ID in ROIVENUE Data Exports

Now your Google Sheet is ready to be populated with data from Roivenue. **Copy the unique Google Document ID.** 

**What and where is the Google Document ID?**

{% hint style="info" %}
**Note:** What and where is the Google Document ID?

Let's say that you have this URL : *<https://docs.google.com/spreadsheets/d/1OQE1SYpMEmmdLHRAc9h829I2Tz73YFElHlhIXr\\_57OY/edit#gid=0>.*

Then the **Document ID** **is this part from the URL**:&#x20;

*OQE1SYpMEmmdLHRAc9h829I2Tz73YFElHlhIXr\_57OY*
{% endhint %}

![The highlighted part of the URL is the Google Document ID](/files/-MKQpb1Nft80CWP8-gWD)

&#x20;After you will have the correct Google Document ID, you can copypaste it to Roivenue's Google Sheet settings.

![](/files/-MObRwxKQlNIdUuYkbX4)