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 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 from Box to SharePoint, you have come to the right post. CloudFuze helps your company transfer data from Box to SharePoint account quickly and securely.

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

2. Box to SharePoint Migration and IT Admin Challenges

As an IT admin/manager, you may already know that manual migration from Box to SharePoint is out of scope. The method doesn’t migrate sharing permissions or other Box-specific features such as Notes, Collections, and Relay.

Box features

In addition to that, the following are some of the major challenges IT teams face while migrating from Box to SharePoint.

  • Transferring large data (often in TBs) via the company’s infrastructure
  • Migrating file and folder sharing permissions of users across the organization
  • Conversion of Box features such as 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’ve helped medium and large-sized businesses 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 migration needs.

4. Box to SharePoint Migration Guide and Demo

This article deeply discusses Box to SharePoint Online migration steps. 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’s 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 get started with Box to SharePoint migration 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. In order 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 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

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

You must click on the Box Business 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 Business 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 didn’t find Box, then it isn’t 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’s important to add a SharePoint Online admin account and not a personal account.

How to Find SharePoint Online Admin Account

Step 1: Sign in to your SharePoint 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, Office 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

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 Tab from the left-hand pane.

Select Box as source and SharePoint as your 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, 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.

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, migrating Box files to SharePoint Online can be quite different if you’ve created different types of 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 steps for migration to different types of SharePoint sites, like 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. FAQs

Technical hurdles are challenges most businesses face during Box to SharePoint 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 the Office 365 account.

Step 2: SharePoint Online Admin page is opened.

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 an 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 5: Click on “Remove from group,” 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?

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.

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 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 CloudFuze handles the long path

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

When CloudFuze come 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 Office 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?

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.