> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://help.datachamp.io/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# Append Rows in Google Sheets with Custom Columns


## ${color}[#1a63ba](Append Rows in Google Sheets with Custom Columns)

In this tutorial, we’ll show you how to append rows to a Google Sheet while keeping a custom column for manual notes or other details. This is useful if you want to export new orders to the same Google Sheet file daily, without overwriting existing data.

${youtube}[](zaqE476j490)


#### ${color}[#1a63ba](Steps to Append Data in Google Sheets:)

1. Set Export Mode to "[Incremental](https://help.datachamp.io/en/article/incremental-exports-feature-z7hj9z/)"
* In the [Report Settings](/en/article/report-settings-overview-1a6cp7t/), change "[Export Mode](https://help.datachamp.io/en/article/export-mode-35l3c/)" to "Incremental".
* This ensures that only new orders (those not previously exported) are included.
![](https://storage.crisp.chat/users/helpdesk/website/d00f55635133d800/incremental_m38rr4.png)
2. Change the storage to "Google Drive / Google Sheets" 
![](https://storage.crisp.chat/users/helpdesk/website/-/d/0/0/f/d00f55635133d800/storgae_1hdw1qa.png)
3. Change File Type and Append Data
* Set "File Type" to "Google Sheets".
* Select "Append" as the export method => this prevents overwriting existing data and instead adds new rows.
![](https://storage.crisp.chat/users/helpdesk/website/-/d/0/0/f/d00f55635133d800/scr-20260119-lbiy_uc29ik.png)

4. Save and run your report
* Click on "Preview" and check your report.
* Then save and run your report.
* DataChamp will now only append new rows while keeping existing rows unchanged, allowing you to update them freely.

#### ${color}[#1a63ba](Import:)
* You must add the custom columns in DataChamp for them to be recognized and retained.
* If they are not added in DataChamp, they may be overwritten when new data is appended.