Create Apps

Basics

• App creation 101 - Turning spreadsheets into apps with Open as App
• Get the idea of app creation
• Do's and Don'ts for your Excel Spreadsheet

Tutorials

• Create survey and form apps based on Excel
• Create an app from a simple Excel calculation
• Create an app with a dynamic dashboard from an Excel inventory list
• Create a license calculator with print functionality

Step "DATA" - Choose your data source

• What happens with my data?
• Upload a file from my computer
• Online hosted files
• Dropbox | Select Spreadsheet
• SharePoint | Select Spreadsheet
• One Drive | Select Spreadsheet

See all 7 articles

Step "TEMPLATE" - Select the type of app

• What is a Template?
• Template List
• Template Contact List
• Template Map
• Template List & Map
• Template Calculation

Step "DESIGN" - Define the logic and style

• App Designer | Add and edit app items individually
• Preview your App | Change Name and App Header Image
• Rearrange elements | Move items, group cells
• Add Cell | How to add cells subsequently
• Add and edit charts | Colors and options for diagrams
• Add List | How to add an extra list

See all 9 articles

Step "CREATE" - Publish your app

• Create | Publish App
• Where is my app?

FAQ

• Where can I create an app?
• How do I upload my spreadsheet?
• Can I use my LibreOffice / OpenOffice Calc spreadsheet?
• Incompatible formulas between Google Sheets and Microsoft Excel
• Does Open as App work with macros in Excel?
• How do I group my list by a specific column?

See all 9 articles