# Importing Data from Excel with Import Wizard **URL:** \ **Category:** Toad for SQL Server\ **Created:** [February 25, 2019, 4:11pm UTC](https://forums.toadworld.com/t/importing-data-from-excel-with-import-wizard/45736 "2019-02-25T16:11:53Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![e.chin](https://avatars.discourse-cdn.com/v4/letter/e/edb3f5/32.png) [@e.chin](https://forums.toadworld.com/u/e.chin)\ **Post date:** [February 25, 2019, 4:11pm UTC](https://forums.toadworld.com/t/importing-data-from-excel-with-import-wizard/45736/1 "2019-02-25T16:11:53Z")
I am importing data from an Excel file with the Import Wizard. I check Column name as header, Empty fields are null and Normalize columns. After normalizing columns, Date\_, Code, Code Value and an extra mnemonic column is added. How do I import without having the extra mnemonic column? ---
**Author:** ![e.chin](https://avatars.discourse-cdn.com/v4/letter/e/edb3f5/32.png) [@e.chin](https://forums.toadworld.com/u/e.chin)\ **Post date:** [July 12, 2019, 1:32am UTC](https://forums.toadworld.com/t/importing-data-from-excel-with-import-wizard/45736/2 "2019-07-12T01:32:08Z")
Does anyone have any insight to do this? ---
**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\ **Post date:** [July 12, 2019, 10:32pm UTC](https://forums.toadworld.com/t/importing-data-from-excel-with-import-wizard/45736/3 "2019-07-12T22:32:43Z")
After you select to normalize your columns there is configuration box that requires you to set the names of the two extra columns. On the next tab you can remove any columns you want and perhaps only export the normalized columns. That is how we designed it. ---
**Author:** ![dan](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/dan/32/12882_2.png) [@dan](https://forums.toadworld.com/u/dan)\ **Post date:** [July 16, 2019, 11:52am UTC](https://forums.toadworld.com/t/importing-data-from-excel-with-import-wizard/45736/4 "2019-07-16T11:52:05Z")
@e.chin Evelyn, can you send us your Excel spreadsheet or a sample of it and add a screenshot of the issue here? Thanks ---
**Author:** ![y.quinones](https://avatars.discourse-cdn.com/v4/letter/y/5f8ce5/32.png) [@y.quinones](https://forums.toadworld.com/u/y.quinones)\ **Post date:** [October 2, 2024, 10:06pm UTC](https://forums.toadworld.com/t/importing-data-from-excel-with-import-wizard/45736/5 "2024-10-02T22:06:09Z")
Hi @dan, I'm a colleague of @e.chin with the identical problem. Here's a screenshot of my screen with the problem. ![screenshot_with_error](https://global.discourse-cdn.com/quest/original/3X/a/8/a898b89e75bfa384f4492583afb63eca2cb611b0.png) I'll send separate posts with screenshots of another colleague's screen without the problem. ---
**Author:** ![y.quinones](https://avatars.discourse-cdn.com/v4/letter/y/5f8ce5/32.png) [@y.quinones](https://forums.toadworld.com/u/y.quinones)\ **Post date:** [October 2, 2024, 10:07pm UTC](https://forums.toadworld.com/t/importing-data-from-excel-with-import-wizard/45736/6 "2024-10-02T22:07:08Z")
Here's a screenshot of my other colleague's screen without the error. This is before normalization. ![correct_screenshot_1](https://global.discourse-cdn.com/quest/original/3X/c/6/c6ddc369ecf890e8c36971eeaf20482ec67eafb2.png) ---
**Author:** ![y.quinones](https://avatars.discourse-cdn.com/v4/letter/y/5f8ce5/32.png) [@y.quinones](https://forums.toadworld.com/u/y.quinones)\ **Post date:** [October 2, 2024, 10:07pm UTC](https://forums.toadworld.com/t/importing-data-from-excel-with-import-wizard/45736/7 "2024-10-02T22:07:54Z")
Here's the 2nd screenshot of my other colleague's screen without the error. This is _after_ normalization. ![correct_screenshot_2](https://global.discourse-cdn.com/quest/original/3X/b/b/bbfa31777ebc80fce95e1fb348104396fe56fc09.png) ---
**Author:** ![rejhan.kuc](https://avatars.discourse-cdn.com/v4/letter/r/f9ae1b/32.png) [@rejhan.kuc](https://forums.toadworld.com/u/rejhan.kuc)\ **Post date:** [January 29, 2025, 9:40am UTC](https://forums.toadworld.com/t/importing-data-from-excel-with-import-wizard/45736/8 "2025-01-29T09:40:47Z")
Hello there, Could you please reach out with your sample data excel sheet being attached for further investigation? You can send your file via e-mail at: [rejhan.kuc@quest.com](mailto:rejhan.kuc@quest.com)