SheetsIE
Automatically import data from Excel, CSV or Google Sheets
Cost is $12/month.
10-Day free trial no credit card required
Connect your Spreadsheets
Build workflows around your Spreadsheets
Transfer the data you want, when you want, where you want
Automate data transfers to and from Google Sheets. Hourly/Daily/Weekly
Import Excel, CSV (comma or semicolon separated), TSV, Open Office or other gSheets files
Setup as many transfers as you need
If you want to share data between sheets or different file types you can simply copy and paste or use Google’s inbuilt Import functions. Unfortunately those methods can be error prone; very time consuming and often difficult to use, especially if you have large data sets to move. The SheetsIE add-on will make the process quicker and easier for you by allowing you to automate the Import and Export of data between files.
► Transfer data to and from gSheets, CSV/TSV, Excel (xls or xlsx) or Open Office
Connect your Google Sheets with other Google Sheets to create systems based on spreadsheets transferring data between sheets automatically on timed triggers or on demand.
With your CSV (Comma separated or Semicolon separated) or TSV (Tab separated) files in Google Drive, you can automatically import all data into your Google Sheets files.
With your Excel files in Google Drive, automatically bring all of your spreadsheet data stored locally to your Google Sheets. You can transfer cell formatting at the same time.
► Consolidate data
You can set up the transfers to consolidate all your sheets data into one sheet for easier analysis and reporting. You can choose to append your data below or to the right of existing data.
► Secure transfer
The data in your spreadsheets are transmitted directly between spreadsheets you manage. No data are are sent to external parties.
► Automatic, Timed Transfers
Update connections between spreadsheets automatically (hourly, daily, weekly or monthly) without having to open your spreadsheets.
► Select data to transfer
You can transfer whole sheets at a time or specify blocks of cells within a sheet. Or you can use Google’s query language to select specific rows and columns to import.
► Email Notification
You can set up notification rules to have the add-on send email notification whenever data have been transferred.
► Import from a Shared Drive
You can set up notification rules to have the add-on send email notification whenever data have been transferred.
► Pricing
The free version of the add-on allows you to run up to 10 automated imports each month. You can also run the add-on with no limits for a 10 day trial period when you first install it. After the trial period the add-on costs $144 a year for an individual user or $300 to cover everyone in the domain.
Sheetgo which is the only comparable add-on, costs $221 or $468 for an individual user. Sheetgo's price for a domain would depend on the number of users but would start at $442. The link below will take you to a sheet comparing SheetsIE and Sheetgo