Why are 500 points killing my drawing?

[Patrick G]

I need to do some very basic surface analysis with about 500 points.

I'm saving the points as a CSV file (CSV (MS-DOS) (*.csv)) from microsoft excel. It's got three columns, X/Y/Z

In a brand new empty DWG, From the insert tab, I'm using "Points from a File" I select the ENZ format and the dwg just becomes useless. It takes 20 minutes to load it takes 15-30 minutes to do anything on the screen.

I'm using Civil3D2021.

What am I doing wrong? How could I do it differently?

Points file attached. Had to resave it as .xlsx so I could upload to Augi

[cadtag]

It took about 1 second here

[Patrick G]

It took about 1 second here

What could I possibly be doing that bogs this down?
I've tried a drawing on my desktop instead of the company network, I've tried the default Autocad template.dwt versus my company template.dwt. I can't figure out how to make this manageable. I go to zoom out and it freezes and takes forever. I get the notice about turning off High Quality Geometery because its so slow.

[Patrick G]

It took about 1 second here

cadtag, Can you do me a favor and check something. I think I may have found the problem. Please open the EXPORT.xlsx files I sent, do you have three broken references on row 1,048,576? (Control down arrow twice should get you there fast)

I created this xlsx with formulas based on output from a CAD plugin. however, I never know how many rows of output I will get from the plug in. So I copied the formula to the whole row. I think when I am bringing this into CAD as a point file, It is looking at one million lines even though every thing below 501 is blank.

I tested by copying all the data from row 501 up into a new xlsx and imported that into CAD as a points file and it works well, no lag.

[Ed Jobe]

I think you answered your own question.

[Patrick G]

I think you answered your own question.

I hope I answered my own question, but like I said, the .xlsx that I posted above has broken refs on row 1mil+. So it makes no sense that cadtag was able to import that xlsx in 1 sec. However if something he did converting to .csv cleaned that error, then that would explain it. Hence I asked to double check. Does that make sense?

[Ed Jobe]

No, I opened it and the bad ref's were still there. Opening as csv didn't change it. But if you cleaned it up and it worked after that, then that's good. I guess you're asking if cadtag did something similar? If I save it as a csv, everything below row 500 looks like this:

,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
#REF!,#REF!,#REF!

However, if I delete #REF!, it doesn't include the blank rows anymore.