ReMoni knowledge Center

Search for answers to your questions by entering keywords below, or look through our knowledge center.

Get data into Excel


NOTE: This guide is made in Excel version 2101 for Windows and does not work for older versions. How to find the version number: Link.

This guide covers how to get data into Excel from the ReMoni API, using a URL string created on the ReMoni API page. See the guide to how it will be made: Link.

 

  1. Open Excel

  2. Select the Data tab and then click From Web.
    Excel_-_Data_-_From_Web.jpg

  3. Insert the URL string from the ReMoni API and click OK.
    Excel_-_Inds_t_url.jpg

  4. Select "basic" and use your email and password from ReCalc.
    Excel_-_Basic.jpg

  5. Now the Power Query Editor opens. On the Transform tab, click "To Table".
    Excel_-_Transformer_-__to_tabel.jpg

  6. Click OK for this dialog box.
    Excel_-_To_tabel.jpg

  7. Then click on the small icon of two arrows in the right corner of the column. Click OK for the next window that appears.
    Excel_-_Udpak_kolonden.jpg

  8. Select the Transform tab and click on Detect data type.
    Excel_-_Detect_data_type.jpg

  9. If it does not convert the Timestamp column to Date/Time itself, this is necessary to do yourself.
    Excel_-_To_Time_date.jpg
  10. First click on the column with Timestamp and then select the Transform tab and click on Reverse Rows.
    Excel_-_Reverse_rows.jpg

  11. Select the Home tab and click Close & Load.
    Excel_-_Close___load.jpgExcel-gem_og_luk.jpg

  12. In order to make a graph of Timestamp and Value, you have to convert the top timestamp to a Time. Click on the top Timestamp then select the Home tab and then click on the dropdown where it says Custom. Select Time.
    Excel_-_Til_klokkeslet.jpg

  13. Select the entire Timestamp and Value column at the same time. On the Insert tab, Select curves.
    Excel_-_Make_Graph.jpg      Excel_-_Graph.jpg

  14. To update data, click on the small update icon on the right side.
    Excel_-_Get_new_data.png