Playtomic ↔ PadelLevels API & Excel Guide

1. Live Conversion

Enter a Playtomic rating or PadelLevels points to see the live conversion:

Rating → Points (API)

Points → Rating (API)

2. API Usage

The API allows dynamic conversion between Playtomic ratings and PadelLevels points:

https://www.coachcalli.co.uk/padel-resources/PadelLevels_Conversion/api.php?rating=5.0
https://www.coachcalli.co.uk/padel-resources/PadelLevels_Conversion/api.php?points=5400

Use JavaScript fetch to integrate in your own scripts:

fetch("https://www.coachcalli.co.uk/padel-resources/PadelLevels_Conversion/api.php?rating=6.0")
  .then(res => res.json())
  .then(data => console.log(data));

3. Excel Integration

3.1 Power Query (Recommended)

  1. Data → Get Data → From Other Sources → From Web.
  2. Enter the API URL, e.g., https://www.coachcalli.co.uk/padel-resources/PadelLevels_Conversion/api.php?rating=5.0.
  3. Expand JSON fields (rating, points, label).
  4. Use a parameter linked to a cell for dynamic updates.

3.2 WEBSERVICE() Formula

=WEBSERVICE("https://www.coachcalli.co.uk/padel-resources/PadelLevels_Conversion/api.php?rating=" & B2)

Returns raw JSON. Use TEXTBEFORE/TEXTAFTER or Excel 365 functions to extract values.

3.3 Offline Excel Lookup

If you prefer not to use the API, you can use a ready-to-use Excel file with the full lookup table:

Download Excel Lookup File
  1. The file contains two sheets: Members (with examples) and Data (lookup table).
  2. Column C in the Members sheet automatically calculates PadelLevels points from column B using XLOOKUP.
  3. Use this as a template for your own member list.

4. Full Rating → PadelLevels Table

This table shows all Playtomic ratings (1.0–7.0, 0.1 increments) and interpolated PadelLevels points:

Playtomic Rating PadelLevels Points

5. Notes & Tips