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

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:
/ @learnexplore
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!

[@LearnExplore]

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

[@gelomisagal3060]

Sir do you have a video tutorial sir on leveling surveying and how to compute for elevation from a given benchmark? And do you have a tutorial on how to compute manual surveyed traverse and getting its correction and adjusted coordinates using excel? Because i remember we did a traverse using TS but manually, our G.E wrote the direct and reverse & dist. shots in a paper then he did some sort of getting the mean of those then plotted in civil3d align the traverse in our given benchmarks (primary control) then he did some sort of computing of corrections and adjustments to get the coordinates of the 2ndry control we made in the ground do u have a video like that and if not i hope u do a video something like that. thanks alot and godbless.

[@sakthivelanbalagan5534]

Very useful video for every surveyor..💯👌

[@user-bj9tg6qq7f]

Thank you! This is very useful.

[@getahunbogale6987]

Best

[@spsingh-vh3iy]

👍

[@greatcivil7485]

Great 👍

[@LearnExplore]

Thanks

[@subhadipmondal2198]

First view👍👍

[@LearnExplore]

Please LIKE this video too if helpful

[@subhadipmondal2198]

@@LearnExplore yes sir Beautiful explain

[@borpit087]

❤😂❤ thank

[@nabanayak1000]

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

[@imransohag3518]

I think Data Extraction command is same more useful.

[@abualayham2220]

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

[@LearnExplore]

Yes. Similarly i made a program. kzbin.info/www/bejne/d4LHnGChrKilidU Download this file and unprotect it by password: LandE You will see the formula

[@umerdraz4452]

I need this excel sheet brother can you send me please

[@alihumza9590]

Why you couldn't use data extraction command?

[@LearnExplore]

We don't have vertices

[@selfreflection9782]

Thank you for the data extraction info.

[@manjaiah4719]

How to create a logfile path sir

[@LearnExplore]

Use logfilepath command

[@examgadh2.0]

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

[@LearnExplore]

I agreed. But with this method one can get the base knowledge of this conversion.

[@artasiantech8551]

IT'S LONG PROSESS

[@LearnExplore]

Yes. It's like a jugaar. But somehow helpful

[@simplifiedman]

I enter quite too long with my 15000 points

[@LearnExplore]

No problem. You can export it

[@engrkpk]

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