How to Import a CSV or Excel File in SQL Developer

If you need to import an Excel or a CSV file into SQL Developer, you can do that pretty easily.
SQL Developer has an Import Data feature that lets you import a CSV or an Excel file into an Oracle database.

To do this, you first connect to your database. Right-click on the Tables entry in your connection and select Import Data.

A screen will appear and is the first step of a wizard of importing data. Select your file, change any settings you need to, and follow the steps to import your CSV or import your Excel file into the Oracle database using SQL Developer.

This can work for small files and large files, but if you have a large file (say, thousands of rows), you may want to try SQL*Loader, which is a utility for specifically importing large files.

Timestamps:
00:00 Introduction
00:22 Sample CSV
00:37 Right-click tables
00:58 Select a file
01:18 Settings
01:48 Select import method
02:29 Enter table name and choose columns
03:14 Column definition
04:04 Summary
04:13 Success and results
04:38 More information

[academyninjakids]

I am not able to find a right directory to my path. It's looks like local file doesn't include my local disk. Do you know how to fix that?

[amanahmed]

this connection section is not coming to in interface
what should I do?

[patrick]

It works on smaller CSV files, but fails for CSV files with over 250, 000 tuples. Any clues to why?