Skip to Main Content
Hours & Login Menu
  • Hours
  • Login
    • Library Search Login
    • Interlibrary Loan
Dartmouth Libraries Dartmouth Libraries

Global dropdown menu

    • Borrow and Request
      • Who Can Borrow
      • What You Can Borrow
      • Loan Periods and Renewals
      • Borrow from Other Libraries
      • Request Materials
      • All Borrow and Request
    • Collections
      • Digital Collections
      • Media Collections
      • Oral Histories
      • Collections Care
      • Donate
      • All Collections
    • Course Reserves
      • Find Course Reserves
      • Create or Add Course Reserves
      • All Course Reserves
    • Off-Campus Access
    • Records Management
      • Retention and Disposition
      • Confidential Monthly Destruction
      • Electronic Records
      • Physical Records
      • Retention Schedules
      • All Records Management
    • Search and Browse
      • Library Search
      • Databases
      • Journals
      • Research Guides
      • Maps and Atlases
      • Newspapers
      • Dartmouth Digital Commons
      • Music Scores
      • BorrowDirect
      • Archives and Manuscripts
      • All Search and Browse
    • Design and Produce
      • Audio and Video
      • Book Arts
      • Digital Art and Design
      • Equipment and Hardware
      • Software
      • All Design and Produce
    • Data Services
      • Research Data Management
      • Data Analysis and Visualization
      • Data Repositories
      • Data Workshops
      • Datasets at Dartmouth
      • All Data Services
    • Digital Scholarship
    • Publishing and Copyright
      • Copyright
      • Open Access
      • Publisher Agreements
      • Publishing for Faculty
      • Publishing for Students
      • All Publishing and Copyright
    • Research Help
    • Teaching and Workshops
    • Print, Copy, Scan
    • Locations
      • Baker-Berry Library
      • Book Arts Workshop
      • Evans Map Room
      • Feldberg Business and Engineering Library
      • Health Sciences and Biomedical Libraries
      • Jones Media Center
      • Library Collections and Services Facility
      • Rauner Special Collections Library
      • Sherman Art Library
      • All Locations
    • Accessibility
    • Events
    • Exhibits
    • Hours
    • Study Spaces
    • About Dartmouth Libraries
      • Council on the Libraries
      • Diversity, Equity, and Inclusion
      • Friends of the Libraries
      • Library Departments
      • Strategic Framework
      • Staff Directory
      • All About Dartmouth Libraries
    • Employment
      • Staff and Professional Positions
      • Student Positions
      • Fellowships
      • All Employment
    • News and Highlights
    • Policies and Guidelines
    • Programs and Awards
      • Alumni Memorial Book Fund Program
      • Librarians Active Learning Institute
      • MAD Research Video Contest
      • Staff Awards
      • All Programs and Awards
    • Contact Us
    • We're Here to Help
      • Students
      • Faculty
      • Alums
      • Staff
      • Visiting Researchers and Community
      • All We're Here to Help
    • Find a Specialist
      • Subject Librarians
      • Audio and Video Production
      • Preservation and Emergency Preparedness
      • Publishing and Copyright
      • Records Management
      • Research Data Services
      • Systematic Review
      • All Find a Specialist
    • Ask Us
  • Hours
    • Library Search Login
    • Interlibrary Loan

Global dropdown menu

    • Borrow and Request
      • Who Can Borrow
      • What Can You Borrow
      • Loan Periods and Renewals
      • Borrow from Other Libraries
      • Request Materials
    • Collections
      • Digital Collections
      • Media Collections
      • Oral Histories
      • Collections Care
      • Donate
    • Course Reserves
      • Find Course Reserves
      • Create or Add Course Reserves
    • Off-Campus Access
    • Records Management
      • Retention and Disposition
      • Confidential Monthly Destruction
      • Electronic Records
      • Physical Records
      • Retention Schedules
    • Search and Browse
      • Library Search
      • Databases
      • Journals
      • Research Guides
      • Maps and Atlases
      • Newspapers
      • Dartmouth Digital Commons
      • Music Scores
      • BorrowDirect
      • Archives and Manuscripts
    • Design and Produce
      • Audio and Video
      • Book Arts
      • Design and Digital Art
      • Equipment and Hardware
      • Software
    • Data Services
      • Research Data Management
      • Data Analysis and Visualization
      • Data Repositories
      • Data Workshops
      • Datasets at Dartmouth
    • Digital Scholarship
    • Publishing and Copyright
      • Copyright
      • Open Access
      • Publisher Agreements
      • Publishing for Faculty
      • Publishing for Students
    • Research Help
    • Teaching and Workshops
    • Print, Copy, Scan
    • Locations
      • Baker-Berry Library
      • Book Arts Workshop
      • Evans Map Room
      • Feldberg Business and Engineering Library
      • Health Sciences and Biomedical Libraries
      • Jones Media Center
      • Library Collections and Services Facility
      • Rauner Special Collections Library
      • Sherman Art Library
    • Accessibility
    • Events
    • Exhibits
    • Hours
    • Study Spaces
    • About Dartmouth Libraries
      • Council on the Libraries
      • Diversity, Equity, and Inclusion
      • Friends of the Libraries
      • Library Departments
      • Strategic Framework
      • Staff Directory
    • Employment
      • Staff and Professional Positions
      • Student Positions
      • Fellowships
    • News and Highlights
    • Policies
    • Programs and Awards
      • Alumni Memorial Book Fund Program
      • Librarians Active Learning Institute
      • MAD Research Video Contest
      • Staff Awards
    • Contact Us
    • We're Here to Help
      • Students
      • Faculty
      • Alums
      • Staff
      • Visiting Researchers and Community
    • Find a Specialist
      • Subject Librarians
      • Audio and Video Production
      • Preservation and Emergency Preparedness
      • Publishing and Copyright
      • Records Management
      • Research Data Services
      • Systematic Review
    • Ask Us
  • Hours
    • Library Search Login
    • Interlibrary Loan
  1. Dartmouth Libraries
  2. Research Guides
  3. Dartmouth Libraries Guides
  4. Bloomberg: Getting Started
  5. Bloomberg Excel Add-in

Bloomberg: Getting Started

Learn how to access and use the Bloomberg Professional Service
  • Getting Started
  • Training
  • Basics
  • Bloomberg Excel Add-in
    • What it is
    • Working with the Excel Add-In
    • Alternatives to using the Excel Add-In
    • Excel Add-in Guides & Help
  • Equities
  • Industries
  • Key Functions & Cheat Sheets
  • Business Home

What it is

The Bloomberg Excel Add-In is a powerful tool that delivers Bloomberg data and analytics into an Excel spreadsheet on the user’s desktop. 

To use the Excel Add-In, you must be logged into Bloomberg. 

Working with the Excel Add-In

1. Use the Import Data Wizard

The Import Data Wizard makes it easy to import Bloomberg data into a spreadsheet by automatically generating the appropriate functions through an easy step-by-step process.

You can launch the Import Data wizard by, selecting Import Data from the Bloomberg Menu or by clicking on the Import Data icon on Excel toolbar. 

Select the type of data you want download, then follow the steps. 

 

2. Use Worksheet Functions in Excel

Bloomberg’s worksheet functions provide intermediate to advanced Excel users flexibility to construct their own formulas to customize the way Bloomberg data is delivered and organized in the spreadsheet. 

In the Excel Add-in, Bloomberg functions are consolidated with flexible optional parameters:

  • BDP (Bloomberg Data Point) is for current data.
  • BDH (Bloomberg Data History) is for historical end of day and historical intraday data.
  • BDS (Bloomberg Data Set) is for large data sets/ bulk data. 

When using any of the formulas, you must specify the security for which you want to retrieve data (Security), and you must specify the data item you want to retreieve (Field). The Security must be represented as (Ticker) (Market Sector), for example TGT Equity.

Fields are represented by mnemonics. Use the Field Search tool in Excel to search by category or keyword. 

For more information about the using Excel Add-in

  • Watch the Bloomberg Essentials  video (Bloomberg Data in Excel) BESS <GO>
  • Download the Getting Started Guide for Students
  • Download the Bloomberg Excel Desktop Guide
  • Download the Function Reference Guide

Alternatives to using the Excel Add-In

Copying and pasting tables from Bloomberg to Excel

  1. Place cursor at the corner of table in Bloomberg.
  2. Click and drag the data you would like to copy.  Bloomberg will copy text/data automatically without Ctrl + C.
  3. In Excel, press Ctrl + V to paste the data.
  4. Click on Data menu from the top in the Excel screen and select "Text to Columns..."
  5. Select "Fixed width-general."

Screenshots

To save a screen go to Export, click on Take Window Screenshot and Send via MSG

Excel Add-in Guides & Help

  • Getting Started Guide for Students
  • Bloomberg Excel Add-in Function Reference
  • Bloomberg Excel Desktop Guide
  • << Previous: Basics
  • Next: Equities >>
  • Last Updated: Jun 5, 2025 9:11 AM
  • URL: https://researchguides.dartmouth.edu/bloomberg
  • Print Page
Login to LibApps
Report a problem
Tags: business, feldberg

Dartmouth Libraries

  • Baker-Berry Library
    • Book Arts Workshop
    • Evans Map Room
    • Jones Media Center
  • Health Sciences and Biomedical Libraries
  • Feldberg Business & Engineering Library
  • Rauner Special Collections Library
  • Records Management
  • Sherman Art Library

About Us

  • Staff Directory
  • Subject Librarians
  • Library Departments
  • Policies
  • Employment
  • Accessibility
  • Federal Depository Library

Contact Us

  • 25 North Main Street
    Hanover, NH, USA 03755
  • Phone: 603-646-2567
  • Contact Us

Give Us Feedback

Dartmouth Libraries

Footer copyright

  • Dartmouth College
  • Copyright © 2025 Trustees of Dartmouth College
  • Facebook
  • Instagram
  • YouTube
Privacy Policy