Data Import & Export

Import Excel Data into Dynamics 365 and SharePoint

Chanuka GeekiyanageChanuka Geekiyanage Nov 13, 2026 868 views

Question details

Import Excel or CSV data into Dynamics 365 and SharePoint while resolving workbook structure and field-mapping issues.

How to Import Excel Data into Dynamics 365 and SharePoint
Product
Microsoft Dynamics 365, SharePoint, and Excel
Device & OS
not provided
Scenario
The user wants to move spreadsheet data into Dynamics 365 records or a SharePoint list.
Observed behavior
Imports can fail because of invalid workbook structure, hidden system sheets, table formatting, or field mappings; CSV imports may contain only partial data.
Before you start

Identify the destination Dynamics 365 table or SharePoint list and check its required columns and data types. Confirm that you have permission to import records or create a list.

Solution 1Recommended

Import a clean template into Dynamics 365

Use this method when a Dynamics 365 import fails or CSV data is missing because columns do not match the destination fields.

1
Download a template

In your Dynamics 365 app, open the destination table or data management area and download an import template for the records you want to create. The menu name varies by app.

2
Enter and check the data

Open the template in Excel and enter data under its existing column headings. Leave any hidden system sheets unchanged, and check that required fields and data types match the destination.

3
Start the import

Return to the Dynamics 365 import or data management area, choose the option to import data, and select the completed workbook or CSV file.

4
Review mappings and results

In the import wizard, map each source column to the appropriate destination field and run the import. Open the import results or error details to identify rejected rows and correct them.

Import a clean template into Dynamics 365
Check CSV columns: For CSV imports, verify that column headings, delimiters, and field types match the destination schema. Saving as CSV UTF-8 can help preserve special characters.
Free Microsoft Office alternative

Prepare Spreadsheet Data with WPS Office

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and Excel format compatibility, making it easy to move existing workbooks into your workflow. Use WPS Spreadsheets to review source data before importing; Dynamics 365 and SharePoint still manage the import and field mapping.

Review spreadsheet columns and source data before an importOpen and edit Microsoft Excel formats, including XLSXUse a familiar interface for an easier transition from Microsoft OfficeWork with a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why did Dynamics 365 import only some of my CSV rows?

Some rows may have invalid values, missing required fields, or incorrect column mappings. Open the import results or error details in Dynamics 365, correct the affected rows, and retry them.

Should I delete hidden sheets from a Dynamics 365 import template?

No. Keep hidden system sheets and the template structure unchanged. Enter your data under the existing headings and map the columns in the import wizard.

How do I make an Excel range available for SharePoint list creation?

In Excel, select the range and choose Insert > Table. Confirm that it has headers, save the workbook, and then use New > List > From Excel on the SharePoint site.

What can I do if SharePoint rejects my workbook?

Try New > List > From Excel with a small new workbook containing a simple table. If that works, check the original workbook's table and column types; otherwise, check permissions or contact Microsoft support.

Can I use ActiveX to import a spreadsheet in Edge or Chrome?

No. Edge and Chrome do not support ActiveX. Use SharePoint's modern From Excel list creation option in a supported browser instead.