Creating a Live Feed to Excel using a Mac

These instructions cover creating a live feed from Arbor into Excel using a Mac. For guidance on using a PC or Google Sheets, see the instructions that appear when creating a Live Feed in Arbor.

 

Go to the age you would like to set up a live feed from. In this case, I'm using the Attendance > Absentees > Persistent Absentees page.

Click the Download button then select Live Feed.

Screen_Shot_2019-08-07_at_08.58.56.png

 

Copy the URL from the pop-up box that appears.

Screen_Shot_2019-08-07_at_09.05.09.png

 

Open a blank Word document and paste your live feed URL onto the page. Save your document as a Plain text (.txt) file.

You can save it anywhere and under any name you wish.

Screen_Shot_2019-08-07_at_11.27.00.png

 

Click Ok in the next step.

 Screen_Shot_2019-08-07_at_11.22.51.png

 

Open a blank Excel document and click into the Data tab. Select the option to Run Web Query.

Screen_Shot_2019-08-07_at_09.31.38.png

 

Select the .txt file from your documents, then click Get Data.

Top Tip: If you can't select the file, please wait for a bit of time for the data to process. 15 minutes should do it! You should then be able to select the file.

Screen_Shot_2019-08-07_at_11.37.59.png

 

Click Ok in the pop-up box to import the data to the existing sheet.

Screen_Shot_2019-08-07_at_11.38.08.png

 

Your spreadsheet will then show that the data is loading.

Screen_Shot_2019-08-07_at_11.38.13.png

 

Once the data has finished loading, you will see it in your spreadsheet.

Screen_Shot_2019-08-07_at_11.38.23.png

 

Remember to save your file as something memorable so you can find it again in the future!

So the live feed refreshes the data each time you open it, you will need to adjust the settings. Go to the Data menu in Excel and select Properties.

Tick the box to Refresh data when opening the file, then click Ok.

The table will then refresh each time you open it. Please note: You may need to resave the file under another name for the changes to take effect.

Screen_Shot_2019-08-07_at_11.44.50.png

 

I'm still stuck!
0 out of 0 found this helpful