Main menu

Pages

This is how you can copy and paste from Google Sheets to Excel

This is how you can copy and paste from Google Sheets to Excel

This is how you can copy and paste from Google Sheets to Excel


  If you typically use spreadsheets, it's very likely that you have documents open more than once in both Google Sheets and Excel.  After all, these are the two main programs for performing these tasks.  In these cases, you can copy and paste from Google Sheets to Excel while maintaining the simple original formatting to save time and move your content from one program to another.

 How to move cells from workspace to Office?


  Copying from Google Sheets to Excel while keeping the simple formatting intact will prevent typical Excel formulas and functions from being activated that may affect the way the contents are displayed.  Learn how to do it below.


  How to copy from spreadsheets to Excel, while keeping formatting simple


  The fact is that when copying from spreadsheets to Excel, many users are concerned about losing the appearance of their contents.  Before performing this procedure, you should make sure that the color and font of the text are consistent and repeated throughout the document.  Otherwise, those colors and lines may be lost.


  Regarding formulas, there are some spreadsheet formulas that don't work in Excel.  These can also be lost.  In addition, if there are references to external data, you should check that they have not been corrupted or damaged by copying and pasting.



  From Google Sheets to Excel, step by step


 Open a Google Sheets document whose contents you will copy and then paste into Excel

 Scroll down to Download, and then click Microsoft Excel (.xlsx)


  Copy Google Sheets to Excel 2

This is how you can copy and paste from Google Sheets to Excel


 Select the location where you intend to save the document in .xlsx format

 Next, go to the site and double-click the document to open it in Excel


  If you're concerned that formula might be lost during the copying process, before copying go to View, View, and Formulas in Spreadsheets.  At this point, copy and paste into Excel, which will retain the text, numbers, and formulas in the spreadsheets.


  Other recommendations for beginners in Excel


  In addition to the above tips, there are also other suggestions that you should consider as an Excel beginner.  If you intend to copy several sheets from one file to another, all you have to do is repeat this simple trick.


  How to copy content from one Excel document to another?


  In those cases, it's easier, because the compatibility between these two Excel documents is absolute.


 Open the Excel document whose contents you want to copy and paste into another document

 Right-click on the sheet you want to copy, and when the menu appears, click Move or Copy

 Click "Book" and "Continue" and select the Excel document into which you will paste the content

 Select the location to place the copy sheet in the new file in Before Sheet, Continue

 Click Make a copy and accept.  Close this Excel document and open the second document

 In the sheet where you are going to paste the content, right-click and select Move or Copy

 Click Before Sheet, and select the location where you will place it

 Check the Make a copy box, and then click OK


  That's it.  This is how quickly you can copy content from one Excel document and paste it into another Excel document.


  Interested in learning more?  We have a beginner's guide to using spreadsheets and a complete free online course in Excel.

Comments