What Is Google Looker Studio?

Google Looker Studio (formerly Google Data Studio) is a free, browser-based data visualization and dashboard tool. It connects directly to Google Sheets, Google Analytics, BigQuery, and dozens of other data sources. For anyone starting out with dashboards, it's one of the best tools available — no software installation, no cost, and a gentle learning curve.

In this tutorial, you'll connect a Google Sheet, add charts, and publish a live, shareable dashboard.

What You'll Need

  • A Google account
  • A Google Sheet with some data (even a simple table works)
  • About 30–45 minutes

Step 1: Prepare Your Data in Google Sheets

Good dashboards start with clean data. Create a Google Sheet with clearly labeled column headers in row 1. For this tutorial, imagine a simple sales table with columns: Date, Product, Region, Units Sold, Revenue. Make sure:

  • Date values are formatted as actual dates, not text.
  • Numbers are stored as numbers, not text with currency symbols.
  • There are no blank rows or merged cells in your data range.

Step 2: Open Looker Studio and Create a New Report

  1. Go to lookerstudio.google.com and sign in with your Google account.
  2. Click the "+" button or "Blank Report" to start a new report.
  3. A "Add data to report" panel appears. Select Google Sheets as your connector.
  4. Choose the spreadsheet and the specific sheet (tab) containing your data.
  5. Click Add and then Add to Report to confirm.

Step 3: Add Your First Chart — A Time Series

  1. From the top menu, click Insert → Time series chart.
  2. Draw a rectangle on the canvas where you want the chart to appear.
  3. In the right-hand panel, set Dimension to your Date column.
  4. Set Metric to Revenue (or Units Sold).
  5. Looker Studio will automatically aggregate the data by the date granularity it detects.

You now have a live line chart showing your metric over time. Any updates to your Google Sheet will automatically reflect here.

Step 4: Add a Bar Chart for Category Comparison

  1. Click Insert → Bar chart and draw it on the canvas.
  2. Set Dimension to Product (or Region).
  3. Set Metric to Revenue.
  4. In the Style tab on the right, enable Sort Descending to rank products by revenue automatically.

Step 5: Add a Scorecard for Key Metrics

Scorecards display a single number prominently — perfect for total revenue, total units, or any KPI you want to highlight at a glance.

  1. Click Insert → Scorecard.
  2. Set the Metric to Revenue. Looker Studio will show the sum of all values.
  3. Add a label like "Total Revenue" in the scorecard's Title field.

Step 6: Add a Date Range Filter

Interactive filters are what elevate a static chart into a real dashboard.

  1. Click Insert → Date range control and place it near the top of your report.
  2. This control will now filter all charts on the page based on the selected date range.

Step 7: Share and Publish

Click the Share button in the top-right corner. You can share a view-only link with anyone, or embed the dashboard in a webpage using the Manage access → Get embed code option. Your dashboard is live and updates automatically whenever your source data changes.

Next Steps

Once comfortable with the basics, explore calculated fields (to create custom metrics), blended data sources (to combine multiple sheets), and custom themes (to match your brand colors). Looker Studio has a surprisingly deep feature set that rewards exploration.