How to import into a table an Excel file

[albaalbetti]

By using Pl/Sql Developer vers. 8.0.4 I see that it's possible to import a file into a table with the function Tools-->Text importer but the problem is that the formats allowed are TXT and CSV. Is there a way for importing directly a XLS as well as it happens, for example, with Toad?
Thanks!

 

[Marco Kalter]

There are 2 methods:

1. Save the Excel file in CSV format and use the Text Importer tool to import it.

2. Use the ODBC Importer tool to directly import the Excel file.

 

[albaalbetti]

Ok, it works.
But in a column in excel I have a text with many carriage returns and after importing by using your advice, I see that in the table the carriage returns are missing

 

[Marco Kalter]

Are the linefeeds (character 10) still present? Carriage returns (character 13) are indeed Windows specific and will be removed when posted to the database.