Switching to Sheets from Microsoft Excel

2. Sheets and Excel best practices

Side by side: 3. Manage data in Sheets

2.i Piece of work with Excel files in Drive

" "

There are unlike ways to work with Microsoft Excel files. Y'all can:

  • Import Excel data into Sheets. Learn more than
  • Convert Excel files to Sheets. Learn more than
  • Edit Excel files in Bulldoze without converting them. Learn more than
  • Convert Sheets files to Excel or other formats. Larn more than

Use Google Sheets to open Excel spreadsheets

2.2 Use Excel and Sheets together" "

If your team uses Microsoft Excel and Sheets, here are some best practices for when to utilize each product.

Catechumen existing Excel spreadsheets to Sheets if:

  • Yous need to collaborate or simultaneously edit with your squad.
  • Your dataset is 5 one thousand thousand cells or fewer.

Continue working in your existing Excel spreadsheets if:

  • Your dataset is greater than 5 million cells.
  • You're using the Hyperion add-on with Excel.
  • If you use rare chart types, such as 3D pyramid charts or pie-of-pie charts.

Collaborate using Google Sheets

ii.three Edit Excel files in Sheets" "

Open up an Excel file from Drive and edit it in Sheets. Whatsoever changes you make are saved in the original Excel format.

Chrome Browser only

  1. Make certain the Office Editing for Docs, Sheets, & Slides extension is not installed:
    1. Open Chrome Browser and in the acme-correct corner, click More"" and then More Tools and then Extensions.
    2. If yous encounter the Part Editing for Docs, Sheets, & Slides extension, click Remove.
  2. In Bulldoze, double-click an Excel file.

    A preview of your file opens.

  3. At the top, click Open up with Google Sheets.

You tin can now edit, share, view version history, collaborate in real-time with others, and more. All changes you make are saved to the original Microsoft Office file.

two.iv Import Excel data into Sheets

" "

You can import data from an Excel file to a new (or existing) Sheets file. Your Excel file won't be inverse, even as yous change the Sheets file.

  1. In Sheets, create a new or open an existing spreadsheet.
  2. Click File and then Import.
  3. Choose the Excel file and click Select.
  4. Choose an import option:
    • Create new spreadsheet
    • Insert new canvas(s)
    • Supplant spreadsheet
  5. Click Import data.
  6. If prompted, click Open at present.

In Sheets, the Import option appears under File in the menu

2.5 Convert Excel files to Sheets

" "

Instead of importing data, you tin catechumen an Excel file to Sheets and proceed working on it in Sheets. Your Excel file won't be inverse.

  1. Open Driveand double-click an Excel file.

    A preview of your file opens.

  2. At the pinnacle, click Open with Google Sheets.
  3. Click Fileand then Salve as Google Sheets.

To automatically catechumen all future uploads of Office files to Google Sheets:

  1. In Bulldoze, at the top, click Settings "" and then Settings.
  2. Next to Convert uploads, turn on Catechumen uploaded files to Google Docs editor format.

    Annotation: Previously uploaded files will not be converted.

In Drive, you'll see the Excel file and the new Sheets file. You can keep the Excel file or delete it. If you proceed the Excel file, to avoid confusion, y'all can rename information technology to something like [Archived] My doc.xls.

Tip: Use these icons to quickly differentiate Sheets and Excel files in Drive:

SheetsSheets ExcelExcel

Upload files to Drive

2.6 Share a copy of a Sheets file in Excel format

" "

Yous can work on a spreadsheet in Sheets and and so transport a copy by email every bit an Excel file (or a PDF).

  1. In Sheets, open the file.
  2. Click File and then Electronic mail as attachment.

  3. Under Attach as, choose Microsoft Excel.

  4. Enter the email accost, subject, and message.
  5. (Optional) Check the Send a copy to myself box.
  6. Click Send.

You tin also download a copy of the Sheets file in Excel, PDF, CSV, ODS, or other formats.

  1. In Sheets, click File and then Download as.
  2. Select the file format you want to download.

Download a spreadsheet and open with another program


Google, Google Workspace, and related marks and logos are trademarks of Google LLC. All other company and product names are trademarks of the companies with which they are associated.

Was this helpful?

How tin can we improve information technology?