One Drive | Select Spreadsheet

You have the option to use an online stored file. For example a spreadsheet from your OneDrive account. (SharePoint online is available for business users.)

When selecting the file, a corresponding "guest-link" will be generated. This does not mean that your file is publicly available!

Access to the spreadsheet will be granted only to the app you created, and (optionally) to users you have invited to this app.

In this article:

• Excel Data from OneDrive
• Access your info
• Safety
• OAuth
• Business account error message

Excel Data from One Drive

Your data will be treated confidentially and used only for this purpose. The connection will be encrypted through an https certificate.

1. Select 'OneDrive' from the 'Connect external service' section.
2. The Microsoft website opens in a pop-up window.
3. Log into your OneDrive account.
4. Select the desired Excel file.
5. Click 'select'.

The Open as App Wizard immediately begins analyzing the file structure and will automatically redirect you to the next step of the app creation process.

Please note that some browsers prevent the website to open "pop-ups". Check your browser settings and allow www.openasapp.net to open pop-up windows permanently or only this time. (In some browsers, you can try it with another click on the cloud icon.)

Let this app access your info?

On first use, you must grant access rights to the application. Open as App needs authorization to run.

You can revoke access in your OneDrive/Microsoft Account settings at any time.

Safety

When using files from your cloud, only the initial app creation process takes place in the Open as App Cloud. In this case the source file will be encrypted and stored temporarily for the creation process only.

Future changes to your spreadsheet are communicated to your mobile devices by your cloud directly. This communication is never taking place via the Open as App cloud.

OAuth

We are currently working on a solution where guest access is not necessary. The authentication will take place on the user's device. The created app can only be opened if the user has already access to the file with his cloud account (e.g. if the file has been shared with the user, or his team on Dropbox Business) AND verified his account on the mobile device.

File from your business account error message

Please make sure not to log in with your business, but the private OneDrive account.

If you want to use a spreadsheet hosted in your business SharePoint online Server you can select the upload option "SharePoint Online" and log in with your business account.