Home
Microsoft

Changing the way business gets done – digital transformation – begins with great data. Microsoft 365 offers powerful tools for building workflows, automation and reporting – PowerApps, Flow, and Power BI. But you need a great place to store all that data.

 

Every month, millions of users turn to SharePoint lists to store critical business data.  Lists are secure, easy to use, and high capacity, with up to 30 million items in a single list.  Today, across Microsoft 365, SharePoint lists store billions of rows of data to house information for scenarios like customers, audits or emergency room availability and more across Microsoft 365.

 

Now, we’re making it easier than ever to get started with a list – using Excel or other lists as a starting point.

Create a SharePoint list from an existing list or from Excel

For years, business data often began life in Excel.  Excel is widely used and a common download format.  But lists are shareable, secure, mobile friendly, easy to use and easy to customize. 

 

As we previewed at SPC18, we’re releasing new abilities to let you create new lists from an existing list, or from an Excel table.  You can start from the Site Contents page.

Lists from lists

You can create a list from all existing lists within any site where you’re an editor.  When the new list is created, the entire list structure is copied, including forms, formatting, and custom metadata columns.   (Content will not be copied.)

L2.jpgCreating a list from other lists

Figure 1 - Creating a list from other lists

Lists from Excel

To create a list from Excel, you can select a table from your most recent Excel files in SharePoint or OneDrive.  You can change the field type of the column if needed, and all your table data will be copied to the new lists.

 

L6.jpgMapping Excel data to the new list

Next steps

Want to try this out now?  Head over to the Business Apps Resource Center for a demo.

 

We’ll start rolling out the new list creation experience to Targeted Release in mid May 2019.   You can share your feedback with us here on the TechCommunity, on UserVoice or at the SharePoint Conference.  As always, if you need more details you can find it on our Microsoft 365 Business Apps Resource Center.  Thanks.

19 Comments
Super Contributor

"you can select a table from your most recent Excel files in SharePoint or OneDrive"

So, you can't select an Excel workbook from your local drive?

Occasional Contributor

All your files should be on OneDrive or SharePoint anyway :smileywink:
This feature was long waited. Helps a lot.

Microsoft

I have some questions for the "list from list" (as I see it a shortcut for saving the list as template then using the template to create a new list):

  • will this allow to create lists with content already (like save as template with content)?
  • Will it work with source list that have more than 5000 items? (it was impossible to save those lists as template)
  • How about using list from other sites/site collection (let's say within a site collections in the same Hub and assuming the same content types are available on both)?

Thanks!

New Contributor

Excellent!

This finally makes "Import from Excel" a really valuable feature!

Frequent Visitor

.

New Contributor

Glad to see this being added. I cannot tell from the demo -- are the internal column names on the newly created table going to match the column display name? I've used "quick" methods to add columns to lists, but ended up with internal column names like t0gh and frankly the couple of minutes I saved creating the table have been more than blown by the time I spend consulting my column cross-reference table when I'm writing some code that reads/updates the list through the REST API. 

Occasional Visitor

COOL!!! 

Senior Member

Brilliant! This makes the work with Excel lists much easier. This was a really good improvement Chris!

Senior Member

Yay!! Cannot wait to me hands on this. :smileyvery-happy:

Senior Member

When's this getting rolled out?

New Contributor

What's the difference between this and the IMPORT FROM SPREADSHEET app? I know that this requires IE running activeX but it still works.

Senior Member

@David1972 I think the answer to you question in your question. It works in modern browsers without a need for ActiveX.

Overall, I think it's supposed to be a little "smarter" too by detecting and giving you the option to set the column types. I personally have had issues getting the "Import from Spreadsheet" version working since we moved to O365. 

New Contributor

@Mike Hatheway but we still have to keep IE around for all those other weird quirky things that SharePoint still won't let us do in any other browser (like open the file explorer!)

;)

Senior Member

@David1972  : I have heard whispers that the new chromium-based version of Edge that is in Dev preview will have a "run in IE11 mode" when it's necessary.  Fingers crossed!

Super Contributor

It's no whispers. They officially announced and showed (in a video) this at Build 2019 keynote :) Although, there were no details in what mode exactly would it work. Some may need IE9 or even IE7 modes with an additional Compatibility settings. So it might not replace IE11 or Enterprise Mode completely.

Super Contributor
Occasional Visitor

How is this feature different from the "import Spreadsheet" app on sharepoint. I use this often and works well. 

Senior Member

@Olga Melo : I believe the main difference is that it works in modern browsers without a need for Internet Explorer or ActiveX. There is also a confirmation screen for data types (pictured above).  

Frequent Contributor

Hi, @Olga Melo.

I've compared the different Import/export options for SharePoint below and agree with @Mike Hatheway that this option makes it more compatible for modern Web browsers since Import requires IE.

 

https://twitter.com/fredyano/status/1123236885365776384

 

Fred