Cannot import this .csv file

Cannot import this .csv file

awood
Collaborator Collaborator
1,311 Views
3 Replies
Message 1 of 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 Likes
Accepted solutions (2)
1,312 Views
3 Replies
Replies (3)
Message 2 of 4

Pointdump
Consultant
Consultant
Accepted solution

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
Message 3 of 4

Pointdump
Consultant
Consultant
Accepted solution

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
Message 4 of 4

awood
Collaborator
Collaborator

I knew it was something simple. Thanks @Pointdump 

 

Awood

0 Likes