992
edits
Rolandtb
Joined 4 May 2023
remove break tags
(fix formatting) |
(remove break tags) |
||
| Line 21: | Line 21: | ||
don’t need real-time, automatic updates. The data will refresh | don’t need real-time, automatic updates. The data will refresh | ||
periodically or when the sheet is manually reopened. | periodically or when the sheet is manually reopened. | ||
* 1. '''Get the raw CSV URL from GitHub:''' Navigate to your CSV file on GitHub, click the '''“Raw”''' button, and copy the URL from your browser’s address bar. This URL | * 1. '''Get the raw CSV URL from GitHub:''' Navigate to your CSV file on GitHub, click the '''“Raw”''' button, and copy the URL from your browser’s address bar. This URL | ||
should point directly to the raw data and typically starts with <code>raw.githubusercontent.com...</code>. | should point directly to the raw data and typically starts with <code>raw.githubusercontent.com...</code>. | ||
* 2. '''Use the <code>IMPORTDATA</code> function:''' In the desired Google Sheets cell (e.g., A1), enter the following formula, replacing <code>"YOUR_RAW_CSV_URL"</code> with the URL you copied: | * 2. '''Use the <code>IMPORTDATA</code> function:''' In the desired Google Sheets cell (e.g., A1), enter the following formula, replacing <code>"YOUR_RAW_CSV_URL"</code> with the URL you copied: | ||