Help & Support
Send Feedback
Sheetgo
Connect with Excel, Google Sheets, CSV or TSV. Automatically consolidate, import, export, filter or append multiple spreadsheets.
417,338 users
Works with
Install
Overview
► Link your Google Sheets with a variety of sources

-> From Google Sheets
Connect your Google Sheets with other Google Sheets to create systems based on 
spreadsheets.

-> From Excel (XLS, XLSX, XLSM)
With your Excel files in Google Drive, automatically bring all of your spreadsheet data stored locally to your Google Sheets. If your Excel files are not in Google Drive, you can easily synchronize your local Excel files with Google Drive using 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/).

-> From CSV or TSV
With your CSV or TSV files in Google Drive, automatically bring all data stored locally to your Google Sheets. If your CSV or TSV files are not in Google Drive, you can easily synchronize your local CSV or TSV files with Google Drive using the Google Drive for Mac/PC (https://www.google.com/drive/download/).

► Only what you need
Use the filter feature to connect (to import or export) and filter data from others Google Sheets, Excel (XLS, XLSX and XLSM), and CSV (or TSV) files and automatically transfer filtered data with a single condition or customize complex conditions using query language.

► Consolidate
Centralize data from multiple sources by using the consolidate function to create a single database for analysis and reporting. This function consolidates only rows that contain data, excluding blank rows, and automatically adjusting to the amount of data in your source files.

► Freeze and Append
Create a historic record of spreadsheet data by freezing spreadsheet values at specified intervals and appending new records below. If the data in your files changes constantly now you can save the data before it changes or save it for backup purposes.

► Distribute
Use the Export feature to easily and automatically distribute data from your Google Sheets to others Google Sheets. Distribute the same data to multiple Google Sheets or distribute unique data using the filter function.

► More features

-> Automatic Updates
Update connections between spreadsheets automatically (hourly, daily, weekly or monthly) at defined intervals without having to open the spreadsheet(s) or execute any manual command.

-> Smart delay
Sheetgo waits for formulas to be executed before consolidating the data to ensure that the source data is ready to be transferred.

-> Peer-to-peer connection
The data in your spreadsheets are transmitted directly from one spreadsheet to another. Copies of your data are never sent to an external database.

-> Preserve Formatting
When the connection is established, Sheetgo preserves the formatting from the source sheet, including column width, fonts, colors, borders, etc.

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

-> Notifications
If something goes wrong with the connection between the spreadsheets, users are notified by email and can see the status of all connections in one place.

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

-> Collaboration
After creating a connection, other users that have permissions to edit your Google Sheets can run and edit the connections as well.

► (NEW) Templates
Most users install Sheetgo to create systems based on Google Sheets, to help on kick start these systems Sheetgo offers a Template gallery where you can start a system based on Google Sheets with one click.

-> Available beta test templates: Cash flow management

-> Coming Soon: CRM, Sales management, HR management, Budget management, Inventory, management, Grades and Attendance for schools and universities, Analytics and dashboards for startups and small business, Reporting for mid-size or big companies

► Problems solved by Sheetgo
1. Do you deal with multiple spreadsheets and data sources? 
2. Have you used IMPORTRANGE or other formulas and find them confusing, hard to find and manage?
3. Do you suffer from data unreliability or difficulty finding correct data?
4. Do you have to do too much manual updating and copy-pasting? 
5. Do you need traceability of your data and reports? 
6. Does it take you a long time to organize, consolidate (merge) and analyze information making and you are more of a data manager than a data analyzer or strategist?
7. Do you need information to be easily available when and where you need it?
8. Do you want to create reporting and dashboards automatically?
9. Do you want to keep historical records of information daily for present or even future use?

► References
Use Sheetgo for marketing, sales, finance, operations, human resources, engineering, administration. For freelancers, students and school administrators, or executives in hospitality, education, architecture, technology and many more fields. Our existing customers use Import Sheet to easily and automatically connect data, increase the reliability of information, time data imports and exports, create analytics and reports, backup data, consolidate (merge) data, eliminate complex formulas, organize information, and create their own enterprise systems and solutions.

► Support
We have an active user community, and provide email and phone support to assist you in the implementation of a system tailored to your needs Have a question? Contact support@sheetgo.com
Reviews
A Google User
October 16, 2017
Simple and easy to use. Has really saved us time and and improved accuracy which is very important to our non-profit. The help is also easy to access.
Submit reply
Cancel
April 4, 2017
Works as advertized, a real time saver. Very reliable.
Submit reply
Cancel
Thank you, Louis! I am glad it is working well for you. :-)
March 30, 2017
Does nothing major you can't already do manually, except that adding a sheet on the bottom of another is cool, but you could record a macro to do that in Excel simply enough. You can't import Excel files on your PC, you have to upload them first. Easier to consolidate in Excel first, then upload. Costs money! I stand corrected! It is free, but it wasn't obvious to me as the website didn't show the free version (just three paid options), so it looked like the add-on was free until you reached a threshold of changes. I assumed the lowest pay option would kick in then.
Submit reply
Cancel
Absolutely wonderful tool. Our file tracking and maintenance system has been greatly improved since finding SheetGo. Game changer!
Submit reply
Cancel
February 27, 2017
This help me a lot when working with some group of team, I don't have to look their sheets separately each time I need updates. Default "import range" function is not enough, since it cannot import the formatting (cells color, border, etc). This is what I looking for!!!
Submit reply
Cancel
February 28, 2017
Thank you, Yoel! We are going to work on continuously importing formatting and not just on the first import or export. Yours, Robert
February 20, 2017
Import Sheet eliminated the need to have two separate but same documents updated by allowing two separate groups of people to access the same information simultaneously but keeping some aspects of a larger document private. The only update I would request is that it translates all the formatting from the source sheet and updates the formatting with each sync.
Submit reply
Cancel
February 19, 2017
thank you! It's very helping
Submit reply
Cancel
February 20, 2017
I am glad for it. Thank you! :-)
February 9, 2017
I've been looking for something like this for a very long time, and I didn't know what it was until I found it here. Import Sheet is everything I need to save time when managing my finances!!! Thank you!
Submit reply
Cancel
February 9, 2017
great addon
Submit reply
Cancel
February 10, 2017
I am glad you find it useful! :-)
February 9, 2017
It's very helping tool.... Thank so much
Submit reply
Cancel
1-10 of 44
Additional information
Search
Clear search
Close search
Google apps
Main menu