How to import Excel into monday.com


Jack Wallen shows you how to import Excel data into your monday.com account to help transform your workflow.

Hands holding smartphone displaying logo of monday.com
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.com project management platform. The one thing holding you back is the data in your Microsoft Excel spreadsheets. Fear not, as monday.com 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.com 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.com account and an Excel spreadsheet.

How to import your Excel spreadsheet

Log in to your monday.com 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.com popup menu includes the Import Data option.

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

Figure B

The options for importing data into monday.com.

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.com.

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.com import data customization tool.

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

Figure F

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

And that’s all there is to importing an Excel spreadsheet into monday.com. 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.



Source link

Leave a Reply

Your email address will not be published.