Update source file | Switch spreadsheet

You can upload a new version of your spreadsheet with new data or additional functionality. It is also possible to change the location of the source file. Example: you created an app with an Excel file from your computer but now you want the file to be synchronized with your Dropbox or Google Drive (Google sheets).

Let's assume you have created an App based on an Excel Contact List from your Computer. Over time some entries have been added to the Excel file so your app is outdated. You have now different possibilities to update your app.

In this article

• Update the source file of your app
• Change storage from Open as App Cloud to Dropbox
• Change storage from Open as App Cloud to Google Sheets (Google Drive)
• Change storage from Dropbox to the Open as App Cloud

Update the source file of your app

You can upload the new Excel file in the Open as App Cloud and basically override the initial source file.

Be careful with updating the spreadsheet. If the structure of the new file is different from the file you created the initial app with, you have to make additional changes regarding the assignment in the app admin.

1. Open your app in the web portal.
2. Navigate to "Manage Data".
3. Select "Update spreadsheet"
4. You can now update the spreadsheet by pasting the link to an online hosted file. (See detailed information here: Change storage from Open as App Cloud to Dropbox.)
5. or by uploading a new Excel file from your computer. (Click or drag & drop in the box.)
6. Save the changes and update your app.

Change storage from Open as App Cloud to Dropbox

You have created the app with a file you uploaded directly from your computer and now your file is hosted online in your Dropbox?

1. Open your app in the web portal.
2. Navigate to "Manage Data".
3. Select "Update spreadsheet"
4. Click "Edit url".
5.  
6. Paste in the link of the online hosted (DropBox) file.
7. Save the changes and update your app.

In case you are not sure how to get the link to your online hosted file please check the help center of your cloud provider for: "Sharing files"

For Dropbox you can check this section: https://www.dropbox.com/help/topics/sharing_files_and_folders

You will find additional information regarding using online hosted spreadsheet files for apps here: https://support.openasapp.net/hc/en-us/articles/208232089

Change storage from Open as App Cloud to Google Sheets (Google Drive)

You have created the app with a file you uploaded directly from your computer and now your file is a google sheet?

1. Open your app in the web portal.
2. Navigate to "Manage Data".
3. Select "Update spreadsheet"
4. Click "Edit url".
5. Paste in the link of the online hosted (Google Drive) file.
6. Save the changes and update your app.

Change storage from Dropbox/Google Drive to the Open as App Cloud

You have created an app based on an Excel file hosted in your dropbox account and now you want to upload the file from your computer?

1. Open your app in the web portal.
2. Navigate to "Manage Data".
3. Select "Update spreadsheet"
4. Upload a new Excel file from your computer. Click on the paperclip to open the upload dialog (or simply drag & drop the Excel file in the box).
5. Select the file on your computer and click "open" if you are using the upload dialog instead of drag & drop.
6. Save the changes and update your app.