Opening PowerSchool Exports (macOS + Windows) - .text > .csv
macOS
<span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span>macOS Video Tutorial: .text to Google Sheets
macOS Video Tutorial: .text to Google Sheets (using Google Drive Desktop)
<span class="fr-mk" style="display: none;"> </span>macOS Video Tutorial: .text to Excel
Note: Step 1 is a One-time step.
1. Click on Finder > Settings > Advanced > Check 'Show all filename extensions' - if it is not checked already
2. Right click (or hold Control + left-click) on the downloaded PowerSchool Export (a .text file) - and click 'Rename'
3. Use the arrow keys on your keyboard or use your mouse to highlight the .text portion, then delete it. Then type .csv and hit enter. When prompted with the "Are you sure you want to..." message - click Use .csv
4. Go to sheets.google.com > Create a new Sheet > File > Import > Upload > Select the .csv file > Import data
Note: If you have Google Drive Desktop installed (it is installed on all computer by default) and are signed into it, you can go Finder > Google Drive > My Drive and drag the .csv over there, and then double-click on it to open.
Windows
<span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span>
Windows Video Tutorial: .text to Google Sheets
<span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span>Windows Video Tutorial: .text to Google Sheets (using Google Drive Desktop)
<span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span>
Windows Video Tutorial: .text to Microsoft Excel
Note: Step 1 and 2 are one-time only.
1. Click on the File Explorer:
2. In File Explorer, click 'View' and then check the box next to 'File name extension'
3. Go to where you downloaded your PowerSchool Student Export. It should now end with '.text':
4. Right-click on the export and select 'Rename'. Change .text to .csv and then hit Enter:
5. You will get a warning, choose 'Yes' anyway:
6. Go to you Google Drive - drive.google.com, then go File Upload:
7. Upload the file you just changed earlier. You should be uploading the .csv file. Once it's done it should look like below: 
8. If you double-click on the file you just uploaded, you should be able to now access the PowerSchool Export in Google Sheets:
