Import Excel Data into Oracle

Step 1. Open SQL Developer and Connect to Your Database.

  • Launch Oracle SQL Developer.
  • In the Connections pane, expand your connection and navigate to the Tables node.\
  • Create a table structure
    Connections pane

Step 2. Initiate the Import Process.

  • Right-click on the Tables node or an existing table (if you want to import data into it).
  • Select Import Data... from the context menu.
    Import Process

Step 3. Select Your Excel File.

  • In the Import Wizard, click the Browse button.
  • Locate and select your Excel file (.xls or .xlsx).
  • Click Next to proceed.
    Next

Step 4. Configure Import Settings.

  • Ensure the correct worksheet is selected.
  • Check the box "Header" if your Excel file has column headers.
  • Adjust the "Skip Rows" value if necessary (e.g., if your data starts from row 2, set this to 1).
  • Click Next.

Step 5. Define Import Method and Table Details.

  • Choose the Import Method.
    • Insert: Directly inserts data into the table.
    • Insert Script: Generates a SQL script with INSERT statements.
  • If creating a new table, provide a Table Name.
  • Click Next.
    Click Next

Step 6. Select Columns to Import.

  • Review the columns detected from your Excel file.
  • Select the columns you wish to import.
  • Click Next.
    Select Columns

Step 7. Map Excel Columns to Table Columns.

  • Map each Excel column to the corresponding table column.
  • Ensure data types are correctly matched.
  • Click Next.
    Table Columns
    Finish

Step 8. Review and Finish.

  • Review the summary of your import settings.
  • Click Finish to start the import process.
    Ok

Step 9. Verify Imported Data.

  • Once the import is complete, you can verify the data by executing a SELECT query on the table: SELECT * FROM your_table_name;
    Data