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

- 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.
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.
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.
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.
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.
Return to the Dynamics 365 import or data management area, choose the option to import data, and select the completed workbook or CSV file.
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.

Create a SharePoint list from an Excel table
Use the modern SharePoint list creation flow when an older spreadsheet import method fails or depends on ActiveX.
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.

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.




