# Import from excel is limited to 65536 rows

**URL:** <https://forums.toadworld.com/t/import-from-excel-is-limited-to-65536-rows/41165>\
**Category:** Toad for SQL Server\
**Created:** [July 12, 2018, 11:23am UTC](https://forums.toadworld.com/t/import-from-excel-is-limited-to-65536-rows/41165 "2018-07-12T11:23:54Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![costabas](https://avatars.discourse-cdn.com/v4/letter/c/258eb7/32.png) [@costabas](https://forums.toadworld.com/u/costabas)\
**Post date:** [July 12, 2018, 11:23am UTC](https://forums.toadworld.com/t/import-from-excel-is-limited-to-65536-rows/41165/1 "2018-07-12T11:23:54Z")

</div>

I want to import the data from an excel file which has approximately 85k rows. Toad imports only up to 65536 rows. Can you please fix this and increase the limit to 1 million or whatever the maximum allowed is in Excel?

Thank you!

---

<div class="post-metadata">

**Author:** ![michael](https://avatars.discourse-cdn.com/v4/letter/m/4bbf92/32.png) [@michael](https://forums.toadworld.com/u/michael)\
**Post date:** [July 15, 2018, 6:40pm UTC](https://forums.toadworld.com/t/import-from-excel-is-limited-to-65536-rows/41165/2 "2018-07-15T18:40:08Z")

</div>

Hi,

Have you try import csv format?

it would be better performance when import with csv format.

Michael