Wranglify

Fix messy data, fully offline

Only for Mac

$19.99

Mac

Paste or open any delimited data sets or log files. Flatten nested json, delete columns, convert dates, generate pivots and charts, save the steps and batch them. Offline Wranglify is a data workbench for the files that break everything else: the 400 MB export, the CSV with two date formats and a JSON column, the extract that cannot leave your machine. Make those edits in a few clicks, save the recipe, and run it over a whole folder of files- or share the recipe with a coworker. Flatten nested json with one click, paste messy xml to see an instant table. Clean it, export it as any format, or generate SQL create and insert statements from the entire file. BATCH THE STEPS OVER THOUSANDS OF FILES, In the app or in your terminal! CSV, TSV, JSON, NDJSON, JSONL, XLSX, SQLite, XML and a .gz of any of them. Exports CSV, JSON, NDJSON, XLSX, SQL statements, and SQLite. It runs entirely on your Mac. No account, no upload, no network connection of any kind. BIGGER THAN THE SPREADSHEET A spreadsheet stops at 1,048,576 rows. Wranglify opened a 497 MB, 5,096,070-line log in 3 milliseconds and scrolled every one of the 5,040,000 records it found, with real row numbers, at the same speed at row 5,000,000 as at row 1. Nothing was skipped and nothing was summarised away. FOR DATA THAT CANNOT LEAVE If the file has customer records in it, the online converter is not an option and neither is the plugin. Wranglify is sandboxed and makes no network requests at all, which is a property you can check rather than a promise you have to take: the app ships a page that reads back its own security policy and then tries to smuggle data out through every channel there is, so you can watch each one refused. There is also a PII scrubber for when the file has to be shared: mask emails and phone numbers, drop columns, or replace an identifier with a stable hash so rows still join. SPLIT A COLUMN AT ANY DELIMITER, IN ONE CLICK "12 High St, London, UK" in one cell. A name field holding "last, first". A key like "2026-Q1-EMEA". Click the column and the delimiter is already chosen, because Wranglify scores which character actually separates values rather than which one appears most, and it sizes the split to the widest value so nothing lands in a leftover column. SQL YOU CAN PASTE Turn a file into CREATE TABLE, INSERT, SELECT and UPDATE for PostgreSQL, MySQL, SQL Server or SQLite. The types come from a scan of the whole file, not the first ten rows: VARCHAR sized to what is actually there, INT or BIGINT by magnitude, DECIMAL by observed scale, NOT NULL only where there are no nulls, and a primary key only where the column is provably unique. Export the whole file as .sql, or as a real .sqlite database. A REAL SQL ENGINE, LOCALLY Load several files as tables and join, filter, group and sort them with SQLite running on your own machine. Every step shows the SQL it generates. PIVOT AND CHART Drag fields into rows, columns and values for a pivot with totals, subtotals, number formats and heat-mapped cells. Copy it as Markdown, HTML or TSV, or save a styled workbook. Charts draw whatever the pivot holds, aggregated in the engine rather than sampled. EVERY FIX IS A STEP The pipeline is a list you can reorder, switch off and undo. Save it as a recipe, hand it to someone else, and run it again next quarter against a file that does not exist yet. Authorize a folder once and apply that recipe to every file in it, from the app or from a terminal. SMALL, ON PURPOSE 10 MB installed, 6.3 MB to download, and that includes a full SQL database engine, a chart renderer, and an XLSX reader and writer. It bundles no browser of its own, so a single architecture is under 5 MB. Nothing in it is padding. OPENS CSV, TSV, JSON, NDJSON, XLSX, SQLite, XML, and .gz of any of them. Writes CSV, JSON, NDJSON, XLSX, SQL and SQLite. ALSO Eleven themes and five typefaces, with contrast checked as a test rather than as a preference. Multiple windows. Drag the finished file straight out of the window into Finder or Mail.

  • This app hasn’t received enough ratings or reviews to display an overview.

XML, opened like everything else Drop or paste an XML file and the repeating element becomes your rows. Attributes arrive as their own columns, nested values are one click from being flattened the way JSON already is, and a document is read without ever fetching anything it points at. A GRID THAT BEHAVES LIKE A GRID Click a cell and use the arrow keys, Tab, Enter, Home and End. Hold Shift to select a range. Start typing to replace a cell, or press F2 to edit what is there - Enter commits and drops a row, Tab commits and moves right. A selection now does something: copy it as tab-separated text and paste it straight into a spreadsheet or an email, fill down or fill right from the edge of the selection, or clear it. All four are on a right-click as well as the keyboard, and each one becomes a single undoable step, so it survives export and travels in a saved recipe. There is also a paper switch above the grid, for reading dark text on white the way a spreadsheet does. It changes the grid alone and leaves your theme everywhere else. CONVERT DATES A new step reads eleven date formats - ISO, epoch in seconds through nanoseconds, US and European slashes, Apache, syslog, Go - and writes back ISO, a plain date, date and time, US or European slashes, or epoch. It detects the format from your data, so adding the step usually gets it right on the first click. A value that does not match becomes empty rather than passing through, so a column that is half one format and half another shows you which rows. RECENT FILES, WHEREVER YOU ARE The list of everything you have opened is now in the header rather than only on the home screen, so you can get back to a file without closing the one you are on. Pasted tables are in it too, under a name of their own, and reopening any of them brings its cleaning steps back. PIVOT AND CHART Pivot columns size to their contents instead of stretching, fields can be dragged into a different order inside a zone, and any header sorts - by a measure to find the big numbers, or by a key to put it in order. Subtotals stay with their groups and the grand total stays last. The chart's Vega-Lite spec is now editable in place, with a run button that redraws from what you typed and a reset that hands control back to the dropdowns. The spec carries no data, so what you edit stays a method you could paste into a notebook. FIXED Pasting into a text field - the regex box, a rename, the SQL console - no longer replaced the file you were working on. The menu bar's hover-to-switch works. The launch splash holds long enough to read.

The developer, John Taverna, indicated that the app’s privacy practices may include handling of data as described below. For more information, see the developer’s privacy policy .

  • Data Not Collected

    The developer does not collect any data from this app.

    Privacy practices may vary, for example, based on the features you use or your age. Learn More

    The developer indicated that this app supports the following accessibility features. Learn More

    • Supported Features

      • VoiceOver

      • Voice Control

      • Dark Interface

      • Differentiate Without Color Alone

      • Sufficient Contrast

      • Reduced Motion

    Seller
    John Taverna
    Size
    3.8 MB
    Category
    Productivity
    Compatibility
    Requires macOS 11.0 or later.
    • Mac
      Requires macOS 11.0 or later.
    Languages
    English
    Age Rating
    4+
    Copyright
    © 2026 John Taverna