Import Website Data Using IMPORTHTML and QUERY Functions
HTML-код
- Опубликовано: 26 июл 2024
- Create a function table from Google's Website! Link to the final product below!
Here's the website we are using:
support.google.com/docs/table...
Timestamps:
00:00 Introduction
01:02 Get the Link
02:06 When to Use IMPORTHTML
03:10 Inspect the Website
04:53 IMPORTHTML Formula Syntax
06:37 Try the SORT Function
07:23 SORT Function Limitations
07:45 QUERY Function: data argument
08:16 QUERY Function: query argument
08:54 query argument SELECT Statement
09:17 query argument Statement
09:40 query argument ORDER BY Statement
10:30 QUERY Function: [headers] argument
10:45 Filter Out Unwanted Rows of Data
11:45 Formatting the Table
12:50 Aggregating Data Using the QUERY Function
13:38 query argument GROUP BY Statement
15:38 query argument LABEL
16:34 Create a Dropdown
17:58 Add a Cell Reference Inside the QUERY Function
20:07 Add Logical IF Statement within the QUERY Function
23:44 Add Another Logical IF Statement to find the Function Name
24:55 Using the Two Dropdowns
26:22 Use COUNTA for Count of Functions Shown
27:30 More Formatting
28:14 Conditional Formatting: Alternating Colors
29:40 Review the Project
30:47 ProTip: Save a Static Copy of Your Table!
32:30 Conclusion
---
If you want a copy of what I made, here's one you can do. If you had trouble importing, this also includes the static data. I took it a step further than the video and added the dropdown functionality as well.
docs.google.com/spreadsheets/...
-
Socials:
WEBSITE: matttechtidbits.github.io/mat...
REDDIT: / matttechtidbits
LINKEDIN www.linkedin.com/in/matthew-k...
Song: "WFH" By Ambiosynthesis
• WFH Наука