There are several ways to do this, but I will only show you how to do this using SQL Developer. Why? Because I just came across this functionality the other day.
However there are some things you have to pay attention to, you might get frustrated with it otherwise.
Let’s start with an Excel file.
via Notes on Oracle: Importing an Excel into an Oracle database.