How to Create a New Google Sheet and Import Data

Creating a new Google Sheet and pulling your data into it is often the first step in any analysis, but getting it right from the start can save you a ton of headaches later. This guide will walk you through creating a new sheet and the best ways to import your data, from simple copy-and-paste to more powerful, automated functions. We'll cover everything you need to know to build a solid foundation for your reports and dashboards.

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

How to Create a New Google Sheet

Google offers a few convenient ways to quickly spin up a new spreadsheet. Let's look at the three most common methods.

1. From Your Google Drive

This is the most organized approach, as it allows you to create the file directly within a specific folder, keeping your Drive tidy from the get-go.

• Navigate to your Google Drive at drive.google.com.
• Go to the folder where you want your new sheet to live.
• Click the + New button in the upper-left corner.
• Hover over the arrow next to "Google Sheets" and select Blank spreadsheet. If you have templates set up, you could also choose "From a template."

Your new spreadsheet will be created in that folder and open in a new tab, ready for you to name it and get to work.

2. From the Google Sheets Hub

If you just want to create a new sheet quickly without thinking about organization first, you can go straight to the source.

• Go to the Google Sheets homepage at sheets.google.com.
• At the top of the page, you'll see a "Start a new spreadsheet" section. Click on the large + tile labeled "Blank."

A new, untitled spreadsheet will open. Keep in mind that this file is saved in the main "My Drive" section of your Google Drive. You might want to move it into a more specific folder later to keep things organized.

3. Using a Browser Shortcut (The Pro Method)

This is by far the fastest way to create a brand new Google Sheet. Just type a special URL into your browser.

• Open a new browser tab.
• In the address bar, type sheet.new and press Enter.

That's it! A new, blank Google Sheet will instantly open. Like the previous method, this sheet is saved to the root folder of your Google Drive, so you may need to move it later.

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

Preparing Your Data for a Smooth Import

Before you even think about importing, a few minutes of data preparation can prevent hours of frustration. "Garbage in, garbage out" is especially true for spreadsheets. Clean, well-structured data is easier to work with, analyze, and visualize.

Here are a few things to check in your source file (like a CSV or Excel file):

• A Single, Simple Header Row: Your data should have one header row at the very top. Avoid merged cells or multiple header rows. Column names should be simple and descriptive (e.g., "Transaction Date," "Product Name," "Revenue").
• Consistent Data Formats: Ensure each column contains only one type of data. A "Date" column should only have dates, a "Sales" column should only have numbers, and so on. Mixed data types (like having "N/A" text in a number column) can cause errors in calculations.
• "Tidy" Data Structure: Follow the basic principle of tidy data: every column is a variable, every row is a separate observation, and every cell is a single value. This simple structure is the most powerful and flexible for creating pivot tables, charts, and formulas.
• No Unnecessary Formatting: Things like cell colors, bold text, or creative fonts won't help with analysis and can sometimes complicate imports. Keep the source data as plain as possible.

Methods for Importing Data into Google Sheets

Once your new sheet is created and your data is prepared, you have several options for getting it into your spreadsheet. The best method depends on the size of your dataset and where it's coming from.

Method 1: Using the Built-in Import Command

The File > Import menu is the most robust and flexible way to upload a data file like a CSV, TSV, or XLSX (Excel) file.

1. In your Google Sheet, go to File > Import.
2. The "Import file" dialog box will appear with several tabs. The most common choice is Upload. Click "Browse" to select a file from your computer or simply drag and drop your file into the window.
3. After your file uploads, an "Import file" settings window will appear. This is where you have some important choices:

Import location:

• Create new spreadsheet: This ignores your current sheet and creates an entirely new Google Sheets file with the imported data.
• Insert new sheet(s): This adds a new tab (or tabs, if your source file has multiple sheets) to your existing spreadsheet file. This is often the safest and most common choice.
• Replace spreadsheet: Use with caution! This will delete all existing sheets in your file and replace them with the data you're importing.
• Replace current sheet: Also be careful with this one. It will delete whatever is in your currently active sheet and overwrite it with the new data.
• Append rows to current sheet: This adds the new data to the bottom of your existing data in the active sheet. It requires the headers to match perfectly.
• Replace data starting at selected cell: This will paste the imported data where your cursor is, overwriting anything in its path.

Separator type:

For files like CSVs or TSVs, a choice of a separator will appear. Google Sheets is usually good at auto-detecting this (either a comma, tab, or custom character), but you can override it if you know the file uses something different.

Convert text to numbers, dates, and formulas:

Keep this checked (set to "Yes"). This tells Google Sheets to intelligently recognize dates as dates and numbers as numbers, which is essential for sorting, filtering, and performing calculations.

Once you've made your selections, click Import data, and your file will be loaded into the sheet.

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

Method 2: Simple Copy and Paste

For smaller datasets, sometimes the easiest way is the best way. If you have your data open in another program like Excel, a web page table, or another Google Sheet, you can often just copy it.

• Select the data from your source application and copy it (Ctrl+C or Cmd+C).
• Go to your new Google Sheet and click on the cell where you want the data to start (usually A1).
• Paste the data (Ctrl+V or Cmd+V).

A Pro-Tip on Pasting: Paste Special

Sometimes, when you copy and paste, you bring over unwanted formatting—bold text, colors, hyperlinks, or underlying formulas. To avoid this, use "Paste special."

Instead of hitting Ctrl+V, use the shortcut Ctrl+Shift+V (or Cmd+Shift+V on a Mac). This will paste only the raw values, without any formatting, giving you a perfectly clean dataset to work with.

Method 3: Using a Formula for Dynamic Imports

For data that needs to stay up-to-date, importing it via a formula is incredibly powerful. The data remains linked to its source, so when one changes, the other can be updated.

Using IMPORTDATA for Web-Hosted CSVs

If your data is stored in a publicly accessible CSV or TSV file online, you can use the IMPORTDATA function to pull it directly into your sheet.

The syntax is simple:

=IMPORTDATA("url_of_the_file")

Simply replace "url_of_the_file" with the direct link to your file. For example:

=IMPORTDATA("https://some-website.com/data/latest-sales.csv")

The data will automatically load into your sheet. Note that the data typically refreshes about once every hour, so it's great for reports that don't need to be real-time to the second.

Using IMPORTRANGE for Other Google Sheets

One of the most useful functions in all of Google Sheets is IMPORTRANGE. It allows you to pull data from one Google spreadsheet directly into another. This is perfect for creating a main dashboard that summarizes data from several other sheets without duplicating work.

The syntax is:

=IMPORTRANGE("spreadsheet_url", "range_string")

• spreadsheet_url: The full URL of the Google Sheet you want to pull data from, wrapped in quotes.
• range_string: The name of the sheet tab and the cell range you want to import, like "Sheet1!A1:G100" or "Revenue Data!A:F", also wrapped in quotes.

For example:

=IMPORTRANGE("https://docs.google.com/spreadsheets/d/123Abc456XyZ..", "Q4 Sales!A1:E50")

The first time you use IMPORTRANGE to connect to a new sheet, you'll see a #REF! error with a blue button asking you to "Allow access." Just click it once, and the two sheets will be permanently connected. The data imported this way is live—if the source sheet changes, your imported data updates almost instantly.

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

Final Thoughts

Mastering a few simple ways to create and import data into Google Sheets unlocks the door to better analysis and smarter reporting. Whether you're uploading a one-time CSV file for a quick project or using IMPORTRANGE to build a live-dashboard, knowing the right method for the job is the first step toward becoming a spreadsheet pro.

As you get comfortable pulling data into a single sheet, you'll quickly discover the next challenge: combining data from multiple platforms. Manually downloading CSVs from Google Analytics, Facebook Ads, Shopify, and your CRM to import them into Sheets is a time-consuming weekly chore. We created Graphed to solve this problem by connecting directly to all your data sources. You can use simple, natural language to instantly build real-time dashboards that combine all your marketing and sales data in one place—no more importing, no more copy-pasting, and no more stale reports.