Add-ons
Check out the store for many more
Add-on

Sheetgo


(844)
offered by sheetgo.com
104,099 users

Overview

Connect Google Sheets, Excel & CSV. Import, export, merge and filter data automatically.
► Link and send data to and from Google Sheets

Google Sheets ↔ Google Sheets
Send data between Google Sheets to create an automated system.

Excel → Google Sheets
Send data from Excel files (XLS, XLSX, XLSM) to Google Sheets automatically, with your Excel files stored in Google Drive. If your Excel files are not in Google Drive, use the Google Drive plug-in for Microsoft Office (https://tools.google.com/dlpage/driveforoffice) or Google Drive for Mac/PC (https://www.google.com/drive/download/).

CSV or TSV → Google Sheets
Send data from CSV or TSV files to Google Sheets automatically, with your files stored in Google Drive. If your CSV/TSV files are not in Google Drive, you can use the Google Drive plug-in for Mac/PC (https://www.google.com/drive/download/).

► Only transfer the data you need
Use the filter feature to select the data you want to transfer. Automatically transfer filtered data with a single condition or customize complex conditions using query language.

(NEW) Filter by color: Transfer filtered data by the color of the cells or rows.

► Consolidate
Centralize data from multiple sources by using the consolidate function to create a single database for analysis and reporting.

► Freeze and Append
Compare data over a period of time by freezing spreadsheet values at specified intervals and appending new records below. If the data in your files changes regularly, you can save the data before it changes, or save it for backup.

► Distribute
Use the Export feature to automatically distribute data from your Google Sheets to other people’s Google Sheets. Distribute the same data to multiple Google Sheets or distribute unique data using the filter function.

► More features

-> Automatic Updates
Schedule automatic updates at defined intervals (hourly, daily, weekly or monthly). No need to open the spreadsheet or do anything manually.

-> Smart delay
Your source data is only transferred when it is ready. Sheetgo waits for formulas to be executed before consolidating the data.

-> Peer-to-peer connection
The data in your spreadsheets is sent directly from one spreadsheet to another. Sheetgo does not copy or store your data. Your data is stored in Google Drive.

-> Preserve Formatting
Keep the formatting of your source sheet (including column width, fonts, colors and borders) in the destination sheet.

-> Security
Sheetgo offers the same level of security as Google and all data transmission is via a secure connection. Sheetgo does not have access to your data.

-> Connections Overview
Monitor all your connections at-a-glance. Check update type, scheduling and status.

-> Connections Overview
Provide visibility to all your created connections for easy monitoring of update type, scheduling and status.

-> Collaboration
When you create a connection, other users who have permission to edit your Google Sheets can run and edit the connections as well.

► Templates (available in the web app only)
Create your own Google Sheets workflow with one click by using a Sheetgo template. Choose a template from our gallery: Marketing KPIs, Timesheet management, Inventory lending, Cash flow, Company OKRs, Project management and more.


► How Sheetgo helps you
1. Centralize information from multiple spreadsheets and data sources.
2. Easier alternative to IMPORTRANGE and other confusing formulas.
3. Quick access to reliable data.
4. Reduce manual updates and copy-pasting. 
5. Get traceability on your data and reports.
6. Spend more time analyzing your data and less time managing your data. Let Sheetgo organize and consolidate (merge) for you.
7. Readily available data - at your fingertips.
8. Create automated reports and dashboards.
9. Save historical data for future use.

► Who’s it for?
Anyone who uses spreadsheets! Use Sheetgo for marketing, sales, finance, operations, education, human resources, engineering and administration. Connect your data easily and automatically, increase the reliability of information, schedule data imports and exports when you want them, create analytics and reports, back up data, consolidate (merge) data, eliminate complex formulas, organize information, and create your own enterprise systems and solutions.

► Support
Get ideas and help from the Sheetgo user community or assistance from our spreadsheet gurus. We offer consultations and demos for business users to help you create your own tailor-made system. Got a question? Contact support@sheetgo.com

Details

Version: 441
Updated: September 16, 2019
Language: English