To export an Excel list to SharePoint, format the data as an Excel table, then create a SharePoint list using New > List > From Excel and select that table. This creates a list populated with a copy of the table’s data; it does not keep the workbook and list automatically synchronized. You will need a Microsoft 365 work or school account, access to the SharePoint site, and permission to create a list. The steps below use Excel for Microsoft 365 on Windows and the current SharePoint experience in a browser.
What You’ll Need
- An Excel workbook saved as an .xlsx file, with one clear header row and one record per row.
- Access to the SharePoint site where the list should live. If you cannot create a list there, ask the site owner to grant permission or create it for you.
- A suitable location for the workbook during import. You can upload it when prompted or select a workbook already stored in a location SharePoint can access.
- A little time to review the imported column types and sample records before using the new list.
Step-by-Step
- Prepare the worksheet. Open the workbook in Excel and go to the sheet containing the records. Keep the data in a simple rectangular range: one header row followed by records, with no blank rows splitting the data. Remove report titles above the headers, totals beneath the records, and notes or unrelated data beside the list. If the workbook contains several separate tables, decide which one should become the SharePoint list and import it separately.
- Make the range an Excel table. Click inside the data and choose Insert > Table. Check that the selected range includes all the intended columns and records, then select My table has headers if the first row contains field names. Choose OK. Excel displays table formatting and a Table Design tab when the table is selected. In Excel for Mac or Excel for the web, the same Insert > Table command is available, although tab placement and labels can vary slightly.
- Check and tidy the headers and values. Give each column a short, distinct header, such as Customer, Order Date, or Status. Do not leave a header blank or use duplicate names. Remove merged cells, subtotals, and decorative rows from the table. Check that dates are real Excel dates rather than text that only looks like a date, and that numbers do not contain stray spaces or inconsistent symbols. Keep each field in its own column; for example, split a full address into separate columns if you will need to filter by city or postal code.
- Save the workbook. Save changes in Excel, preferably as an .xlsx workbook, and note its name and storage location. If the file is open in Excel for the web, make sure changes have finished saving before you switch to SharePoint. The import uses the workbook’s saved contents, not unsaved edits that remain only in an open desktop session.
- Open the destination SharePoint site. In a browser, sign in with the same work or school account that has access to the site. Navigate to the site where colleagues should find the new list. Confirm that it is the correct team or project site before continuing; lists are associated with a site, and creating one on the wrong site can expose data to the wrong audience or make it harder for intended users to find.
- Start a list from the workbook. On the SharePoint site, select New > List, then choose From Excel. If the option is not immediately visible, check the available list-creation options or ask the site owner whether your account is allowed to create lists. The wording or placement may vary slightly with your organization’s SharePoint layout, but choose the option that creates a list from an Excel workbook, not the option that simply uploads a file to a document library.
- Choose the workbook and table. Follow the prompt to upload the .xlsx file or select a workbook that is already available to SharePoint. After the workbook is read, select the Excel table you prepared. If a table-selection menu appears, choose the intended table rather than a worksheet name or an unrelated table. If no table is offered, go back to Excel, confirm the range was converted with Insert > Table, save the workbook, and try again.
- Review the columns before creating the list. SharePoint previews the data and may suggest a type for each column, such as text, number, date, or yes/no. Check that the suggestions suit the actual values. A date column should be recognized as dates, and quantities should be numeric if you plan to sort or calculate with them. Inspect the first column carefully: it may be used for the list’s default Title field. Adjust column names or types in the setup screen when those options are available, and do not assume that a workbook’s colors, formulas, validation rules, or formatting will become SharePoint list features.
- Name the list, set its location, and create it. Enter a useful list name and, if offered, a description that explains what the records are for. Check the site location and any visibility or navigation options shown in the form. Select Create or the equivalent confirmation button. Wait for SharePoint to finish importing, then open the new list and inspect several records, including the first and last rows. Confirm the row count is plausible, dates and numbers look right, and the columns are in a sensible order.
After creation, the SharePoint list is a separate copy of the imported data. Editing the original workbook will not automatically update the list, and editing the list will not update the workbook. If you need to add a few records later, add them in the list or use a deliberate update process; do not assume that repeating the import will merge changes into the existing list.
Common Mistakes
- Uploading the workbook instead of importing its table. Uploading an .xlsx file to a document library stores the workbook as a file. It does not create editable SharePoint list items. Use New > List > From Excel when the goal is a list.
- Leaving the data as a normal cell range. The import flow may not find a selectable table unless you convert the data using Insert > Table. Check that the table includes the header row and all intended records.
- Expecting workbook features to transfer. Treat the import as data transfer, not a conversion of the entire spreadsheet. Formulas, conditional formatting, charts, macros, validation lists, and workbook layout should not be assumed to work as list features after import. Confirm important calculated values and rebuild any needed behavior using appropriate SharePoint features.
- Using inconsistent values in a column. Mixing dates with text, or numbers with labels such as “unknown,” can lead to a poor type choice or values that do not sort as expected. Clean the source data or choose a flexible text type where that is the right fit.
- Assuming the import creates a live connection. The workbook and list are separate after import. If ongoing synchronization matters, plan a supported update or automation process rather than relying on repeated imports.
Tips
- Use plain, recognizable headers because they become list column names and help people understand what each field contains.
- Import a small, representative table first if you are unsure how SharePoint will interpret dates, currency, or mixed values. Check the result before preparing a larger source workbook.
- Decide who should be able to view or edit the list before importing sensitive information. List access is governed by SharePoint permissions, so verify the destination site’s membership and sharing settings.
- Keep a backup of the original workbook. It preserves the source data and gives you a reference if you need to correct the list or repeat the import.
- Use a sensible list name and description, and consider adding the list to site navigation if colleagues need to find it regularly. Avoid names that are so broad that users cannot distinguish it from other lists.
Troubleshooting
From Excel is missing. Make sure you are on the SharePoint site itself and open New > List, rather than working only in a document library. Your organization’s interface may differ, or your account may not have permission to create lists. Ask the site owner or Microsoft 365 administrator to check your access and the site’s available features.
The workbook or table is not listed. Confirm that you selected an .xlsx workbook SharePoint can access and that it has finished saving. In Excel, click inside the data and verify that Table Design appears; if it does not, create a table with Insert > Table. Save the workbook again, then restart the import and select the correct file. If the workbook is stored somewhere the import cannot browse, upload a copy when prompted.
Columns have the wrong type or values look wrong. Check the source cells for mixed formats, text masquerading as dates, symbols included in numeric values, or blank cells in the header row. Correct the source and import again into a new test list, or adjust the list columns and correct the affected items after import. For a production list, compare a sample of records with the original before inviting people to rely on it.
Some records are missing or the import takes too long. Confirm that the Excel table range actually includes those records and that they are not outside the formatted table. For a large workbook, check your organization’s current SharePoint and Microsoft 365 limits and consider importing a smaller, verified batch. Do not assume that a list view showing only some rows proves the other items were not imported; list views can be filtered. Clear or review the view filters and search for a known record.
You created the list on the wrong site. If it is empty or safe to remove, ask the site owner about deleting it and recreate it on the correct site. If people have already added data, do not delete it until you have confirmed how to preserve those changes. SharePoint list permissions and deletion policies may be managed by your organization.
Frequently Asked Questions
Does exporting an Excel list to SharePoint keep it synchronized?
No. Creating a list from Excel imports a copy of the selected table. Later edits to the workbook do not automatically appear in the list, and list edits do not flow back to the workbook. For recurring updates, use an approved process designed for synchronization.
Can I export only one table from a workbook?
Yes. Convert the desired range into its own Excel table and select that table in the SharePoint import flow. If the workbook contains multiple tables, choose the one with the records you want. You can create separate SharePoint lists for separate tables when that structure makes sense.
Can I do this with Excel for Mac or Excel for the web?
Yes. The essential preparation is the same: create and save an Excel table, then use SharePoint in a browser to create a list from the workbook. In Excel for Mac or the web, use Insert > Table; ribbon placement can differ from Windows, but the SharePoint import steps are browser-based.
Will Excel formulas become calculated SharePoint columns?
Do not count on that. The import is intended to bring in tabular data, not reproduce workbook logic. Verify any formula-driven values after import, and recreate calculations with suitable SharePoint list features if needed.
Can I add more rows by importing the workbook again?
Do not assume a second import will update or append to the existing list; it may create another list instead. For a small number of additions, add items directly to the list. For bulk or repeated updates, choose a controlled method that matches your organization’s SharePoint setup and safeguards existing edits.
Related
- How to Enable Track Changes in Excel
- Enable Scroll Lock in Excel: Keyboard and On-Screen Methods
- How to Enable the Share Option in Excel for Collaboration
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Google Sheets: Count Cells With Specific Text in a RangeTo count cells that exactly match text in Google Sheets, use =COUNTIF(A2:A100,"Paid"); to count cells that contain the…
- Excel Group Shortcut Key: Rows, Columns, and OutlinesIn Excel for Microsoft 365 on Windows, select the rows or columns you want to group and press…
- How to Put a Filter in Google Sheets and Sort DataTo put a filter in Google Sheets, select your data range, including its header row, then choose Data…
- How to Archive Old Emails in Outlook 365 and Find ThemTo archive old emails in Outlook 365, select the messages and choose Archive; Outlook moves them to the…
- Excel Consolidate Button: Where It Is and How to Use ItIn Excel for Microsoft 365 on Windows, find the Consolidate button on the Data tab, in the Data…
- Lock Cells in Google Sheets: How Cell Protection WorksYes. In Google Sheets, use Data > Protect sheets and ranges to restrict editing of selected cells or…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.