1. Help Center
  2. Tips, hacks & troubleshooting

Solving common errors

1. Your file(s) exceed(s) Google Sheets limit of 5 million cells.

Google Sheets counts all cells from all tabs inside your spreadsheet, including blank cells. To check the current amount of cells used, please consult this add-on.

How to fix: Remove any blank cells, columns, rows, and sheets. Furthermore, remove any no longer needed cells. If you still exceed the limit, split the data logically among several spreadsheets, and use Sheetgo to connect your data.


2. Source files have different column headers. Read more.

Sheetgo cannot consolidate sheets that have different column headers, i.e., different columns. Every source sheet needs to follow the same column order. 

How to fix: Adjust your source sheets headers manually. The more it looks like a data table, the better your data Design is.

3. Source files are too large! Try to consolidate fewer files, or delete non-essential data (sum of the size of the file).

Your source file (Excel or CSV file) is too large to be handled. Sheetgo today can handle files up to 15MB. However, we are continually working on increasing this number.

4. You don't have access to edit the destination file. Please request edit permission from the owner of the spreadsheet.

Sheetgo requires edit permissions to the destination spreadsheet to transfer data into it. If you're receiving this error, a few things could be wrong:

  • The file owner didn't permit you to edit the file
  • Your access could be denied because someone removed your permission to view the file