How to Import Datasets or Spreadsheets to Google Sheets

Not only can you create new Google Sheets, but also you can import your current datasets or worksheets to Google Sheets. Although Google Sheets and Microsoft Excel Worksheets are different, there are no transition issues when importing your Excel spreadsheets to Google Sheets.

Step 1: To import your data or Excel spreadsheets, click the "Folder" icon on the top-right corner above the file list;

Step 2: In the "Import File" window, click the "Upload" tab and click "Select a File from your device";

Your uploaded Sheet will automatically open when the file upload is complete.

Alternatively, when you are working on a Sheet, you can also import datasets or spreadsheets with the steps below:

Step 1: In the Sheet, click the "File" tab from the ribbon and select "Import" from the drop-down list;

Step 2: Click the "Upload" tab and click "Select a File from your device" in the "Import File" window;

Step 3: Navigation to the file location and select the proper file from your computer;

Step 4: Select the proper options in the "Import file" dialog box, and click the "Import Data" button;

Step 5: After successfully uploading your spreadsheets, you will see the message on the top of the window;

Step 6: If you want to check the file, you can click "Open Now" (step 5), or you can always find the file from the Google Sheets list.

Leave a Reply