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

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