Bloomberg Lab, Fall Term: Library: Excel

1. When you are looking at data tables, click on the settings menu.
2. In the settings, click on the Excel settings and make sure you choose Export as "values."
3. If you need the data to be segmented you can select that option here. 

1. You can set the periodicity in the In the fundamentals tab. In this example we have selected 10 years of annual data. 

2. Once you have configured your settings, select the Output option and choose Excel.