Skip to Questions

Fast Answers - Find an answer or "Ask Us!" for sources.

Useful Tip: Type keywords rather than proper names; e.g., companies or countries rather than Apple or China

Thomson ONE: Excel add-on

How can I pull an item from Thomson ONE into a spreadsheet using the Excel add-on?
Last Updated: Jan 09, 2015  |  3252 Views

Was this helpful? 0   0


Download the Thomson ONE  Excel Add-in, if you haven't already done so.

In Excel, use the Item Lookup from the Thomson ONE  menu tab.

You will get a menu as follows:

Make your selections for the Company, Period, Value, and Layout And Caption.  Then double click on the item you want where the results of the search are displayed.  The values and caption will then be inserted into the cells in your spreadsheet.

Other Answers / Comments (0)

    Other Ways to Contact Us

    Ask us.  Get Fast Answers.

    For Harvard affiliates or on-site visitors.  

    Request a research consultation.

    Hours of service.

    Baker Library | Bloomberg Center, Harvard Business School, Soldiers Field, Boston, MA 02163, 617-495-6040