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
- Id:
widget_395 - Price: Ƀ 50 a run, plus the Call Price, Ƀ 0.1 an API run. Your first 100 API runs carry no Call Price.
- Widget page: Run it in your browser
- Docs: Call Abyss from your code
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=ExactA 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.