5 Easy Ways to Save CSV as Google Sheets File

Steps:

1. Open Google Drive: Navigate to Google Drive and sign in with your Google account.
2. Upload CSV File: Click on the New button and select File upload. Choose your CSV file from your local machine.
3. Open with Google Sheets: Once uploaded, right-click the file, hover over Open with, and select Google Sheets. The CSV file will now open as a Google Sheet.
4. Save Changes: Google Sheets automatically saves the file in the same location. You can rename it if needed.

Steps:

1. Open Google Sheets: Go to Google Sheets and create a new blank spreadsheet.
2. Use Import Tool: Click on File > Import > Upload. Select your CSV file.
3. Configure Import Settings: Choose whether to replace the current sheet or create a new one. Adjust separator settings if necessary (default is comma for CSV).
4. Complete Import: Click Import. Your CSV data will now appear in the Google Sheet.

Steps:

1. Open Google Sheets: Create a new spreadsheet.
2. Access Apps Script: Click on Extensions > Apps Script.
3. Write Script: Use the following script to import a CSV file from Google Drive:

function importCSV() {
  var file = DriveApp.getFilesByName('your_file.csv').next();
  var csvData = Utilities.parseCsv(file.getBlob().getDataAsString());
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  sheet.getRange(1, 1, csvData.length, csvData[0].length).setValues(csvData);
}

4. Run Script: Save the script and run the importCSV function. Ensure the CSV file is in your Google Drive and named correctly.

Steps:

1. Open CSV File: Use a text editor or spreadsheet software (e.g., Microsoft Excel) to open the CSV file.
2. Copy Data: Select all data and copy it (Ctrl+C or Cmd+C).
3. Paste into Google Sheets: Open a new Google Sheet, select the first cell, and paste the data (Ctrl+V or Cmd+V).
4. Adjust Formatting: If necessary, use the Text to Columns feature under Data to ensure proper separation.