Go to Output Styles>Open Style Manager>From the list, check off the style Tab Delimited.
Go to Output Styles>Tab Delimited now appears in your drop down. Check it off.
Optional Tip:
Click Edit Tab Delimited, then click Bibliography>Templates.
Click Reference Type>Journal Article.
Copy the text from the Generic box to the box for Journal Article. These are the fields that will appear in your spreadsheet.
Every |field name| à indicates a new column. You can remove columns here that you do not want to appear by simply deleting them from the template.
You can also edit any other aspect of the how you would like the information to appear from the left hand column of this window, for example, journal name, sentence case, bolded fields, etc.
Highlight all the references you would like included in the Excel sheet.
Right-click on the highlighted references and select Copy Formatted References.
Open a new Excel sheet and place the cursor in cell A2. Paste the formatted references.
From here, you may want to add your own column headers in the first row and clean up the data as you would like it to appear.
Troubleshooting
If fields appear in multiple or random columns:
You may notice some inconsistencies in your spreadsheet, if the spreadsheet is beyond reasonably being able to fix within Excel, follow the steps below:
Make a backup copy of your Endnote Library by click on File (EndNote if you are using a Mac) and then click on Save a Copy.
Click on File (Or EndNote for Mac) then Open Library, and open the copy of your library.
Highlight all the references by clicking on All References on the left-hand column, then Control or Command+A to highlight all the references.
Go up to Library, click on Find and Replace.
Place the cursor in the box Find. Then click on Insert Special>Carriage Return.
Place the cursor in the box Replace. Press the space bar.
Go to the drop down menu Select A Field. Choose Any Field.
Click Change.
Now follow the steps for Copying the Formatting References to Excel.
