Proteomics records and data processing
Exported Excel documents from proteome discoverer are filled with additional nested values that need to be removed before they can be easily imported into R.
To do so, select the visible cells from the first tab with the other rows collapsed, go to home, find and select, and pick go to special. Select "Select Visible Cells Only" and select ok. Then select copy and paste these into a new spreadsheet.
Save this spreadsheet as "Data Reduced" with additional identifying information, including a brief description of the experimental design.