Creating toposolid from csv - no points found

Creating toposolid from csv - no points found

blank...
Advisor Advisor
611 Views
2 Replies
Message 1 of 3

Creating toposolid from csv - no points found

blank...
Advisor
Advisor

I'm trying to create a toposolid from a csv file, but I'm getting "No points were found in the file" no matter what I try.

 

This is how file looks when opened in Excel

 

Clipboard03.jpg

 

I tried saving it as a txt (ms dos), but that didn't help either.

 

 

Csv file attached.

Units are meters, C column is the height, A and B columns are coordinates used by surveyors in my country, from geodetic reference system they use, that's why they're enormous.

0 Likes
Accepted solutions (1)
612 Views
2 Replies
Replies (2)
Message 2 of 3

RDAOU
Mentor
Mentor
Accepted solution

@blank... 

 

It is using a separator (delimiter) other than a comma. For example, if the number formatting in Excel is set to follow Windows regional settings where ; is the separator, Revit will not be able to read these points.

 

Option A: Go to Windows Control Panel >> Region >> Advanced settings >> Format tab >> List Separator Change the separator to a comma ( , ). Then, resave the CSV file.

Option B: Open the CSV file in Notepad, then use Find and Replace to replace all ( ; ) with a comma ( , ).

 

 

RDAOU_0-1742199104358.pngRDAOU_1-1742199114437.png

 

 

 

YOUTUBE | BIM | COMPUTATIONAL DESIGN | PARAMETRIC DESIGN | GENERATIVE DESIGN | VISUAL PROGRAMMING
If you find this reply helpful kindly hit the LIKE BUTTON and if applicable please ACCEPT AS SOLUTION


0 Likes
Message 3 of 3

blank...
Advisor
Advisor

@RDAOU wrote:
  • Option B: Open the CSV file in Note Pad, then find and replace all ";"or whichever separator that csv is using with "," comma

 

RDAOU_0-1742199104358.pngRDAOU_1-1742199114437.png

 

 

 


This was it! Didn't think to check in Notepad how Excel exports it.

Thank you!