SharePoint On Premises to SharePoint Online Migration

Aftab Alam
Aftab Alam linkedin | Updated On - May 19, 2022 |

Read time 5 minutes

Microsoft offers a special migration software for SharePoint on-premises users who want to migrate their sites, site collections, document library, and other data to SharePoint Online. We discuss how you can migrate them using professional software.

When users purchase Office 365 Business and Enterprises plans, they get several Microsoft applications like Exchange, Teams, SharePoint, etc. The complete MS Office Suite is also available to increase your productivity and business efficiency.

The SharePoint Online is the cloud-based incarnation of the SharePoint on-premises application that helps the business create, manage, verify the contents, and facilitate collaboration. It strengthens teamwork, finds essential information quickly, and establishes a collaboration infrastructure for the whole organization.

Also, when you have purchased Office 365 subscription, you need to migrate from SharePoint on-premises to SharePoint Online directly. Microsoft has developed a unique tool for making the migration job easier by moving the on-premises data to SharePoint Online and OneDrive.
SharePoint Migration tool public preview

If you visit the following URL, you can see a brief introduction of the tool that migrates data from SharePoint Server 2016, 2013, and 2010. The other source files are Network and local file shares.
If you click the Install button, it will install on your computer, and later you can start working on it.


Site Admin: To migrate a complete SharePoint Site, the Site Administrator should log in to the tool.
Global and SharePoint Admin: To migrate data at an organization-level, the Global or SharePoint Administrator should log in to the tool.

  1. Once you have logged in with your account in the tool, you can choose ‘Start your first migration.’
  2. Select SharePoint Server and enter the Site URL where your source data is present. Then click Next.
    NOTE – The Proxy connection will not connect with the SharePoint Migration Tool.
  3. Enter the username and password of the SharePoint site. The account should have the permissions mentioned above. Then click Sign in.
    NOTE – Once the user has signed in to the tool, it will not require input credentials again.
  4. Select the document library consisting of essential files. The dropdown option will include all the available choices.
  5. Select the SharePoint site URL of the destination account where you want to migrate the source site data.
  6. Choose the document library of the destination SharePoint site.
  7. Select Add, and the task will add to the migration list. Similarly, you can create more such tasks.

Migrate Files From a Local File Share

  1. To migrate only files from a local file share, you need to sign in to the SharePoint Migration Tool.
  2. Click ‘Start your first migration,’ there select File Share.
  3. Input the source path of the local file share where the data is present. Click Next.
  4. Input the destination site URL of SharePoint where you want to migrate the data. Click Next.
  5. Select the document library from where the data will be selected. Click Next.
  6. The task will add to the migration list, and you can create more tasks similarly.
  7. Once you have reviewed the selected data, then you can click Migrate option.

Bulk Migration Using CSV File

When the number of sites is too many, and you cannot move them individually, you should create a CSV file containing the data of all the source and targeted sites.

  1. Open MS Excel on your system and create the following types of columns-
    Column A “Source” The on-premises SharePoint Server site URL. It is mandatory.
    Column B “Source DocLib” The name of the SharePoint Server document library. It is optional.
    Column C “Source SubFolder” The name of the subfolder in the document library. It is optional.
    Column D “Target Web” The destination SharePoint site URL. It is required mandatory.
    Column E “Target DocLib” The name of the document library with the SharePoint site for destination account. It is required mandatory.
    Column F “Target SubFolder” The name of the subfolder in the document library. It is optional.
  2. Now, start the SharePoint Migration tool and choose the option to ‘start your first migration.’
  3. Select the option for ‘JSON or CSV file for bulk migration.’
  4. Input the full path of the CSV file where the data is present. Click Add.
  5. Input the URL of the SharePoint site for the destination. Click Next.
  6. Enter the location of the complete CSV file, click Add.
  7. If you want to add more files for migration, click ‘Add a source’ and click Next.
  8. Review the previous settings and click Migrate. The migration will start.

Professional Method

The SharePoint Migration Tool from Microsoft can accomplish the migration, but it requires well-maintained hardware resources, proper settings, and various permissions. So, you should use professional software that supports both SharePoint (on-premises & online) and migrate data both ways. Kernel Migrator for SharePoint is a safe platform to manage large-scale SharePoint migration from any source.

It can also migrate data from Public Folder, Microsoft Teams, OneDrive, and Google Drive. Several additional features empower selective migration, and you can access the migrated data at the destination instantly after the migration.


Q. Can I schedule migration using Microsoft’s SharePoint migration tool?

A. No, the Microsoft tool does not provide such benefits. Although, Kernel Migrator for SharePoint lets you schedule a large migration easily.

Q. Does the Microsoft SharePoint Migration tool support other migrations like Microsoft Teams and Google Drive?

A. Yes, it can migrate data from such platforms.

Q. What are the filter options to migrate the SharePoint site using the professional tool?

A. There are various filter options available in the tool that you can apply to select the specific data of the site.

Q. Does both these tools provide migration reports?

A. Yes, both tools provide migration reports differently.


The manual method to migrate SharePoint data using Microsoft tool will migrate the data, but there are several limitations. You should use SharePoint Migration and overcome the manual method’s limitations. The software can handle unlimited migration supporting different platforms. It can also migrate data from SharePoint online to on-premises. So, you get great flexibility with the tool.