However, you’ll need to know how the file is delimited whether it’s tab or comma delimited, or with some other character. You can import directly from an Excel file that’s saved in CSV format. Importing CSV: Import Directly From an CSV File # The Excel file automatically converts to Google Sheets format.It opens in a newly created spreadsheet in your Google Sheets account.The formatting matches that of the original Excel spreadsheet as much as possible. You will notice several things happen when you use this approach to convert Excel to Google Sheets. In Google Sheets, just follow these steps to open an Excel file directly. You can open an Excel file (*.XLSX) directly, but you’ll need to go through a step to upload the file first. From Excel File: Just Open the Excel File Directly #
This will fill in the sheet with all of the data you’ve copied from the Excel spreadsheet.
However, there are multiple ways you can do this depending on the format of the original data.