Linkly & Microsoft Excel live feeds

How to get Live Feeds of your Click Data into Microsoft Excel

1. Open your Excel workbook

2. Go to the Data tab -> click From web.

   

   

   Go to the Data tab -> click From web.

3. The data URL dialog will open.

   

   

   The data URL dialog will open.

4. Grab the data URL.

   Right-click on the Data as CSV tab in the Linkly dashboard and select Copy link address.

   

   

   Grab the data URL.

5. Enter copied link in URL field.

   Then click OK.

   

   

   Enter copied link in URL field.

6. Then click Load

   

   

   Then click Load

7. Go to Queries and connection pane on right side

   

   

   Go to Queries and connection pane on right side

8. if Queries and connection pane not visible, go to Data → Queries & Connections

   

   

   if Queries and connection pane not visible, go to Data → Queries & Connections

9. Right-click on query → Select properties

   

   

   Right-click on query → Select properties

10. Properties dialog box will open

    Tick Refresh every field and insert 999 in minutes field. Then click OK.

    More frequent refreshes may get rate limited on Linkly.

    

    

    Properties dialog box will open