fbpx
Blog /

How to Import CSV into Google Sheets

A CSV file stores tabular data formatted in plain text. It is one of the most widely used formats for storing data, and is compatible with a number of different platforms, including spreadsheets, databases, and business systems.

But with the emergence of reliable data connectors, many SalesOps users are moving away from manual CSV exports. SalesOps users can now import data directly into their spreadsheets from Salesforce and other company systems.

But even with access to data connectors, some users will still need to import CSVs into Google Sheets from time to time.

Here are the top ways to import a CSV into Google Sheets, based on step-by-step walkthroughs.

What is a CSV File?

A Comma Separated Values (CSV) file is a plain text list of data. CSV files are organized in a tabular format, in a table of rows and columns. This format is ideal for the table-based structure of spreadsheets and databases.  

Because they are easy to generate and stored in plain text, CSV files are often used to exchange data between systems. Many business systems, such as HubSpot and Looker, allow SalesOps users to manually export data as CSV files.  

Here’s an example of how a CSV file looks in plain text.

csv example
   

Each line represents a corresponding row, and each comma represents a corresponding column. Now let’s open the CSV in Google Sheets. This show us what the plain text data looks like in a spreadsheet:

csv in google spreadsheet

The line breaks and commas from the plain text file line up with the spreadsheet rows and columns.

Moving Away from CSVs: Real-Time Data in Google Sheets

CSVs are still widely used across business sectors, especially in roles that require frequent data modeling and analysis. The CSV is the standard file format for importing/exporting data from business systems.

However, for anything other than one-time uploads, CSV files can become painful. For instance, if a SalesOps user needs to update a forecasting spreadsheet every day, all the manual uploads and copying/pasting will seriously hamper efficiency.

But this cumbersome process doesn’t just waste time. It also leads to errors, inaccuracies, and out-of-date data. This, in turn, compromises the reports and dashboards that stakeholders rely on to make decisions.  

Coefficient allows SalesOps users to import data directly into Google Sheets, rather than through a mess of CSVs. Our automatic data updates also ensure that the data always stays up to date. But it’s unrealistic to assume that our customers will never encounter CSVs.

Sometimes, a CSV is all that’s available at the moment. That’s why we built a data connector to import CSVs into Google Sheets. Here’s how to import CSVs into Google Sheets with Coefficient, along with other popular methods.  

Import CSV into Google Sheets: Best Methods    

Coefficient

 Here’s how to automatically import CSVs into Google Sheets with Coefficient.

Click Extensions on the top menu of Google Sheets. Then select Add-ons > Get add-ons to open Google Workspace Marketplace.  

install coefficient

Find the app by typing in ‘Coefficient’ into the search bar. Follow the prompts for installation.

google workplace marketplace

Select the Google account you want to associate with Coefficient. Click Allow to give Coefficient the required permissions.

coefficient data security

After the installation, go back to Extensions on the Google Sheets menu. You’ll see Coefficient as an add-on in the dropdown. Click Launch, and Coefficient will appear on the sidebar.  

google sheets data connectors

Click Import from… on the Coefficient app sidebar.  

import data google sheets

Scroll through the list of data sources. Click on CSV.

import csv google sheets

Three options will appear: Upload file, Pick from Google Drive, and Import from URL. Click Upload file.

upload csv google sheets

Authorize Coefficient to connect to your Google Drive.

csv google drive

Once you connect to Google Drive, choose a CSV to upload from your device.

upload csv google sheets

After selecting the CSV file to upload, you will automatically be routed to the Coefficient sidebar.

From there, you can choose the Columns to import, Filters for the data (comparative operators) and Advanced settings (rows to skip).

Over 50K pros building reports use Coefficient to automate business systems data into their Google Sheets
"What an amazing app! Coefficient makes integrating some of the most complex systems unbelievably simple! Set up your integrations in less than a minute."
Yonatan Schvimer

import columns csv spreadsheets

Once you’ve selected these settings, press Import to pull the CSV data into Google Sheets.

csv google sheets list

Now try importing a CSV using Pick from Google Drive.

csv google drive spreadsheets

This will allow you to choose import CSVs stored on Google Drive. Select a CSV from your Drive.

csv format google drive

Once you import your CSV, you can use Coefficient to automatically update the data. This setting will pull the CSV file in Google Drive on a weekly, daily, or hourly basis, so the data always stays up to date.

automatic data update google sheets

Finally, you can also import CSVs into Google Sheets using Coefficient’s Import from URL option.

import csv from url google sheets

Simply provide the URL for the CSV file you want to import.

public csv spreadsheets

As in the previous example, you can filter the CSV import, and perform automatic data updates, using the Coefficient sidebar.

Google Sheets: Native Methods

Google Sheets offers different ways to import CSVs natively. Here’s an overview of all the options.  

Google Drive Homescreen

For the first option, navigate to the Google Drive homescreen. Then click on New.

file upload google sheets

Click File upload.

upload csv google sheets

Then choose the CSV you want to upload. The CSV file will upload to your Google Drive.

google drive csv file format

Now click on the CSV file in Google Drive. You’ll see a view-only preview of the CSV file. Click the Open with drop-down and choose Google Sheets.

view only csv google

The CSV data will be imported into a new Google spreadsheet.

import csv into google spreadsheet

Although this is a quick way for importing CSVs into Google Sheets, the method is only suited for one-time uploads that require no customizations. Unlike Coefficient, Google Sheets does not allow you to:

  • Choose CSV columns to import with point-and-click functionality
  • Dynamically filter data before importation
  • Automatically update data when a CSV file changes

File Menu

You can also import CSVs into Google Sheets directly from the file menu.

Open a new Google spreadsheet and click File -> Import.

file import google sheets

Then choose a CSV to upload. You can choose a CSV file stored on Google Drive or upload one from your device.

import csv file google sheets

 Choose the Import location for the CSV file. Possible locations include:

  • Create new spreadsheet
  • Insert new sheet(s)
  • Replace spreadsheet
  • Replace current sheet
  • Append to current sheet
  • Replace data at selected cell

create new spreadsheet csv upload google sheets

This drop-down offers several options for appending and merging data, but in practice, manually performing this step with each upload eats tons of time. It can also lead to errors and inaccuracies in the dataset.

You can also select the Separator type before importing the CSV data. Don’t change this option unless you know the CSV is using a separator other than a comma.  

separator type csv file

Click Import data. The CSV data will be imported into a Google spreadsheet.

csv upload google sheets

Google Sheets IMPORTDATA Function

You can also import data into Google Sheets using the IMPORTDATA function.

IMPORTDATA allows you to import data from a URL that contains a .csv or .tsv (tab-separated value) file.

The syntax for the function is straightforward:

IMPORTDATA(url)

The URL must appear in quotes. You can also reference cells that contain URLs, such as

IMPORTDATA(B3)

For example, let’s import an open source CSV from URL into Google Sheets: Sales Data for Men’s Fashion Stores. Type this formula into a cell:

=IMPORTDATA(“https://vincentarelbundock.github.io/Rdatasets/csv/Ecdat/Clothing.csv“)

The data will populate into the Sheet:

IMPORTDATA csv google sheets

You can also combine IMPORTDATA with other functions in Google Sheets. See the examples in our blogs on VLOOKUP and QUERY.

Importing CSVs into Google Sheets: Top Options for Your Team

Despite the emergence of tools such as Coefficient, some teams still choose to manually pull data from CSV into Google Sheets. However, teams can leverage the full power of Coefficient’s filters and automatic data updates to streamline the process of importing data from CSVs.

Since most systems lack adequate Google Sheets data connectors, many teams still rely on CSVs for data wrangling. By leveraging Coefficient, they can speed up their efforts and spend less time manually inputting CSV data, and more time on analysis.

Try Coefficient for free now. Our CSV connector is entirely free to use — check it out to see what it can do for your workflows and sales processes.  

Wait, there's more!

Connect any system to Google Sheets in just seconds.

Get Started Free
50,000+ users on
Google Marketplace
Trusted by thousands
of companies