📘 About Mini CSV Explorer

← Back to Main Page

🧭 Main Menu Functions

  • New File: Start with a blank table.
  • Load File: Upload a CSV file with intelligent file size management and delimiter detection.
  • Export File: Download the current table as a CSV. You can rename the file inline.
  • Clear: Reset the workspace and remove all data.
  • Delimiter: Set the character used to separate values (default is comma).
  • Pagination: Navigate large datasets using the page selector.
  • Theme Toggle: Switch between light and dark mode.

📁 Smart File Size Management

Mini CSV Explorer automatically analyzes your files and provides intelligent handling for different file sizes to ensure optimal performance.

🚦 Automatic File Analysis

  • Small Files (<1MB): Load instantly with full data processing.
  • Medium Files (1MB-10MB): Load with progress indication and performance optimization.
  • Large Files (10MB-50MB): Smart warning with sampling options to maintain responsiveness.
  • Very Large Files (>50MB): Recommended sampling with multiple options for different use cases.

🎯 Sampling Options

  • Random Sample: Statistically representative subset of your data.
  • Top Rows Sample: First N rows for structure analysis and initial exploration.
  • Custom Sample Size: Choose exactly how many rows to load.
  • Proceed Anyway: Load the full file if your system can handle it.

📊 Sample Indicators

  • File Name Display: Shows "(sample: X of Y rows)" when working with sampled data.
  • Sample Type: Indicates whether it's a random sample or top rows sample.
  • Progress Tracking: Real-time loading progress with percentage and row count.

⚙️ Action Menu Features

📊 Analyze & Group

  • Describe Column: View stats like min, max, mean, and unique count.
  • Show Value Counts: See frequency of each value.
  • Group & Aggregate: Apply functions like Count, Sum, Mean, Median, Std Dev, Top Value.

🔍 Filter & Clean

  • Filter Column: Select values to include or exclude.
  • Replace Values: Swap values in bulk.
  • Remove Duplicates: Keep only the first occurrence.
  • Drop Missing Values: Remove rows with empty/null values.

➕ Insert & Arrange

  • Add Column (Right/Left): Insert a new column next to the selected one.
  • Add Row (Up/Down): Insert a new row above or below the selected one.
  • Move & Reorder Columns: Drag column headers to rearrange their order instantly.

🗃️ Transform & Extract & Delete

  • Extract Selected Columns/Rows: Create a new table from selected data.
  • Concatenate Columns: Merge multiple columns into one using a custom separator. Optionally ignore empty values.
  • Delete Column/Row: Remove the selected item.
  • Delete Selected Columns/Rows: Remove all selected items.

✅ Select & Deselect

  • Select/Unselect Column/Row: Toggle selection for the current item.
  • Select All Columns/Rows: Select every item in the dataset or page.
  • Unselect All Columns/Rows: Clear all selections.

📈 Visualize

  • Chart This Column: Create visualizations for a single column with auto-recommended chart types.
  • Chart vs Other Columns: Create multi-column visualizations to explore relationships between data.

📈 Data Visualization & Charts

Create interactive charts and visualizations from your data with just a few clicks. Charts automatically adapt based on your column types (numerical 🔢 or categorical 📝).

📊 Single Column Charts

  • Bar Chart: Perfect for categorical data frequency visualization.
  • Pie Chart: Show proportions and percentages of categorical data.
  • Histogram: Display distribution of numerical data with customizable bins.
  • Box Plot: Visualize quartiles, median, and outliers in numerical data.
  • Violin Chart: Combine box plot with density estimation for detailed distributions.
  • Summary Stats: Comprehensive statistical overview with key metrics and insights.

📈 Multi-Column Charts

  • Scatter Plot: Explore relationships between two numerical columns.
  • Line Chart: Track trends and changes over time or ordered data.
  • Bubble Chart: Three-dimensional data with optional color grouping.
  • Grouped Bar Chart: Compare categorical data across different groups.
  • Stacked Bar Chart: Show part-to-whole relationships in categorical data.
  • Multi-Column Bar Chart: Side-by-side comparison of multiple numerical columns.
  • Multi-Column Box Plot: Compare distributions across different categories.
  • Heatmap: Visualize correlations and patterns in data matrices.
  • Density Plot: Smooth distribution visualization for continuous data.
  • Grouped Histogram: Compare distributions between different categories.

🎨 Chart Customization

  • Auto-Recommendations: Get suggested chart types based on your data types.
  • Custom Titles & Labels: Add meaningful titles and axis labels.
  • Color Grouping: Add a third dimension by coloring data points by another column.
  • Legend Control: Show/hide legends and customize display options.
  • Interactive Options: Hover for details, zoom, and pan functionality.

💾 Chart Export

  • PNG Export: High-resolution raster images perfect for presentations and reports.
  • SVG Export: Scalable vector graphics ideal for publications and web use.
  • Auto-Naming: Intelligent file naming based on chart type and columns used.

🔧 Advanced Features

Powerful features that enhance your data exploration workflow and boost productivity.

🖱️ Interactive Controls

  • Drag & Drop Columns: Click and drag column headers to instantly reorder your data structure.
  • Column Visibility: Hide/show columns with visual indicators showing count of hidden columns.
  • Dynamic File Naming: Edit file names inline in the main menu for better organization.
  • Context-Aware Actions: Actions adapt automatically based on column types (🔢 numerical vs 📝 categorical).

🔍 Smart Search & Navigation

  • Action Menu Search: Built-in search bar to quickly find specific operations.
  • Expandable Action Groups: Collapsible sections to focus on relevant functionality.
  • Smart Pagination: Efficient navigation through large datasets with page size optimization.
  • Real-time Filtering: Actions update in real-time based on search terms.

⚡ Performance Optimizations

  • Progressive Loading: Visual progress indicators for long-running operations.
  • Lazy Evaluation: Calculations performed only when needed to maintain responsiveness.
  • Memory Management: Intelligent handling of large datasets with sampling strategies.
  • Background Processing: Chart calculations and data operations run in web workers.

🎨 User Experience

  • Dark/Light Mode: Full theme support with automatic adaptation of all components.
  • Responsive Design: Works seamlessly across desktop, tablet, and mobile devices.
  • Accessibility: Keyboard navigation and screen reader support throughout the interface.
  • Visual Feedback: Clear indicators for loading states, selections, and operations in progress.

❓ Frequently Asked Questions

📁 File Management

  • How do I upload a file? Click "Load File" in the top menu and choose your delimiter. Large files will show smart sampling options.
  • What if my file is too large? The app automatically detects large files and offers sampling options to maintain performance.
  • How do I export my data? Click "Export File" to download your current table. You can rename the file inline before exporting.
  • Can I work with different delimiters? Yes! Set your delimiter before loading files. Common options include comma, semicolon, tab, and pipe.

📊 Data Analysis & Visualization

  • How do I create charts? Right-click any column header and select "Chart This Column" or "Chart vs Other Columns" from the action menu.
  • What chart types are available? 16 different chart types including bar charts, scatter plots, histograms, box plots, and more. Charts auto-adapt based on your data types.
  • Can I export my charts? Yes! Charts can be exported as high-resolution PNG images or scalable SVG files.
  • How do I customize charts? Use the chart configuration panel to add titles, labels, legends, and color groupings.

🔧 Advanced Features

  • How do I reorder columns? Simply drag and drop column headers to rearrange them instantly.
  • Can I hide columns? Yes! Use the action menu to hide columns. A counter shows how many are hidden.
  • Is there a way to search for actions? Yes! Use the search bar in the Action Menu to find tools instantly.
  • How do I switch themes? Use the 🌞/🌙 toggle in the top-right corner for full dark/light mode support.

⚡ Performance & Limitations

  • Can I undo actions? Not yet — export your data before making major changes.
  • How much data can I load? The app handles files of any size with intelligent sampling for large datasets (>10MB).
  • Why are some operations slow? Complex calculations run in background workers to keep the interface responsive. Progress bars show current status.
  • Does it work on mobile? Yes! The interface is fully responsive and works on desktop, tablet, and mobile devices.

🚀 Ready to Explore?

Mini CSV Explorer is built for speed, clarity, and flexibility. Whether you're cleaning messy data or diving into analysis, every action is just a click away.