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
Q

Bloomberg: copying tables to Excel

How do I copy data from Bloomberg and paste to Excel?
Last Updated: Dec 18, 2013  |  15789 Views
Topics: Bloomberg

Was this helpful? 0   0
A

Answer

Copying from Bloomberg

  1. Move the cursor to one corner of the area to copy.
  2. Highlight the area to be copied. Be sure to include column headings.
    A dotted line may or may not appear around the highlighted area.
  3. Hit Ctrl-C to copy highlighted area.
    (Not all screens can be copied. As an alternative, try typing GRAB then hit GO to e-mail a screen image.)

Pasting into Excel

  1. In an empty worksheet, hit Ctrl-V to paste. Each row of information from Bloomberg will be pasted into a single cell of the spreadsheet.
  2. Highlight the first column of the pasted data.
  3. In Excel, from the Data menu select Text to columns
  4. In the wizard that opens, indicate data are in fixed-width format then click on Next.
  5. If necessary, specify locations of column dividers then click on Next.
  6. Select data type General (recommend format) then click on Next.

     

    It usually is not necessary to specify the data type for each column. Make additional changes if desired. Text data is interpreted as text, whether text or numbers. A Date can be translated into its internal Excel date format. Do not import column indicates a column should be ignored (not recommended.)

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