Oracle XE-Data Uploading from CSV file

This is a step-by-step guide on the simplest of the simplest ways by which data can be uploaded from CSV file to Oracle table. I have done uploading using this way for as many as 10,000 records without any performance issues. It went very swiftly.

Login to OracleXE first and follow the instructions below:

Step 1 - Click Utilities

Step 2 - Click Data Load/Unload

Step 3 - Click Load

Step 4

Step 5 - Click Load Spreadsheet Data

Step 6 - Follow the screen

Step 7 - Follow the screen

Step 8 - Follow the screen

Step 9 - Follow the screen

Step 10 - Follow the screen


  1. Is there any pl/sql way to upload data from CSV to oracle table

  2. There are many possibilities to do that, but probably the easiest one is via a databaselink from Oracle to Excel, after configuring ODBC (Open DataBase Connectivity).

    More details can be found on:

  3. I have a question regarding the upload data from excel. I am getting error saying that file can't be larger than 32kb. I tried as script also and its the same problem. I have system admin rights but didn't find where to increase the maximum script byte size. Can you please help me with this? Thanks,

  4. Is there this tools can used with dblink