{"id":5244,"date":"2021-05-11T11:35:08","date_gmt":"2021-05-11T14:35:08","guid":{"rendered":"https:\/\/guillermopareja.com\/?p=5244"},"modified":"2021-05-11T11:35:10","modified_gmt":"2021-05-11T14:35:10","slug":"como-importar-datos-de-una-hoja-de-calculo-de-google-hacia-otra","status":"publish","type":"post","link":"https:\/\/guillermopareja.com\/en\/digital-marketing\/how-to-import-data-from-one-google-spreadsheet-to-another\/","title":{"rendered":"How to import data from one Google spreadsheet to another"},"content":{"rendered":"

If you are a user of Google Sheets<\/a> You probably need to link or import data from another spreadsheet to another from time to time. This is not a complicated process and there are several ways to accomplish it.<\/p>\n\n\n\n

Of course, you can copy and paste your data, which works well for a small portion of data. However, this process does not allow your information to be linked to the original source, which means that the values of the copied cells are not updated if they undergo any change.<\/p>\n\n\n\n

For this reason I present you 3 ways to import your data from one Google spreadsheet to another, whether they are within the same document or not.<\/p>\n\n\n\n

  1. Import data within the same Google spreadsheet.<\/strong><\/li><\/ol>\n\n\n\n

    If the data you want to import is in the same document and comes from a single cell, you can use this simple formula [= SheetName! CellName] in the destination cell.<\/p>\n\n\n\n

    \"\"<\/figure>\n\n\n\n

    This method works well when you want to import simple calculations. This procedure links both cells so if you make a change to the original cell, it is immediately updated in the new cell.<\/p>\n\n\n\n

    1. Import data from a spreadsheet into another document.<\/strong><\/li><\/ol>\n\n\n\n

      It is likely that for a variety of reasons you need to keep your data in separate spreadsheets and still need to combine information from them, especially if you are looking to do reports for your clients.<\/p>\n\n\n\n

      In this case, I recommend that you use the following formula: [= IMPORTRANGE] for which you must:<\/p>\n\n\n\n