Data Import & Export

How to Fix Microsoft Lists Excel Import Errors Caused by Column Types

John Wilson Oct 21, 2026 868 views

Question details

Users need to resolve errors where Microsoft Lists skips rows or fails to import Excel data properly due to incompatible column types or complex workbook formatting.

How to Fix Microsoft Lists Excel Import Errors Caused by Column Types

Product: Excel
Device & OS: not provided
Scenario: Importing an existing Excel workbook into Microsoft Lists to create a new list or update data.
Observed behavior: Microsoft Lists skips rows during the import process or generates errors because the Excel values do not match the expected list column types, or the workbook contains formulas, hidden rows, and extra formatting.

Before you start

Make sure your Excel file is completely closed in all spreadsheet applications before attempting the import, and verify that you have the appropriate edit permissions for the target Microsoft List.

Solution 1Recommended

Clean and Format Excel Data to Match List Columns

Ensure all data types in Excel correspond directly to the intended Microsoft Lists column types and remove complex elements that disrupt the import process.

Microsoft Lists requires clean, static data to successfully map Excel columns to list columns. Complex elements like formulas, hidden rows, mixed data types, and custom cell formatting can confuse the import engine, causing it to skip rows or fail entirely.

Standardize column values

Review each column in your Excel worksheet. Ensure the data consistently matches the intended Microsoft Lists type (e.g., all Dates in a date column, all Numbers in a number column). Fix any cells containing mixed data types.

Remove formulas and formatting

Highlight your entire dataset, copy it, and right-click to select 'Paste as Values'. This removes all formulas and leaves only the static data. Clear any custom cell formatting that might interfere.

Delete hidden rows and extra content

Unhide all rows and columns in your worksheet. Delete any empty rows, empty columns, or irrelevant data notes outside your main table boundaries.

Transfer to a clean workbook

If errors persist after cleaning, select your dataset, copy it, and paste it into a brand new, blank Excel workbook. Save this new file as an .xlsx document and attempt the import again.

Clean and Format Excel Data to Match List Columns

Format as Table: Formatting your data as an official Excel Table (using the shortcut Ctrl+T) before saving can help Microsoft Lists recognize the data structure and column headers more accurately during the import.

Free Microsoft Office alternative

Prepare Your Spreadsheets Flawlessly with WPS Office

While Microsoft Lists requires strict data formatting for successful imports, you can easily clean, organize, and prepare your Excel files using WPS Office. It offers a lightweight, highly compatible alternative to Microsoft Office for all your spreadsheet needs.

1. Open your file in WPS Spreadsheet: Launch WPS Office and open the Excel workbook you need to prepare for Microsoft Lists.
2. Clean your data: Select your entire table, copy it, right-click, and choose 'Paste as Values' to strip out all formulas and problematic formatting.
3. Save as a standard format: Click 'Menu', select 'Save As', and ensure the file is saved in the standard .xlsx format before importing it into Lists.

100% compatible with Microsoft Excel (.xlsx) formatsEasily clean data, remove formatting, and clear formulas with Paste SpecialLightweight application with fast loading speedsFamiliar user interface makes switching incredibly easy

microsoft office alternative - wps office

Frequently Asked Questions

Why does Microsoft Lists skip rows when importing from Excel?

Lists will skip rows if the data in those specific rows does not align with the designated column type (for example, having text in a column meant only for numbers). It also skips rows containing hidden elements, errors, or complex formulas.

Can I import an Excel file with formulas into Microsoft Lists?

It is highly recommended to remove formulas before importing. Select your data, copy it, and paste it back using 'Paste as Values' to ensure Lists reads the static data correctly instead of the underlying formula.

How do I fix the 'We couldn't create your list' error?

This error often occurs if the Excel file has custom formatting, merged cells, or unsupported elements outside the main table. To fix it, copy only the required data table into a fresh, blank workbook, save it, and try importing the new file.

Excel & Data Problems