Excel
Add Excel as a destination from Google Drive
-
Under Destination on the right, select Add destination, and choose Excel from the drop-down.
-
Select Workbook and choose the desired Workbook from the drop-down. Since SeekWell currently only supports
.xlsxfiles, this drop-down will show all.xlsxfiles in your Google Drive. -
Select Sheet1 and enter the Sheet name you want to send data to. Please note, the entire sheet will be replaced.
If you need other data points or formulas on the same Sheet, send your SeekWell data to one sheet (e.g. "seekwell") and use a formula or pivot table to reference the data from another sheet. -
Select A1 to enter the range using A1 notions, for example, "Sheet1!A1".
-
Run your SQL. When the query is done, refresh the file in Drive to see your data.
OneDrive (Beta - Invite Only)
-
Contact us to be added to the beta trial.
This feature will not work without contacting support. -
Log in to seekwell.io to authorize the app here.
-
Write your SQL and run it. Make sure the results in the app are what you want in Excel.
-
Under Destination on the right, select Add destination and choose Excel from the drop-down.
-
Select the spreadsheet from the drop-down that displays all the
.xlsxfiles in your One Drive. -
Enter the range using A1 notions, for example, "Sheet1!A1". The sheet must already exist.
-
Run the query again, the results will be sent to Excel.
