Data Import & Export

Fix Microsoft Lists Not Importing First Excel Columns (ID/Type Conflict)

Elise Williams Oct 12, 2026 869 views

Question details

Users are unable to import the first columns of an Excel spreadsheet into Microsoft Lists or SharePoint due to column naming conflicts.

How to Fix Microsoft Lists Not Importing First Excel Columns

Product: Excel, Microsoft Lists
Device & OS: not provided
Scenario: Importing an Excel table into Microsoft Lists or SharePoint.
Observed behavior: The first columns (often named 'ID' or 'Type') are missing or fail to import correctly because they conflict with reserved system columns.

Before you start

Ensure your Excel data is formatted as a Table before attempting the import, and verify that you have edit permissions for the destination Microsoft List.

Solution 1Recommended

Rename Conflicting Column Headers in Excel

The most effective way to resolve this issue is by renaming headers that conflict with SharePoint's internal reserved columns.

Microsoft Lists and SharePoint rely on underlying system databases that automatically generate specific hidden columns for every item created. If your imported Excel file contains headers that match these system columns exactly, the import engine will ignore them or throw an error to prevent database corruption.

Locate Table Headers

Open your Excel file and locate the first row containing your table headers.

Identify Reserved Names

Check the first few columns for headers named exactly 'ID' or 'Type'.

Rename the 'ID' Column

Click on the cell containing 'ID' and rename it to a unique identifier such as 'Identifier', 'Item ID', or 'Record Number'.

Rename the 'Type' Column

Click on the cell containing 'Type' and rename it to 'Category', 'Item Type', or 'Class'.

Save and Re-import

Save the Excel workbook and retry the 'Import from Excel' process in Microsoft Lists.

Rename Conflicting Column Headers in Excel

Reserved System Columns: SharePoint and Microsoft Lists automatically generate their own hidden 'ID' and 'Content Type' columns for every item, which is why matching names cause import failures.

Free Microsoft Office alternative

Edit and Prepare Excel Data Seamlessly with WPS Office

If you frequently encounter compatibility issues or need a lightweight tool to manage your spreadsheets before uploading them to online platforms, WPS Office is an excellent free alternative. It offers full compatibility with Microsoft Excel formats, ensuring your data is perfectly prepared for any import.

1. Open File in WPS: Launch WPS Spreadsheet and open your .xlsx file.
2. Rename Headers: Double-click the 'ID' or 'Type' header cells and type a non-conflicting name.
3. Save and Export: Save the document normally; it retains full compatibility with Microsoft Lists.

Fully compatible with Microsoft Excel (.xlsx, .csv) formats.Easily edit, rename, and format tables to prevent data import conflicts.Familiar user interface with virtually no learning curve.Free and lightweight alternative to Microsoft Office.

microsoft office alternative - wps office

Frequently Asked Questions

Why does Microsoft Lists reject the 'ID' column?

Microsoft Lists is built on SharePoint, which uses an auto-generated, read-only system column named 'ID' to uniquely identify every row. Importing an external column with the exact same name causes a system conflict, so the import tool skips it.

Are there other reserved column names I should avoid importing?

Yes. Besides 'ID' and 'Type', you should avoid using exact names like 'Modified', 'Created', 'Author', 'Editor', 'Version', and 'Attachments' as these are also internal system columns utilized by SharePoint and Microsoft Lists.

Do I need to format my Excel data as a table before importing to Microsoft Lists?

Yes. Microsoft Lists requires your Excel data to be formatted as a recognizable Table. You can do this in Excel or WPS Spreadsheet by selecting your data range and pressing Ctrl+T before saving the file.

Excel & Data Problems