Step-by-Step Guide: Transferring Data From Excel to Google Sheets

Quick Links

• How to Import an Excel Document into Google Sheets

Did someone send you an Excel document, but you don’t have Excel? Giving up on Microsoft Office and making the change to Google Drive? No problem; Google Sheets lets you import your Excel files. And while it might not support some of the same features and effects of an Excel document, it works pretty well.

How to Import an Excel Document into Google Sheets

To view an Excel document on Google Sheets, you must first upload the file to your Google Drive. Open Google Drive , click “New,” and then click “File Upload” to get started.

Related: How to Create a Drop-Down List in Google Sheets

Navigate to your file(s) and then click “Open.”

Alternatively, you can drag and drop a file from your computer directly into the web browser for an easy upload.

Once your file uploads, right-click it, point to “Open With” on the context menu, and then select “Google Sheets.”

Related: 5 Google Sheets Features You Should Know

Google then converts your document into a Google Sheets file on your Drive account.

After you’ve finished editing your file, you can either share it with others or download and export your document back into a Microsoft Excel format by going to File > Download As and then clicking the “Microsoft Excel” option.

Related: How to Create Shareable Download Links for Files on Google Drive

If you’d rather download your document in PDF, ODS, CSV, or other formats, you can do that too.

The file is then downloaded to the browser’s default download folder.

Also read: