How to pull a single integer from a 1 line CSV file on the internet e.g. github into Google Sheets

Draft created: Mar 27, 2026 22:43 (UTC).
Get a single integer without a header (via Stack Overflow:: Google Sheets IMPORTDATA() with no header
- where Col2 is the second column, Offset 1 means skip the first row and 0 means Specifies the number of header rows in the input range, which enables transformation of multi-header rows range input to be transformed to a single row header input.
Official Google Docs: QUERY function, Query Language Reference (Version 0.7)

=QUERY(
IMPORTDATA(
"https://raw.githubusercontent.com/thunderbird/thunderbird-desktop-metrics-and-reports/refs/heads/main/CONCATENATED_FILES/2026-03-sumo-desktop-report.csv"),
"SELECT Col2 Offset 1", 0)