Collecting Data

The first step in surviving the datapocalypse is to collect your data. On this page you will learn how to copy sheets between Google Sheets files, how to import spreadsheets into Google Sheets, and the ultimate tool for surviving the datapocalypse....VlookUp.

Copy To

The Copy To function copies a sheet from one Google Sheets file to another. This is a great option for quickly transferring data from one Google Sheet to another.

Steps:

On the sheet name click on the upside down triangle.
Choose Copy To.
Navigate your Drive to find the spreadsheet you want to copy the data to.

Import

This feature allows you to import other Google Sheets files or upload Excel and csv files into your Google Sheet. This is a great tool for migrating form Excel to Sheets!

Steps:

Click on file in the menu.
Click on import.
Navigate your Google Drive or upload your Excel or csv file.
After finding your file press select.
Choose your import location. To import a file into a current Sheet file choose Insert new sheets(s)

VlookUp

VLookUp is a formula that allows you to look up data in a range based on a specific lookup value. This is your secret weapon for surviving the Datapocalypse because it saves you time! If you have a file that has first name, last name, and student id and another file that only has student id you can use Vlookup to quickly add the first and last names to the file. This formula takes a little bit of time to figure out but once you do it unlocks a ton of options and can solve the issue with multiple spreadsheets with different information.

Google Sites

Report abuse