Everything you need for working with CSV

CSVUtility is a spreadsheet for people who actually live in CSV files, not a general-purpose workbook that happens to open them.

Download for MacOSBrowse every feature

What CSVUtility is built for

Edit it exactly how you want

A familiar spreadsheet grid with freeze panes, fill handles, and a formula bar. It stays smooth from a hundred rows to multi-gigabyte files.

CSVUtility Mac CSV editor showing a large retail orders spreadsheet

More than an editor

Filter with conditions like status = Paid, run spreadsheet functions, inspect a column, and compare unsaved changes side by side.

CSVUtility filtering rows on payment status

Keep your format, keep your data

CSVUtility detects delimiter and encoding on open, then changes nothing you did not. Compare saved versus current before you write.

CSVUtility Diff View comparing saved and current spreadsheet versions side by side

Everything in the app

Every editing, cleaning, analysis, and export tool in CSVUtility, grouped the way you use them.

Editing & Navigation

Spreadsheet-style editing designed specifically for CSV data.

  • Spreadsheet Grid

    Edit CSV data in a familiar row-and-column grid that stays smooth as you scroll, even on huge files.

  • Multi-Cell Editing

    Select multiple rows or cells and apply a value across the entire selection.

  • Drag to Move Cells

    Move a single cell or complete multi-cell range by dragging its border, with a live destination outline and full undo support.

  • Fill Handle

    Drag the selection handle to repeat values and formatting across a larger range.

  • Formula Bar

    View and edit long or multi-line cell values without losing sight of the surrounding data.

  • Go To Cell

    Jump directly to a cell, row, or column using references such as E6, E, or 120.

  • Freeze Panes

    Freeze the first row, first column, or everything above and to the left of the current selection.

  • Word Wrap

    Wrap long cell values and automatically adjust row heights to fit their contents.

  • Read-Only Mode

    Protect a sheet from accidental edits while continuing to inspect, search, filter, and navigate it.

  • Command Palette

    Quickly find and run common commands from a searchable keyboard-driven palette.

Columns & Table Structure

Reshape a CSV without manually rebuilding its columns.

  • Rename Columns

    Change a column heading directly from its context menu.

  • Add Columns

    Insert a new column immediately to the left or right of the current selection.

  • Duplicate Columns

    Copy an entire column, including its header, into a new adjacent column.

  • Move Columns

    Reorder columns without waiting for the whole file to reload.

  • Delete Columns

    Remove unwanted columns with undo support.

  • Split Columns

    Split values using a chosen separator, automatically creating as many columns as required.

  • Combine Columns

    Join multiple selected columns into one, with a custom separator and heading.

  • Transpose Selection

    Swap the rows and columns of a selected block.

  • Resize and Fit Columns

    Set an exact width or automatically fit columns to their contents.

Find, Filter & Sort

Locate, isolate, and arrange the records that matter.

  • Fast Find & Replace

    Search across the entire sheet or a selected range, with case-sensitive and whole-cell matching options.

  • Column Value Filters

    Choose which distinct values should remain visible directly from a column.

  • Row Filters

    Filter with conditions like status = Paid, using column names, AND / OR, NOT, LIKE, and blanks.

  • Live Filter Help

    See colour as you type, and a clear error if a condition is not valid yet.

  • Quick Sort

    Sort a column alphabetically, numerically, chronologically, or by value length.

  • Advanced Multi-Column Sort

    Build an ordered set of sorting rules with independent direction and blank-value handling.

  • Filtered Export

    Export only the rows currently visible through an active filter.

Cleaning & Transformation

Turn inconsistent data into something dependable.

  • Trim Whitespace

    Remove unwanted spaces and line breaks surrounding selected values.

  • Collapse Repeated Whitespace

    Replace inconsistent runs of spaces, tabs, and line breaks with clean single spaces.

  • Change Text Case

    Convert selected values to uppercase, lowercase, or title case.

  • Normalize Line Breaks

    Convert mixed line-ending styles into a consistent format.

  • Remove Control Characters

    Strip hidden control characters while preserving useful tabs and line breaks.

  • Replace, Prefix, and Suffix

    Transform selected cells by replacing text or adding content before or after each value.

  • Numeric Transformations

    Add, multiply, or round numeric cells across an entire selection.

  • Fill Blank Cells

    Populate empty cells with a chosen value or carry the latest value down a column.

  • Blank Repeated Values

    Collapse repeated values by keeping the first and clearing subsequent duplicates.

  • Progress and Cancellation

    Safely stop long-running transformations before they modify the live sheet.

Data Quality & Analysis

Find problems and understand a selection without leaving the grid.

  • Data Quality Check

    Scan a CSV for malformed rows, unexpected column counts, unbalanced quotes, blank headings, and duplicate headings.

  • Issue Navigation

    Jump directly between detected data-quality problems in the sheet.

  • Selection Statistics

    See count, sum, average, minimum, and maximum values for the current selection.

  • Column Profiles

    Inspect distinct values, blanks, inferred value types, numeric ranges, and potential outliers.

  • Spreadsheet Functions

    Optionally use portable A1-style SUM, AVERAGE, COUNT, MIN, and MAX formulas.

  • Background Formula Evaluation

    Calculate formulas across very large file-backed ranges without blocking scrolling or selection.

  • Formula Validation

    See whether a formula is valid, malformed, cyclic, or references cells outside the sheet.

Multiple Sheets & Comparison

Work across files without constantly switching context.

  • Tabbed Workspace

    Keep multiple CSV files open in a single window and quickly switch between them.

  • Split-Screen Sheets

    Right-click a tab to open a second sheet beside the current one, with an adjustable divider.

  • Independent Split Tools

    Search, sort, filter, diff, and use functions independently in either visible pane.

  • Saved-versus-Current Diff

    Compare unsaved changes against the saved file in a synchronized side-by-side view.

  • Cell-Level Change Highlighting

    Clearly distinguish added, removed, changed, and unchanged cells.

  • Automatic Session Restore

    Reopen files from the previous session when CSV Utility launches.

Import, Export & Sharing

Keep control over how data enters and leaves the app.

  • Automatic Format Detection

    Detect common delimiters and text encodings when opening a file.

  • Configurable Import Defaults

    Choose a preferred delimiter and encoding for ambiguous or legacy files.

  • Multiple Delimiters

    Open and export comma-, tab-, semicolon-, and pipe-separated files.

  • Text Encoding Support

    Work with UTF-8, UTF-8 BOM, UTF-16, Windows-1252, and ISO Latin-1.

  • Configurable Line Endings

    Export using Unix-style LF or Windows-style CRLF line endings.

  • Flexible Export Scope

    Export the complete file, current filtered view, or selected cells.

  • Copy As JSON

    Copy the current selection as formatted JSON.

  • Copy As Markdown

    Turn selected cells into a ready-to-paste Markdown table.

  • Copy As SQL

    Generate SQL INSERT statements from selected data.

  • Open Hyperlinks

    Open URLs stored in cells directly in the default browser.

Performance & Reliability

Native macOS engineering for files that ordinary spreadsheet apps struggle with.

  • Multi-Gigabyte File Support

    Use files much larger than your Mac’s free memory. CSVUtility reads what it needs as you go.

  • Draw Only What You See

    The grid paints the cells on screen, not millions of hidden ones.

  • Faster Repeat Opens

    Unchanged large files open much faster the second time.

  • Background Operations

    Keep searching, filtering, and cleaning in the background so the grid stays usable.

  • Previous Versions

    Keep a copy on disk before overwriting a file, then open it from Finder if you need it back.

  • External Change Detection

    Automatically refresh clean documents when another application changes them on disk.

  • Full Undo and Redo

    Reverse cell edits, transformations, sorting, filtering, and structural column operations.

  • Works on Apple silicon and Intel

    One download for both kinds of Mac.

  • Automatic Updates

    Get new versions in the app. Updates are signed and checked by Apple.

Personalization

Configure the workspace around the way you work.

  • Light and Dark Appearance

    Follow the macOS appearance or choose a permanent light or dark theme.

  • Custom Accent Colour

    Choose the colour used for selections, active tools, and primary actions.

  • Grid Text and Density

    Adjust cell text size and default row height.

  • Custom Grid Dimensions

    Choose how many rows and columns newly opened sheets display, with defaults of 100 rows and 26 columns.

  • Searchable Settings

    Find preferences quickly from one continuous settings screen.

Common questions

Can CSVUtility open large CSV files on a Mac?

Yes. CSVUtility is a Mac CSV editor for multi-gigabyte files. It reads the file from disk as you scroll instead of loading every cell into memory. In a 1 GB test on a 14-inch MacBook Pro (M1 Pro, 16 GB), it opened 12.49 million rows and 99.9 million cells in 2.03 seconds.

How do CSVUtility limits compare with Excel and Google Sheets?

Google Sheets allows up to 10 million cells. Excel worksheets allow 1,048,576 rows. The 1 GB CSVUtility benchmark contained 99.9 million cells and 12.49 million rows, so almost 10 times the Sheets cell ceiling and 11.9 times Excel worksheet rows. That Excel comparison is the worksheet grid, not Power Query or the Data Model.

Does CSVUtility support SQL filters on CSV files?

Yes. Choose Filter from the Edit menu and type a condition using your column names, like status = Paid. You can combine conditions with AND, OR, and NOT, and use LIKE for partial matches. Mistakes show as you type. A two-condition filter over 12.49 million rows took 14.58 seconds in the 1 GB test.

Will CSVUtility change my CSV format when I open a file?

No. CSVUtility detects delimiter, encoding, and quoting on open, then keeps your data as it is. Leading zeros stay intact, dates are not rewritten, and you choose delimiter, encoding, and line endings when you export.

Is CSVUtility free to download for macOS?

Yes. Download CSVUtility for Mac and start editing. No account required. Updates install in the app. It needs macOS 14 or later.

How is CSVUtility different from Excel or Google Sheets?

CSVUtility is a CSV editor, not a general spreadsheet. It keeps your text as you saved it, opens files far larger than a worksheet can hold, and includes tools made for CSV work: row filters, a saved-versus-current compare, column split and combine, and checks for broken rows.

Does CSVUtility run on Windows or Linux?

No. CSVUtility is a Mac app for Apple silicon and Intel. It is checked by Apple, and it can restore a previous copy of a file you overwrite.

Try every feature today

Free to start. See the 1 GB benchmarks for measured open, search, filter, and export times.

Download for MacOS