Sometimes it is very handy to have a solution to paste or drag&drop Excel data into a database. The solution we are offering here utilizes Oracle Application Express and Oracle database. Excel data can be pasted via a web browser into the database and then published on the web page.
Our Paste Excel Data application makes it possible to build Ad-hoc web reports based on the data stored in MS Excel, and then make additional processing for example to remove duplicates or to harmonize data. This is the common task required by major corporations nowadays. Instead of using Excel worksheets, one can utilize this approach to achieve the goal.
Also, this solution helps in unifying usage of data and publishing it for anyone concerned, also reducing extra work with endless Excel sheets by a single user.
This is a sample application and requires further customization according to your reporting needs.
Minimum Application Express version is 3.2.
Oracle XE can be used as a free option for the database.
Download application for APEX 3.2
You can check the working sample on