Trimble Business Center

Hi Patrick,

Not sure if this is the best way, but it works in this case if perimeter and area are the only attributes you need to export.

Select all the polygons, then go to Export -> GIS tab -> Shapefile exporter. You can leave all the settings as default.

This export will create a folder containing 4 files. One of them is .DBF. You can open that file with Excel, and it should look something like below. Then you can resume the edit there.

The other way is to; print plan set,ocr, select text, and copy into excel. This can be less reliable though. 

Thank you Rui. The other method I ended up using was the area length and count command which will generate pretty much the same data directly in excel. 

This works but there are other tables that would be great to be able to grab and copy their data to excel that I don't think these methods would be applicable too. 

Hi Patrick,

Not sure if this is the best way, but it works in this case if perimeter and area are the only attributes you need to export.

Select all the polygons, then go to Export -> GIS tab -> Shapefile exporter. You can leave all the settings as default.

This export will create a folder containing 4 files. One of them is .DBF. You can open that file with Excel, and it should look something like below. Then you can resume the edit there.

The other way is to; print plan set,ocr, select text, and copy into excel. This can be less reliable though. 

I was going to suggest the area/length/count report.  I have learned the hard way to not print it and use OCR, it may look like you got everything correct but there can easily be one little 6 read in as a 0 somewhere and you're hosed.

The other way is to; print plan set,ocr, select text, and copy into excel. This can be less reliable though. 

Do you guys explode the table or not  when printing PDF sheet?  That way its printed as text and not as a drawing.

------------------------------
Francisco Guerrero

Original Message:
Sent: 12-21-2020 07:52
From: Wayne Welshans
Subject: Export Table to Excel

I was going to suggest the area/length/count report.  I have learned the hard way to not print it and use OCR, it may look like you got everything correct but there can easily be one little 6 read in as a 0 somewhere and you're hosed.

The other way is to; print plan set,ocr, select text, and copy into excel. This can be less reliable though. 

Do you guys explode the table or not  when printing PDF sheet?  That way its printed as text and not as a drawing.

------------------------------
Francisco Guerrero

Original Message:
Sent: 12-21-2020 07:52
From: Wayne Welshans
Subject: Export Table to Excel

I was going to suggest the area/length/count report.  I have learned the hard way to not print it and use OCR, it may look like you got everything correct but there can easily be one little 6 read in as a 0 somewhere and you're hosed.

The other way is to; print plan set,ocr, select text, and copy into excel. This can be less reliable though.