What is the correct way to import xls to SharePoint?

Asked By Jamin Ywain 60 points N/A Posted on - 09/16/2012

What is the correct way to import xsl to SharePoint. I have the latest version installed but when ever I tried to import I get a access denied error.

• Status: Open
• Question Views: 851
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: System Utilities

Answered By Prince Medalla 5 points N/A #145845

What is the correct way to import xls to SharePoint?

Read the following steps and check if you're doing the process correctly.

1. Go to SharePoint and click Site Actions. Under it, click More Options.

2. The create dialog of SharePoint should now be opened. This allows you to create different contents such as pages, lists, and sites.

3. Click the Import Spreadsheet then press Create. A custom list from an Excel data file will now be created. Name the custom list and select the xlsx file using the browse functionality.

4. Click Import. By this time, MS Excel will open and will let you select the range of cells that you will be importing in the custom list of SharePoint. Note that the column names will be defined by the first row cells selected in Excel.

5. Click Import.

 

 

About Prince Medalla

Questions
2

Answers
25

Best Answers
4

• Vote Up 0 Vote Down

• Posted on - 09/23/2012
• Question Category: System Utilities