InsightSQL

English | 中文

A tool that can quickly view Excel, CSV and Parquet using polars SQL, base on Tauri.

screenshot

• polars SQL for query

  

• CSV to xlsx

  

• Excel to CSV

  

• Cat

  

• Rename

  

• select

  

✨Features

• Use Polars SQL for querying, allows to load Excel, CSV and Parquet files, support saving as csv, xlsx or paquet files
• Merge multiple CSV or Excel files into one CSV or xlsx file (use Polars concat_lf_diagonal)
• Batch convert Excel to CSV
• Count the rows of CSV files
• Batch convert CSV to Excel
• Rename the columns of a CSV
• Select, re-order columns
• Select fields matching rows
• Fill empty fields in selected columns of a CSV
• Split one CSV file into many CSV files
• Add an index for a CSV
• Drop headers from CSVs
• Convert Chinese to Pinyin for specific column in CSV
• Replace CSV data using a regex
• Apply series of string, math transformations to given CSV column/s

🍖How to use?

• Download InsightSQL.7z, extract and run InsightSQL.exe

🏃‍Runtime Environment

• Node.js 18+
• pnpm 9.9.0+
• 🦀Rust 1.82.0+

🚀Development

1. Clone this repositories

   git clone https://github.com/tansen87/InsightSQL.git

2. cd to the directory of the project

   cd InsightSQL

3. Install dependencies

   pnpm i

4. Development

   pnpm tauri:dev

5. Build

   pnpm tauri:build

video

• bilibili

Thanks

• tauri-pure-admin
• qsv