Sometimes you may find it easier to handle teammates' comments in an Excel spreadsheet. EndNote allows you to export references into Excel with predefined fields. A simple way is to use the "Export to Excel" output style following the steps below.
However, the exported data may look a bit messy and sometimes the format may not meet your needs. In this case, you can try the hard way - to customize your own output format. Watch the tutorial or follow the steps below.
Source: MD Anderson Cancer Center, University of Texas
Now you have set the output fields for Journal Articles. You may select another Reference Type and set the output fields for that particular type. You may take a look at the reference types you have in the library so you know which one needs to be defined.
One more step to do is to replace all carriage returns with semicolons. This step will merge multiple lines of data (e.g. author names, keywords) into a single line in each field so that all fields can be correctly displayed in Excel.
Be cautious! After you have replaced the carriage returns, the step CANNOT BE UNDONE. So we strongly suggest to you SAVE A BACKUP of your library before you proceed.