Import Excel into a SharePoint List: Step-by-Step

How-to basics · Updated November 20, 2026

To import Excel data into SharePoint, format the data as a table, then choose New > List > From Excel on your SharePoint site, select the table, review its column types, and create the list. If the list already exists, use Edit in grid view to paste compatible rows. You’ll need permission to create or edit lists, and the workbook should have clear column headers and one record per row.

What You’ll Need

  • A SharePoint site where you have permission to create a list, or edit an existing list.
  • An Excel workbook saved as an .xlsx file. It can be on your computer or, depending on the picker shown, in OneDrive or SharePoint.
  • A tidy data range with one header row, no merged cells, and consistent values in each column.
  • A plan for the destination columns, especially dates, numbers, choice values, and any required fields.

The instructions below are for SharePoint Online and Excel for Microsoft 365 on Windows. The modern SharePoint interface can vary slightly by organization. Excel for Mac has the same basic table command, though ribbon labels or workbook pickers can look different.

Step-by-Step

  1. Choose whether to make a new list or add to an existing one. From the SharePoint site, use New > List > From Excel to create a separate list from the workbook. This is the most straightforward route for a first-time import. If you must add records to a list that already contains data, skip to step 6; creating a new list will not merge the rows into the existing one.
  2. Prepare the worksheet in Excel. Put the field names in the first row, such as Customer, Order Date, and Status. Use one row for each record, and avoid blank rows or columns inside the data. Remove merged cells, totals rows, notes, and decorative headings from the range you plan to import. If the worksheet has several unrelated tables, import each table separately.
  3. Turn the data into an Excel table. Click a cell in the data range, then select Insert > Table. Confirm the selected range and check My table has headers before selecting OK. If the workbook has multiple sheets, make sure you create a table on the sheet containing the intended records. Excel for Mac also has an Insert > Table command, though the dialog may be arranged differently. Save the workbook.
  4. Start the SharePoint import. Open the target site and select New > List. Choose From Excel. If you do not see that choice, you may be using a different site interface or lack permission to create lists; see Troubleshooting below. Select the workbook using the available upload or file picker. If you upload a local copy, make sure you choose the final, saved version rather than an older draft.
  5. Select the table and review the preview. SharePoint should display tables it can read from the workbook. Choose the one you prepared, then inspect the preview before continuing. Check that the first row is being treated as headers, the first and last records are present, and values have not shifted into neighboring columns. Enter a useful list name and, if offered, a description. Avoid a name that will be confusing to other site members.
  6. Check the column types before creating the list. Review the type SharePoint assigns to each column. A date field should be a date, a price or quantity should be numeric or currency as appropriate, and a category may be better as a choice field if you want people to select from a fixed set later. Text is often the safest type for codes that can start with zero, such as postal codes or account references. Change a detected type when the interface allows it, and check any required-field settings. SharePoint’s import creates list data; it does not reproduce Excel formulas, conditional formatting, charts, or workbook layout as list features.
  7. Create the list and inspect the imported records. Select Create (or the equivalent confirmation button). When the list opens, check several rows—not just the first one—and compare them with the workbook. Verify dates, decimal places, text that begins with zero, and long values. SharePoint may create or retain a default Title column, so check the column names and decide whether to rename, repurpose, or hide it. Make any necessary column adjustments before sharing the list for routine updates.
  8. For an existing list, prepare matching rows in Excel. Check the destination list’s columns and required fields first. Arrange the new records so each value corresponds to the correct editable SharePoint column. Do not include the header row in the data you paste. Remove Excel-only totals and formulas if you do not want their displayed results added as ordinary values. Save a copy of the workbook so the source data remains unchanged.
  9. Paste the rows into the existing list. Open the list and select Edit in grid view from the command bar. In Excel, select the data cells to add and copy them. In SharePoint, click the first blank cell under the matching starting column and paste. The columns must line up in the same order as the destination cells, and values must be valid for their SharePoint column types. Review the pasted rows, then select Exit grid view to finish editing. If your list does not show blank rows or grid editing, ask a site owner about your permissions or use the list’s available item-entry method.
  10. Confirm the result with the people who will use it. Check that users can open the list and that useful views show the imported data. If you created a new list, test a new item to confirm its fields behave as expected. For an existing list, confirm that the added items appear once and that no unintended columns or rows were included.

Common Mistakes

Importing a range that is not a table: The From Excel flow looks for a structured table, so a formatted worksheet range alone may not appear. Use Insert > Table and confirm the header option.

Using duplicate, blank, or confusing headers: Headers become list column names. Give each one a clear, distinct name before importing, and avoid relying on a blank heading that SharePoint may replace or reject.

Letting Excel reinterpret identifiers: Excel can turn values such as 00127 into 127, or interpret text as dates. Set the source cells to Text before entering or pasting such identifiers, then verify the values in the import preview and the finished list.

Assuming the workbook itself transfers: The import moves tabular data, not the full Excel experience. Formulas, macros, charts, formatting, and worksheet protections do not become equivalent SharePoint list features.

Pasting into the wrong columns: Grid view paste depends on the selected starting cell and column order. A shifted range can put data in the wrong fields or trigger validation errors.

Tips

  • Keep the workbook’s original sheet and make a separate, cleaned import table. This gives you a reference if you need to compare or re-import records.
  • Use consistent formats in each column. For example, do not mix dates, words such as “unknown,” and numbers in one date column.
  • Choose a sensible type before users start editing. A choice field can standardize a short status list, while a text field is more flexible for free-form notes.
  • For a large or business-critical import, try a small sample first. Confirm the column mapping and permissions, then import the full set after the sample looks right.
  • Plan how you will identify duplicate records. SharePoint does not automatically know that two rows with similar names represent the same person or transaction.
  • Keep the list’s purpose and ownership clear. Site members may have different rights to view, add, edit, or delete items, and list permissions can be managed separately from the workbook.

Troubleshooting

The From Excel option is missing: Confirm you are on the intended SharePoint site and using its modern interface. Your account may not have permission to create lists. Ask a site owner to check your access or create the list for you. If the site uses a customized experience, look for the Lists app or an equivalent create-list command.

The workbook or table does not appear: Save the workbook as .xlsx, close it if it is being edited, and check that the data is an Excel table with headers. If you use a cloud file picker, make sure the file is stored in a location you can access with the account currently signed in. Reopen the import flow after saving changes.

SharePoint rejects a value: Look for a mismatch between the data and the destination type, such as text in a number field, an invalid date, or a value outside a choice column’s permitted options. Correct the source data or adjust the column type where possible, then retry. For an existing list, grid view may show a validation warning on the affected cell.

Dates, zeros, or decimals look wrong: Inspect the original Excel cells and the imported list separately. Excel may have changed the underlying value before import, and SharePoint may display dates or numbers using site or column settings. Correct the source value, check the list column configuration, and test with a single record before repeating a bulk paste.

Some rows are missing or appear twice: Compare the imported list with the source table’s row count and check for blank rows, filters, or a second import attempt. Before retrying, determine which records already arrived. Remove duplicates carefully or use a stable identifier to distinguish records; do not assume similar names are unique.

Grid view will not accept the paste: Check that you have edit permission, that you selected an editable cell, and that pasted values match required fields and column types. Try a small block first. If the list contains calculated or system-managed columns, exclude them from the copied range and paste only into editable columns.

Frequently Asked Questions

Can I import an Excel file into a SharePoint list that already exists?
There is not a general From Excel option that merges a workbook directly into any existing list. For a modest set of compatible records, use Edit in grid view to paste rows. For a larger or more complex transfer, plan a supported migration method and test it before changing the live list.

Does importing preserve Excel formulas?
No. SharePoint lists store field values and list settings, not Excel formulas as working formulas. If you need a calculated result, import the value or recreate the calculation using an appropriate SharePoint list feature.

Can I import multiple worksheets at once?
The import flow works with a selected table, not the whole workbook as a set of connected sheets. Prepare and import each required table separately, then check how the resulting lists should relate to one another.

Will Excel formatting become SharePoint formatting?
Generally, no. Expect the data and column structure to transfer, not cell colors, merged layouts, charts, or conditional formatting. Set up list views and column formatting separately if they are needed.

Can I use this process on a Mac?
Yes. The list creation and editing steps happen in SharePoint in a browser, so they are largely the same. In Excel for Mac, create the source table with Insert > Table; the file picker and some ribbon details may look different from Windows.

What should I do before importing thousands of records?
Test a representative sample, check the list’s column design and permissions, and confirm that your chosen import method handles the volume and data types. Large lists can also require careful view design; ask your SharePoint administrator about organizational limits and migration options.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.