Copying the content on the Sharepoint to a spread sheet

Import data from a SharePoint list:

http://office.microsoft.com/en-us/excel-help/import-data-from-a-sharepoint-list-HA010131473.aspx#BM2

1. If your list is not already open, click its name on the Quick Launch. If the name of your list doesn't appear, click View All Site Content, and then click the name of your list.
2. On the Actions menu , click Export to Spreadsheet.
3. If you are prompted to confirm the operation, click OK.