Google Sheets as Data Source

Using Excel,SQL,Oracle, and other ODBC Compliant Databases
Post Reply
PeeWhy
Forum Contributor
Forum Contributor
Posts: 5
Joined: Mon Nov 24, 2014 6:50 pm

Google Sheets as Data Source

Post by PeeWhy »

Is it possible for Noventri to use a google sheet as the data source?
Martin-Noventri

Re: Google Sheets as Data Source

Post by Martin-Noventri »

Hi PeeWhy,

Google sheets are natively in a currently unsupported format (extension .gsheet) for Noventri Suite. However, there is an option on Google sheets to export/download your file as an Excel spreadsheet. After doing this, data could be pulled into Noventri Suite from the Excel file.

Kind regards,
Martin
Martin-Noventri

Re: Google Sheets as Data Source

Post by Martin-Noventri »

Hi PeeWhy,

Something else you might be able to use for managing an Excel sheet is Microsoft Excel Online in harmony with Microsoft One Drive. This will allow you to sync an Excel sheet online with a One Drive folder on your PC. Then in Suite, you can connect to the One Drive version of the Excel sheet.

Microsoft Excel Online has multiple user capabilities as well, so numerous users can have access to the shared Excel file. Please go to the links below for more information about these two Microsoft services.

Microsoft Excel Online - https://office.live.com/start/Excel.aspx
One Drive - https://onedrive.live.com/about/en-us/

Kind regards,
Martin
Post Reply