1. Create a view that contains the desired data
2. Select the data you would like to copy within Microsoft Project
3. Click on >Edit, >Copy Task (Ctrl-C)
4. Within Excel, click on Paste
Note that the selected information is pasted accurately, but it lacks the column headings, the WBS or outline structure and it does not retain the bold formatting for Summary Tasks or the Project Summary Task. Also note that the date format now includes the time.
This approach is quick and simple but makes it very tough to decipher the details of this project. Additional work or formatting may be required to get this file in a workable state.
See "Getting Data From Microsoft Project to Excel" for other options.