How to Fix Cannot Create a Microsoft List from an Excel Workbook
Question details
Users are unable to create a Microsoft List by importing an Excel workbook due to existing list conflicts or generic import errors.
- Product
- Microsoft Lists, Microsoft Excel
- Device & OS
- not provided
- Scenario
- Attempting to create a new Microsoft List by uploading and importing source data from an existing Excel workbook.
- Observed behavior
- Microsoft Lists displays a generic error or incorrectly reports that the list already exists, even after previously created test lists have been deleted.
Ensure your Excel data is formatted as a Table, the workbook is closed before importing, and you have the necessary 'Edit' permissions on the target SharePoint site.
Copy Data to a New Excel Workbook and Switch Browsers
Transferring your source data to a fresh Excel file and using a different web browser often bypasses hidden cache issues and persistent naming conflicts.
When you delete a test list in SharePoint, the system may still hold the name or file parameters in its cache or recycle bin. Creating a completely new workbook with a different file name forces Microsoft Lists to process the data as a fresh import.
Open your original Excel workbook, select all the data you wish to import, right-click the selection, and choose 'Copy'.
Open a new, blank Excel workbook and paste your copied data into the first sheet. Ensure you format the pasted data as a Table (Insert > Table).
Click 'File' > 'Save As' and save the new workbook with a completely different file name than the one previously used.
Close your current browser (such as Chrome or Firefox), open Microsoft Edge, and log into your SharePoint site to attempt the list creation process again using the newly named workbook.
Create the List on a Different SharePoint Site
If the current SharePoint site has corrupted list cache or persistent recycle bin conflicts, creating the list on an alternative site can help you verify if the data itself is the issue.
Manage Your Spreadsheet Data Smoothly with WPS Office
While Microsoft Lists handles SharePoint tracking, dealing with complex Excel file preparation can sometimes be frustrating. Try WPS Office, a free, lightweight, and highly compatible alternative for all your spreadsheet creation, editing, and formatting needs.
- 1. Install WPS Office: Download and install WPS Office for free from the official website.
- 2. Open your data: Launch WPS Spreadsheets and open your existing tabular data or start a new workbook.
- 3. Format and export: Easily clean your data, format it as a table, and save it as an .xlsx file ready for upload to any external platform.
Frequently Asked Questions
Why does Microsoft Lists say my list already exists when I just deleted it?
This happens because SharePoint retains deleted lists in the site recycle bin, causing a backend naming conflict. You must either empty the recycle bin from the Site Settings or use a completely different name for your new list.
Does my Excel data need to be formatted in a specific way before importing to Microsoft Lists?
Yes, Microsoft Lists requires your Excel data to be formatted as a Table. You can do this in Excel by selecting your data range and pressing Ctrl+T, or navigating to Insert > Table before saving the workbook.
Can browser extensions cause generic errors in Microsoft Lists?
Yes, certain ad-blockers or privacy extensions can interfere with the background scripts used by SharePoint and Microsoft Lists during the upload process. Switching to a clean browser profile or a different browser like Edge often resolves this.
