How to Import Survey Data from Microsoft Excel into Autocad Civil 3D

[@azeez-t3o]

How did u save the excel file on your laptop…did u put .Csv at the end of d file name

[@JohnOkelloh]

Simply convert Excel to CSV. You can watch it here: kzbin.info/www/bejne/sJWqf5ereruEgas

[@agunbiadesamuel6810]

It is not working despite closing excel

[@JohnOkelloh]

Did you delete the header/heading row? Did your format in excel match the format that you chose in AutoCAD civil 3d?

[@agunbiadesamuel6810]

@JohnOkelloh I have gotten it.. the PNED(Comma delimited) was in .txt instead of .csv so I had to modify it to .csv in civil3d

[@JohnOkelloh]

@@agunbiadesamuel6810 Did you manage to plot after modifying your points?

[@agunbiadesamuel6810]

@@JohnOkelloh yes .. thanks alot

[@lindamuturi7288]

Please share how you added negative sign to the coordinates in excel .

[@JohnOkelloh]

I typed it just like any other character in excel. (Start by typing negative sign followed by coordinate)

[@lindamuturi7288]

By negative you mean the hyphen symbol?because I keep doing that but the excel cell with the coordinate is changed into a formula

[@JohnOkelloh]

@@lindamuturi7288 you can use hyphen as negative. If you had already typed the coordinates and you want to introducea negative (-). Place cursor in front of the coordinate and press (-), then press enter. Do not press another cell while the other cell that you are introducing a negative is still active.

[@JohnOkelloh]

Perhaps I need to do another tutorial for this.

[@drumsNmuscles]

Great video! I was stuck and unable to open my points in Civil 3D, even though I had the right Point File Format, and was unaware my excel sheet needed to be closed! Massive help, I would have been sitting here forever trying to figure that out. Thank you again,

[@JohnOkelloh]

I'm glad that this video helped 🙏🙏🙏

[@dorkboyvibes9877]

Great video! I look forward to seeing more of your content!

[@JohnOkelloh]

I appreciate 🙏🙏🙏

[@innocentalion50]

Through your channel may you help me to understand GPS fully because I be only understood how to get points and connect Rover and the base.

[@innocentalion50]

I really need your help from start.

[@Okelloh1]

@@innocentalion50 In the near future. Stay tuned.

[@mudimbipierrot6348]

Thank you very much ❤❤❤

[@JohnOkelloh]

🙏🙏🙏

[@danielokumu5006]

Good content

[@JohnOkelloh]

🙏🙏🙏