Excel
tables can be exported to SharePoint, and in the demo below
Peter Kalmström, CEO and Systems Designer of kalmstrom.com
Business Solutions, shows how to do it.
The major benefit of this method is that it is simple and
quick. However, when Excel creates the list in SharePoint
it makes a number of "mistakes". In the article
"Enhance SharePoint list created from Excel export"
we describe how to fix most of those problems.
When you have exported the Excel data to SharePoint it can
only be updated in SharePoint. Changes in SharePoint can
be pulled down to Excel by using the Excel Refresh button,
but not vice versa. You should also be aware that you cannot
change the order of columns or exclude columns from the
export. The table will be exported just as it is.