Each object a separate line in Export to Spreadsheet



I was wondering if anyone could help me with my CellProfiler spreadsheet. When I measure objects such as nuclei and nuclear staining through two “Identify Primary Objects” modules and relate them using “Relate Objects,” the resulting spreadsheets include a line for every nucleus, making it time consuming to search through the sheet to find the total number of objects for each image. How do I get CellProfiler to just export total numbers, such as total number of nuclei per image and total number of nuclei with co-localized nuclear stain?

Thank you for your help!


Hi Sophia-
That information should already be present in your Image.csv spreadsheet. The number of Nuclei will be Count_Nuclei; if you want to test fraction colocalizing, though, MaskObjects may be a better choice than RelateObjects.

Good luck!