Import Terrain XYZ - Error is not in the right format

[Vojtech Slavik]

Hey guys I need little help with formatting coordinations.

I'm doing terrain model from DWG drawings

1. I got 3D Lines / curve - > I opened in Rhino and exported from lines to points and save like . txt = XYZ

2. I opened in "notepad" and remove all symbols what I don't need it

3. Then I opened in Excel and export to the 3 columns

After all my work with it ... I stile cannot export it to Archicad 😕
I got Error note

What's wrong I'm doing ? It's becoming quite complicated but I really would like to learn it how to do it.

*No Elements were created. The source file is corrupted, is not in the right format or doesn't contain valid coordinates.

[Mathias Jonathan]

what kind of separator (tabulation, semicolon, comma... ) did you use?

when you open the xyz file with textedit?

[Vojtech Slavik]

I replace all separation and put all numbers in to the columns in excel. I think that i tested all of them 🙂 which one is correct ? 

[Mathias Jonathan · Accepted solution]

I work with tabulation for separator and no comma (point).

After a second look, your numbers seems really big. I always work with meters. Perhaps a problem in this direction?

[Vojtech Slavik]

Thanks this is it ... I exported in meter but My export was in millimeters.

I fixed it just change meter to millimeters