Platform

Convert Stripe payment and balance CSV exports to clean JSON

Convert Stripe balance and payment CSV exports to clean JSON with amount conversion and metadata parsing.

🛡️ Your rows never leave your browser.
Why Onfyt: Correctly unescapes Stripe's double-quoted JSON metadata column—a parsing edge case that breaks generic CSV-to-JSON tools.

Interactive Sample Data

idamountcurrencycreateddescription
ch_abc1234500usd1710000000Order #1001
ch_def4568200usd1710086400Order #1002

How this tool works

Stripe's CSV exports contain several encoding quirks: monetary amounts are stored in the smallest currency unit (cents for USD, so $45.00 appears as 4500), created timestamps are Unix epoch integers, and the metadata column contains a double-escaped JSON string that standard CSV parsers struggle with. This tool handles all three transformations: converts cent integers to decimal dollar amounts, converts Unix timestamps to ISO 8601 UTC strings, and parses the metadata JSON column into a proper nested object in the JSON output. Stripe financial exports contain nested customer objects, fee breakdowns, refund metadata, and Unix epoch timestamps that need transformation before loading into accounting software or data warehouses. DataFix converts Stripe transaction CSVs into clean JSON records, parsing Unix timestamps into ISO-8601 strings, converting cents into standard currency decimals, and structuring fee arrays for instant ingestion into Postgres, BigQuery, or custom accounting microservices. Stripe transaction exports contain Unix epoch timestamps, currency representations in cents, and nested metadata blocks. Converting records into structured JSON parses timestamps into ISO-8601 strings and structures financial line items for automated bookkeeping ingestion. Converting Stripe transaction archives into JSON structures parses Unix epoch seconds into readable ISO timestamps and converts minor currency units (cents) into decimal amounts. This structured layout integrates directly into microservice billing databases. Nested fee objects and customer tax identifiers are cleanly preserved in the emitted JSON documents, supporting direct reconciliation with Stripe API webhooks.

Things that usually go wrong

  • Stripe amounts are in the smallest currency unit (cents for USD). The tool divides by 100 — for currencies like JPY with no subunit, disable this conversion.
  • Refunds appear as negative amounts.

Edge cases we tested

🧪 Non-USD currency (EUR, KES)

Amount conversion skipped when currency is not cent-based; user warned.

🧪 Metadata column with nested arrays

Parsed as nested JSON array within the object.

🧪 Refunded charge with negative amount

Negative cents correctly converted to negative dollar amount.

Frequently Asked Questions

Are all Stripe transaction types included?

Yes — charges, refunds, payouts, and fees are all included with a 'type' field.

Can I get a CSV output instead of JSON?

Use the standard CSV→JSON→CSV pipeline, or use the Google Ads Cleaner for tabular-only output.

Related tools

Platform

Shopify Customer Export Cleaner

Normalize Shopify customer exports: merge split address fields, clean phones, and strip internal metadata.

Open Tool →
Platform

Google Contacts CSV Fixer

Fix Google Contacts CSV exports to import into Outlook, Apple Contacts, or CRM platforms.

Open Tool →
Platform

Mailchimp List Cleanup

Clean Mailchimp subscriber exports: remove unsubscribes, deduplicate, fix emails, and strip metadata.

Open Tool →