Reconcile two spreadsheets API

Give it two spreadsheets that should hold the same rows, such as a shop's order export and the accounting system's. It tells you which rows match, which cells

Input

Send these Fields as input. A Field not listed here is refused.

file_a

First file (.xlsx or .csv)

An https URL or an upload id.

  • Type: string
  • Required: yes
  • Length in characters: at least 1

file_b

Second file (.xlsx or .csv)

An https URL or an upload id.

  • Type: string
  • Required: yes
  • Length in characters: at least 1

key_columns

Columns that identify a row, separated by commas

  • Type: string
  • Required: no
  • Length in characters: at most 30000

tolerance

Numbers are equal when they differ by at most

  • Type: number
  • Required: no
  • Value: at least 0

text_match

Text

  • Type: string
  • Required: no
  • Allowed values: Exact, Ignore case and spaces at the ends

Run it

One call presses the Widget and answers the run once its status is succeeded or failed, however long it takes. The key is read from ABYSS_API_KEY. Install the library with npm install abysshub or pip install abysshub; cURL sends the Fields as a form.

JavaScript

// index.mjs
import Abyss, { file } from "abysshub";

const abyss = new Abyss();

const run = await abyss.run("widget_395", {
  file_a: file("shop-orders-2026-10.xlsx"),
  file_b: file("accounting-2026-10.csv"),
  tolerance: 0.05,
  text_match: "Exact",
});

console.log(run.result);
for (const path of await run.save("output")) {
  console.log(path);
}

Python

from abysshub import Abyss, file

abyss = Abyss()

run = abyss.run("widget_395", {
    "file_a": file("shop-orders-2026-10.xlsx"),
    "file_b": file("accounting-2026-10.csv"),
    "tolerance": 0.05,
    "text_match": "Exact",
})

print(run.result)
for path in run.save("output"):
    print(path)

cURL

curl https://api.abysshub.com/v1/widgets/widget_395/runs \
  -H "Authorization: Bearer $ABYSS_API_KEY" \
  -F file_a=@shop-orders-2026-10.xlsx \
  -F file_b=@accounting-2026-10.csv \
  -F tolerance=0.05 \
  -F text_match=Exact

A succeeded run carries its result and its output_files. Their URLs are signed for each read: re-read the run, never store a URL. A run still queued or running in the answer (after an hour, or when the API is busy) is read again at its Location with ?wait=true.

What it answers

The Example Run's result, the JSON the Widget wrote to output/output.json:

{
  "key_columns": [
    "Order No"
  ],
  "rows_in_a": 240,
  "rows_in_b": 239,
  "rows_in_both": 237,
  "rows_equal": 232,
  "rows_different": 5,
  "only_in_a": 3,
  "only_in_b": 2,
  "cells_different": 5,
  "columns": {
    "Order Date": {
      "different": 0
    },
    "Customer No": {
      "different": 0
    },
    "Status": {
      "different": 1
    },
    "Amount": {
      "different": 4
    }
  },
  "columns_only_in_a": [
    "Channel"
  ],
  "columns_only_in_b": [
    "Invoice No"
  ],
  "match": false
}

More

Keys, files, errors and limits: API access.