# What are the limits of Excel import?

**URL:** <https://forums.visual-paradigm.com/t/what-are-the-limits-of-excel-import/14895>\
**Category:** General Questions/Discussions\
**Created:** [January 10, 2019, 12:54pm UTC](https://forums.visual-paradigm.com/t/what-are-the-limits-of-excel-import/14895 "2019-01-10T12:54:13Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![jghass](https://avatars.discourse-cdn.com/v2/letter/j/a587f6/32.png) [@jghass](https://forums.visual-paradigm.com/u/jghass)\
**Post date:** [January 10, 2019, 12:54pm UTC](https://forums.visual-paradigm.com/t/what-are-the-limits-of-excel-import/14895/1 "2019-01-10T12:54:13Z")

</div>

I have a Dictionary of Terms in an Excel file that has 43K records. I have attempted to import this into a Glossary Grid on 2 separate occasions. It does not complete. I have attempted to debug this issue and Windows appears to suggest that this is waiting on network to complete.

I suspect, based on this info, may be caused by the fact that I have elected to store the Project on VPOnline. I am going to attempt to create this Glossary with the Project saved locally.

Am I asking too much of VP?

---

<div class="post-metadata">

**Author:** ![peter.wong](https://forums.visual-paradigm.com/user_avatar/forums.visual-paradigm.com/peter.wong/32/3250_2.png) [@peter.wong](https://forums.visual-paradigm.com/u/peter.wong)\
**Post date:** [January 11, 2019, 1:20am UTC](https://forums.visual-paradigm.com/t/what-are-the-limits-of-excel-import/14895/2 "2019-01-11T01:20:33Z")

</div>

May you provide our log file (vp.log file) to us for checking any exception thrown during the excel importing?  
_(vp.log can be exported from Help \> About Visual Paradigm … \> Export Log File…)_

* * *

_Sorry, I am not sure do I understand the problem. You mean:_  
pt.A.  
Import a 43000+ rows excel into VP, but the imported Glossary Terms are less than 43000  
and you found Windows prompt: “waiting on network to complete”

pt.B.  
You think the problem comes from your VP Project is a teamwork project.

* * *

about pt.B  
It should not be a problem.  
It is because, your VP Project (.vpp file) is checked out into your local disk.  
And the actions of _Excel importing_, _Glossary editing_, _Drawing on a diagram_, _etc…_ will not interact with VP-Online immediately.  
So, there should be no any networking problem when you import an excel.

about pt.A,  
if that message is prompted by Windows, I think it may be because the excel file is stored in a network drive, and something got wrong when reading the excel file? (It is my guess only… I never try it…)  
_(But no this case, I think no glossary term can be imported into VP. But now, you got some terms imported, some terms not…)_