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 files size)

Your source file (Excel or CSV file) is too large to be handled. Sheetgo today is able to handle files up to 15MB. However, we are constantly 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 in order to transfer data into it. If you're receiving this error, a few things could be wrong:

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