SmartQueryTools

Arrow Tools

77 free Arrow tools — all run in your browser. No uploads, no account required.

Arrow Converters

Convert CSV to Arrow Online

Convert CSV files to Arrow format directly in your browser. No upload required — your data never leaves your device.

Convert Parquet to Arrow Online

Convert Parquet files to Arrow format directly in your browser. No upload required — your data never leaves your device.

Convert JSON to Arrow Online

Convert JSON files to Arrow format directly in your browser. No upload required — your data never leaves your device.

Convert NDJSON to Arrow Online

Convert NDJSON files to Arrow format directly in your browser. No upload required — your data never leaves your device.

Convert TSV to Arrow Online

Convert TSV files to Arrow format directly in your browser. No upload required — your data never leaves your device.

Convert Arrow to CSV Online

Convert Arrow files to CSV format directly in your browser. No upload required — your data never leaves your device.

Convert Arrow to Parquet Online

Convert Arrow files to Parquet format directly in your browser. No upload required — your data never leaves your device.

Convert Arrow to JSON Online

Convert Arrow files to JSON format directly in your browser. No upload required — your data never leaves your device.

Convert Arrow to TSV Online

Convert Arrow files to TSV format directly in your browser. No upload required — your data never leaves your device.

Convert Arrow to NDJSON Online

Convert Arrow files to NDJSON format directly in your browser. No upload required — your data never leaves your device.

Convert Arrow to Excel Online

Convert Arrow files to Excel format directly in your browser. No upload required — your data never leaves your device.

Convert Excel to Arrow Online

Convert Excel files to Arrow format directly in your browser. No upload required — your data never leaves your device.

Convert Arrow to YAML Online

Convert Arrow files to YAML directly in your browser. Download clean, human-readable YAML — no upload required.

Convert YAML to Arrow Online

Convert YAML files to Arrow format directly in your browser. No upload required — your data never leaves your device.

Convert Arrow to XML Online

Convert Arrow files to XML directly in your browser. Download a structured XML document with one element per row — no upload required.

Convert Arrow to SQL Online

Convert Arrow files to SQL INSERT statements directly in your browser. Copy or download the generated SQL — no upload required.

Convert Arrow to Markdown Table Online

Convert Arrow files to a Markdown table directly in your browser. Copy the output and paste it into any Markdown document.

Convert Arrow to HTML Table Online

Convert Arrow files to an HTML table directly in your browser. Copy the markup or download a ready-to-use HTML file.

Arrow Operations

Deduplicate Arrow Files Online

Remove duplicate rows from Arrow files instantly in your browser. No upload, no server — 100% private.

Filter Arrow Files Online

Filter rows in Arrow files by column value, directly in your browser. Your data stays on your device.

Sort Arrow Files Online

Sort Arrow files by any column, ascending or descending, directly in your browser.

Split Arrow Files Online

Split Arrow files into multiple smaller files by row count, directly in your browser.

Sample Arrow Files Online

Sample rows from Arrow files — first N, last N, or random — directly in your browser.

Manage Columns in Arrow Files Online

Drop or select specific columns from Arrow files directly in your browser. No upload required.

Rename Columns in Arrow Files Online

Rename columns in Arrow files instantly in your browser. No upload, no server — your data stays on your device.

Merge Arrow Files Online

Merge and concatenate multiple Arrow files into one, directly in your browser.

Trim Whitespace in Arrow Files Online

Trim leading and trailing whitespace from all text columns in Arrow files, directly in your browser. No upload required.

Fill Empty Values in Arrow Files Online

Fill empty and null values in Arrow files with a custom replacement value, directly in your browser.

Transpose Arrow Files Online

Transpose Arrow files — flip rows and columns — directly in your browser. No upload, no server.

Extract Head of Arrow Files Online

Extract the first N rows from Arrow files directly in your browser. Choose how many rows to keep and download the result — no upload required.

Extract Tail of Arrow Files Online

Extract the last N rows from Arrow files directly in your browser. Choose how many rows to keep and download the result — no upload required.

Add Row Numbers to Arrow Files Online

Add a row number index column to Arrow files directly in your browser. Set the column name and starting number — no upload required.

Validate Arrow Files Online

Validate Arrow file structure in your browser. Check null counts, distinct values, and data types for every column — no upload required.

Count Values in Arrow Files Online

Group and count rows by any column in Arrow files directly in your browser. Sort by frequency or value to find the most common entries — no upload required.

Extract Unique Values from Arrow Files Online

Extract all distinct values from any column in Arrow files directly in your browser. Download the unique values list — no upload required.

Compare Arrow Files Online

Compare two Arrow files directly in your browser. See rows only in file A, only in file B, and rows common to both — no upload required.

Format Timestamps in Arrow Files Online

Reformat timestamp and date columns in Arrow files directly in your browser. Convert between ISO 8601, Unix epoch, US date, and custom strftime patterns — no upload required.

Find & Replace in Arrow Files Online

Find and replace text values in Arrow files directly in your browser. Supports plain text and regex patterns across any column — no upload required.

Split Column in Arrow Files Online

Split a column into multiple columns by delimiter in Arrow files directly in your browser. Turn "First Last" into separate first and last name columns — no upload required.

Combine Columns in Arrow Files Online

Combine multiple columns into one in Arrow files directly in your browser. Merge first name and last name, join address fields, or concatenate any columns with a custom separator — no upload required.

Convert Case in Arrow Files Online

Convert text columns to UPPERCASE, lowercase, or Title Case in Arrow files directly in your browser. Apply case conversion to any or all text columns at once — no upload required.

Aggregate Arrow Files Online

Group and aggregate Arrow files by any column directly in your browser. Calculate sum, average, min, max, and count for any numeric column — no upload required.

Round Numbers in Arrow Files Online

Round numeric columns in Arrow files to any number of decimal places directly in your browser. Set precision per column with a simple slider — no upload required.

Add Conditional Column to Arrow Files Online

Add a new column to Arrow files based on an if/else condition directly in your browser. Set a value for rows that match and a different value for rows that don't — no upload required.

Extract with Regex from Arrow Files Online

Extract text matching a regular expression from Arrow files directly in your browser. Pull out emails, URLs, phone numbers, or any pattern into a new column — no upload required.

Parse Dates in Arrow Files Online

Parse and convert date columns in Arrow files between formats and timezones directly in your browser. Supports ISO 8601, US/EU dates, Unix timestamps, and custom patterns — no upload required.

Compare Schema of Arrow Files Online

Compare the schemas of two Arrow files directly in your browser. See which columns exist in each file and spot type mismatches — no upload required.

Cast Column Types in Arrow Files Online

Change column data types in Arrow files directly in your browser. Cast text to numbers, dates to timestamps, or any supported type conversion — no upload required.

Unpivot Arrow Files Online

Reshape Arrow files from wide to long format directly in your browser. Melt multiple columns into variable/value pairs — no upload required.

Shuffle Arrow Files Online

Randomly shuffle the row order of Arrow files directly in your browser. Useful for randomising data before sampling or ML train/test splits.

Bin Column in Arrow Files Online

Bucket a numeric column in Arrow files into labelled ranges — equal-width bins or custom edges. Runs entirely in your browser.

Add Calculated Column to Arrow Files Online

Add a new column to Arrow files computed from an arithmetic expression over existing columns. No formulas, no code — just point and click.

Extract JSON Column from Arrow Files Online

Extract values from a JSON-encoded column in Arrow files into a new flat column using a JSON path expression. Runs in your browser.

Calculate Date Difference in Arrow Files Online

Calculate the difference between two date or timestamp columns in Arrow files directly in your browser. Output in days, months, years, hours, minutes, or seconds — no upload required.

Normalize Columns in Arrow Files Online

Normalize numeric columns in Arrow files using min-max scaling (0–1) or z-score standardisation (mean=0, std=1). Adds new columns alongside the originals — no upload required.

Rank Rows in Arrow Files Online

Add a rank column to Arrow files based on any column's values. Choose RANK, DENSE RANK, or ROW NUMBER, with optional partitioning — runs entirely in your browser.

Add Cumulative Sum to Arrow Files Online

Add a running total column to Arrow files for any numeric column. Optionally order by a date or sequence column and restart totals per group — no upload required.

Detect Outliers in Arrow Files Online

Detect statistical outliers in Arrow files directly in your browser. Flag or remove rows where numeric values exceed a chosen number of standard deviations from the mean — no upload required.

Validate Email Addresses in Arrow Files Online

Validate email addresses in Arrow files directly in your browser. Add a boolean column flagging valid and invalid emails, or filter to show only invalid rows — no upload required.

Add Moving Average to Arrow Files Online

Add a moving average, rolling sum, rolling min, or rolling max column to Arrow files directly in your browser. Choose window size, order-by column, and optional partitioning — no upload required.

Search Text in Arrow Files Online

Search for text across all string columns in Arrow files directly in your browser. Filter rows to only those containing your search term and download the results — no upload required.

Get Top N Rows from Arrow Files Online

Extract the top N rows per group from Arrow files directly in your browser. Get the top 5 products per category, highest scores per team, or any ranked subset — no upload required.

Add Percent of Total to Arrow Files Online

Add a percentage-of-total column to Arrow files directly in your browser. Show each row's share of the grand total, or the share within each group — no upload required.

Parse URL Column in Arrow Files Online

Parse URL columns in Arrow files and extract host, path, query string, and fragment into separate columns — directly in your browser, no upload required.

Add Lag / Lead Column to Arrow Files Online

Add a LAG or LEAD column to Arrow files to shift any column forward or backward by N rows. See previous day's sales, next value in a sequence, or any time-shifted comparison — runs entirely in your browser.

Filter by Date Range Arrow Files Online

Filter Arrow files to rows within a date range using simple start and end date pickers. See a live match count before you apply the filter — no upload required, runs in your browser.

Compute Correlation Matrix for Arrow Files Online

Compute a Pearson correlation matrix for numeric columns in Arrow files directly in your browser. Instantly spot which variables move together — colour-coded heatmap, no upload required.

Find Fuzzy Duplicates in Arrow Files Online

Find near-duplicate rows in Arrow files using Levenshtein edit distance or Jaro-Winkler similarity — all in your browser. Set your own threshold and download the matched pairs as CSV — no upload required.

Hash & Anonymise Columns in Arrow Files Online

Anonymise or pseudonymise columns in Arrow files by replacing values with MD5, SHA-256, or DuckDB hashes — directly in your browser. Useful for GDPR compliance and sharing data without exposing PII — no upload required.

Group Concatenate Arrow Files Online

Concatenate text values within each group in Arrow files directly in your browser. Group rows by a column and join the values of another column into a single delimited string — no upload required.

Truncate Dates in Arrow Files Online

Truncate date and timestamp columns in Arrow files to a chosen precision — year, quarter, month, week, day, hour, or minute — directly in your browser. Rounds timestamps down to the start of each period. No upload required.

Coalesce Columns in Arrow Files Online

Fill null values in Arrow files from other columns — return the first non-null value across up to 8 columns in priority order. Add the result as a new column. Runs entirely in your browser.

Add UUID Column to Arrow Files Online

Add a UUID column to Arrow files directly in your browser. Generate random UUIDv4 or time-ordered UUIDv7 identifiers for every row. Choose the column name and position — no upload required.

Pad Column in Arrow Files Online

Left-pad or right-pad a column in Arrow files to a fixed width directly in your browser. Zero-pad numeric codes, pad product IDs to a fixed length, or right-pad text fields — no upload required.

Compute Percentiles for Arrow Files Online

Compute percentiles, median, MAD, mode, and kurtosis for numeric columns in Arrow files directly in your browser. Optionally group by a category column. Results download as CSV — no upload required.

Find Arg Max / Min in Arrow Files Online

Find the value of one column at the row where another column is maximum or minimum in Arrow files — directly in your browser. Optionally group by a category to get per-group results. No upload required.

Arrow Viewer Online

View and inspect Arrow files directly in your browser. Browse rows, check column names and data types — no upload required, your data stays on your device.

About Arrow

Apache Arrow defines both an in-memory columnar format and an IPC (Inter-Process Communication) file format for persisting Arrow data to disk. The format is designed for zero-copy reads, SIMD-optimised operations, and high-speed data exchange between systems and programming languages — all without the serialisation overhead of formats like CSV or JSON. DuckDB, pandas, Polars, PySpark, and Ray all use Arrow as their internal memory representation.

Arrow IPC files appear in high-performance data engineering contexts: passing a large dataset from a Python process to a Rust worker without copying memory, checkpointing in-memory Arrow tables to disk for fast reload, sharing data between processes using Arrow Flight, and as an exchange format in distributed query systems. If you are building or debugging a pipeline that uses Arrow natively, you may occasionally need to inspect or convert an Arrow file.

Arrow is rarely the end destination for data — it is an intermediate format for performance-critical exchange. Our Arrow tools let you inspect the schema and contents of an Arrow IPC file, convert to CSV or Parquet for storage and sharing, or convert from other formats into Arrow. Everything runs in the browser with no installs.

Frequently Asked Questions

What is the difference between Apache Arrow and Parquet?

Arrow is an in-memory columnar format optimised for zero-copy access and processing speed. Parquet is a disk-based columnar format optimised for compression and efficient storage. Arrow IPC files preserve the in-memory layout (no decompression needed on read) but are typically larger than Parquet. Parquet is the right choice for long-term storage; Arrow is the right choice for fast inter-process data exchange.

What is an Arrow IPC file?

An Arrow IPC (Inter-Process Communication) file stores one or more Arrow record batches — chunks of columnar data — in a binary format that can be memory-mapped directly, enabling zero-copy reads. The file has a .arrow extension (or sometimes .ipc). It is produced by any Arrow-compatible library when you write an Arrow table to disk.

Can I open an Arrow file without Python?

Yes. Use the Arrow Viewer or Arrow to CSV converter here to inspect or export the contents without a Python environment or data science toolchain. Arrow files are read natively in the browser.