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 the 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 the 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 the 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 the 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 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.

SharePoint Online

The cloud parts are functional components that extend your SharePoint Online environment in Microsoft 365.

Supports Classic and Modern sites for SharePoint Online/Microsoft 365

Small Business Pricing and Discounts


Top SharePoint Online Products

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

Calendar Plus


Employee Directory Plus

Org Chart Plus

Simple Search


Tree View


On-Premises Only

These web parts extend SharePoint beyond its out-of-the-box capabilities by tailoring it to your requirements with Bamboo Solution’s growing portfolio of SharePoint Web Parts.

SharePoint 2016, 2019, 2022 – Classic Pages Only


Top On-Premises Only Products

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

Calendar Plus

Data Viewer

Password Change

Password Expiration

Password Reset


Our team of Microsoft 365 Technology Consultants helps you get the most out of your Microsoft technology, we have the best Microsoft 365 talent to streamline your organization.

Consulting to Streamline Your Department

M365 Plus

Managed Services

Microsoft 365

Consulting to Streamline Your Department

Human Resources

Information Technology

Marketing Campaigns




Our Consultants Have What You Need

Federal Contractors