Cannot import this .csv file

Cannot import this .csv file

awood
Collaborator Collaborator
1,332件の閲覧回数
3件の返信
メッセージ1/4

Cannot import this .csv file

awood
Collaborator
Collaborator

Hi All,

Not sure what I'm doing wrong.

I took a .txt file, modified it a bit in excel.

Saved it as a .csv.

It looks like it's formatted correctly but, when I Import Points from File, Civil 3D 2020 keeps telling me "No point file format match found". It should be a standard PNEZD Comma Delimited format.

 

I attached the original .txt file, and the newly saved .csv file.

 

Is there something hidden in the point .csv file I'm missing?

Probably something simple...

 

Thanks,

AWood

0 件のいいね
解決済み
1,333件の閲覧回数
3件の返信
返信 (3)
メッセージ2/4

Pointdump
Consultant
Consultant
解決済み

Alex,
"Is there something hidden in the point .csv file I'm missing?"
Yup. A "Byte Order Mark", or >>>BOM<<<. Just resave in a format without the BOM.

 

BOM_1.png

 


Dave

Dave Stoll
Las Vegas, Nevada

EESignature

64GB DDR4 2400MHz ECC SoDIMM / 1TB SSD
NVIDIA Quadro P5000 16GB
Windows 10 Pro 64 / Civil 3D 2025
メッセージ3/4

Pointdump
Consultant
Consultant
解決済み

In Excel, use this CSV format:

 

BOM_1.png

 


Dave

Dave Stoll
Las Vegas, Nevada

EESignature

64GB DDR4 2400MHz ECC SoDIMM / 1TB SSD
NVIDIA Quadro P5000 16GB
Windows 10 Pro 64 / Civil 3D 2025
メッセージ4/4

awood
Collaborator
Collaborator

I knew it was something simple. Thanks @Pointdump 

 

Awood

0 件のいいね