3. Sheets: Copy Sheets Into Your Spreadsheet — Copy from .csv and .xls File Types
At work, in your community, or at home, you may be given a spreadsheet of data to incorporateinto another spreadsheet. You might need to compile two different data sets. Or, you mightwant to create a spreadsheet from a different file type to make it easier to work with.
For example: your manager may send you a monthly salesreport that you need to add to the rest of the reports for the year,your classmates may send you a new stage of a project plan to incorporate into your projecttracker, or your friends may simultaneously be workingin different spreadsheets, planning specific parts of an elaborate trip.
Instead of managing several different spreadsheets in different formats, it’s convenient tohave them all in one location. In this video, you will download a spreadsheetin another file format and convert it using Google Sheets. Then, you will combine thenew sheet with your existing project. In this example, your team members collected dataon a different aspect of the fundraiser -- product costs and sales prices -- and you need tocombine their spreadsheet with your t-shirt sales spreadsheet so you can share all ofthe data. To begin, download the starter project nextto this video. Notice it’s a different file format than Google Sheets.
Then, navigate to the folder where you saved it, and open the spreadsheet.
In a new tab, open Google Drive.
Upload the spreadsheet.
Open the file, then open it with Google Sheets.
Finally, download and save it.
Nice work! The information in these sheets, such as costs and prices, isn’t found inthe sales data. There’s also not a natural place to cut and paste tables about projectcosts into an existing sheet. Plus, you already have a sheet of related data, and it’s moreconvenient to have everything in one place. So, copy the new sheets to your existing project.
Then, rename them and assign them a new color.
Or, “import” another file type, like aC-S-V, into your project.
For this lesson, you will use the Sales byTeam Member and Cost, Revenue, and Profit sheets.
Now you’ve combined two spreadsheets into one. This will make working with the datamuch more convenient. Now, it’s your turn:Download the starter project, Upload the file to Google Drive,Open and save it in Google Sheets, And copy the new sheets to your existing spreadsheet.