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

• How to create an app from a monthly Excel report
• Automatic list analysis with charts and filter function
• Create an app from an Excel calculation
• Create an app from an Excel stock inventory list
• Create survey and form apps based on Excel
• Creating an App with User-Specific Data Entry

See all 7 articles

Data sources for the app

• 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 9 articles

App Types

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

App design and customization

• App Designer | Add and edit app items individually
• Preview your App | Change Name and App Header Image
• Change the order of elements or arrange them next to each other
• 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

Publish your app

• Create | Publish App
• Where is my app?

App Items and Components

• Action Buttons
• Add action button to jump to another app
• Add action button to generate PDF file
• Change action button type for the main function of the app
• Add action button to jump from page to page

FAQ

• How do I group my list by a specific column?
• Show images in the list
• Can I add cells from a different worksheet?
• Where can I create an app?
• How do I upload my spreadsheet?
• Can I use my LibreOffice / OpenOffice Calc spreadsheet?

See all 9 articles