Google Sheets Integration
This is the most common workflow for operations, production, and marketing teams who keep asset dimensions in a shared spreadsheet.
Step 1: Select the width and height columns in your Google Sheet.
Step 2: Use a helper formula such as `=B2&"x"&C2` to combine each row into a `1920x1080` string.
Step 3: Copy the combined column and paste it into the batch converter.
Step 4: Review the output, then download CSV or copy the results back into the sheet.
You can calculate a raw ratio inside Sheets with `=TEXT(B2/GCD(B2,C2),"0")&":"&TEXT(C2/GCD(B2,C2),"0")`, but Sheets alone will not give you nearest standards, match quality, or CSS padding values.
Figma Integration
Design teams often need a fast ratio audit after a client changes frame sizes or when a handoff includes many artboards across channels.
Step 1: Select the frames you want to inspect in Figma.
Step 2: Copy or export the dimensions from Dev Mode, a plugin, or your design inventory notes.
Step 3: Paste that list into the converter to normalize ratios and spot odd sizes.
Step 4: Use Copy as Markdown to paste the findings into FigJam, a design review note, or a client delivery checklist.
This works best when the tool is used as a cleanup layer after design exploration. It is faster to normalize late than to manually scan dozens of frame sizes while designing.
Notion Integration
Notion databases often hold asset specs, campaign plans, and upload requirements, but they are weak at ratio classification when the source data is messy.
Step 1: Export the Notion database as CSV or copy the dimensions column directly.
Step 2: Paste the list into the batch converter.
Step 3: Copy the Markdown table if you want a clean version for a project doc or QA checklist.
Step 4: Paste the results back into Notion for a reusable spec reference.
Command Line / API Logic
Automated workflows do not need the web UI. The core parsing and ratio logic can be reproduced in a small script for CI checks, media pipelines, or CMS preprocessing.
Step 1: Parse each resolution string with a regex that accepts multiple separators.
Step 2: Simplify width and height with a greatest common divisor calculation.
Step 3: Compute decimal ratio, padding-top, and nearest named standard for every row.
Step 4: Emit CSV, JSON, or console output depending on your pipeline.
function gcd(a, b) {
return b === 0 ? a : gcd(b, a % b);
}
function parseResolution(str) {
const match = str.match(/^(\d+)\s*(?:[x×:,/]|\s+)\s*(\d+)$/i);
if (!match) return null;
return { w: Number.parseInt(match[1], 10), h: Number.parseInt(match[2], 10) };
}
function getAspectRatio(w, h) {
const d = gcd(w, h);
return {
ratio: `${w / d}:${h / d}`,
decimal: (w / h).toFixed(4),
paddingTop: `${((h / w) * 100).toFixed(2)}%`
};
}from math import gcd
import re
def parse_resolution(value):
match = re.match(r"^(\d+)\s*(?:[x×:,/]|\s+)\s*(\d+)$", value)
return (int(match.group(1)), int(match.group(2))) if match else None
def aspect_ratio(width, height):
divisor = gcd(width, height)
return {
"ratio": f"{width // divisor}:{height // divisor}",
"decimal": round(width / height, 4),
"padding_top": f"{(height / width) * 100:.2f}%"
}