How to Get Data from Google Trends
Hemera Technologies/Photos.com/Getty Images
Google introduced the Trends feature in 2004. The service has become a popular research tool for web developers, students, and SEO analysts. Google Trends includes an export feature on every results page. Users can export search trends data as a CSV.
This file can be easily imported into an Excel spreadsheet or a Google document. Downloading the CSV data file takes only a few minutes to complete.
- Google introduced the Trends feature in 2004.
- This file can be easily imported into an Excel spreadsheet or a Google document.
Open a web browser. Visit the Google home page at Google.com.
Click the "Sign In" button in the upper-right-hand corner of the page. Enter your Google username and password, then click "Sign In."
Visit the Google Trends site at trends.google.com. Enter a search term into the search bar. Click the "Search Trends" button.
Click the plus sign at the bottom of the page next to "Export This Page to a CSV File." Choose "CSV with Relative Scaling" or "CSV with Fixed Scaling." The CSV file will begin downloading to your computer automatically. The relative scaling option scales the graph data to the average traffic amount during the entire time period you chose to examine. The fixed option scales the graph from the average traffic amount during a fixed point in time in the graph. The options affect the appearance of the graphs only and do not alter the data.
- Click the "Sign In" button in the upper-right-hand corner of the page.
- Click the plus sign at the bottom of the page next to "Export This Page to a CSV File."
You should choose the option that best displays the data for your needs.
Keith Patrick has been writing online since 2008. His articles appear on Patch.com and various other websites. He is currently studying journalism and e-commerce at DePaul University in Chicago.