How to import and export to Excel?

At monday.com, we offer both import and export Excel functionalities.¬†ūüéČ Keep reading to learn how it works!

Import from Excel

Import from Excel is now here! With just a simple upload you can turn your Excel spreadsheets into a beautiful board in just a few steps. 

Step 1

Click on your avatar located on the upper right corner of your screen and select "integrations".

Screen_Shot_2017-09-18_at_9.27.42.png

 

Step 2

Click "Import" under Excel

 

A pop will appear to upload your Excel sheet

Screen_Shot_2017-07-09_at_10.37.54.png

  • Either drag or browse for the Excel sheet you'd like to import
  • Select "Create Board" if the excel is created exactly as you wish the board to look or "Adjust your Excel" to manually control the board layout.

Screen_Shot_2017-07-25_at_14.34.19.png

Step 3

If you selected "Adjust your excel" follow the below:

  • Follow the steps provided, starting with choosing your Headers

Screen_Shot_2018-03-15_at_14.21.33.png

  • Select the column you'd like to be the First column

Screen_Shot_2018-03-15_at_14.22.22.png

  • Select your column types. The System will suggest column types for you, you can manually change this by clicking the drop down menu.¬†

Screen_Shot_2018-03-15_at_14.22.37.png

  • Select "Create Board" and you have your new board!¬†

Here's a video of how you can do this:

Screen_Shot_2018-08-13_at_12.28.27.png

Export from Excel

  • Export a board

Click the Hamburger Menu Icon (3 lines) on the upper right hand side of the board. Then choose Export to Excel and that's it! 

Screen_Shot_2018-08-02_at_14.40.06.png

Screen_Shot_2018-08-13_at_12.29.04.png

  • Export a pulse

Click on the pulse you'd like to export to Excel and then click the Hamburger Menu Icon (3 lines) on the upper right hand side of the pulse. Then choose Export to Excel and that's it!

  • Export multiple pulses at once!

You can export multiple pulses to Excel at once by using the batch actions:

Hover over the color line of one of the pulses you'd like to export. 

  • Use the boxes to select¬†the pulses you'd like to export.
  • As you select pulses, you will find the count of pulses with actions at the bottom of the screen.
  • Click on "Export", and you'll be able to export to Excel all the pulses selected!

1.png

To learn more about internal integrations, feel free to check out this article. 

If you have any further questions, don't hesitate to reach out to our customer success team right here. We are available 24/7!

  

 

Was this article helpful?
7 out of 11 found this helpful

Comments