I created a custom list in datasheet view and populated it with a fairly large number of items.

I am now discovering a few limitations with this list type versus a the standard SharePoint custom list (the new user friendly automate rules, and integration with Lists in Teams).

Is there any easy way to convert any existing custom list in datasheet view to a regular custom list?

This would save a ton of time if I don't have to recreate the list.

1 Answer 1


There is no option to convert existing list in datasheet view to a regular custom list.

As a workaround, you could export data from existing list by using "Export to Excel", then create a list by using "Import Spreadsheet" in the site contents.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.