This page will provide a guide for MAG employees to incorporate data from sheets into Monday.com
All Staff + James
Day-to-day operations
Monday.com
Importing your sheets into Monday.com can help you manage your data more effectively, collaborate more powerfully with your team, and streamline your workflows.
Map the row that you'd like to be the first row of the new board. If it is not the row that is highlighted by default, you can select another row by clicking on this row. Once selected, press Next.
Which column should be the first column on the board? Select the desired column and press next.
Note: When selecting the Header and First column, everything to the left and above the selections will not be included in your board.
Determine the column type of each column that you are importing.
Note: There are a limited number of column types that our import supports. To see your options for each column and to switch the column type, select the down arrow from the column header.
The import limitation is 3,000 rows and 20 columns. If your file is larger than this, the import will cut off at this limitation.
Once on monday.com, you can change the column types of your imported board. To do this, go to the column header > select the down carrot to launch the column menu > select 'Change Column Type' > and select the available columns to change.
Imports create a new board in your account. If you'd like to import to an existing board, you can do so by importing from the board directly. This import supports adding new items to the board but is not a full mapping of columns. Go to the 'New Item' button > down carrot > import items > copy and paste a list of items to import from your Google sheet.
Note: There is currently no way to import several tabs at once. If your Google Sheet has multiple sheets/ tabs, it is recommended to import each tab individually.
Last Update Date: 15/06/23
Updated By: Lesley