Excel confirms that your list data is well organized in this last step.
Then, Excel checks the data in each column to ensure that the data belongs to one of the data types supported by Windows SharePoint Services: text, currency, dates, numbers, or hyperlinks. If it doesn't, Excel will usually apply the text data type to each column. If you do not want to accept the formatting applied by Excel, you can go back to the list to check formatting in the specific cells and make any necessary changes.
Excel also checks whether each column contains only one type of data. For example, a column in a published list cannot contain both numbers and text. If a list column did mix the two types, Excel would apply the text data type for every cell in the column. Given a choice between numbers and text, Excel would choose text.
In the practice session at the end of the lesson we'll talk a bit more about what goes on in the Publish List to SharePoint Site dialog box.
Note Formulas are not exported to the SharePoint site. They are converted to values. If you have the list total row turned on, the total row will not be exported.
