How to Merge Sheets on a Google Spreadsheet
By Andrew Aarons
Google offers it all, or tries to. After asserting itself as the top search engine and offering free email, Google introduced a Web-based office suite called Google Drive. The program functions like Microsoft Office or OpenOffice, but all its files float online. The Spreadsheet program -- an Excel equivalent -- functions much like Excel but with a few quirks. Merging two spreadsheets, which uses automation in Excel, is a manual process in Drive.
Merging Existing Spreadsheets
Log in to your Google account and click "Drive" to open your list of documents. Open the spreadsheet you're working with and identify the two sheets you want to merge. Ensure that the rows and columns match in both sheets.
Click on the tab for the sheet from which you want to take the data. Highlight the range of cells to copy and press "Ctrl-C" to place the data on your computer's clipboard.
Click on the tab of the sheet to which you want to copy the data. If you want to add the data to columns beside your existing data, click on the cell to the right of your data (at the top) and press "Ctrl-V" to paste the data. For complex sheets, copy single columns or rows and insert the copied data into new columns or rows beside its corresponding data.
Merging Two Sheets Into a Single New Document
Log in to Google and open Drive, then open the first of the spreadsheets that you want to merge. On the first spreadsheet, click "File" and "Download as... Microsoft Excel." Give your file a name and choose a location to save the file, then click "Save." Close this spreadsheet in Drive.
Open the second spreadsheet. Click "File" and choose "Import." Click "Choose File" and browse to the sheet you downloaded in the previous step.
Select the appropriate import action for your sheet: "Append Rows to Current Sheet" or "Replace Data Starting at Selected Cell." Click "Import." Drive will match the cells from the first sheet to the second. To do this, your separate sheets should have the same format and cell size.
Living in Canada, Andrew Aarons has been writing professionally since 2003. He holds a Bachelor of Arts in English literature from the University of Ottawa, where he served as a writer and editor for the university newspaper. Aarons is also a certified computer-support technician.