When importing data from a spreadsheet into monday, there are limits to how many items and columns you can import per board:
Enterprise Plans
- 100,000 items
- 300 columns
Non-Enterprise Plans
- 10,000 items
- 200 columns
Using monday's native spreadsheet importer, you can import up to 8000 items and 20 columns at a time.
In this tutorial, we'll show how you can use Data Importer to import the full 10,000 (100,000) and 200 (300) columns if you're using the non-enterprise (enterprise) plan.
If your Google Sheet exceeds the board limit Data Importer will automatically handle the overflow and create a new board so that all your items are loaded into monday.
Install the Data Importer app for monday.com
-
You can install the Data Importer app from the monday.com app marketplace.
-
Once you’ve installed the app, you can return back to your board, then press then press the add view button.
-
Select the ‘Board views’ dropdown, press ‘Apps’ then select the ‘Data Importer’ app. This will load a new board view with the Data Importer app.
Connect to your Google Account
1. Select the Google Sheets application from the dropdown list, then press the blue Connect button.
2. A new tab will open up that will allow you to connect your account with Google. Choose the Google account that you want to authenticate for. You can always connect to a different account later if you need to.
Set-up your Google Sheets Integration
1. Navigate to your large Google Sheet. Ensure that the header names are in the first row.
2. Copy the url from the browser search bar.
3. Paste the url into the 'Google Sheets Url' field.
4. Select the sheet name that you want to import data from. In this case it is just Sheet1.
5. Select the fieds that you want to import from your sheet.
Optional: Map Columns to your Monday Board
If you want to import your items into an existing board and group, follow the below steps:
1. Select your existing monday board and the group you want to import your sheet in to.
2. Click on the column settings button to open the modal.
3. In the 'Column Mapping' section, you can select the columns from your existing monday board that you want to map your Google Sheets columns to. Data Importer will automatically set the column type to the type of the existing column.
4. If you don't map to an existing column, a new column will be created. You can set the type of this column in the 'Column Type' section.
Press Run and wait for Data to load
1. Once you’ve filled out all the required fields, press the blue Run button.
2. For large imports, Data Importer will run these in the background so that you can close the view and continue with your other tasks.
3. Once the import is complete, you will receive an email to navigate to your imported data.
View Your Data
1. Once you've opened your import, you'll be able to see your new board that contains all your imported items and columns.
2. If your import exceeds the item limit, Data Importer will automatically create a new board for you and continue your import into this board.
Automatically sync your Google Sheet with your monday.com board
Now that you know how to import a large Google Sheet into a monday board, you can automate your imports by using Data Importer's scheduler. This means your boards will automatically refresh with the latest data, even when you're offline or not signed into monday.com
You can customise the schedule by frequency, days of import, time and timezone.
You can view all your scheduled imports in one table from all of your applications.
