SharePoint on a Mac Video

SharePoint 2010 on a Mac from Dux Raymond Sy on Vimeo.

SharePoint 2010 on a Mac OSX Compatibility List

Creating and Editing SharePoint Content

ContentFeature	Description	Works on an OS X Mac?
Document Library	Stores collections of documents	Yes
Form Library	XML Based business forms	No (Requires InfoPath)
Picture Library	Store and share photos.	Yes
Links	List of Web and file share links	Yes
Announcements	List of announcements	Yes
Contacts	Contact database	Yes
Events	Calendar of events	Yes
Tasks	List of taks	Yes
Issues	An issues tracking database	Yes
Custom List	Specify your own columns	Yes
Custom List in Datasheet View	Edit a custom list as a Datasheet	No
Import Spreadsheet	Create a new list from an existing spreadsheet	No
Discussion Board	Discuss issues related to project	Yes
Survey	Create a survey for users	Yes
Basic Page	Create a new simple Web page	Yes
Web Part Page	Add a Web page consisting of Web Parts	Yes
Sites and Workspaces	Create a new sub site to your SharePoint	Yes

Import Excel Spreadsheet to a SharePoint 2010 Custom List

Import data from Excel into SharePoint 2010. We have the following Excel containing usage data of different browsers over the months.

Go into SharePoint 2010 and select the option “More options…” under “Site actions”.

This will open the create dialog of SharePoint 2010 which normally allows you to create content like sites, pages and lists. Look for something called “Import spreadsheet” and press the “Create” button.

“Import spreadsheet” will create a custom list from an Excel data file. Give the custom list a name and use the browse functionality to select the earlier mentioned xlsx file. Click on the “Import” button to start the import.

This will open Excel and let you select the range of cells to import into the custom list of SharePoint 2010. The first row in the Excel sheet will define the column names.

When the “Import” button is clicked the Excel sheet is closed and the new custom list is opened in SharePoint 2010. As you can see the columns are based on the first row of the selected data. The data is not linked in any way back to Excel. So you will need to export it again to get linked data. The custom list is standard SharePoint and will allow you to do anything with this list what would be possible in SharePoint 2010.

"The specified file is not a valid spreadsheet or contains no data to import" Error When Importing an Excel Spreadsheet into SharePoint 2010

In Internet Explorer click Tools --> Internet Options.
Click Security --> Trusted Sites > Sites --> and add your site name.
Make sure to enter both the http and https form of the URL.
You'll need to uncheck the box for "require sever verification"