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.”
Android Police: Google Sheets cell limit doubles in new update, inching closer to Microsoft Excel. “How many cells would you say Google Sheets has? Take a wild guess — one million, maybe two? That used to be the case until Google increased the total number of cells in the spreadsheet from two million to five million in 2019. In an insane move, the company is now taking sheets from five million cells to 10 million to give users more space to work with.”
Digital Inspiration: How to Create Dynamic Open Graph Images with Google Sheets. “Generate dynamic Open Graph images for your website with Google Sheets without requiring Puppeteer. All pages on your website can have their own unique Open Graph images created from a Google Slides template.”
MakeUseOf: The 9 Best Google Sheets Formatting Tips for Creating Professional-Looking Spreadsheets. “There are so many ways to make Google Sheets look beautiful to impress with your data visuals. The majority of spreadsheet apps focus on the computation part, leaving the data visualization and formatting to the user. Therefore, if you don’t format your spreadsheet carefully, the audience may find it boring, since plain and simple data is not interesting. The same goes for Google Sheets.”
MakeUseOf: The Advantages and Limitations of Using Macros in Google Sheets. “Though running a macro is easy, it may not be feasible or acceptable in all cases. By understanding the benefits and drawbacks of Google Sheets macros, you can use them efficiently and securely.” More of an overview than a how-to.
MakeUseOf: The 10 Best Google Sheet Quick Hacks You Probably Didn’t Know . “You might have been using Google Sheets for storing and visualizing numerical data for both personal and collaborative work. However, it’s not only a spreadsheet tool with many rows, columns, and formulas. You can also use it to do various cool stuff to wow your audience. In this article, we’ll introduce you to some of the best Google Sheet hacks you need to know to become a master of the platform.” Nice roundup.
Digital Inspiration: How to Change the Date Format in Google Sheets. “You can customize the date format in a Google Sheet with the TEXT function and completely change the way the date and time values are displayed in the worksheet.”
How-To Geek: How to Use Interactive Dates in Google Docs. “If you want to include an interactive date in your document, Google Docs gives you simple ways to do it. Once you insert it, you can customize the format and use the date to schedule an event in Google Calendar.”
Google Workspace Updates: New intelligent suggestions for formulas and functions in Google Sheets. “Formula suggestions will make it easier to write new formulas accurately and help make data analysis quicker and easier. Simply begin inserting a formula in Sheets—suggestions will be automatically displayed and as you continue to type. You can view additional incremental suggestions in the drop-down menu.”
Digital Inspiration: Essential Date Functions for Google Sheets. “Master all the important date functions for Google Sheets with working formula examples. Whether you are looking to calculate the number of working days before the project is due or days until your upcoming birthday, this is the place to start.”
Search Engine Journal: How to Use Google Sheets for Web Scraping & Campaign Building. “According to Google’s support page, IMPORTXML ‘imports data from any of various structured data types including XML, HTML, CSV, TSV, and RSS and ATOM XML feeds.’ Essentially, IMPORTXML is a function allows you to scrape structured data from webpages — no coding knowledge required. For example, it’s quick and easy to extract data such as page titles, descriptions, or links, but also more complex information.”
Digital Inspiration: Sort by Random – How to Randomize the Order of Rows in Google Sheets. “There are multiple ways to randomize the data rows in Google Sheet. You can either use the built-in SORT function of Google Sheets or create a menu-based function that lets you randomize data with a click.”
Digital Inspiration: How to Replace Accented Characters (diacritics) with English letters in Google Sheets
Digital Inspiration: How to Replace Accented Characters (diacritics) with English letters in Google Sheets. “The REMOVE_ACCENTED function for Google Sheets will replace all accented characters in the referenced cell, like the letters è, õ, ā, ĝ and so on with their normal Latin equivalents.”
My Master Designer: Using Google Sheets As Database With Python. “In this article, we’ll use Google Sheets as a database with the help of Python. Use SQL or NoSQL softwares when large databases and complex operations are required. A reminder before you start reading the article Google Sheets isn’t exactly database software, but it’s a simple spreadsheet program where you can store your data.”