Your app data is stored in a Google spreadsheet. You may want to migrate your app data to a Microsoft Excel file. This article explains how to proceed so you don't lose any data and your app displays correctly.
Method 1: Export your Google Sheets data to Microsoft Excel
Open your Google spreadsheet. From the File menu, select Download and then Microsoft Excel.
Sign in to your Microsoft account. Go to the Awesome Table web app and create a new app.
Click Select a workbook.
Select your Excel file from SharePoint or OneDrive. Click Open.
Click Create.
Under App Configuration, select the Visualization type you want. Under Advanced Parameters select a Template for your app if you have one. Learn more: CSS template.
Click Update App.
 |
 |
Method 2: Copy / Paste your data from Google Sheets to Excel
Open your Google spreadsheet. Select the cells from your data sheet, right-click and copy your data.
Sign in to your Microsoft account. Open a new blank workbook.
Click in the cell A:1 and paste your data (Cmd+V or Ctrl+V).
If your app contains CSS code, go back to your Google spreadsheet, open your Template sheet and copy the first line.
Then copy/paste the cells one by one from your Google spreadsheet to your Microsoft Excel file.
- Double-click the cell
- Paste the data (Cmd+V or Ctrl+V)
When you are done, go to the Awesome Table web app and create a new app.
Click Select a workbook.
Upload your Excel file in Sharepoint or OneDrive. Select Files in the Upload menu.
Select your Excel file. Click Open.
Click Create.
Under App Configuration, select the Visualization type you want. Under Advanced Parameters select a Template for your app if you have one. Learn more: CSS template.
Click Update App.
|
|