When Uploading an Excel File

Switching to Sheets from Microsoft Excel

2. Sheets and Excel best practices

Next: iii. Manage data in Sheets

2.i Piece of work with Excel files in Drive

There are dissimilar means to work with Microsoft Excel files. You tin can:

• Import Excel information into Sheets. Learn more
• Catechumen Excel files to Sheets. Learn more
• Edit Excel files in Drive without converting them. Learn more
• Convert Sheets files to Excel or other formats. Learn more than

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.

Convert existing Excel spreadsheets to Sheets if:

• You need to collaborate or simultaneously edit with your team.
• Your dataset is 5 million cells or fewer.

Continue working in your existing Excel spreadsheets if:

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

2.three Edit Excel files in Sheets

Open an Excel file from Bulldoze and edit it in Sheets. Whatsoever changes you brand are saved in the original Excel format.

Chrome Browser just

1. Make certain the Office Editing for Docs, Sheets, & Slides extension is not installed:

   1. Open Chrome Browser and in the top-right corner, click More More Tools Extensions.
   2. If you see the Role Editing for Docs, Sheets, & Slides extension, click Remove.

2. In Drive, double-click an Excel file.

   A preview of your file opens.

3. At the tiptop, click Open with Google Sheets.

You 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.

2.four Import Excel data into Sheets

Y'all can import information from an Excel file to a new (or existing) Sheets file. Your Excel file won't be changed, even as y'all change the Sheets file.

1. In Sheets, create a new or open up an existing spreadsheet.
2. Click File Import.
3. Choose the Excel file and click Select.
4. Choose an import option:

   • Create new spreadsheet
   • Insert new canvass(southward)
   • Replace spreadsheet

5. Click Import information.
6. If prompted, click Open now.

2.5 Convert Excel files to Sheets

Instead of importing data, you can catechumen an Excel file to Sheets and keep working on it in Sheets. Your Excel file won't be changed.

1. Open up Driveand double-click an Excel file.

   A preview of your file opens.

2. At the height, click Open up with Google Sheets.
3. Click File Salvage as Google Sheets.

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

1. In Bulldoze, at the top, click Settings Settings.
2. Adjacent to Catechumen uploads, plough on Convert uploaded files to Google Docs editor format.

   Note: Previously uploaded files volition non exist converted.

In Bulldoze, you'll run across the Excel file and the new Sheets file. Y'all can continue the Excel file or delete it. If you keep the Excel file, to avoid defoliation, you can rename it to something like [Archived] My doc.xls.

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

Sheets Excel

2.6 Share a copy of a Sheets file in Excel format

Yous can piece of work on a spreadsheet in Sheets and so send a copy by electronic mail as an Excel file (or a PDF).

1. In Sheets, open the file.
2. Click File Email equally attachment.

3. Under Attach every bit, choose Microsoft Excel.

4. Enter the email accost, bailiwick, and message.
5. (Optional) Bank check the Ship a copy to myself box.
6. Click Send.

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

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

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.

Next: 3. Manage data in Sheets

Was this helpful?

How can we improve information technology?

stokespervage.blogspot.com

Source: https://support.google.com/docs/answer/9331167?hl=en

Share this post