When you come close to the cell limit, you often experience errors, which can end up affecting the productivity and efficiency of your work. Luckily, there are a few solutions to avoid reaching the cell limit and encountering these difficulties. Let\u2019s explore precisely how reaching the Google Sheets cell limit can affect you and how to solve this issue.<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
What are the limitations of Google Sheets?<\/h2>\n
Before going into more detail on cell limitations, this is a list of 8 key Google Sheets limitations:<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
- \n
- Cell limit:<\/b> 10 million cells or 18,278 columns (column ZZZ) for spreadsheets that are created in or converted to Google Sheets. This same limit applies for spreadsheets imported from Excel and CSV.<\/li>\n
- Row limit:<\/b> 40,000 new rows at a time.<\/li>\n
- Tab limit:<\/b> 200 sheets per workbook.<\/li>\n
- Finance formulas:<\/b> 1,000 GoogleFinance formulas.<\/li>\n
- ImportRange formulas:<\/b> 50 cross-workbook reference formulas.<\/li>\n
- ImportData, ImportHtml, ImportFeed, or ImportXml formulas:<\/b> 50 functions for external data.<\/li>\n
- String limit:<\/b> 50,000 characters. When you convert a document from Excel to Google Sheets, any cell with more than 50,000 characters will be removed.<\/li>\n<\/ul>\n
[\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
What happens when you are close to the Google Sheets cell limit?<\/h3>\n
Usually, when you are near the 10million cell limit in Google Sheets, you will receive an error message like this:[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/cell-limit-\u2013-1.png” alt=”Google Sheets cell limit 0″ title_text=”cell limit \u2013 1″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]However, there are other consequences of getting close to the cell limit, which can end up affecting the way you work.<\/p>\n
Here are just a few of the things you may encounter:[\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
- \n
- Long load time:<\/b> With so much data, your Google Sheet files can become quite heavy. This means that your computer needs to work harder in order to open everything, leading to a longer load time.<\/li>\n
- Failing add-ons:<\/b> Some add-ons may not be able to open as your computer will be prioritizing opening and updating your actual datasets.<\/li>\n
- Crashing:<\/b> In some cases, the processing power required to keep your files open and running can be too much. As a result, Google Sheets may get too overwhelmed and crash unexpectedly.<\/li>\n<\/ul>\n
[\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]Rather than letting ourselves get to this stage, there are a few ways that you can effectively count the number of cells in your spreadsheet so you know well in advance when you will reach the cell limit.[\/et_pb_text][et_pb_text _builder_version=”4.27.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
How do I count the number of cells?<\/h3>\n
The cell limit in Google Sheets includes both blank cells and cells including data. Unfortunately, there is currently no app or add-on available that can automatically count the number of cells in your Google Sheets. There is a function you can use to get the total number of cells containing data in your spreadsheet file.<\/p>\n
The COUNTA<\/a> function allows you to count the number of cells in your file that contain data. By applying this formula to your spreadsheet, you can keep track of how many cells you\u2019re using in your file.<\/p>\n
Let\u2019s take a look at how to use the COUNTA formula in your own Google Sheets file.<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.27.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Step 1: Open your Google Sheets file<\/h4>\n
Open your Google Sheets file.<\/p>\n
Below is an extensive database of all the employees in my company.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/cell-limit-\u2013-2.png” alt=”Google Sheets cell limit 1″ title_text=”cell limit \u2013 2″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Step 2: Insert the COUNTA formula<\/h4>\n
In your spreadsheet, click on a blank cell and add the COUNTA formula using the following format:[\/et_pb_text][et_pb_text module_class=”spreadsheet-function” _builder_version=”4.16″ border_width_left=”4px” global_colors_info=”{}” theme_builder_area=”post_content”]=COUNTA(first_cell:last_cell)[\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]In this example, I will be selecting a range from A1 to G637. So my formula will look like this:[\/et_pb_text][et_pb_text module_class=”spreadsheet-function” _builder_version=”4.16″ border_width_left=”4px” global_colors_info=”{}” theme_builder_area=”post_content”]=COUNTA(A1:G637)[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/cell-limit-\u2013-3.png” alt=”Google Sheets cell limit 2″ title_text=”cell limit \u2013 3″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Step 3: Get your blank cell count<\/h4>\n
Once your formula is ready, click enter.<\/p>\n
The number returned is the number of non-blank cells.[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/cell-limit-\u2013-4.png” alt=”Google Sheets cell limit 3″ title_text=”cell limit \u2013 4″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.27.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Limitations of the COUNTA function<\/h5>\n
Although the COUNTA formula is easy to use and quick to apply, it does have some limitations:<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
- \n
- Doesn\u2019t include blank cells:<\/b> The COUNTA will only count the cells that contain data within them. As mentioned before, the cell limit in Google Sheets also includes blank cells, so the formula isn\u2019t as effective as we need it to be.<\/li>\n
- Manual range input:<\/b> The COUNTA formula cannot automatically be applied to your entire spreadsheet. Instead, you have to manually input the cell range, which may become tedious and complex if you\u2019re dealing with thousands of rows or columns of data.<\/li>\n
- Tab limit:<\/b> The COUNTA formula can only be applied to cells within the tab you\u2019re in. You cannot determine the number of cells in your entire spreadsheet with one formula. You must apply the formula to each separate tab within your Google Sheet.<\/li>\n<\/ul>\n
[\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]Although there are some limitations with the COUNTA formula, it does give you a good idea of whether you may be close to the cell limit.<\/p>\n
With this accurate insight, you can then carry out various solutions to reduce your heavy spreadsheet and avoid crashes, data loss, and other errors.[\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
How do I reduce the number of cells inside a Google Sheet?<\/h3>\n
As Google Sheets does count blank cells as part of the cell limit, the most simple way to avoid the limit is to delete these empty cells. You can do this by using the Filter feature in Google Sheets.<\/p>\n
Highlight the entire dataset in your spreadsheet and head to Data > Create a filter<\/b>.[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/cell-limit-\u2013-5.png” alt=”google sheets cell limit 5″ title_text=”cell limit \u2013 5″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]In a column, click on the filter icon. Under Filter by values<\/b>, click Clear<\/b>, then select (Blanks)<\/b>. Press OK<\/b>.[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/cell-limit-\u2013-6.png” alt=”google sheets cell limit 6″ title_text=”cell limit \u2013 6″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]Google Sheets should now only show your empty cells. Highlight the empty cells all at once by holding down the shift key and clicking on the last row in your spreadsheet.<\/p>\n
Right-click and select Delete selected rows<\/b>.[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/cell-limit-\u2013-7.png” alt=”google sheets cell limit 7″ title_text=”cell limit \u2013 7″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]Click on the filter icon again. Click Select all<\/b> to bring back the cells with your data.<\/p>\n
Once finished, click OK<\/b>.[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/cell-limit-\u2013-8.png” alt=”google sheets cell limit 8″ title_text=”cell limit \u2013 8″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.27.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Although this method is effective to remove empty cells, it can be pretty time-consuming. What\u2019s more, it only works when you have entire empty rows. If you use it on empty cells in the same rows as your used cells, the entire structure and formatting of your data will be affected. As a result, you can mix up your original data.<\/p>\n
There is a much easier way to avoid the cell limit altogether without risking the loss or unwanted change of data. Let\u2019s see how you can use Sheetgo to avoid the 10 million cell limit<\/strong>.<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.27.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Avoid the Google Sheets’ 10 million cell limit with Sheetgo<\/h3>\n
With Sheetgo<\/a>, you can reduce how heavy your spreadsheets are without sacrificing any of your data.<\/p>\n
Here are three ways to use the Sheetgo add-on to reduce the number of cells in your files.<\/p>\n
Click the button below to install the Sheetgo add-on in your Google Sheets.<\/p>\n
[\/et_pb_text][et_pb_text admin_label=”Connections B – Merge, split, filter – Vertical” module_class=”sheetgo-post-no-shadow-img md2-contained-button vertical-banner-container” _builder_version=”4.27.2″ _module_preset=”default” text_font=”||||||||” background_color=”#f2f7ff” max_width=”700px” module_alignment=”center” max_height=”300px” custom_margin=”20px|0px|20px|0px|true|true” custom_padding=”25px|25px|25px|25px|true|true” sticky_limit_bottom=”section” border_radii=”on|20px|20px|20px|20px” border_width_all=”1px” border_color_all=”#d9e7ff” saved_tabs=”all” global_colors_info=”{}” global_module=”50477″ theme_builder_area=”post_content”]<\/p>\n
![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/connections-top-processors-main.webp\")
<\/p>\n![\"39\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/Recommended-for-Google-Workspace-badge.webp\")
<\/p>\nMerge, split, and filter spreadsheets<\/span>
Regardless of the file format, Sheetgo can handle it.<\/span><\/p>\n![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/available-on-google-workspace-button-text.webp\")
<\/a><\/p>\n[\/et_pb_text][et_pb_text _builder_version=”4.27.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
1. Split your data<\/h4>\n
Sheetgo\u2019s Split feature allows you to dramatically reduce the weight of your spreadsheet by dividing it into multiple smaller spreadsheets.<\/p>\n
You save lots of time and effort with Sheetgo\u2019s automated transfer and have complete control of which data is transferred to a separate spreadsheet.<\/p>\n
These spreadsheets will constantly be updated with the latest data, so if you edit or add to the original file, the change will automatically be applied to the new spreadsheet.<\/p>\n
To find in-depth instructions on how to use the Split feature in the Sheetgo add-on, take a look at our post on How to split Google Sheet into multiple sheets<\/a>.[\/et_pb_text][et_pb_text _builder_version=”4.27.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/04\/split.png” alt=”Split feature Sheetgo” title_text=”split” module_class=”sheetgo-post-no-shadow-img” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.27.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
2. Merge your data<\/h4>\n
If you have successfully split your large sheet into multiple sheets but want to reduce your cells further, merging your data might be the perfect solution.<\/p>\n
Let\u2019s say you have multiple files containing separate datasets. You can create a \u201csummary sheet\u201d in each spreadsheet that analyses all the data.<\/p>\n
You can then use the merge feature in the Sheetgo add-on to connect all of these summary sheets back into one central file.<\/p>\n
This allows you to receive all insights from your files in one place without dealing with a lot of data.<\/p>\n
To discover how to merge specific tabs within multiple sheets into one main spreadsheet, look at this post on How to merge multiple files into one<\/a>.[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/04\/merge.png” alt=”Merge feature Sheetgo” title_text=”merge” module_class=”sheetgo-post-no-shadow-img” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.27.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
3. Filter your data<\/h4>\n
You may know the data you need to transfer within your large file. You can use the Sheetgo filters to extract the same cells you need. Sheetgo offers three filters; Filter by condition, Filter by query, and Filter by cell color. These cover how you can select and transfer specific data within your spreadsheet.<\/p>\n
Once the data has been successfully filtered to the required cells, you can automatically transfer them to a new spreadsheet file using Sheetgo. To learn more on how to use the Sheetgo filters, check out this post on how to
Filter Google Sheets from one sheet to the other<\/a>.<\/p>\n[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/04\/filter.png” alt=”Filter feature Sheetgo” title_text=”filter” module_class=”sheetgo-post-no-shadow-img” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.27.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
4. Build a BigQuery database<\/h4>\n
BigQuery can hold much more information than Google Sheets. If you reach the cell limit, perhaps you should consider using a database.<\/p>\n
After you set up this database, you can use Sheetgo to fetch information, filter it, and send it to a spreadsheet, effectively keeping your information close at hand.<\/p>\n
This system should perform better processing as properly built databases have more efficient structures. It should also make your data more reliable, as BigQuery lets you assign more granular permissions.<\/p>\n
How to get data from BigQuery to Google Sheets automatically<\/a><\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.27.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
How to increase the cell limit in Google Sheets<\/h3>\n
There you have it! Even though Google Sheets has a 10 million cell limit, you may reach it in some circumstances. Sheetgo<\/a> offers multiple solutions to combat this dilemma so that you can avoid the risk of errors or computer crashes altogether.<\/p>\n
With Sheetgo, you can split, merge, or filter your data to increase the number of available cells in your Google Sheets\u2014all without sacrificing any of your data.[\/et_pb_text][et_pb_text _builder_version=”4.22.2″ background_color=”#f9f9ff” custom_margin=”40px||40px||false|false” custom_padding=”15px|25px|15px|25px|true|true” border_width_left=”3px” border_color_left=”#808e95″ global_module=”26540″ saved_tabs=”all” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Editor\u2019s note<\/strong>: This is a revised version of a previous post that has been updated for accuracy and comprehensiveness.<\/em><\/p>\n
[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"
Did you know that Google Sheets has now increased its 5 million cell limit to 10 million cells? Google Sheets is one of the most popular spreadsheet tools. It also provides almost five times the number of cells in a single spreadsheet than Excel. Google Sheets gives users a 10 million cell limit, this is […]<\/p>\n","protected":false},"author":2,"featured_media":38558,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"At Sheetgo we work with many clients who ultimately get back to us with errors they are experiencing with their Google Sheets. After analysing<\/span>\u00a0all the errors, one of the most frequently reported refers to Google Sheets' 2 million cells limit to be used inside a single Google Sheet.<\/span>\n
What happens if you are close to Google Sheets' 2 million cells limit?<\/h2>\nIf your total number of cells used inside a single spreadsheet is close to 2 million cells, common problems you might experience can be of the following nature:\n
- \n \t
- The spreadsheet takes a long time to load<\/li>\n \t
- Add-ons like Sheetgo fail to work properly<\/li>\n \t
- The spreadsheet randomly crashes inside the active web browser tab<\/li>\n<\/ul>\n
![\"A](\"https:\/\/sheetgo.com\/wp-content\/uploads\/2017\/01\/snap-chrome.jpg\")
\nFigure 1<\/strong>: A heavy Google Sheets caused Chrome to crash<\/p>\nPrior to resolving any of these problems, you need to count the number cells used inside your spreadsheet. At Sheetgo<\/span> we use the following Google Apps Script<\/a> to count the number of cells used inside a spreadsheet:<\/span>\n
function number_of_cells(){<\/span>\n \u00a0\u00a0var formatThousandsNoRounding = function(n, dp){<\/span>\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0var e = '', s = e+n, l = s.length, b = n < 0 ? 1 : 0,<\/span>\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0i = s.lastIndexOf('.'), j = i == -1 ? l : i,<\/span>\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0r = e, d = s.substr(j+1, dp);<\/span>\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0while ( (j-=3) > b ) { r = ',' + s.substr(j, 3) + r; }<\/span>\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0return s.substr(0, j + 3) + r +<\/span>\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0(dp ? '.' + d + ( d.length < dp ?<\/span>\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0('00000').substr(0, dp - d.length):e):e);<\/span>\n \u00a0\u00a0};<\/span>\n \u00a0\u00a0var sheets = SpreadsheetApp.getActiveSpreadsheet().getSheets()<\/span>\n \u00a0\u00a0var cells_count = 0;<\/span>\n \u00a0\u00a0for (var i in sheets){<\/span>\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0cells_count += (sheets[i].getMaxColumns() * sheets[i].getMaxRows());<\/span>\n \u00a0\u00a0}<\/span>\n \u00a0\u00a0Logger.log(formatThousandsNoRounding(cells_count))<\/span>\n}<\/span><\/pre>\nTo run this script, inside your active spreadsheet, go to <\/span>Tools > Script Editor<\/span><\/i> and replace the entire code you see with the above one. Then, press <\/span>Ctrl + S\u00a0<\/span><\/i>to save the project. Next, click on the run button (the triangular playback icon next to the bug icon) and confirm the permissions. Once done, press <\/span>Ctrl + Return <\/span><\/i>to display the log window which will show you the number of cells used inside the spreadsheet from within which you ran this script.<\/span>\nHow to reduce the number of cells inside a Google Sheet?<\/h2>\nThe first step in reducing the number of cells is to eliminate any blank and unused cells as Google counts these as well. If this is not enough, the preferred method of solving any of the aforementioned problems in relation to Google Sheets' 2 million cells limit is to split the affected spreadsheet into multiple smaller sheets. Let us say work for a department that has\u00a0a 1.5 million cells Google Sheet to hold all the data of 5 sub-departments. In this case, divide your data logically into 5 spreadsheets, each holding 300,000 cells.\n\n[caption id=\"attachment_2258\" align=\"aligncenter\" width=\"683\"]
![\"Demonstrating](\"https:\/\/sheetgo.com\/wp-content\/uploads\/2017\/01\/2-million-cells-sheets-diagram.png\")
Figure 2<\/strong>: Demonstrating a workflow to split and consolidate a single large Sheet into many smaller ones[\/caption]\n\n\u00a0\n\nWithin these Sheets, create summary sheet tabs that hold the analysis of each subset of your data. Next, inside a blank new Google Sheets, you can use the Consolidate<\/a>\u00a0function of our Sheetgo add-on to selectively import and merge only the data held inside the summary sheet tabs.\n\nThis will significantly reduce the number of cells used inside your spreadsheet and hopefully prevent errors like the ones mentioned above.\nAlternative: using a filter<\/h2>\nIn addition to using consolidate, you can filter only for the data you require. This makes the transferred sheets significantly lighter. Read more about filter in our\u00a0article \u201cImport filtered data from Excel to Google Sheets<\/a>\u201d.\n
Any questions?<\/h2>\nI would be very glad to help you with any questions or problems regarding this article. Please ask them on our Google+ community<\/a>.\n\n\u00a0","_et_gb_content_width":"","footnotes":""},"categories":[29],"tags":[56,28],"class_list":["post-2246","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-spreadsheets-tips","tag-connections-b","tag-spreadsheets"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/2246","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/comments?post=2246"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/2246\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media\/38558"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media?parent=2246"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/categories?post=2246"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/tags?post=2246"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
- Manual range input:<\/b> The COUNTA formula cannot automatically be applied to your entire spreadsheet. Instead, you have to manually input the cell range, which may become tedious and complex if you\u2019re dealing with thousands of rows or columns of data.<\/li>\n
- Failing add-ons:<\/b> Some add-ons may not be able to open as your computer will be prioritizing opening and updating your actual datasets.<\/li>\n
- Row limit:<\/b> 40,000 new rows at a time.<\/li>\n