How to Directly Export from Excel to SharePoint

After you create an Excel table in a worksheet, you may want to share it with other users via a website. Microsoft SharePoint has an Import Spreadsheet app to help you to do just that. This isn’t the only way to import a spreadsheet though, is it? And can you be sure you won’t see any problems while importing data? The answer to both of these questions is “No.” The good news is that I know another method that’s a better way to do it. In Excel 2010, you can easily share workbook data with a SharePoint site that exports data from Excel to SharePoint directly. What is it, and how can you do it? In this article, I will show you how to export data using the Export Table to SharePoint List option of Excel. This option provides the added benefit of column mapping. You can manually choose column to column mapping, so that the column names don’t need to be exactly the same.

Now, I will show you how to export data from SharePoint to Excel.

Step 1: Open the Excel file that you want to export and create a table.

 

Step 2: In the Ribbon, on the Design tab, in the External Table Data group, click Export option -> click the Export Table to SharePoint List option.

 

Step 3: Type the Web address of your SharePoint site, then type the list name and description for your SharePoint list. Click the Next button to review the table of columns and data types. Then click Finish button.

Note: If you check the Create a read-only connection to the new SharePoint list check box, you will need to update the table data on the worksheet with any changes on the SharePoint site using Refresh option in Excel.

Note: After clicking the Finish button, the system will ask you to login into the domain as a user who has the permission to create lists on the site.

 

Step 4: Click the OK button to confirm that the table was successfully published, or click the hyperlink address to open the SharePoint list directly.

 

This is the result:


SharePoint

Applications

SharePoint apps are stand-alone applications that perform specific tasks on a SharePoint site. Apps can perform functions such as managing a discussion board or knowledge base, performing project management or time tracking tasks, or doing other workflow operations.

SharePoint

Product Suites

Experience greater power and savings by bundling our SharePoint apps and web parts.


Essentials


Essentials Plus


Bamboo Premier


Project Management Suite


Knowledge Management Suite


External User Manager


SharePoint

Web Parts

Extend SharePoint beyond its out-of-the-box capabilities by tailoring it to your requirements with Bamboo Solution’s growing portfolio of Web Parts. Web Parts are the building blocks of pages on a SharePoint site that can be used to customize the user interface and content of a site page. 

SharePoint

Product Suites

Experience greater power and savings by bundling our SharePoint apps and web parts.


Essentials


Essentials Plus


Bamboo Premier


Project Management Suite


Knowledge Management Suite


External User Manager


Office 365

Cloud Parts

Cloud Parts are functional components that extend your SharePoint environment whether it’s hosted, on-premises, or part of Microsoft Office 365. More than mere ports of existing software to the cloud, our Cloud Parts have been built from the ground up to take advantage of the best that the cloud has to offer.

SharePoint

Product Suites

Experience greater power and savings by bundling our SharePoint apps and web parts.


Cloud Parts Suite for O365/SP Onl.


Featured Services

SharePoint Health Check

A SharePoint Health Check will identify the causes of issues and risks associated with your specific environment, and is custom tailored to provide you with the best recommendations to optimize your SharePoint environment.

SQL Health Check

Document recommendations relating to performance, stability, availability, or a specific focus you request of your SQL Server database instances.

My SharePointXperts

The truth is that each SharePoint skill may not be a full time job for many organizations, and it is nearly impossible for one person to do everything you need – so augment your team with SharePointXperts; providing the skill sets you need when you need them!