About FileGlance

A powerful tool for viewing, filtering, and transforming tabular data files.

Why FileGlance?

Frustrated by:

Needing different tools for different formats.
Lack of tools optimized for quickly understanding data.
Messy files that require cleaning before use.

I built FileGlance as a side project and a fun way to learn React and Tailwind.

Maybe it will help others, too.

It aims to be both:

Simple: Just drag and drop a file; it automatically detects encoding, delimiter, headers, and more.
Powerful: Run custom JavaScript to filter and transform data at scale.

Features

Drag-and-drop support for all common file types (CSV, XLSX, JSON, etc.)
Automatic detection of file encoding, delimiters, and data location
Optimized display (hides empty columns by default)
Simple filtering with value facets for exact matches
Full-text search across data
Basic sorting functionality
Advanced row filtering using custom JavaScript
Advanced value transformation using custom JavaScript
One-click export to CSV, XLSX, or JSON
Handles large files with virtualized list rendering
Visual representation of value counts (histograms for numeric data)
Progressive Web App (PWA) support
Privacy-focused: Your data never leaves your device

Use Cases

Data Viewing & Exploration

View raw data and column types. Get visualizations for categorical and continuous data (histograms). For numeric values, see statistics like average, median, min, and max.

Data Filtering & Cleaning

Apply quick filters with one click or use complex filter functions with custom JavaScript. Remove duplicates, incomplete, or corrupted data.

Data Transformation

Transform data using custom JavaScript functions. For example, split the domain from an email or format Unix timestamps to readable dates.

Tech Stack & Code

FileGlance is built with TypeScript, Next.js/React, Tailwind CSS, and Recharts. It is open source under the AGPL license. Interested developers can find the full source code on GitHub: https://github.com/dell-mic/file-glance