I have some maps of pieces of lands and I want to convert the coordinates to excel sheet

I want to arrange the data like this in the excel sheet:

land number( the pink number in the pic) accompanied by its coordinates in each row

I will be really thankful if you can help me

enter image description here

link to the map file above:


I want to have 3 columns in the excel sheet

1) representing the land number text value

2) representing the the coordinates of that land separated by "_" like this 23.87718162405882_57.10554858573619_23.877357092058385_57.105595188322354_23.877292855536815_57.10588146117277 each two representing a point/corner

3) the block number where the land is

if the format of the coordinates can not be like above then there is no harm having 3 columns x and y or easting and northing plus point number. therefore each land will have rows of the same points number

  • which is your autocad version? your attached file size is 17 MB..a lesser extract would have been easier to view.. – vinayan Apr 22 '12 at 15:12
  • there are many possiblities. you said "it's coordinates". Do you just want the text value and the coordinate of it's insert point? or do you want the text value and each coordinate of the polygon? please update your question with the explanation. – Brad Nesom Apr 22 '12 at 22:49
  • I have updated the question – Sami Al-Subhi May 1 '12 at 18:59
  • And which autocad? Map?, civil3d?, or just autocad?. Version number? – Brad Nesom May 2 '12 at 17:50
  • just AutoCAD version:F.51.0.0 – Sami Al-Subhi May 6 '12 at 11:00

You can use the query to report, or the export functions.
report query
I will wait on your reply to the comment question and fill in more detail.

  • sorry for the late reply I had mid-exams. I was so busy. thank you for offering help. I answered your comment question. is that possible you think. sorry I have not used autoCAD before. – Sami Al-Subhi May 1 '12 at 18:47
  • Yes entirely. see other comment – Brad Nesom May 2 '12 at 17:51

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.