Tutorials and guides related to the use of Google Sheets functions and features.
Learn how you can import XML to Google Sheets using the IMPORTXML function. As a bonus stage, we’ll show you the XML to Excel or BigQuery importing option.
Learn how you can concatenate strings, columns, and different data formats in Google Sheets using the CONCATENATE function and its alternatives.
Learn about the Google Sheets date format: which date formats are available, how they work, which date functions you can use, and much more.
Do you need to set up a database for your small business? Check out how you can use Google Sheets as a database for an e-commerce store, website or app.
Google Apps Script tutorial for programming with Google Sheets. Learn how to create custom functions, custom menus, and connect to other data sources.
Review this blog post to learn how to link data between Google Sheets by utilizing different approaches, and pick the one that will suit you the best.
With the Google Sheets SPARKLINE function, you can create miniature charts contained within a cell. Learn how it works!
Learn what a Gantt chart is and how to create Gantt charts in Google Sheets using conditional formatting, stacked bar charts, and templates.
Read the definitive tutorial on how to make a chart or how to create a graph in Google Sheets, and check out the real-life use cases.
How will you choose to sort data in Google Sheets: the built-in functionality, or Google Sheets functions, such as SORT and QUERY. Read more in this tutorial.