How to Fix 'e.split Is Not a Function' Error in SharePoint List Items
Question details
Users need to resolve an error preventing them from opening or editing specific SharePoint list items after importing spreadsheet data.

- Product
- Microsoft SharePoint / Microsoft Excel
- Device & OS
- not provided
- Scenario
- Clicking to edit a list item in the SharePoint panel after importing a list from an external Excel workbook.
- Observed behavior
- The edit panel fails to open, and the system displays the error message “Something went wrong. e.split is not a function.”
Verify that your web browser is fully up to date and ensure you have site permissions to create a test list for troubleshooting purposes.
Isolate Browser and Cache Issues
Use a private browsing window to determine if the error is caused by corrupted browser cache data or conflicting extensions.
Browser cache and third-party extensions can sometimes interfere with SharePoint's JavaScript execution, triggering the e.split error.
Launch your web browser and open a new Private or Incognito window (e.g., Ctrl+Shift+N in Chrome).
Log in to your SharePoint site, navigate to the affected list, and attempt to edit the problematic item.
If the error does not appear in the private window, return to your normal browsing session, clear your cache and cookies, and disable active extensions to permanently resolve the issue.

Import Clean Data as Plain Values
Strip hidden formatting from the original Excel workbook that may be causing unsupported column data errors in SharePoint.
Use WPS Office for Clean and Seamless Spreadsheet Management
While resolving SharePoint list errors requires web-based troubleshooting, preparing your data cleanly is much easier with a reliable office suite. As a free, lightweight alternative to Microsoft Office, WPS Spreadsheet offers excellent compatibility and intuitive tools to ensure your data is stripped of hidden formatting before importing it to online platforms.
- 1. Open a New Spreadsheet: Launch WPS Spreadsheet and create a new blank workbook.
- 2. Clean Your Data: Copy your raw data, right-click the destination cell, and select 'Paste Special' > 'Unformatted Text'.
- 3. Save for Import: Save the document as a standard .xlsx file, ensuring it is ready for an error-free SharePoint import.

Frequently Asked Questions
What does the 'e.split is not a function' error mean in SharePoint?
This is a JavaScript error that occurs in the browser when SharePoint attempts to process data—usually expecting a text string—but receives an unexpected format, often due to corrupted cache or unsupported column data imported from Excel.
Why do SharePoint lists imported from Excel cause editing errors?
Excel workbooks exported from other sources might contain hidden formatting, unsupported characters, or incompatible column types that SharePoint cannot properly parse in its native edit panel.
How can I find which column is causing the e.split error?
Compare the affected rows with working rows in your list. Look for unusual values, special characters, or multi-line text fields that might have retained hidden HTML formatting from the original Excel import.




