Help on use of Scientometric tools (for instance, extract author location)

@hawthorne wrote:

And then I would be able to count directly from the cells of Excel?

Yes, Excel is a spreadsheet which enables mathematical and statistical calculations so you would be able to automatically sum numerical data or count non–numerical data. Excel is also capable of generating charts and graphs linked to data files which allows for automatic updating when changes are made to a data file.

For information on  how to include Endnote field names  as column  headers in the Excel spreadsheet  refer to this thread.