How to Put Data in Google Sheets

Putting data into Google Sheets is the first step toward transforming raw numbers into useful insights. This guide will walk you through all the essential methods for populating your spreadsheets, from simple manual entry to powerful, automated data feeds. We'll cover everything you need to know to get your data in the right place so you can start analyzing it.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

The Basics: Manual Data Entry

The most straightforward way to get data into Google Sheets is by putting it there yourself. This method works best for smaller data sets, quick notes, project plans, or when you are transcribing information from a non-digital source.

Typing Directly into Cells

Just click on a cell and start typing. Seriously, it's that simple. Press Enter to move to the cell below or Tab to move to the cell to the right. Use the arrow keys to navigate anywhere you need to go. This is ideal for creating lists, logging expenses, or building a small table from scratch.

Copying and Pasting

Copying and pasting is a massive time-saver. You can copy data from almost anywhere - a website, a Word document, a PDF, or another spreadsheet program like Excel - and paste it directly into Google Sheets.

Here’s how it works:

1. Highlight the data you want to copy from your source.
2. Use the keyboard shortcut Cmd+C (Mac) or Ctrl+C (Windows) to copy it.
3. Open your Google Sheet, click on the cell where you want the data to start, and use Cmd+V or Ctrl+V to paste.

Pro Tip: Pasting Without Formatting Sometimes when you paste data, it brings along unwanted fonts, colors, or cell structures. To avoid this, use the "Paste special" feature. After copying your data, right-click on the destination cell and select Paste special > Paste values only. This will paste just the text and numbers, ignoring all the formatting.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Importing Data from Files

For larger data sets, manual entry isn't practical. Instead, you can import data directly from files on your computer. Google Sheets natively supports common formats like Excel (.xlsx), comma-separated values (.csv), and tab-separated values (.tsv), which are formats used by nearly every data reporting tool for exporting.

Follow these steps to import a file:

1. In Google Sheets, go to File > Import.
2. A new window will appear. Click on the Upload tab.
3. Drag your file into the window or click "Select a file from your device" to find and choose it.
4. After the upload is complete, you'll see an "Import file" menu with options telling Google Sheets where to put the new data.

Understanding Your Import Options

You have a few choices for how the data is imported:

• Create new spreadsheet: This puts the imported data into a brand-new Google Sheets file. The original sheet you were in will remain untouched.
• Insert new sheet(s): This adds the imported data as a new tab (or tabs) within your current spreadsheet. This is great for compiling multiple reports in one place.
• Replace spreadsheet: This deletes everything in your current spreadsheet and replaces it with the data from the imported file. Use this with caution!
• Replace current sheet: Similar to the above, but only replaces the specific tab you are currently viewing.
• Append rows to current sheet: This adds the imported data to the bottom of the existing data on your current tab. This is useful for combining data from multiple files with the same column headers.

You can also specify the separator type (like comma or tab) and choose whether to convert text to numbers, dates, and formulas. In most cases, the "Detect automatically" setting works perfectly.

Pulling Live Data from the Web with Functions

Google Sheets includes powerful built-in functions that can pull data directly from websites and other spreadsheets. This allows you to create dynamic reports that update automatically without any manual work. Here are the most useful ones.

IMPORTHTML: Quickly Grab Tables & Lists

Ever see a useful table on a website (like Wikipedia) and wish you could instantly pull it into your sheet? The IMPORTHTML function does exactly that. It's built to scrape data from simple tables or lists on a web page.

The formula looks like this:

=IMPORTHTML("url", "query_type", "index")

• "url": The full web address of the page, enclosed in quotes.
• "query_type": Either "table" or "list", depending on what you want to pull.
• "index": A number indicating which table or list to grab from the page (starting from 1). For example, if you want the third table on the page, you'd use 3.

Example: Let's import a list of S&P 500 companies from Wikipedia. The URL is https://en.wikipedia.org/wiki/List_of_S%26P_500_companies, and the first table on the page contains the constituents. Here is a simplified formula using just part of that table:

=IMPORTHTML("https://en.wikipedia.org/wiki/List_of_S%26P_500_companies", "table", 1)

Place this formula in a cell, and Google Sheets will instantly populate the data from that table. It's a fantastic tool for pulling public data without copy-pasting.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

IMPORTDATA: Link to a CSV File online

Many data sources publish raw data as CSV files available at a public URL. The IMPORTDATA function is perfect for pulling this information directly into your sheet.

The syntax is incredibly simple:

=IMPORTDATA("url_of_csv_file")

For example, government agencies and markets often provide data via CSV URLs. Just find the link, pop it into the formula, and your data will appear and stay synced with the source file.

IMPORTRANGE: Connect Your Sheets Together

One of the most valuable functions is IMPORTRANGE. It lets you pull data from one Google Sheet into another. This is perfect for dashboards, summaries, and creating master reports that pull from different team or project sheets.

Here's the structure:

=IMPORTRANGE("spreadsheet_url", "range_string")

• "spreadsheet_url": The full URL of the Google Sheet you want to pull data from.
• "range_string": The tab name and cell range you want to import, like "Sales Data!A1:F100".

Important: The first time you use IMPORTRANGE to connect to a new sheet, the cell will show a #REF! error. Simply hover over the cell and click the "Allow access" button that appears. This is a one-time security step to authorize the data connection.

Automating Data with Integrations & Scripts

When you outgrow simple functions, you can turn to integrations and scripts to automatically pipe data from your favorite apps - like your CRM, ad platforms, and analytics tools - directly into Google Sheets.

Using Google Workspace Add-ons

The Google Workspace Marketplace is filled with third-party add-ons built to sync data from specific services. Tools like Supermetrics, Coefficient, and Growth FullStack specialize in connecting platforms like Google Analytics, Facebook Ads, HubSpot, and Salesforce to Google Sheets. After installing an add-on, you'll get a new sidebar where you can authenticate your apps, build reports, and schedule automatic data refreshes to keep your sheet updated.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Connecting via Zapier or Make.com

Tools like Zapier and Make act as a bridge between your apps. You can set up workflows (called "Zaps" or "Scenarios") that automatically perform actions based on a trigger. For example:

• Trigger: New deal is marked as "Won" in HubSpot.
• Action: Create a new row in a "New Sales Log" Google Sheet.

This "push" method is great for building event-driven logs or lists, adding new data in real-time as it's generated in other applications.

Custom Scripts with Google Apps Script

For maximum control and customization, you can use Google Apps Script. This is a cloud-based scripting platform built into every Google Sheet (go to Extensions > Apps Script). It uses JavaScript to let you create custom functions, automate tasks, and pull data from virtually any service with an API.

While this requires some coding knowledge, it unlocks capabilities far beyond standard functions. You could write a script that runs every morning to fetch key metrics from your Shopify store, format the data, and email a summary to your team - all without lifting a finger.

Final Thoughts

Getting your data into Google Sheets is the foundation of any analysis, and mastery of these different methods gives you immense flexibility. Whether you're typing in a simple list, importing a weekly ad spend CSV, or setting up a completely automated feed from your CRM, there is a method perfectly suited to your needs.

Once your data is in place, the next challenge is turning it into meaningful dashboards and reports. This often involves downloading multiple CSVs, wrestling with pivot tables, and manually refreshing everything. To simplify this, we built Graphed for this exact problem. You can connect your marketing and sales platforms like Google Analytics, Shopify, or Salesforce directly. Then, just describe the dashboard you want in plain English — like "Show me our top-performing campaigns by revenue for the last month" — and our AI builds it instantly, with real-time, interactive charts, freeing you to focus on strategy instead of report-building.