Microsoft 365 and Office | SharePoint | For Business | Windows

Hi @Brad Hagan, 

Good day, and I appreciate the clear description of your issue. 

I understand that you are encountering a situation where Microsoft Lists prompts you to correct information despite there being no obvious errors in your data. This issue is typically the result of hidden formatting or metadata conflicts that arise when information is migrated from Excel into the SharePoint-based structure of Microsoft Lists. 

1. Firstly, I recommend that you first verify that the data in any "Choice" or "Date" columns matches your list's requirements exactly. Even a single trailing space at the end of a word in your Excel spreadsheet can cause a validation failure, as the system perceives it as a value that does not exist in your defined options. 
2. I suggest using the "Edit in Grid View" feature to help you pinpoint the exact locations of these "ghost" errors. Within this view, Microsoft Lists will usually highlight problematic cells with a red border, and I have found that hovering your cursor over these highlighted areas will often provide a tooltip explaining the specific nature of the conflict.
   Using the 'Edit in grid view' feature makes it easy to identify columns with invalid values. Once the specific error is located, you can update the column's format to ensure data remains valid. 
3. After that, kindly try stripping all background formatting by pasting your Excel data into a plain-text application like Notepad before copying it into your list. This process removes any hidden HTML or Excel-specific properties that may be triggering validation errors during the paste process. 
4. I also encourage you to check the very bottom of your list to ensure that no additional blank rows were accidentally included in your selection. If your list has mandatory fields, the system will prevent you from saving if it detects empty rows that it believes should contain data. 
5. Finally, temporarily changing the column type to "Single line of text" if you are still unable to save your progress. This change often bypasses strict validation rules, allowing you to save the data first and then reconfigure the column to its original type once the information is successfully captured. 

I hope these recommendations assist you in resolving the issue and continuing with your work. Please feel free to reach out if you require any further assistance or if the error persists.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

The pasted data is being validated against the column types that Microsoft Lists/SharePoint inferred from the source (Excel). At least one column is flagged as invalid and must be corrected or excluded before the list can be created.

To proceed:

1. When the "fix information" prompt appears, locate the specific column it highlights.
2. Adjust that column’s field type or data so it matches what the list expects:
   • If the column is meant to be text but was inferred as a number, date, or currency, change the field type to Text.
   • If the column is meant to be a number or date but contains non‑numeric or non‑date values, either correct those values or change the field type to Text.
   • If there are values that do not belong in the list, choose Do not import for that column so it is skipped.
3. After fixing or excluding the problematic column, continue the creation process and select Create.
4. Once the list is created, open it, go to Settings > List Settings, and review each column’s type. Adjust any that were inferred incorrectly (for example, change from Number to Currency, or from Date to Text) and then save.

If the error persists even though the data looks correct, set the problematic column’s type to Text during import, or temporarily choose Do not import for that column, create the list, and then add that column manually afterward via List Settings.

References:

• Create a list based on a spreadsheet
• Use a screen reader to create a list from the Microsoft Lists app
• Add, edit, or delete list items