1. Introduction

The way data is organized in Box is very different to that of SharePoint (SharePoint Online). And this fundamental difference creates challenges for Box to SharePoint Online migration.

Box vs SharePoint

But with the right approach, you can steer clear of the challenges.

If you are an IT admin exploring the best ways to migrate Box to SharePoint Online, you have come to the right post. CloudFuze helps your company transfer files from Box to SharePoint Online account quickly and securely.

If you are short of time, learn directly from our migration team or watch the migration video:

Please check our Box to OneDrive migration guide if you would like to migrate to OneDrive for Business instead.

2. Box to SharePoint Online Migration: IT Admin Challenges

As an IT admin/manager, you may already know that the manual method to migrate from Box to SharePoint Online is out of scope. The method doesn’t migrate sharing permissions, TBs/PBs of data, timestamps, and Box-specific features such as Box Notes.

Migration challenges

Here are some of the major challenges IT teams face while migrating data from Box to SharePoint.

  • Transferring large data (often in TBs and PBs) via the company’s infrastructure
  • Migrating file and folder sharing permissions of users across the organization
  • Conversion of Box features such as Box Notes to relevant formats in SharePoint like MS Word
  • Migrating external shares, shared links, timestamps, file version history, etc
  • Tracking and monitoring the migration project status, especially if the data to be migrated is large
  • Risk of downtime during migration

3. CloudFuze’s Crucial Role in Box to SharePoint Migration

CloudFuze is a cloud data migration platform built for companies of all sizes, especially enterprises that need to migrate between leading cloud storage and collaboration services like Box, SharePoint, OneDrive, Dropbox, Google Drive, etc.

We have helped enterprises and SMBs with Box to SharePoint Online migration, including Future State, an Accenture company, and Stein Law LLC.

Box to SharePoint clients

With the capabilities to migrate sharing permissions, internal and external shares, version history, timestamps, comments, and Box-specific features, we cater to all types of Box to SharePoint Online migration and overall Box to Microsoft 365 migration needs.

Box to Microsoft 365 migration with CloudFuze

4. Box to SharePoint Online Migration Guide and Demo

This article deeply discusses the steps to migrate Box to SharePoint Online. If you are an IT admin exploring a migration solution and don’t have time to read, please contact our migration team for a personalized demo or quote.

We are in constant communication with our clients, and we have a deep understanding of their pain points. Just like the way we help our migration clients, we’ve made this guide and its FAQ section intricate to address the challenges your company faces/may face.

5. Readying Box and SharePoint Admin Accounts

The first and the basic step to copy files from Box to SharePoint Online is to ready the admin accounts of both clouds and add them to CloudFuze X-Change.

Since it is a business migration, you need to make sure that you are adding an admin account of Box and SharePoint, and not personal.

Adding Box

Before adding the Box account, check whether you are already an admin of the account and have admin login credentials ready. To successfully authorize Box and initiate migration, you must be an admin. Co-admin or users can’t facilitate the migration.

How to Find Box Admin Account?

If you are a co-admin of Box account and unsure of who is the admin of your organization’s Box account, you can follow these steps.

Step 1: Log into your Box account.
Box Account

Step 2: Click on the Admin Console icon on the left side of the page.
Box Admin Account

Step 3: Click on Users and Groups and it will redirect to a page where you can find users and their roles/privileges.
Users And Groups

You may read more about Box admin and co-admin privileges from here.

Authorizing Box Business from CloudFuze

With CloudFuze, the steps to migrate Box to SharePoint Online start with adding Box Business to the webapp.

Step 1: Locate Box Business Icon and click on it.
Box icon

You must click on the Box logo under the “Business Clouds” section.

Step 2: Enter Your Box Admin Login Credentials.
Box login

Enter your Box Business admin login credentials in the popup and click on “Authorize”.

Step 3: Find Box in the “Manage Clouds” tab.
Find Box

You will get an on-page notification once authorization is successful. Alternatively, you can go to the “Manage Clouds” section to find the Box account added there. If you cannot find Box, then it is not added successfully.

Adding SharePoint Online

After adding Box, the next step is to add the admin account of SharePoint Online. Similar to adding Box, it is important to add a SharePoint Online admin account and not a personal account.

How to Find SharePoint Online Admin Account

Step 1: Sign into your Microsoft 365 Admin Portal and select “Active users”.
Microsoft 365 admin center

Once done, you can see the list of the users where you can add a user, delete, or even reset the password of a user.
Active users

Step 2: Select the Admin from Office 365 Admin Portal.
Office 365 global admin

Remember, Microsoft 365 global admin is the admin of SharePoint Online as well and those global admin privileges are required to add and authorize SharePoint Online.

By selecting a user, a pop-up will be displayed where you can see the role of the user, so the role must be a Global Admin.

Authorizing SharePoint Online from CloudFuze

Similar to adding Box, add SharePoint Online to CloudFuze webapp to be able to migrate data from Box to SharePoint.

Step 1: Identify the SharePoint Online icon under “Business Clouds” and click on it.
SharePoint Online icon

Step 2: Enter Your SharePoint Online Sign-in Credentials.
SharePoint Online login

Enter your login credentials of your SharePoint Online on the pop-up window.

Step 3: Click on Manage Clouds.
Manage clouds

By clicking on “Manage Clouds”, you can see whether the SharePoint Online account is added successfully.

6. Steps for Box to SharePoint Online Migration

Click On Team Migration from the left-hand pane.

Select Box as the source and SharePoint as the destination, click on the Next button.
Source and destination clouds

After clicking on the Next button, you will enter the Content Mapping page which is the second step to initiate migration.
Box to SharePoint Online Mapping page

To migrate from Box to SharePoint Online, you need to map the source and destination users via a CSV file. There are three steps involved in this process:

  1. Mapping users in a CSV file
  2. Uploading CSV file
  3. CSV file validation & downloading the report

1. Mapping users in a CSV file

Step 1: Create an Excel sheet and follow the column layout and syntax format as shown below.
CSV excel sheet

Step 2: Make sure to enter the names of the right folders in the source and destination path. Also, save the Excel sheet in CSV format.

2. Uploading CSV file

Step 1: In the Content Mapping page, click on the right CSV icon with an up (↑) arrow indication.
Upload CSV file

Step 2: On clicking the CSV icon, a pop-up will be displayed. Browse the file from your saved location and select the file.
CVS upload pop-up

3. CSV file validation & downloading the report

Once the CSV file is uploaded, the validation process will start. The time for validation depends on the number of mappings that are present in the CSV file.
CSV validation

After the validation is complete, the report will be automatically saved to your computer. You can manually download the validation report by clicking on the CSV icon with a down (↓) arrow.

7. Migrate to Different Types of SharePoint Sites

Unlike migrating data to OneDrive for Business or other cloud storage, the steps to migrate Box to SharePoint Online can be quite different if you have created different types of SharePoint Online sites.

In this section, we have tried to address real-life SharePoint site migration needs which may resonate with your company’s requirements.

Below, we have covered the steps to copy files from Box to different SharePoint sites, e.g., SharePoint Public site and SharePoint Private site.

How to migrate content to SharePoint Public site

Step 1: Create a CSV file in an Excel sheet. Use the column and syntax template shown below:
SharePoint Online CSV files

Step 2: In the source and destination path column, start with / and enter the folder or subfolder name.

Note: Path names should be upper case.

Step 3: Save the CSV file before uploading to make sure that all the entries are intact.

How to migrate content to SharePoint Private site

Step 1: To migrate to any private site, the global admin of SharePoint should be a member of that site.

Step 2: CSV file creation processes are the same for the Private sites as that of the Public sites.
SharePoint Online CSV files

How to migrate multiple Box users’ folders to one Admin site in SharePoint

When migrating from Box to one SharePoint admin site, source cloud users and paths can be different, but destination cloud user and path (site) need to be the same.
One admin site

How to migrate multiple Box users’ folders to multiple Admin sites in SharePoint

When migrating to multiple admin sites, source cloud users and paths can be different, and destination cloud users and path (site) can also be different.
Multiple admin site

8. Box SharePoint Migration FAQs

Enterprises as well as SMBs face technical challenges during Box to SharePoint Online migration or other cloud migration. Depending on your company’s migration requirements or data structure, your IT team may face challenges specific to the company’s operations.

You can reach out to us with a quote form to understand how CloudFuze can help you mitigate challenges and create a migration success story. Also, you may get help from our in-depth FAQ section below:

SharePoint Online FAQ

1. How to create a public and private SharePoint Online site?

Step 1: Log into your Microsoft 365 account.

Step 2: Choose SharePoint Online from the list of other Microsoft 365 apps.

Step 3: Click on “Create Site”.
Create a site

Step 4: Select the Team site option.
SharePoint sites

Step 5: From the Privacy settings drop-down, select “Public” as the option.
Site privacy settings

Step 6: To create a private site, simply change the privacy settings to “Private”.
Site privacy settings

2. How to add or remove site members?

Step 1: Click on the “Members” tab on the left section of any site.

Step 2: Click on the “Add Members” button to add new members to the site.
Add site members

Step 3: If you want to delete a particular person, click on the user profile, you will see an option to “Remove from group”.

Step 4: Only the person you select is deleted from the group.
Remove user from group

3. What are the special characters that are not allowed in SharePoint?

“/”, “:”, “?”, “|”, “<“, “>”, “\\”, “\””, “*” , “~”, “/”, “.”, “:”,.

These are the special characters not allowed in SharePoint Online.

Box FAQ

1. How will Box Notes be migrated to SharePoint Online?

Box Notes will be converted into Microsoft Word documents which will be available for use in SharePoint Online as well as OneDrive for Business.

2. Is it possible to migrate the comments and version history of every Box Notes document?

Yes, with CloudFuze X-Change, you can migrate all the comments of Box Notes documents while preserving the version history when migrating from Box to SharePoint Online.

3. Will Box to SharePoint migration be safe?

With a migration tool like CloudFuze X-Change, you can ensure data safety when migrating to SharePoint Online from Box. Our migration tool uses the safest data authorization protocols, including REST API and OAuth.

4. What will happen to Google Docs, Google Slides, and Google Sheets created in Box?

All types of Google files created in Box will be converted into respective Microsoft files. For example, Google Docs will be converted into Microsoft Word, Google Slides will be converted into Microsoft PowerPoint, and Google Sheets will be converted into Microsoft Excel.

Box to SharePoint Online Migration FAQ

1. Which is better: cut or copy files from Box to SharePoint?

Copy-and-paste action is always the right choice for almost all types of cloud migration. Compared to cut-and-paste action, there are many benefits that copy-and-paste action brings, including low risk of downtime, easier deployment of retry mechanisms, and full-fledged disaster recovery.

2. How does CloudFuze handle long paths?

Total path length includes the length of the file name and the folder path. The total path is limited to 400 characters in Office 365.

When CloudFuze comes across this type of situation, it creates a folder called “LongFileName” at the root of the SharePoint Online site.

3. Is there a risk of downtime during Box to SharePoint Online migration?

CloudFuze X-Change uses a copy-and-paste action and therefore mitigates the risk of downtime which, otherwise, can disrupt operations. Once the users are properly mapped and parameters set, the migration tool migrates data as a background activity to ensure workflow isn’t affected.

4. How does CloudFuze handle special characters unsupported by Microsoft 365?

Following are the characters that are not supported by Office 365 in file or folder name
” * : < > ? / \ |
Users can choose whether to replace the unsupported special characters with Underscore or Hyphen.

5. Is there a throttling risk when migrating high-volume data from Box to SharePoint Online?

Yes. Unfortunately, businesses can stand at throttling risk when migrating high-volume data not just during Box to SharePoint migration but also when migrating to other clouds. In many cases, cloud storage companies limit data transfer bandwidth if they detect high-volume data migration.

At CloudFuze, our migration team commits to helping migration clients by reaching out to cloud storage companies and quickly resolving bandwidth throttling issues.

6. Do I have to create sites before migrating Box data to SharePoint Online?

Yes, it’s only by creating sites first that you can make an informed decision as to which data goes where.

7. How are Box files comments migrated to SharePoint Online?

When there are any conversations on a file, Box will represent that in the following way.
Box file

When you click on the file, you can see the comments on the file on the right-hand side.
Box file comments

When a file has conversations, CloudFuze creates a CSV file with the same name.
CSV file with comments 1

On clicking the CSV file, all the comments will be displayed as follows:
CSV-file-with-comments-2

Start Migration Now

CloudFuze supports more than 40 cloud Migration services including Google Drive, Dropbox, Amazon, and Box etc.