A useful tip for importing data from a large Google Sheet

Google Drive has a limit of 10MB per file export, meaning any Google Sheets file over 10MB cannot be imported into Klipfolio. Oftentimes though, only a subset of a larger Sheets file is needed for use in Klipfolio, but there may be formulas or calculations being done in the main sheet that makes copying and pasting data into a smaller sheet infeasible.  

The steps below detail how to use the IMPORTRANGE formula in Google Sheets to import only the necessary data into Klipfolio, without breaking any existing formulas or data relationships in your main spreadsheet.

     1. Create a new Google Sheets file


  1. In a cell in the new file, insert the IMPORTRANGE formula with the following arguments:
  • First, the full URL of the Sheet you would like to pull data from 
  • Second, the cell reference to that sheet for the relevant data (ie “Sheet1!A:Z”)

This will return with an exact copy of the data in your original spreadsheet, and will automatically update as new changes are made to your original spreadsheet. This trick is a great way to reduce the size of your Google Drive data sources in Klipfolio! 


Please sign in to leave a comment.