ProblemYou receive error while creating custom List using Excel spreadsheet using SharePoint Online Modern interface.
Error occurs when you upload a file from device or choose file already on site, on the screen which says 'Check the column types below and choose a new type if the current selection is incorrect'.
Title is a required filed and can't be empty.
AnalysisLists have Title column as mandatory. The Title is clickable link which takes you to the list item details by opening the display form. Though you are allowed to select any column type, try keeping it as single line of text.
This error occurs when the excel column/header which is selected as Title contains empty entry.
Solution/FixMake sure your excel data is correct and in the format that SharePoint expects -
- Does not contain blank rows.
- More importantly, the column which you select as Title should not have blank cells/entries.
- Title is always mandatory, so you cannot have blank values here.
- Fix all blank entries in excel (for Title column) and re upload.
More Posts related to SharePoint,
- Managed Metadata error - The data returned from the tagging UI was not formatted correctly
- How to generate client id and secret to register SharePoint App with OAuth
- Create SharePoint Site Collection with new Content database in existing web application
- Fix Error 2711 SQL RBS client - The installer has encountered an unexpected error. The specified Feature name ('Docs') not found in Feature table
- How to exclude results from SharePoint Search
- 'Edit Document' Requires a Windows Sharepoint Services-compatible application and Microsoft Internet Explorer 6.0 or higher
- [Solved] SharePoint Access Denied error editing Document Name
- Recommended size and resolution for SharePoint Online Site logo
- SharePoint Server 2016 IT Preview - new improved Features and Enhancements
- Restore deleted Office 365 SharePoint group site
- SharePoint An unexpected error has occurred - Correlation ID and PowerShell Merge-SPlogfile
- [Solved] SharePoint Search Internal server error exception
- SharePoint CAML query error - The XML source is not correct
- How to hide quick launch in SharePoint classic site
- Not receiving email notification alert in SharePoint Online workflow - Power Automate, FLOW
- Change SharePoint search results FullTextSqlQuery RowLimit 10000
- Fix Power BI error Access to the resource is forbidden when connecting SharePoint Online List as data source
- [Fix] Restricted View permission level missing in SharePoint Online site library
- How to upload file programmatically to SharePoint Document Library using Server Object Model C# .Net
- How to create classic site in SharePoint Online
- That did'nt work, Issue type User not in directory - SharePoint external access error
- Merge-SPlogfile PowerShell - SharePoint Correlation ID error
- Fix Power BI 404 not found error when connecting SharePoint Online List as Data Source
- SharePoint Server 2016 IT Preview Deprecated Removed features
- SharePoint error - An exception occurred when trying to issue security token: This implementation is not part of the Windows Platform FIPS validated cryptographic algorithms..
- Display Output in Java Console as a Table - Java
- Spotlight Search file path location on Mac OS X Mavericks or Yosemite - Mac-OS-X
- JDK Location in Android Studio - Android-Studio
- How to do calculations in Mac Terminal - MacOS
- How to make a dummy phone call from Android Emulator device - Android
- How to install Zsh shell - HowTos
- SharePoint Online REST API not returning all list items and limit to only 100 rows - SharePoint
- Add X days from today in Command Line - HowTos