📘 About Mini CSV Explorer

← Back to Main Page

🧭 Main Menu Functions

  • New File: Start with a blank table.
  • Load File: Upload a CSV file. Choose your delimiter before loading.
  • 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.

⚙️ 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.

❓ Frequently Asked Questions

  • How do I upload a file? Click “Load File” in the top menu and choose your delimiter.
  • How do I export my data? Click “Export File” to download your current table.
  • Can I undo actions? Not yet — export your data before making major changes.
  • How do I switch themes? Use the 🌞/🌙 toggle in the top-right corner.
  • Is there a way to search for actions? Yes! Use the search bar in the Action Menu to find tools instantly.

🚀 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.