AI Data

Every AI Data tool on Zhankeng, with the real price on each card. Start from 3 free credits when you sign up.

Excel to Chart

3 ⚡

Upload an Excel or CSV file and get a finished chart. The file is read in your browser and never uploaded.

Big Screen Dashboard

3 ⚡

Build a 16:9 data wall with KPI cards and charts from your own table, then present it full screen.

Digital Twin Scene

3 ⚡

Place your table's objects in a 3D scene, colour them by thresholds and replay them over time.

Dashboard Canvas

5 ⚡

Build a 16:9 data wall from your own table: place any panel anywhere, drag to arrange, and configure every block on its own.

Compare Two Tables

1 ⚡

Load two Excel or CSV files and find the rows that do not match: missing entries, extra entries and changed values. Both files are read in your browser.

Clean a Table

1 ⚡

Remove duplicates, trim spaces, split columns, find and replace, fill blank cells. Build a cleaning recipe and export the result. The file never leaves your browser.

Merge Tables

1 ⚡

Combine several Excel or CSV files into one table — columns line up by header name, and you can add a column that records which file each row came from. Everything runs in your browser.

Split a Table

1 ⚡

Split one Excel or CSV file into many — one file or worksheet per value of a column. The file never leaves your browser.

Pivot Table

1 ⚡

Cross-tabulate your own table in the browser: pick rows, columns and a value, and the totals follow. Nothing is uploaded.

Data Overview

1 ⚡

See what is really in a table before you work on it: types, missing values, duplicates, distribution, outliers and correlations. Nothing is uploaded.

Outlier Finder

1 ⚡

See which rows are unusual, not just how many: pick the numeric columns, choose the rule, and export the flagged rows. Nothing is uploaded.

AI Data Insights

3 ⚡

Let AI read your numbers: your browser computes an aggregate summary, you see exactly what will be sent and confirm it, then the model explains it. No cell values leave your browser.

Join Tables

1 ⚡

Pull columns from one table into another by a shared key — the VLOOKUP you always wanted. Both files stay in your browser.

Trend Forecast

1 ⚡

Turn a date column into a forecast: pick a period, choose a method, and see the next periods with a backtest error you can judge. Nothing is uploaded.

Unpivot Table

1 ⚡

Turn a wide table into a long one in your browser: keep the columns that identify a row, flatten the month columns, and export the result.

Transpose Table

1 ⚡

Swap rows and columns in your browser: turn a wide table on its side, preview the result and export it as CSV or Excel. Nothing is uploaded.

Test Data Generator

1 ⚡

Build a realistic test table in your browser: pick the columns and their types, set the row count and a seed, then export CSV or Excel. Nothing is uploaded.

Table Validator

1 ⚡

Check a table against your own rules — required, unique, ranges, patterns, date order — and export the rows that fail. Nothing is uploaded.

Fuzzy Dedupe

1 ⚡

Group near-duplicate rows — the same name written differently — and export one row per group. You confirm each group yourself.

Fuzzy Match

1 ⚡

Match two lists whose names are written differently — pick a column on each side, set a threshold, and get the pairs plus what is left over.

Data Masking

1 ⚡

Mask the personal data in a table before you send it out — names, phones, emails, IDs — and export the masked sheet. Nothing is uploaded.

Table to Markdown

1 ⚡

Turn a table into text you can paste: Markdown, HTML, TSV, SQL inserts, JSON, XML, YAML, LaTeX, INI, TOML, JSON Lines or an ASCII table. Nothing is uploaded.

Text Extractor

1 ⚡

Pull every email address, link, phone number, date, IP and number out of a block of text — in your browser.

CSV Validator

1 ⚡

Check whether a CSV file is really valid: unclosed quotes, rows with the wrong number of columns, duplicate headers. Runs in your browser.

Batch QR Codes

1 ⚡

Turn a column of links, IDs or text into one QR code per row and download the whole batch as a ZIP. Runs in your browser.

CSV Encoding Fixer

1 ⚡

Open a CSV that shows up as garbage, detect its encoding (GBK, Big5, Shift-JIS, Latin-1) and export clean UTF-8 — with a BOM for Excel.

Web Table to CSV

1 ⚡

Paste a web page (or its HTML) and turn any table on it into CSV or Excel — in your browser, without uploading the page.

XML to Table

1 ⚡

Paste an XML file and turn the repeated elements into rows and their children into columns — then export CSV or Excel. Runs in your browser.

Fixed Width to CSV

1 ⚡

Turn COBOL, bank or mainframe exports into CSV or Excel: set the column widths (or detect them) and the fixed-width text becomes a real table.

Big CSV Viewer

1 ⚡

Open a big CSV or TSV in your browser, scroll through hundreds of thousands of rows, search, fix a few cells and export the result.

CSV to SQL

1 ⚡

Turn a spreadsheet into SQL you can run: pick the dialect, the statement type and the table name.

CSV to Text Templates

1 ⚡

Write a header, a per-row line and a footer, and turn your table into arrays, dictionaries, URL queries or any text you need.

CSV to PDF

1 ⚡

Turn a spreadsheet into a PDF you can print: pick the paper size, font size, borders and whether the header repeats on every page.

CSV to Word

1 ⚡

Turn a spreadsheet into an editable Word document: paper size, orientation, font size, borders and a header that repeats on every page.

CSV to Image

1 ⚡

Turn a spreadsheet into a picture you can paste anywhere: pick the font size, colour scheme, borders and zebra stripes.

CSV to Fixed Width

1 ⚡

Turn a spreadsheet into a fixed-width text file: set the column widths, alignment, letter case and optional ASCII borders.

Sankey Diagram Generator

1 ⚡

Turn three columns — where the flow starts, where it goes and how much — into a sankey diagram, then export it as a PNG.

Waterfall Chart Generator

1 ⚡

Turn a list of changes into a waterfall chart — see exactly what moved the total, up or down.

Funnel Chart Generator

1 ⚡

Turn stage counts into a funnel chart, with each step's share of the first stage shown on the chart.

Box Plot Generator

1 ⚡

Compare groups at a glance: quartiles, median and outliers from any table, in your browser.

Bar Chart Race

1 ⚡

Turn three columns — time, name, value — into an animated ranking race you can play and export.

Pareto Chart Generator

1 ⚡

Turn a list of causes or categories into a Pareto chart — sorted bars, a cumulative line and the 80% cut-off.

Heatmap Generator

1 ⚡

Turn three columns — row, column, value — into a heatmap with a colour scale.

Query a Table with SQL

1 ⚡

Run SQL on a CSV or Excel file in your browser: SELECT, WHERE, JOIN and GROUP BY on your own data, then export the result.

Table to GeoJSON & KML

1 ⚡

Turn a table of latitude and longitude into a GeoJSON or KML map file in your browser, with an instant preview and a list of rows that could not be placed.

GeoJSON Viewer & Simplifier

1 ⚡

Paste or upload a GeoJSON file to validate it, preview it on a map, shrink it with Douglas-Peucker simplification, and export it as GeoJSON, KML or CSV.

CSV to Multi-line Data

1 ⚡

Turn a spreadsheet into one record after another with every field on its own line — the shape LDIF, property lists and ticket templates use.

CSV Escape Tool

1 ⚡

Escape text into a valid CSV field, or read a CSV field back into its original value — and see exactly why each quote is there.

SQL to CSV

1 ⚡

Run a SQL script — including a mysqldump file — in your browser and export the result as CSV, JSON, HTML or Markdown.

Table Text to CSV

1 ⚡

Paste a Markdown, LaTeX, MediaWiki or AsciiDoc table and get a real table back, ready to export as CSV, JSON, HTML or Markdown.

YAML to CSV

1 ⚡

Paste a YAML document and get a real table: one row per list item, columns from the keys — ready to export as CSV, JSON, HTML or Markdown.

KML to CSV

1 ⚡

Turn a KML file into a table of points: name, description, longitude, latitude and altitude, ready to export as CSV, JSON or HTML.

HTML Links to CSV

1 ⚡

Turn a page of HTML into a table of its links: the URL, the anchor text and the domain, with filters to keep or drop links by word.

Split Text or CSV

1 ⚡

Split a long text or CSV file into several smaller ones — by lines or by size — and download them as a ZIP.

Table Generator

1 ⚡

Draw a table cell by cell, merge cells, then export it as HTML, Markdown, CSV or any of the other formats.

Frequently asked questions

Do I need an account?
You can browse and read everything without an account. Signing up takes a minute and gives you 3 free credits to run the tools.
Are my files uploaded?
Tools marked as browser-local run entirely on your device — nothing is uploaded. AI tools send only the text or image you submit for that single run.