Create SharePoint lists from Excel or other lists

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.)

Creating 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.

Mapping Excel data to the new list


Triphla Cloud Tech Solutions

Comments

Post a Comment

Popular posts from this blog

Microsoft Whiteboard: now more colorful and customizable than ever

Image
The Whiteboard team has been hard at work since our announcements at Ignite. A s we gather more and more feedback from our growing customer base, we’ve also been rolling out great new features, with more on the way soon. Let’s take a look at what’s changed. New pen colors and thicknesses Responding to popular demand, we’ve added 10 new pen colors and three more pen thicknesses, allowing Whiteboard users to express themselves more colorfully and boldly than ever. To access the new colors and thicknesses, click on the pen you have selected to pop up the palette. Background colors and gridlines Just like it’s great to have options for pen color, customizing the look and feel of the board itself can help your ideas stand out – and can make your boards more usable and readable as well. Whiteboard now offers nine options for board color and eight types of gridlines that can be used together or separately to customize your boards’ backgrounds. These options are selectable in
Read more

SharePoint page enhancements

Image
There’s a SharePoint page for that. From content-rich home pages that serves entire organizations, to recurring quarterly business review read outs, to internal campaigns, to “welcome to the company” starter pages. As the rich capabilities of modern SharePoint pages evolve, all communicators can better design and promote their information throughout their team and across the organization. We are excited to announce the following page enhancements (screenshots + links to learn more below): Customize title region  | control what the title region of each page looks like (layout, alignment, title, date). Section backgrounds  | display as distinct sections with visual variety throughout the page. Custom page thumbnails  | Choose a preferred thumbnail from Page details. Custom page descriptions  | Create a custom description from Page details. FYI:  removal of the Feedback button  in preparation of new feedback experience  |  in preparation for a new feedback experience coming soon
Read more

New device modeling experience in Azure IoT Central

Image
On the Azure IoT Central team, we are constantly talking with our customers to understand how we can continue to provide more value. One of our top pieces of product feedback has been for a clearer device modeling experience that separates the device instance from the device template. Previously, viewing the device and editing the device template took place on the same page through an “Edit Template” button. This caused a lack of clarity between when you were making a change that applied to the device or if your changes were getting applied to all devices in that template. Recently we've begun a flighted rollout of a new device modeling experience that begins to directly address this feedback. For app builder roles, we have introduced a new “Device Templates” navigation tab that replaces the existing “Application Builder” tab, as well as updated the pattern in which you view or edit your device templates. To edit your device templates, you can visit the “Device Templates” tab
Read more