7.2. Exporting Data from an Excel Spreadsheet into a Custom List

In the last section, you saw that when you export a SharePoint list to Excel, you can manually update the Excel spreadsheet with changes made in SharePoint, but you cannot update SharePoint with changes made to the Excel spreadsheet. Let's now take a look at what you can do when you start from Excel 2007.

For the example shown here, I've created an Excel table that lists the top 30+ brightest stars in the evening skies. The table includes the name of the star, the name of the constellation in which the star can be found, and the star's apparent magnitude.

ABSOLUTE VS. RELATIVE BRIGHTNESS FOR THE LAYMAN

Apparent magnitude defines the relative brightness of the stars when you view ...

Get Office and SharePoint 2007 User's Guide: Integrating SharePoint with Excel, Outlook, Access, and Word now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.