Bloomberg has a useful Excel add-in that allows you to export data from the terminal easily.
You will need to set it up in your profile on one of our Bloomberg terminals. You can do this by going to the desktop of any Bloomberg PC and double-clicking the Install office add-ins icon. Click Install when prompted. Once you have installed the add-in, it will work when you log into any of our Bloomberg terminals.
The add-in will allow you to export data from Bloomberg to Excel and to use various pre-set templates and a formula builder to import data into Excel. You can also use Bloomberg Query Language (BQL) which is an SQL-like language that will allow you to perform your own calculations in the Bloomberg cloud.