Smartsheet Import: How to Make It Automatedly

If you’re feeling intimidated by changing your project management system, don’t be. Smartsheet import in an automated way isn’t just an idea anymore. Sounds interesting? Keep on reading to figure out more.

Smartsheet Import: Excel and Other Options 

The key to success is a choice. So if you consider about importing your data to Smartsheet, you got at least three options to choose from:

  • Built-in import option: Smartsheet enables you to import the existing Excel files, Google Spreadsheet, and Trello boards. When you move these types of files, you create a new sheet automatically. Make sure your files don’t exceed 50 MB or 20 000 rows. Note that you can’t import images from external files, formulas, and archived Trello cards;
  • Import from Microsoft Project: you can import projects from Microsoft Project. Smartsheet doesn’t support constraints that’s why some rows can be out of order after the data import. You can import sheets from a Microsoft Excel Workbook as well;
  • Automated migration service: Migration Wizard allows you to import all your core data. The tool preserves all connections between records so that you can find them easily after Smartsheet import. The process is automated so you don’t need to move any of your data manually.

How to Run Automated Smartsheet Migration?

You’ve decided to use the automated migration service to get your data to Smartsheet. Great choice. Here’s a quick guide on how to succeed with this task.

1. Sign up or log in to your account.

2. Connect your source platform to the Migration Wizard tool by filling in the needed credentials.

Trello Source Platform

3. Configure the connection between our tool and your source system.

Trello Configure Connection

4. Choose Smartsheet as your target platform and provide the necessary credentials.

Import Smartsheet

5. Configure your connection: choose the Sheet you want to migrate.

Import Smartsheet

6. Select objects you’d like to migrate from your source platform to Smartsheet.

Import Smartsheet Objects

7. Map your records to ensure that they migrate to the right places.

Smartsheet Mapping

8. Start a free demo migration and wait till your migration preview is ready.

Smartsheet Demo Import

9. Once your Smartsheet import demo is complete, check a downloadable report. To make sure that your data migrated the way you wanted.

Smartsheet Import

Note: Go on with the next step only if you are satisfied with the result of your demo migration. In case there is anything you would like to change, drop us a line.

10. Setup your full data migration and finish your Smartsheet import.

What Data Can You Import to Smartsheet?

Smartsheet import via automated service helps you migrate the following data:

  • Groups for tasks
  • Tasks together with Comments, Attachments and Custom fields
  • “Started at” and “Completed at” dates of tasks
  • Users

Note: “Created at” dates of comments and comment authors migrate in the description of task comments. In addition, task formatting doesn’t migrate.

Make sure that such fields as Title, Status, Assigned to, and Description should be present in the Project lists.

You can also customize your Smartsheet import to specific business needs. Contact our representative to figure out more details.

How to Prepare for Smartsheet Data Import?

Before running your data migration, it is important to prepare for it. So, check the following steps before proceeding with the data import process:

  1. If you have access credentials for both source and target platforms. Without it, our Wizard Migration tool won’t be able to create a connection with the project management software.
  2. If you acquire admin rights on both platforms to perform the migration. 

Note: To make the migration process faster, check your entities before transferring and delete duplicates.

A Bottom Line

Automated Smartsheet import isn’t rocket science. If you’re planning Smartheet import soon, make sure you test-drive Project Management Migration Service.

Ready to migrate your data to Smartsheet?

Run a Free Demo
Book a Call
— %s