Revit wont import CSV topography file

[Anonymous]

Hello, I´m trying to import topography from a surveyor into the REVIT.  I have an excel file with x,y,z points. Saved as CSV. Everytime when I try to import it by ,,Specify points file" revit says ,,no points were found". I tried to look for many solutions but none of them worked. Tried to save the excel as an CSV ( comma delimited) or CSV UTF-8. But it gives me the same result. Uploaded my csv file into Attachments aswell. Thank you for your advices or tips.

[barthbradley]

That's not a proper CSV file.  Plus, the Coordinates are way too far away for Revit. 

Try the attached TXT file. You can create a Toposurface from TXT files as well as CSV.  

[Anonymous]

that is weird, it should look like this. 

[Anonymous]

also what kind of coordinates do you mean? x y?

Screenshots from autocad: 

[barthbradley]

See my revised txt file above. 

[Anonymous]

is it cutout? because it shouldnt look like that or the part of it should but there should be 2 roads from both sides. Also can you tell me how did you manage to filter out the ,,751" and ,,116" from the begging of every number? or coordinates

[barthbradley]

I think my x coordinates are wrong then. Drop the beginning digit from each x coordinate value. 

Here's the main issue with your CSV file. Your xyz coordinates are all dumped into one colomn. On top of that, they are separated by semi-colons.  Revit translates COMMA SEPARATED x,y,z values - not semi-colon separated x,y,z values.   Lastly, the x,y coordinates are too large.  You need to truncate values.  Essentially this is like moving the Toposurface closer to the Revit Internal Origin.  

[Anonymous]

that is right they were all dumped into one colomn. My friend managed to fix that. And even after revit still showed me the  points not found error. 

[barthbradley · Accepted solution]

Are you sure this truncation doesn't work or is incorrect?  

000.000, 000.000, 000,000 

[Anonymous]

Now, when I edit it with the points visible it looks correct. Thank you for your help. Even tho I would like to know why my CSV file didnt work. I did watch many youtube tutorials and they all did the same thing. And it did work for them. Maybe it´s because of numbers being ,,too big" for revit. I dont really know. But thank you for your help.