Import CSV - no points were found in file error

[michaelN96YM]

I've checked all over to find a solution wrt a csv file import to create topography. See atatcehed csv file.

I've tried changing period to comma and neither works.

Keep getting the same issue. 

[barthbradley]

Try deleting the 4th column. You only need x,y,z.  

...get rid of the semi-colons in the cell values.  

[ToanDN]

The CSV format is all wrong.  If you are not sure if the semicolon separating columns or separating decimals then it is better to ask the author to give you a tabulated csv.

[michaelN96YM]

This is super weird - see my screen shot of the csv file - does not look like the one you opened.

 

[michaelN96YM]

I've got a pretty good understanding as it is very simple, the csv file i have only has three columns with numeric data. 

The column/period is part of the value. I tried using a period and then column. 

[barthbradley]

Widen the columns. I didn't notice right away either.  

[barthbradley]

screenshot 2.png looks correct.  Does that one fail as Comma Separated Values?  Try saving it as a txt file and using that. 

[michaelN96YM]

I tried that, still no luck.

 

[barthbradley]

All the values are in one column!  

[michaelN96YM]

I did expand all the cells, not getting what is showng on your side. I've added the csv file again.

[michaelN96YM]

They are not in one column, that i can ensure you. 

[barthbradley]

---

@michaelN96YM wrote:

They are not in one column, that i can ensure you. 

---

[michaelN96YM]

Not sure why it looks like that on your side, on my side it is in three columns

[michaelN96YM]

I tried saving it as csv utf-8. See attached images to show you they are in seperate columns

[barthbradley]

Okay, if it's 3 columns on your end, then use a comma to separate values.  On my end (and in that screenshot), I see semicolons.  

[barthbradley]

Yeah, I don't what's going on, but I've downloaded and opened your CSV three times and this is what I get:

If the CSV you posted here is the same CSV you are using in Revit, then there's your problem.    

[michaelN96YM]

I tried another projects csv - all in one column with extra information (point indicator). see image. And it worked...now i'm super confused

[barthbradley]

Why don't you save that file as a txt file?  Revit can create a Toposurface from txt as well. 

Here's what I get. Weird-looking Topo.  Look familiar to you? 

[barthbradley]

I copied all the data in the A column to Notepad, replaced all the semicolons with commas, and saved it.  Then I used this txt file to create the Topo you see.  

[barthbradley]

---

@michaelN96YM wrote:

I tried another projects csv - all in one column with extra information (point indicator). see image. And it worked...now i'm super confused

---

You couldn't have created a Toposurface from a CSV formatted that way.