OOXML Automation

presalytics · Analytics

Analytics No Auth Free & Open analytics

This API helps users convert Excel and Powerpoint documents into rich, live dashboards and stories.

Authentication

No authentication requiredFree to use with no key needed.

Sample Requests

GET AxisDataTypes: List All Possible Types

List Types: Use this method to retreive a list of possible options for the AxisDataTypes type. Use the Id from oneof the returned elements on to make changes to elements in the Chart object space.

https://api.apis.guru/v2/specs/presalytics.io/ooxml/0.1.0/Charts/AxisDataTypes

Hover any highlighted part to learn what it does

curl -X GET "https://api.apis.guru/v2/specs/presalytics.io/ooxml/0.1.0/Charts/AxisDataTypes"

import requests
response = requests.get(
    "https://api.apis.guru/v2/specs/presalytics.io/ooxml/0.1.0/Charts/AxisDataTypes",
)
print(response.json())

const url = 'https://api.apis.guru/v2/specs/presalytics.io/ooxml/0.1.0/Charts/AxisDataTypes';

const response = await fetch(url); 
const data = await response.json();
console.log(data);

package main

import (
	"fmt"
	"io"
	"net/http"
)

func main() {
	targetURL := "https://api.apis.guru/v2/specs/presalytics.io/ooxml/0.1.0/Charts/AxisDataTypes"
	req, _ := http.NewRequest("GET", targetURL, nil)

	client := &http.Client{}
	resp, _ := client.Do(req)
	defer resp.Body.Close()
	body, _ := io.ReadAll(resp.Body)
	fmt.Println(string(body))
}

require "net/http"
require "json"

uri = URI("https://api.apis.guru/v2/specs/presalytics.io/ooxml/0.1.0/Charts/AxisDataTypes")

http = Net::HTTP.new(uri.host, uri.port)
http.use_ssl = uri.scheme == "https"

req = Net::HTTP::Get.new(uri)

res = http.request(req)
puts JSON.parse(res.body)

<?php
$url = "https://api.apis.guru/v2/specs/presalytics.io/ooxml/0.1.0/Charts/AxisDataTypes";
$opts = ["http" => [
    "method" => "GET",
]];
$ctx = stream_context_create($opts);
$res = file_get_contents($url, false, $ctx);
print_r(json_decode($res, true));

GET PlotType: List All Possible Types

List Types: Use this method to retreive a list of possible options for the PlotType type. Use the Id from oneof the returned elements on to make changes to elements in the Chart object space.

https://api.apis.guru/v2/specs/presalytics.io/ooxml/0.1.0/Charts/PlotType

Hover any highlighted part to learn what it does

curl -X GET "https://api.apis.guru/v2/specs/presalytics.io/ooxml/0.1.0/Charts/PlotType"

import requests
response = requests.get(
    "https://api.apis.guru/v2/specs/presalytics.io/ooxml/0.1.0/Charts/PlotType",
)
print(response.json())

const url = 'https://api.apis.guru/v2/specs/presalytics.io/ooxml/0.1.0/Charts/PlotType';

const response = await fetch(url); 
const data = await response.json();
console.log(data);

package main

import (
	"fmt"
	"io"
	"net/http"
)

func main() {
	targetURL := "https://api.apis.guru/v2/specs/presalytics.io/ooxml/0.1.0/Charts/PlotType"
	req, _ := http.NewRequest("GET", targetURL, nil)

	client := &http.Client{}
	resp, _ := client.Do(req)
	defer resp.Body.Close()
	body, _ := io.ReadAll(resp.Body)
	fmt.Println(string(body))
}

require "net/http"
require "json"

uri = URI("https://api.apis.guru/v2/specs/presalytics.io/ooxml/0.1.0/Charts/PlotType")

http = Net::HTTP.new(uri.host, uri.port)
http.use_ssl = uri.scheme == "https"

req = Net::HTTP::Get.new(uri)

res = http.request(req)
puts JSON.parse(res.body)

<?php
$url = "https://api.apis.guru/v2/specs/presalytics.io/ooxml/0.1.0/Charts/PlotType";
$opts = ["http" => [
    "method" => "GET",
]];
$ctx = stream_context_create($opts);
$res = file_get_contents($url, false, $ctx);
print_r(json_decode($res, true));

GET RowCol: List All Possible Types

List Types: Use this method to retreive a list of possible options for the RowCol type. Use the Id from oneof the returned elements on to make changes to elements in the Chart object space.

https://api.apis.guru/v2/specs/presalytics.io/ooxml/0.1.0/Charts/RowCol

Hover any highlighted part to learn what it does

curl -X GET "https://api.apis.guru/v2/specs/presalytics.io/ooxml/0.1.0/Charts/RowCol"

import requests
response = requests.get(
    "https://api.apis.guru/v2/specs/presalytics.io/ooxml/0.1.0/Charts/RowCol",
)
print(response.json())

const url = 'https://api.apis.guru/v2/specs/presalytics.io/ooxml/0.1.0/Charts/RowCol';

const response = await fetch(url); 
const data = await response.json();
console.log(data);

package main

import (
	"fmt"
	"io"
	"net/http"
)

func main() {
	targetURL := "https://api.apis.guru/v2/specs/presalytics.io/ooxml/0.1.0/Charts/RowCol"
	req, _ := http.NewRequest("GET", targetURL, nil)

	client := &http.Client{}
	resp, _ := client.Do(req)
	defer resp.Body.Close()
	body, _ := io.ReadAll(resp.Body)
	fmt.Println(string(body))
}

require "net/http"
require "json"

uri = URI("https://api.apis.guru/v2/specs/presalytics.io/ooxml/0.1.0/Charts/RowCol")

http = Net::HTTP.new(uri.host, uri.port)
http.use_ssl = uri.scheme == "https"

req = Net::HTTP::Get.new(uri)

res = http.request(req)
puts JSON.parse(res.body)

<?php
$url = "https://api.apis.guru/v2/specs/presalytics.io/ooxml/0.1.0/Charts/RowCol";
$opts = ["http" => [
    "method" => "GET",
]];
$ctx = stream_context_create($opts);
$res = file_get_contents($url, false, $ctx);
print_r(json_decode($res, true));

Postman Setup Guide

Get Postman ↗

See official documentation for authentication and setup.

What can you build with OOXML Automation?

OOXML Automation is a Analytics API. Developers commonly use analytics APIs for:

tracking product usage and user behaviour
building custom reporting and BI dashboards
measuring marketing and campaign performance
running funnel, retention, and cohort analysis
aggregating metrics from multiple data sources

No authentication required. This API is open — no signup or key needed. Ideal for quick prototypes and public-facing features. OOXML Automation is free to use, making it a low-risk choice to experiment with.

New to APIs? Read our beginner's guide

Open documentation ↗