What can we help you with?

How to Import and Export to Excel

So, your team has jumped on the bandwagon and has finally transferred its workflow to monday.com but... you still have some data and lists over in Excel. Don't worry... we won't tell anyone. 🤫 We get it and we're here to help you out! Keep reading to find out how to import the rest of your data from Excel to monday.com or to export your monday.com data to Excel if you're not ready to let go just yet. 

 

Import your data from Excel

In Just a few steps, you can transform all of the data from your Excel spreadsheet into a monday.com board! Check out this video or keep reading for a step-by-step guide:

 

  • Step 1

Click your profile picture and select 'Import Data' like this:

image_1.png

Select "Excel" as shown here:

image__1__1.png

  • Step 2

You can choose to either drag and drop your Excel file into the pop-up in the center of the screen or you can click to browse your documents and select your spreadsheet. 

image__2__1.png

Once you've selected your file, you'll receive the following message:

image__3__1.png

Click "Let's customize your new board" to make sure everything appears exactly how you want!

  • Step 3

Select the row in your spreadsheet that will become the headings for your new board's columns and then click "Next" like this:

image__4__1.png

Everything above your first row will not be imported into your board.  

 

Note: You can import a maximum of 50 columns and 8,000 rows at a time. 

 

  • Step 4

Select the column in your spreadsheet that will become the first column in your board (the names of your items) and then click "Next" like this:

image__5__1.png

  • Step 5

Our system is pretty good at guessing which column types are a good fit for your data, but you can change them manually by clicking the drop-down menu for each column. You can only import columns as a Number, Status, Email, Date, or Text column. You can, however, change the column type after import.

Note:  If your column has 9 or fewer labels, the column suggestion on your imported sheet will be "status". If your columns have more than 9 labels, the column suggestion on the import will be "text".

 

When you're done, click "Create Board". 

image__6__1.png

Note:  If your Excel spreadsheet has multiple tabs, only the first tab will import.

 

Import data into an existing board

There are a few ways to import your data from any external source, including Excel, Google Docs, Microsoft Word, and more! Keep reading to check out these time-saving tips!

 

Import from Excel or CSV

For this example, let's say that you want to import the following Excel table to your existing board:

image_230.png

To import this data directly to an existing board, go to the blue "New Item" button on the board and select "Import Items" from the dropdown menu:

Frame_203.png

On the next screen, you can either drag your Excel or CSV file into the frame or choose "click to browse" to select the document from your computer. Once you have made your selection, you will see the following window:

Frame_204.png

We want the "New Flavor Ideas" column to be the first column on the board. Choosing this column will narrow your option under the "Map the columns in your excel to the board's columns" section.

This second section is where you'll toggle on/off the columns that you want to import. We want to import the Status column, so we'll toggle it on. Then we'll select the corresponding column on the existing board. In this case, we're mapping the "Status" column on Excel to the "Status" column on the board.

Note:  The only column types supported by this import process are: Status, Number, Text, Date, Email, and Phone. You can change the column type after import.

 

Our final selections will look like this:

Frame_205.png

Click "Import" to complete the process!

 

Note: Keep in mind that if your status labels don't match the labels on your board exactly, they will import as new status labels. You can use Batch Actions to edit labels if needed.

 

Copy & Paste Heaps of Items

We've been brainstorming new ice cream flavor ideas on an Excel spreadsheet and we want to move them into our "New Flavor Ideas" group in our Ice Cream Flavors board! With just one click, we can copy and paste several items from our external source straight into our group of items! 

  • Step 1

All we have to do is highlight the items we'd like to import and use our keyboard copy shortcut or right-click to copy like this:

image_2.png

  • Step 2

Next, we'll click on '+ Add' in the group we'd like to add these items to and use our paste keyboard shortcut or right-click "Paste" like this:

image_3.png

And voila! All of our items have been added to our board! 

image_4.png We can click the 'X' in the menu below to de-select these items, or use Batch Actions to update them to suit our board!

 

Note:  At this time, this is only available for the first column on an existing board, meaning that we cannot paste a list of data into other columns. 

 

Batch Actions

If you have a list of items in another monday.com board, you can import them all into another board with just one click using Batch Actions! We have a board listing all of our ice cream toppings, and we're running low on a few of our toppings! Let's move a few of the toppings to our "Ice Cream Orders" board so that we'll remember to order them!

  • Step 1

First, we'll select all of our items and click 'Move to' in our Batch Items menu and then select "Move to board".

image_5.png

  • Step 2

We can then choose our board and which group within that board we'd like to see these items in!

image_6.png

Check out how beautifully integrated these items are in their new spots!

image_7.png

 

Export a board to Excel

We have a board containing our ice cream shop's list of ice cream flavors that we want to export to Excel. Check out how easily we can export our board to an Excel spreadsheet!

All we have to do is click the 3 dot menu at the top right corner of our board, click 'More actions' and then 'Export board to Excel'. From here, we can choose whether we want to export just the table or to include all updates and update replies. 

image_5.png

This is what our board looks like as an Excel spreadsheet:

image_6.png

If we choose to export our table with updates, we will see the table in one tab, and all of the updates and replies in a separate tab in our spreadsheet just like this:

image_7__1_.png

 

Export groups or items to Excel

We can export full groups or individual items to Excel! 

  • Export groups

To export a group to Excel, simply click the arrow to the left of your group's name, and click "export to Excel"!

image_8.png

  • Export items

To export items, select the ones you would like to export using Batch Actions. Next, click "Export" in the Batch Actions toolbar below. 

image_9.png

You will be prompted to choose whether or not to tick the boxes including or excluding updates as well as subitems in your Excel file! 

image_10.png

 

Export your account to Excel

The admin of your account can download the entire account's data as a .zip file containing all boards and files including Private and Shareable Boards. The boards will each be downloaded as Excel spreadsheets. Check out this article to see how to do it in detail, or keep reading!

Click your profile picture, and select "Admin". 

image_1.png

 

From the Admin section, under the "Account" tab of our "General" settings, you can scroll down to "Export account data" and click "Export"!

image_2.png

 

Note: For now, this action does not include Dashboards, but don't worry - their data all comes from boards that will be exported in your .zip file!

 

After a few hours, you'll receive an email with a .zip file containing all of your account's data! Make sure to download it within 24 hours of receiving the email, or you will have to repeat this process. 

 

 

If you need any further assistance, please feel free to reach out to our Customer Success Team right here. We are available 24/7 and happy to assist :)