Hands holding smartphone displaying logo of monday work management
Image: monticellllo/Adobe Stock

Your company and your teams have decided to dive fully into the digital transformation rabbit hole and have gone full in on the monday work management project management platform. The one thing holding you back is the data in your Microsoft Excel spreadsheets. Fear not, as monday work management has an import function that makes it very easy to import that data.

SEE: Hiring kit: Project manager (TechRepublic Premium)

One thing to keep in mind before you start this task is that when faced with an Excel spreadsheet with multiple tabs, monday work management will only import that first tab. Because of this, you’ll want to split those tabs into individual spreadsheets. There’s no way around this caveat.

With that said, let’s get to the import.

What you’ll need to import Excel

The only things you’ll need to make this work are a monday work management account and an Excel spreadsheet.

How to import your Excel spreadsheet

Log in to your monday work management account and click your profile icon in the bottom left corner of the window. From the resulting popup menu (Figure A), click Import Data.

Figure A

The monday work management popup menu includes the Import Data option.
The monday work management popup menu includes the Import Data option.

In the next window (Figure B), click Excel.

Figure B

monday work management
The options for importing data into monday work management

A new popup will appear (Figure C) where you can either drag your file into the box or click Click To Browse to locate your data manually.

Figure C

Uploading your Excel spreadsheet to monday work management
Uploading your Excel spreadsheet to monday work management

Once you’ve added the file, click Let’s Customize Your New Board (Figure D).

Figure D

Ready to customize your day? Let’s do it.

Here are the board customizations you must take care of to finish up the import:

  • Select the first row of data (Figure E).
  • Select the first column of data.
  • Customize your columns and make sure to map the titles of each column for the data they contain.

Figure E

The monday work management import data customization tool.
The monday work management import data customization tool.

After completing the customization, click Create Board (Figure F), and monday work management will finish the process.

Figure F

One more click and your data will be imported into monday work management.
One more click and your data will be imported into monday work management.

And that’s all there is to importing an Excel spreadsheet into monday work management. This is a great way to finish up that digital transformation and migrate your data into a more powerful, flexible platform.

Subscribe to TechRepublic’s How To Make Tech Work on YouTube for all the latest tech advice for business pros from Jack Wallen.

Subscribe to the Developer Insider Newsletter

From the hottest programming languages to commentary on the Linux OS, get the developer and open source news and tips you need to know. Delivered Tuesdays and Thursdays

Subscribe to the Developer Insider Newsletter

From the hottest programming languages to commentary on the Linux OS, get the developer and open source news and tips you need to know. Delivered Tuesdays and Thursdays