Data Transporter

Data Transporter

The upgrade to IMPORTRANGE

Move and sync data between Google Sheets with scheduling, filtering, and archiving.

Get Add-on Free forever

Perfect for

Teams using Sheets as databases
Automating recurring reports
Managing multi-sheet workflows
Backing up important data

Why upgrade from IMPORTRANGE?

IMPORTRANGE
Manual Scripts
Data Transporter
See all transfers in one place
Visual configuration (No code)
No technical knowledge required
Stable when sheets are renamed
Schedule automatic transfers
Filter data before transfer
Archive with dates
Export code for customization

Features

Copy or move data

Transfer data between any sheets in seconds

#core

Combine sources

Merge multiple sheets into one (or split one into many)

#core

Replace or append

Overwrite old data or add new rows below

#core

Fast batch processing

Custom batch sizes for large files

#core
···

Choose what transfers

Values only, formulas, formatting, or everything

#filtering
💾

Run once or save

Test first, then save your configuration for future use

#automation

Dynamic filters

Transfer only what you need with date, text, or number filters

Filter by text, numbers, or dates (today, last 7 days, etc.) #filtering
📅

Schedule transfers

Daily, weekly, monthly, or custom intervals

#automation
#

Custom header rows

Works even if headers start in row 2, 5, or 7

Perfect for sheets with title rows or merged headers #filtering
🕐

Auto-timestamp

Record when each transfer happened

#automation
📦

Auto-archive

Create dated backups on schedule

Coming Soon: Archive when full #automation
</>

Export code

Get the raw Apps Script code for free — no vendor lock-in, full control

#developer

See it in action

[GIF or screenshot placeholder]

Get started in 3 steps

  1. 1

    Install

    Add Data Transporter from the Google Workspace Marketplace

  2. 2

    Configure

    Open Extensions > Data Transporter and set up your transfer

  3. 3

    Run or Schedule

    Execute once or schedule to run automatically

Ready to simplify your spreadsheets?

Join teams already using Data Transporter to save hours every week

Install Free Add-on

Works with any Google Sheets account