Export an Excel table to SharePoint

You can export data from an Excel table to a SharePoint list. When you export the list, Excel will create a new SharePoint list on the site. You can then work with the data on the site, just like you would for any other SharePoint list.

Note: Exporting a table as a list does not create a data connection to the SharePoint list. If you were to update the table in Excel after exporting it, the updates will not be reflected in the SharePoint list.

To export a table in an Excel spreadsheet to a list on a SharePoint site, you need:

• A SharePoint site where you are creating the list.

• Permissions to create lists on the site. If you are not sure, contact your SharePoint site administrator.

To view the list in datasheet view on the SharePoint site you need:

• Excel or Access. These programs are required for using the datasheet view on the SharePoint site.

Note: Datasheet view is not supported in 64-bit version of Microsoft Office. It is recommended that you install 32-bit version of Office in order to be able to use Datasheet view in a list on a SharePoint site.

Export a table to a SharePoint list

Click inside the table.

Click Design >> Export >> Export Table to SharePoint List.



In the Address box, type the address, or URL of the SharePoint site.

Important: Type everything that’s in your Web address before the “/default.aspx”. For example, if the address is http://contoso/default.aspx, type http://contoso. If the address is http://contoso/teams/accounting/sitepages/home.aspx, type http://contoso/teams/accounting.



In the Name box, type a unique name for the list.

Optionally, enter a description in the Description box.

Click Next.

Note: You may be asked to enter your Office365 credentials, or organizational domain credentials, or both.

Review the information given in Columns and Data Types and then click Finish.

Click OK.

A message indicating that your table is published, along with the Uniform Resource Locator (URL) appears. Click on the URL to go to the list.

Note: Another way to open the list is to go the SharePoint site, click the gear icon on the upper-right corner, and click Site Contents.

Supported data types

Some Excel data types cannot be exported to a list on the SharePoint site. When unsupported data types are exported, these data types are converted to data types that are compatible with SharePoint lists. For example, formulas that you create in Excel are converted to values in a SharePoint list. After the data is converted, you can create formulas for the columns on the SharePoint site.

When you export an Excel table to a SharePoint site, each column in a SharePoint list is assigned one of the following data types:

• Text (single line)

• Text (multiple lines)

• Currency

• Date/time

• Number

• Hyperlink (URL)

If a column has cells with different data types, Excel applies a data type that can be used for all of the cells in the column. For example, if a column contains numbers and text, the data type in the SharePoint list will be text.

Restore the Team in Microsoft Teams using SharePoint Online Management Shell

IMPORTANT: As a best practice, we recommend always staying current: uninstall the old AzureADPreview version and get the latest one before you run SharePoint Online Management Shell commands.

In your search bar, type SharePoint Online Management Shell. Pin it to the Taskbar.

Right-click on SharePoint Online Management Shell. and select Run ISE as Administrator.

To uninstall a previous version of AzureADPreview, run this command:

Uninstall-Module AzureADPreview

To install the latest version of AzureADPreview, run this command:

Install-Module AzureADPreview

At the message about an untrusted repository, Click on "Yes to All". It will take a minute or so for the new module to install.

Restore the deleted Team

Note: You must have Office 365 global admin or organization management permissions.
Install the most current preview version of AzureADPreview module,  to make sure these steps work for people.
Run the following command to connect to Azure AD

Connect-AzureAD

In the Sign in to your Account screen that opens, enter your Office 365 admin account and password to connect you to your service, and click Sign in.

Run this command to display all soft-deleted Office 365 groups in your organization that are still within the 30 day retention period:

Get-AzureADMSDeletedGroup

Take note of the object ID of the group, or groups, you want to restore. If you don't see the group you're looking for on this list then it has likely been purged permanently.

Caution: If a new group has been created with the same alias or SMTP address as your deleted group, you will have to delete that new group before you'll be able to restore your deleted group.

To restore that group run this command:

Restore-AzureADMSDeletedDirectoryObject –Id <objectId>

This process usually takes just a few minutes but in a few rare cases it can take as long as 24 hours to completely restore. To verify that the group has been successfully restored, run this command in PowerShell:

Get-AzureADGroup –ObjectId <objectId>

Once the restore has successfully completed, the group should reappear on the navigation pane in Outlook and Outlook on the web. All restored content, including SharePoint, Microsoft Team and Planner, should be available to the group members again.

_________________________________________________________________________________

Permanently delete the Team in Microsoft Teams

Sometimes you may want to permanently purge a group without waiting the 30 days for the soft-delete to expire. To do that, start PowerShell and run this command to get the object ID of the group:

Get-AzureADMSDeletedGroup

Take note of the object ID of the group, or groups, you want to permanently delete.

Caution: Removing the group removes the group and its data forever.
To remove the group run this command in PowerShell:

Remove-AzureADMSDeletedDirectoryObject –Id <objectId>

To confirm that the group has been successfully purged, run the Get-AzureADMSDeletedGroup cmdlet again to confirm that the group no longer appears on the list of soft-deleted groups. In some cases it may take as long as 24 hours for the group and all of its data to be permanently deleted.

Restore a deleted Office 365 Group

If you've deleted an Office 365 group, by default it's retained for 30 days. This 30-day period is called "soft-delete" because you can still restore the group. After 30 days, the group and associated content is permanently deleted and cannot be restored.

During the "soft-delete" period if a user tries to access the site they will get a 403 forbidden message. After this period if the user tries to access the site they will get a 404 not found message.

When a group is restored, the following content is restored:

Azure Active Directory (AD) Office 365 Groups object, properties and members
Group SMTP address
Exchange Online shared inbox and calendar
SharePoint Online team site and files
OneNote notebook
Planner

If you have a connected Microsoft Team or Office 365 Connected Yammer group, that related content is restored, too.

You can also permanently delete a soft-deleted group if you can't wait the 30 days for the retention period to expire for the content to be permanently deleted. 

_________________________________________________________________________________

Restore an Office 365 Group using the Exchange admin center

Go to the .

In the left navigation of the Office 365 admin center, expand Admin center, and then choose Exchange.

In the Exchange admin center, select recipients, and then choose groups. You can view whether the group is Active or soft Deleted. If the group has been permanently deleted, it won't be listed at all.

To view the exact time when the group was soft deleted, select the group and view the info in the right pane.

Select the Office 365 group you want to restore, and then choose the restore icon.

Choose refresh to update the information on the page. Your group will show as Active.

_________________________________________________________________________________

Restore an Office 365 Group using SharePoint Online Management Shell

IMPORTANT: If you use Remove-MsolGroup in PowerShell to delete a group, this will delete the group permanently. When using PowerShell to delete groups, it's best practice to use Remove-AzureADMSGroup to soft-delete the Office 365 group. 

That way you can restore it if needed.Install the preview version of the Azure Active Directory Module for SharePoint Online Management Shell

IMPORTANT: As a best practice, we recommend always staying current: uninstall the old AzureADPreview version and get the latest one before you run SharePoint Online Management Shell commands.

In your search bar, type SharePoint Online Management Shell. Pin it to the Taskbar.

Right-click on SharePoint Online Management Shell. and select Run ISE as Administrator.

To uninstall a previous version of AzureADPreview, run this command:

Uninstall-Module AzureADPreview

To install the latest version of AzureADPreview, run this command:

Install-Module AzureADPreview

At the message about an untrusted repository, Click on "Yes to All". It will take a minute or so for the new module to install.

_________________________________________________________________________________

Restore the deleted group

Note: You must have Office 365 global admin or organization management permissions.
Install the most current preview version of AzureADPreview module,  to make sure these steps work for people.
Run the following command to connect to Azure AD

Connect-AzureAD

In the Sign in to your Account screen that opens, enter your Office 365 admin account and password to connect you to your service, and click Sign in.

Run this command to display all soft-deleted Office 365 groups in your organization that are still within the 30 day retention period:

Get-AzureADMSDeletedGroup

Take note of the object ID of the group, or groups, you want to restore. If you don't see the group you're looking for on this list then it has likely been purged permanently.

Caution: If a new group has been created with the same alias or SMTP address as your deleted group, you will have to delete that new group before you'll be able to restore your deleted group.

To restore that group run this command:

Restore-AzureADMSDeletedDirectoryObject –Id <objectId>

This process usually takes just a few minutes but in a few rare cases it can take as long as 24 hours to completely restore. To verify that the group has been successfully restored, run this command in PowerShell:

Get-AzureADGroup –ObjectId <objectId>

Once the restore has successfully completed, the group should reappear on the navigation pane in Outlook and Outlook on the web. All restored content, including SharePoint and Planner, should be available to the group members again.

_________________________________________________________________________________

Permanently delete an Office 365 group

Sometimes you may want to permanently purge a group without waiting the 30 days for the soft-delete to expire. To do that, start PowerShell and run this command to get the object ID of the group:

Get-AzureADMSDeletedGroup

Take note of the object ID of the group, or groups, you want to permanently delete.

Caution: Removing the group removes the group and its data forever.
To remove the group run this command in PowerShell:

Remove-AzureADMSDeletedDirectoryObject –Id <objectId>

To confirm that the group has been successfully purged, run the Get-AzureADMSDeletedGroup cmdlet again to confirm that the group no longer appears on the list of soft-deleted groups. In some cases it may take as long as 24 hours for the group and all of its data to be permanently deleted.

Content copied from:
https://support.office.com/en-us/article/restore-a-deleted-office-365-group-b7c66b59-657a-4e1a-8aa0-8163b1f4eb54?ui=en-US&rs=en-US&ad=US#bkmk_perm

OneDrive Ribbon missing

OneDrive for Business is a SharePoint Library. OneDrive provisioning is also controlled in SharePoint admin center. By default, you may not see the Files, Library Ribbon. We can use simple trick to get the Ribbon back.



1. At the end of the URL, add "?ShowRibbon=true" as shown below.
    All.aspx?ShowRibbon=true

2. Click on the Gear Icon, as shown below and click on Ribbon, it will be On

   

Now you can see the Files, Library Ribbon.

Assign a user to administrator roles in Azure Active Directory

This article explains how to assign an administrative role to a user in Azure Active Directory (Azure AD). Added users don't have administrator permissions by default, but you can assign roles to them at any time.

Assign a role to a user

1. Sign in to the Azure AD admin center with an account that's a global admin for the directory.
2. Select Users and groups.
   
3. Select All users.
   
4. Select a user from the list.
5. For the selected user, select Directory role and then assign the user to a role from the Directory role list. For more information about user and administrator roles, see Assigning administrator roles in Azure AD.
   
6. Select Save.

Install Azure (RM, AD & SPO) modules in PowerShell

NOTE: Run the below PS Command in Windows PowerShell ISE thru Admin mode.

Install PowerShellGet
Install-Module PowerShellGet -Force
While Loading, you will see a couple of dialog boxes for Acceptance, Click on Yes to All

Install Azure PowerShell
Install-Module -Name AzureRM -AllowClobber
While Loading, you will see a couple of dialog boxes for Acceptance, Click on Yes to All

In Windows 10: Everything works fine.
In Windows 7: Turn on Script Execution in both the Locations given below.

Local Computer Policy\Computer Configuration\ Administrative Templates\ Windows Components\Windows PowerShell

Local Computer Policy\User Configuration\ Administrative Templates\ Windows Components\Windows PowerShell


Manage Execution Policy
To get all of the execution policies that affect the current session and displays them in precedence order, type:

Get-ExecutionPolicy -List
To set the execution policy in a particular scope, type:
Set-ExecutionPolicy AllSigned -Scope CurrentUser
Set-ExecutionPolicy AllSigned -Scope LocalMachine

Load the AzureRM module
Import-Module -Name AzureRM
While Loading, you will see a couple of dialog boxes for Acceptance, Click on Yes to All

Install the Azure AD Module
Install-Module MSOnline
While Loading, you will see a couple of dialog boxes for Acceptance, Click on Yes to All

MSOnline Public Preview module
Install-Module AzureADPreview
While Loading, you will see a couple of dialog boxes for Acceptance, Click on Yes to All

Microsoft SharePoint Online Services Module for Windows PowerShell
Install-Module -Name Microsoft.Online.SharePoint.PowerShellWhile Loading, you will see a couple of dialog boxes for Acceptance, Click on Yes to All

If you notice any warning as shown below, add -Force to the end of the above Powershell command.

Restart the Windows PowerShell ISE after completion.
Now you can see all the Modules loaded.

Enable the Power BI Adoption content pack for Office 365

Note: This is pre-release documentation for a public preview, and is subject to change in future releases.

The Adoption content pack is now also available for Office 365 US Government Community.

Steps to enable Office 365 Adoption content pack Power BI reports

To get started with the Adoption Content Pack, you first need to get Power BI, and then instantiate the content pack in the Office 365 admin center.

Get Power BI

If you don't already have Power BI, you can sign up for the free Power BI service. Choose Get started free to get the free version.

You can also expand Products to buy a version of Power BI.

Enable the content pack

To instantiate the content pack, you have to be either a global administrator, Exchange administrator, Skype for Business administrator, or SharePoint administrator.

See Office 365 admin roles for more information.

1. Sign in with your admin credentials, and go to the Admin center.
2. In the admin center, expand the left nav, and go to Reports > Usage.
3. On the Usage page, locate the Office 365 Adoption card, and choose Get started.
   
4. On the Reports panel that opens, set Make data available to the Office 365 Adoption content pack for Power BI to On > Save.
   This initiates the data collection. [which normally takes between 2 and 48 hours depending on the size of the tenant]
   When the data collection is complete, the Go to Power BI button is enabled (no longer gray), and the card includes a tenant Id.
5. Copy the tenant Id and choose Go to Power BI.
   
6. When you get to Power BI, sign in. Choose Get Data, then under Content Pack Library choose Services > Get.
   
7. In the Apps tab, type Office 365 in the search box and then select Office 365 Adoption Preview > Get it now.
8. On the Connect to Office 365 Adoption screen, type in the tenant Id you copied in step (5) > Next.
9. On the next screen, choose oAuth2 as the Authentication method > Sign in. If you choose any other authentication method, the connection to the content pack will fail.
   
10. Once the content pack is instantiated the Office 365 Adoption dashboard will be available in Power BI on the web. The initial loading of the dashboard will take between 2 to 30 minutes
    See working with the reports in the adoption content pack for tips on how to view and use these reports.

Make the collected data anonymous

To make the data that is collected for all reports anonymous, you have to be a global administrator. This will hide identifiable information such as user, group and site names in reports and in the content pack .

1. In the admin center, expand the left nav, and go to Settings > Services & add-ins.
2. On the Services & add-ins page choose Reports, and then turn on the toggle next to Display anonymous identifiers instead of names in all reports.This setting gets applied both to the usage reports as well as to the content pack.
   
3. Choose Save.

Enabling Audit Logs in SharePoint Online

You can enable audit logs at Site Collection level in SharePoint Online.

Go to Site Settings >> Site Collection Administration >> Site collection audit settings

Automatically trim the audit log for this site is Yes by default and grayed out.

You can choose the number of days between 1-90.

Path of the default Maintenance Log Library. [_catalogs/MaintenanceLogs]

https://spdevonline.sharepoint.com/_catalogs/MaintenanceLogs/Forms/AllItems.aspx

Customize SharePoint Online Sign-in Page

Customize SharePoint Online Sign-in Page

In SharePoint Online you can brand your own sign-in page using the Azure Active Directory (AD) subscription that is included with your Office 365 subscription from the Azure AD thru the Admin Centers.

You can directly go to https://portal.azure.com/ if you already have access.

Click on Azure Active Directory, select Company Branding then Edit.

Below are the options you should be able to update.

1. Sign-in page background image
2. The banner logo
3. User name hint
4. Sign-in page Text

Under Advanced settings, you have 4 more options

1. Sign-in page background color
2. Square logo image
3. Square logo image, dark theme
4. Show option to remain signed in

Save the page once completed.

Below are the updated Options.

OneDrive is not provisioned for this user

Case: OneDrive is not provisioned for this user

Solution: We have two scenarios for accessing OneDrive.

1. Login thru the Client installed with Office Pro plus, which creates a local OneDrive Folder.
2. Login thru the Web, creates a personal site under SharePoint 'My Sites' Site Collection.

Both are interdependent. Because Sync of Items plays a key role.

Though, you install OneDrive Client and try to login, you cannot login because you are not provisioned to create Personal Site. If you click on OneDrive icon in web, it may re-direct to Delve (https://delve.office.com/).

Enable "Create Personal Site" option.

Go to SharePoint admin center >> user profiles >> Manage User Permissions

Note: We can also include specific groups, if not needed for Everyone.

After enabling the above Permissions, You should be able to login into the OneDrive with your Office Account and also Personal Account.

1. Login with Office Account creates a OneDrive folder with Tenant Name

2. Go to OneDrive Try Icon and right click on it to get the below screen.

Click on Settings >> Account tab. Click on 'Add an account' to add you Personal Microsoft Account. 

It creates a folder with Personal (as shown below)

Startup activity will be created in Windows to take care of the Sync Activity.

Icons missing in Office 365 portal

Issue: We were using Office 365 Enterprise E5 Trial. Later got Office 365 Enterprise E3. Once the E5 Trial was expired, the icons got disappeared. Specifically, Word, Excel, One Drive and SharePoint. Tested on IE and Chrome browsers and with peers computers and all the same. Surprisingly this happened to all users.

They even got disappeared from my apps page also https://portal.office.com/myapps

Want to get them back....?

Solution: Surprisingly the solution is in SharePoint admin center.

Please go to SharePoint admin center >> settings >> Show or hide options to make sure OneDrive for Business and sites are selected as Show.

Hooray..........They all are back.