Import Excel Data Into a SharePoint List: Practical Checklist for SharePoint Owners

SharePoint site owners often need to bring existing spreadsheet data into a SharePoint list to enable team collaboration, version history, and permissions management. The import process can fail or produce errors when the Excel file contains unsupported data types, merged cells, or blank rows. This article provides a practical checklist that covers preparing your Excel file, choosing the correct import method, and handling common issues after the import. Following this checklist will help you avoid data loss and save time during the migration.

What the Import Feature Does and What You Need Before Starting

The SharePoint import feature reads an Excel workbook and creates a new SharePoint list with columns that match the spreadsheet columns. Each row in the worksheet becomes a list item. The feature works only with .xlsx files. It does not work with .xls, .csv, or .xlsm files. You must have at least Edit permissions on the site where you create the list. The Excel file should contain a single table or a named range. If the file has multiple sheets, only the active sheet is imported. The import process preserves the first row as column headers. All other rows become list items. The system automatically detects data types such as text, number, date, and currency. It does not import formulas or calculated values. Instead, it imports the displayed value at the time of import. Before you start, confirm that your Excel file is closed. An open file can cause a sharing violation error.

Supported Data Types and Limitations

SharePoint maps Excel data types to list column types. Text columns become Single line of text. Numbers become Number. Dates become Date and Time. Currency becomes Currency. Boolean values become Yes/No. The import does not support Excel tables with structured references, pivot tables, charts, or conditional formatting. If your worksheet contains hyperlinks, only the display text is imported. The URL is not preserved. Images embedded in cells are ignored. Data validation rules from Excel are not transferred. You must reapply validation in SharePoint after the import.

Checklist to Prepare Your Excel File for Import

Following this checklist reduces the chance of errors during the import process. Complete each step before opening the SharePoint import wizard.

1. Convert all data to a flat table
   Remove any merged cells. Unmerge all cells and fill the blank cells with the appropriate value. Delete any subtotal rows, grand total rows, or summary rows. The worksheet must contain only a single rectangular range of data with headers in the first row.
2. Remove blank rows and columns
   Delete any completely empty rows or columns within the data range. Blank rows cause SharePoint to create empty list items. Blank columns create empty columns in the list. Use Excel’s Go To Special > Blanks feature to identify and remove them.
3. Standardize column headers
   Column headers must be unique. Duplicate headers cause the import to fail. Replace spaces with underscores or keep them, but be consistent. SharePoint will use the header text as the internal column name. Keep headers shorter than 255 characters. Avoid special characters such as /, \, , ?, :, [, ], and #.
4. Check data types per column
   Ensure that each column contains only one data type. Mixing text and numbers in the same column forces SharePoint to treat the entire column as text. Format date columns consistently using the same date format throughout. For currency columns, format the cells as Currency in Excel before importing.
5. Remove formulas and replace with values
   Select the entire worksheet. Copy it. Then use Paste Special > Values to replace all formulas with their current displayed values. This step prevents SharePoint from attempting to interpret formulas as text.
6. Save the file as .xlsx
   Use File > Save As and choose Excel Workbook (.xlsx). If your file is in .xls or .csv format, open it in Excel and resave it as .xlsx. The SharePoint import wizard accepts only .xlsx files.

Steps to Import Excel Data Into a SharePoint List

After your Excel file is prepared, use the following steps to create the list. These steps apply to SharePoint in Microsoft 365. The interface may vary slightly between tenants.

1. Navigate to the target SharePoint site
   Open the site where you want the new list to appear. Click the gear icon in the upper right and select Site contents.
2. Start the list creation wizard
   On the Site contents page, click New and then select List.
3. Choose the From Excel option
   In the Create a list panel, click From Excel. A file picker dialog opens.
4. Upload your Excel file
   Click Browse and select the prepared .xlsx file. Alternatively, drag and drop the file into the upload area. Wait for the file to upload completely.
5. Select the worksheet or table
   If your workbook contains multiple sheets, a dropdown appears. Choose the sheet that contains the data you want to import. If your data is in a named range, select that range from the dropdown.
6. Review the column mapping
   SharePoint displays a preview of the columns and the first few rows. Verify that each column header appears correctly. If a column shows as Unrecognized, go back to your Excel file and clean the header.
7. Set the list name and description
   Enter a name for the list. The name must be unique within the site. Optionally, add a description. Click Create.
8. Wait for the import to finish
   SharePoint processes the file and creates the list. A progress bar appears. Do not close the browser window during processing. When the import completes, the new list opens with your data.

Common Issues After Import and How to Fix Them

Imported data shows #N/A or #VALUE errors

This error appears when the Excel file contained formulas that were not converted to values. Open the original Excel file, select all data, copy it, and use Paste Special > Values. Save the file and reimport. If the list already exists, delete it and start over.

Date columns display as numbers after import

SharePoint may interpret date columns incorrectly if the Excel date format is ambiguous. In Excel, select the date column and apply a clear date format such as 14-Mar-2023. Save the file and reimport. After the list is created, you can change the column format in SharePoint list settings.

Some rows are missing from the list

Blank rows in the Excel file cause SharePoint to stop importing at the first blank row. Check your Excel file for any completely empty rows within the data range. Delete them and save the file. Also ensure that the data range does not contain empty cells in the first column. SharePoint treats a blank first column as the end of the dataset.

Column headers appear as Field1, Field2, etc

This happens when the first row of the Excel file does not contain headers, or when the headers contain unsupported characters. Open the Excel file and verify that the first row contains text headers. Remove any special characters listed in the preparation checklist. Save and reimport.

Item	Import From Excel (New List)	Copy and Paste Into Existing List
Description	Creates a new SharePoint list from an .xlsx file	Pastes data from Excel into an already existing list using Quick Edit
Data types	Auto-detected from Excel formatting	Must match existing list column types
Column mapping	Automatic based on headers	Manual column alignment required
Rows supported	Up to 5000 rows per import	Limited by list view threshold (5000 items)
Best for	Creating a new list from scratch	Adding data to an existing list structure

Now you can import Excel data into a SharePoint list with confidence by following the preparation checklist and the step-by-step wizard. After the list is created, verify that all columns have the correct data types by opening List Settings. For large datasets, consider using Microsoft Power Automate to import data in batches to stay within the 5000-row view threshold. An advanced tip: create a site column template in SharePoint that matches your Excel headers before importing, then map the imported columns to the existing site columns for consistent metadata across the site.