User Tools

Site Tools


howto:netspreadsheet

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
howto:netspreadsheet [2021/05/04 18:49] – [Notes for Admins] va7fihowto:netspreadsheet [2021/08/09 09:28] (current) – [LibreOffice or Excel] va7fi
Line 8: Line 8:
 If you don't have LibreOffice or Excel on your computer, you'll want to install [[https://libreoffice.org/ |LibreOffice]] first, which is a free and open source office suite. If you don't have LibreOffice or Excel on your computer, you'll want to install [[https://libreoffice.org/ |LibreOffice]] first, which is a free and open source office suite.
  
 +===== Quick Demo ===== 
 +For those who don't like to read instructions... 
 +{{  netrollcall.gif  }}
 ===== Downloading The File ===== ===== Downloading The File =====
 Currently, the file is not public, contact [[va7fi@rbox.me |Patrick, VA7FI]] if you'd like access. Currently, the file is not public, contact [[va7fi@rbox.me |Patrick, VA7FI]] if you'd like access.
Line 175: Line 177:
 {{ :howto:ised_import.png?350}} {{ :howto:ised_import.png?350}}
   * Download [[http://www.ic.gc.ca/eic/site/025.nsf/eng/h_00004.html |Amateur call sign list (delimited TXT format)]].   * Download [[http://www.ic.gc.ca/eic/site/025.nsf/eng/h_00004.html |Amateur call sign list (delimited TXT format)]].
-  * Extract text file from zip file and change extension from: \\ ''.txt'' to ''.csv''+  * Extract ''amateur_delim.txt''
   * In Google Sheets, unhide and select the ''ISED Data'' tab.   * In Google Sheets, unhide and select the ''ISED Data'' tab.
   * Go to ''File'' > ''Import'' > ''Upload'':   * Go to ''File'' > ''Import'' > ''Upload'':
howto/netspreadsheet.1620179362.txt.gz · Last modified: 2021/05/04 18:49 by va7fi