# import excel file **URL:** \ **Category:** Toad for Oracle & DevOps Toolkit\ **Created:** [May 31, 2017, 11:02am UTC](https://forums.toadworld.com/t/import-excel-file/39534 "2017-05-31T11:02:07Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![smattiko](https://avatars.discourse-cdn.com/v4/letter/s/4bbf92/32.png) [@smattiko](https://forums.toadworld.com/u/smattiko)\ **Post date:** [May 31, 2017, 11:02am UTC](https://forums.toadworld.com/t/import-excel-file/39534/1 "2017-05-31T11:02:07Z")
How do I import an excel file into TOAD? I am on version 12.10.0.30. Thanks. ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [May 31, 2017, 11:07am UTC](https://forums.toadworld.com/t/import-excel-file/39534/2 "2017-05-31T11:07:14Z")
1. Go to the Schema Browser 2. Find the table that you want to import into. RIght-click it and choose “Import data” 3. A wizard will guide you through the rest of the process. For fastest import, check “Use Array DML” on the last step. ---
**Author:** ![smattiko](https://avatars.discourse-cdn.com/v4/letter/s/4bbf92/32.png) [@smattiko](https://forums.toadworld.com/u/smattiko)\ **Post date:** [May 31, 2017, 11:12am UTC](https://forums.toadworld.com/t/import-excel-file/39534/3 "2017-05-31T11:12:45Z")
I don’t have a table I want to import it into. Do I have to create one? ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [May 31, 2017, 11:15am UTC](https://forums.toadworld.com/t/import-excel-file/39534/4 "2017-05-31T11:15:03Z")
Yes. If your excel file has column names in the first row, the create table wizard can help you pull the column names and datatypes from the Excel file. Go to Database -\> Create -\> Table. Then click “Load cols from file” at the bottom. Make whatever adjustments are needed after that and click OK to create the table. Then you can follow the steps from my first reply. ---
**Author:** ![smattiko](https://avatars.discourse-cdn.com/v4/letter/s/4bbf92/32.png) [@smattiko](https://forums.toadworld.com/u/smattiko)\ **Post date:** [May 31, 2017, 11:31am UTC](https://forums.toadworld.com/t/import-excel-file/39534/5 "2017-05-31T11:31:04Z")
It keeps on saying “Duplicate column names are not allowed.” when I’m trying to create the table with the “Load cols from file”. There are no duplicates though. ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [May 31, 2017, 11:39am UTC](https://forums.toadworld.com/t/import-excel-file/39534/6 "2017-05-31T11:39:30Z")
Make sure that the list of columns on the create table dialog is empty before you click “Load Cols from File”. Then if you still get that error, there should be one column in the create table dialog after that - this is the one that it found a duplicate on. If the column name is blank - then there is a column without a heading in the excel file. If the column name is not blank, then there must be two by that name. (Note that spaces and other characters not allowed in table names will be converted to underscores…so if you had “COLUMN 1” and “COLUMN\_1” in your excel file, then both would come into your table as COLUMN\_1, and that would be a duplicate. ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [May 31, 2017, 11:40am UTC](https://forums.toadworld.com/t/import-excel-file/39534/7 "2017-05-31T11:40:49Z")
If you don’t see the problem, send your excel file to me at [john.dorlon@quest.com](mailto:john.dorlon@quest.com) and I’ll take a look. Feel free to delete the data out of it (except column headers!) if it’s confidential. ---
**Author:** ![smattiko](https://avatars.discourse-cdn.com/v4/letter/s/4bbf92/32.png) [@smattiko](https://forums.toadworld.com/u/smattiko)\ **Post date:** [May 31, 2017, 11:42am UTC](https://forums.toadworld.com/t/import-excel-file/39534/8 "2017-05-31T11:42:03Z")
I got it to work and imported file. Thank you for all the help. ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [May 31, 2017, 11:52am UTC](https://forums.toadworld.com/t/import-excel-file/39534/9 "2017-05-31T11:52:35Z")
You’re welcome. I’m changing that error message for the next version to tell you the duplicate column name and which position it is found in the source file, so you won’t have to hunt for it. ---
**Author:** ![rthornton12](https://avatars.discourse-cdn.com/v4/letter/r/35a633/32.png) [@rthornton12](https://forums.toadworld.com/u/rthornton12)\ **Post date:** [March 10, 2022, 6:00pm UTC](https://forums.toadworld.com/t/import-excel-file/39534/10 "2022-03-10T18:00:07Z")
> [@smattiko](#): > > 12.10.0.30 I'm new so please bare with me! I'm on version version 6.7.0.176 of Toad for SQL Server. I can not find the Schema Brower in the app? Thanks, Bob ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [March 10, 2022, 6:03pm UTC](https://forums.toadworld.com/t/import-excel-file/39534/11 "2022-03-10T18:03:46Z")
@rthornton12 Please post in the Toad for SS forum. This one is Toad for Oracle. They are totally separate products with totally separate teams. [Toad for SQL Server - Toad World® Forums](https://forums.toadworld.com/c/toad-for-sql-server/11) Thanks. ---
**Author:** ![rthornton12](https://avatars.discourse-cdn.com/v4/letter/r/35a633/32.png) [@rthornton12](https://forums.toadworld.com/u/rthornton12)\ **Post date:** [April 25, 2022, 1:54pm UTC](https://forums.toadworld.com/t/import-excel-file/39534/12 "2022-04-25T13:54:47Z")
Sorry about that!