How to Import a CSV File into Google Sheets | Quick Guide

Reading Time: 2 minutes
Import CSV into Google Sheets

Objective

Learn how to import a CSV file into Google Sheets

Why Import a CSV File into Google Sheets?

Google Sheets is a free software where you can collaborate with your team members on projects. Since CSV files are limited to offline use only, working on Google Sheet will provide you with the flexibility to work from anywhere. Moreover, everything is saved automatically in Google Sheets, thereby preventing data loss due to unforeseen circumstances such as computer crashes, low battery etc.

How to import a CSV File into Google Sheets?

Let’s see how to import CSV file into google sheets in 2 steps…

1. Upload File

  • Open Google Sheets.
  • Select “File” → “Import” → “Upload” → “Select a file from your computer”.
Upload CSV file into Google Sheets
Figure 1: Upload File
Upload your CSV file here
Figure 2: Upload your file here

2. Choose Your CSV File

  • Navigate to the folder with the file.
  • Choose your file.

3. Import Data

  • A set of parameters will pop up.
Choose the parameters as shown to import CSV file into Google Sheets
Figure 3: Choose the parameters as shown
  • Select “Replace Spreadsheet.
  • Select  Detect Automatically.
  • Checkmark “Convert text to numbers, dates and formulas”.
  • Click on “Open now”.

See Also

How to Import an Excel File into Google Sheets: Learn how to import an Excel file into Google Sheets.

How to import JSON in Google Sheets: Learn how to import JSON in Google Sheets.

Leave a Reply