How to Conver Excel Spreadsheet into Database Application

Prerequisites

Request a workspace and user here, if you do not have one .
Download and unzip the tasks.zip file into your working directory.

Step by step in the Apex environment

_{Courtesy : www.oracle.com}

Create a Database Application From Excel Spreadsheet

To create a database Application perform the following steps:

Log in to Oracle Application Express with detail provided by HDS APEX administrator.
Workspace : <your workspace name>
Username : <your username>
Password : <your password>
Select the drop down next to Application Builder and select Database Applications.
Click Create.
Select Database and click Next.
Select From Spreadsheet and click Next>.
Select Upload File and click Next.
Select the file you want to upload. In this case, tasks.txt.
As the file is in .txt (not csv) format. Change the separator from , to \t and click Next.
The columns and data is identified from the file. You may change them if you wish in this wizard window. In this case, you want to enter Task for the Table Name and click Next.
Enter Tasks for the Plural Name and click Next.
You could change the label for each column in this wizard window. The label would be stored as a user interface default so that when you use it on a page, the label will be used instead of the column name.
You can identified access mode (read only or read write) and the way the report will be displayed (classic or interactive) and click Next.
Select a Theme which determines the look and feel of the application. In this case, accept the default Theme 1 and click Next.
Click Create to create the application.
Click Run Application to see your application.
Enter valid username and password for this application and click Login. In this case, your credential to the workspace.
The report for your applications is displayed as an Interactive report . You can click the Edit Icon in from of one of the row to see the detail.
The form is displayed. You can make changes to the data from this page.

Your application has been created successfully and you have seen the pages that are created.