How-To Geek: How to Import Data With Google Sheets Functions

How-To Geek: How to Import Data With Google Sheets Functions. “You may want to work with data in your spreadsheet that resides elsewhere. Using a set of Google Sheets functions, you can import data from a CSV file, RSS feed, web page, or another spreadsheet. With the functions we’ll describe here, you can pull data into your sheet from external sources. Then, analyze, manipulate, format, and do what you please with your new data.”

MakeUseOf: How to Build a Simple and Effective Content Calendar in Google Sheets

MakeUseOf: How to Build a Simple and Effective Content Calendar in Google Sheets. “With many content calendar software available, it can be challenging to pick one. Some are overcomplicated, some are outside your budget, and others give you a suite of tools you’ll never use. It may even be that you’re still trying to pick your favorite and need a solution in the meantime—one without a paywall or trial period. Whatever the situation, you can create one that offers what you need—and nothing more—using spreadsheet software.”

How-To Geek: 6 Effective Ways to Use Explore in Google Sheets

How-To Geek: 6 Effective Ways to Use Explore in Google Sheets. “The Explore feature works differently in Google Sheets than in Google Docs. You can use it to get useful details about your data to help you analyze it. You can also use pieces that the tool provides in your spreadsheet. If you’re looking for a handy way to learn more about the data in your Google Sheet, here are various ways to use the Explore feature.”

Chrome Unboxed: Google Docs, Sheets, and Slides will now warn you of Office file compatibility issues

Chrome Unboxed: Google Docs, Sheets, and Slides will now warn you of Office file compatibility issues. “First and foremost, a new warning indicator will appear if your file has compatibility issues in Drive. It will appear and stay for the entirety of your editing session or so long as there are problems to be certain you address them before shipping the document off to its recipient.”

Digital Inspiration: How to Calculate the Percentage Score in a Google Forms Quiz

Digital Inspiration: How to Calculate the Percentage Score in a Google Forms Quiz. “When someone takes the quiz and submits the form, the responses are recorded in a Google Sheet that is set as the response destination for your Google Form. There’s something interesting here as well. If the associated form is a quiz, Google Sheets will automatically add an extra column in the response sheet titled ‘Score’ and this column will be populated with the total marks obtained by respondent in the quiz.”

TechCrunch: Google is adding new Drive, Docs, Sheets, Slides and Keep optimizations for tablets

TechCrunch: Google is adding new Drive, Docs, Sheets, Slides and Keep optimizations for tablets. “Google introduced Android 12L earlier this year to make tablets easier to use, and at I/O, the company announced plans to update more than 20 Google apps on tablets to optimize them for larger screens. Today, Google said it’s adding several new features for Drive, Docs, Sheets, Slides and Keep to get started on this promise.”

Search Engine Land: 11 Google Sheets formulas SEOs should know

Search Engine Land: 11 Google Sheets formulas SEOs should know. “While it’s not great at plotting ranking data (inverting the y-axis is always ugly), there are numerous ways to use Google Sheets for SEO. Here are 11 of the formulas and tips I find myself using for SEO on an almost daily basis – for keyword management, internationalization, content/URL management and dashboards.” Just ignore the SEO part. This is an excellent roundup of Google Sheets functions with quick, digestible examples.

MakeUseOf: How to Find Public Google Docs (and Slides, Forms, Sheets, and Drawings too)

MakeUseOf: How to Find Public Google Docs (and Slides, Forms, Sheets, and Drawings too). “Similarly, you can easily find public Google Docs, Slides, Forms, Drawings, and Sheets using some easy but Advanced Search operations and tools. In this article, we’ll show you some simple tricks to help you find public Google Drive files including Slides, Forms, Sheets, and Drawings.” Joy Okumoko does it again. I didn’t know about Heystack.

Digital Inspiration: How to Auto-Download Podcasts to Google Drive with Google Sheets

Digital Inspiration: How to Auto-Download Podcasts to Google Drive with Google Sheets. “This tutorial describes how you can use Google Sheets to build your own podcast manager. You can specify a list of your favorite podcast shows in Google Sheets and it will automatically download new episodes to your Google Drive in neatly organized folders. The setup is very simple, the app is completely open-source and you need no programming language.”