Extract Pset to excel

[shahr.jfz]

Hi everyone,

A couple of years ago, I used a script created by @KirkWM to extract Property Set (PSET) data to Excel. It worked great back then, but I’m having trouble with it now.

Currently, I’m working with 3D solids, and the script doesn’t seem to extract the PSET data in a format that Excel can process easily. Additionally, I have a large number of Property Sets, and not all of them are assigned to every 3D solid in the drawing.

I’m looking for a more robust or updated solution that:

• Works reliably with 3D solids
• Exports the data in a clean, structured Excel format

I’ve uploaded the original script, my DWG file, and a sample Excel output to this post for reference.

If anyone could take a look or point me in the right direction for a better approach, I’d really appreciate it.

Thanks in advance!

Property Set Values-Output to Excel v2 (all) (1).dyn (79.6 KB)
interferenza type.dwg (5.4 MB)

[Aymen.Rzigui]

Hi @shahr.jfz !

I have the solution for you, try this out and let me know if you face any problems (the .dyn file is attached to my answer)

This will generate an Excel sheet where every solid is separated from another solid by 1 blank row (to have data in a more structured and organised way) but you still need to do some formatting in Excel to make it more readable (as shown in the screenshot below)

Please tick this as an accepted solution if it worked for you. Thanks
3D Solids Property Set to Excel V2.dyn (66.3 KB)

[shahr.jfz]

thank you @Aymen.Rzigui it works totaly fine now