Skip to main content Freeman School of Business Freeman School of Business Library Tulane University Homepage

Bloomberg @ Turchin Library

Guide to using the Bloomberg Financial system.

Exporting & Printing

Please be aware of data download limits.

Exporting & Downloading
There are two ways to get Bloomberg data into Excel 

  1. Search directly from Excel. Open Excel first, click on Bloomberg, then import data. A new screen will open where you enter your data selections.
  2. Export from Bloomberg into Excel. This exporting capability is limited to certain data elements within Bloomberg. Not all data can be exported. When this function is available it will be listed under OPTIONS or ACTIONS, not export. If under OPTIONS, click on options, then download to Excel. If under ACTIONS, click on Export to Excel, select the rows you desire to export, then click Download on the red bar.

How to copy and paste 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."

Printing
Not all data or documents may be printed. Use the green PRINT key to print the information page by page. The PRINT key prints only the current screen unless you type in the number of pages to print. The number of pages available displays in the top right of the screen.

Screenshots

Saving Screenshots
To save a screen go to Export and click on Grab Screen. Not all screens can be saved.  You can also type GRAB <GO>