992
edits
Rolandtb
Joined 4 May 2023
fix formatting
(how to update a google sheet cell with numbers from a github csv file) |
(fix formatting) |
||
| Line 18: | Line 18: | ||
'''Method 1: Using the <code>IMPORTDATA</code> Function (Manual/Semi-automated)''' | '''Method 1: Using the <code>IMPORTDATA</code> Function (Manual/Semi-automated)''' | ||
This method is the simplest if your CSV file is publicly accessible and you | This method is the simplest if your CSV file is publicly accessible and you | ||
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<br /> | * 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<br /> | ||
should point directly to the raw data and typically starts with <code>raw.githubusercontent.com...</code>.<br /> | should point directly to the raw data and typically starts with <code>raw.githubusercontent.com...</code>.<br /> | ||
| Line 26: | Line 26: | ||
<pre class="excel">=IMPORTDATA("YOUR_RAW_CSV_URL")</pre> | <pre class="excel">=IMPORTDATA("YOUR_RAW_CSV_URL")</pre> | ||
* 3. '''Press Enter:''' The data from the GitHub CSV file will populate the sheet starting from | * 3. '''Press Enter:''' The data from the GitHub CSV file will populate the sheet starting from | ||
that cell. The data will automatically arrange itself into rows and | that cell. The data will automatically arrange itself into rows and | ||
columns | columns | ||
| Line 88: | Line 88: | ||
** Under “Select event source”, choose '''Time-driven'''. | ** Under “Select event source”, choose '''Time-driven'''. | ||
** Configure the frequency (e.g., every hour, day) and save the trigger | ** Configure the frequency (e.g., every hour, day) and save the trigger | ||
== 2026-01-15 How to syntax colour and highligt aka escape JavaScript code in wikitext== | == 2026-01-15 How to syntax colour and highligt aka escape JavaScript code in wikitext== | ||
* apparently it's <code><syntaxhighlight lang="javascript">your JavaScript code here</syntaxhighlight></code>. For example: | * apparently it's <code><syntaxhighlight lang="javascript">your JavaScript code here</syntaxhighlight></code>. For example: | ||