Export Coordinates from AutoCAD to Excel in regular intervals via LIST and LOGFILEPATH COMMAND

preview_player
Показать описание
In this session I have shown how to export coordinate data i.e. Easting Northing data from an alignment drawing in AutoCAD to Excel. If you have only a drawing of an alignment of Road project, Railway project or any other project and you want to export the chainage wise coordinate details then this video will be helpful to you.
First, I applied MEASURE command to split the alignment in a fixed interval by placing POINTs through the alignment.
Then selected all points.
Then I applied LOGFILEPATH, LOGFILEON Command and then applied LIST Command in AutoCAD to extract the all POINTs data.
Then I copied all data to excel and used Text-to-Column feature in excel and extracted the coordinates for each chainage.
I have also shown how to cross check the extracted data by applying formula in EXCEL.
Hope you will like this video.
________________________________________________________________________
Join this channel to get access to premium excel sheets:

Your little support will boost our potential to serve you more educative contents.

If you think this tutorial is helpful please Like & Share this video and Subscribe our channel to get free updates

With best wishes
L&E Team!
Рекомендации по теме
Комментарии
Автор

Extremely sorry for the background music, will recitify in next video. Please give a LIKE 👍 to show your support 🙏

LearnExplore
Автор

Sir Easting and Northing Coordinat Revert Tell me how to fix it Sir

nabanayak
Автор

I think Data Extraction command is same more useful.

imransohag
Автор

Pa g just make alignment and export file report…. Gal muk gayi… yea kya laila majnoon ki lamahdod kahani suna rahay ho…

engrkpk
Автор

Why you couldn't use data extraction command?

alihumza
Автор

Hello sir how are you? I want formola (if) in excel that saying If the bearing is coming in part one add nothing
If coming in part two {180-bearing} or coming in part 3 {bearing -180} or coming in part 4 {360-bearing} if you have any idea about that please thaks

abualayham
Автор

I need this excel sheet brother can you send me please

umerdraz
Автор

Very useful video for every surveyor..💯👌

sakthivelanbalagan
Автор

Isse easy Cad Tools K dwaara Excel Sheet Nikalta hai...

examgadh.
Автор

I enter quite too long with my 15000 points

simplifiedman