Bandika taarifa za CREATE TABLE + INSERT, hariri data ndani, kisha pakua faili ya.xlsx iliyo tayari kufunguliwa. Uchanganuzi wote hufanyika kwenye kivinjari chako — SQL yako haitoki kifaa chako.
MySQL, PostgreSQL na SQLite CREATE TABLE / INSERT zote zinachanganuliwa kwa usahihi. Vitambulishi vinaweza kufungwa katika backticks, nukuu mbili au mabano ya mraba. INSERT ya safu nyingi (VALUES (...), (...), (...)) inasaidiwa.
Hapana. Uchanganuzi na uzalishaji wa.xlsx vyote vinafanyika kabisa ndani ya kivinjari chako kupitia JavaScript. Faili inayotokana huhifadhiwa moja kwa moja kwenye kifaa chako.
Bofya seli yoyote kuhariri · Tab kusogea · Enter kushuka · Esc kughairi
Haraka, faragha, bila usakinishaji — geuza dampo za SQL kuwa kitabu cha kazi cha Excel tayari kufunguliwa.
Karatasi moja kwa kila jedwali lengwa la CREATE TABLE / INSERT. Majina ya nguzo hutoka CREATE TABLE, au yanatafsiriwa kutoka orodha ya nguzo za INSERT.
Hutoa faili halisi ya Office Open XML.xlsx. Hufunguka vizuri katika Excel, Numbers, LibreOffice na Google Sheets.
Uchanganuzi wote na uzalishaji wa kitabu cha kazi hufanyika kwenye kivinjari chako. SQL yako haipakiwi kamwe kwenye seva zetu.
Nambari zinabaki nambari (zilizopangwa kulia), booleans zinabaki booleans, NULL inabaki tupu, herufi zinabaki maandishi. Hakuna ubadilishaji wa kimya kuwa tarehe.
Huelewa sintaksia ya MySQL, PostgreSQL na SQLite: backticks, vitambulishi vya nukuu mbili, herufi zilizotorokwa, INSERT ya safu nyingi.
Bofya seli yoyote kuhariri data kabla ya kupakua. Ongeza au futa safu na nguzo, badilisha majina ya vichwa, na ondoa safu tupu — yote kwenye kivinjari chako.
Parse INSERT statements client-side, build a real.xlsx file in your browser.
Paste any combination of CREATE TABLE and INSERT INTO statements from MySQL, PostgreSQL, or SQLite dumps. Our parser handles multi-row inserts, escaped quotes, NULL values, dates, numerics, and binary BLOBs (rendered as Base64 strings).
Once parsed, the data appears in a spreadsheet-style grid. Edit any cell, add or delete rows, rename columns. Changes are kept in browser memory — no server round-trip per edit, no "saving..." delay.
When you click download, we use SheetJS (xlsx.js) to construct an Office Open XML .xlsx file directly in JavaScript. Each table becomes a separate worksheet. The file is bit-identical to one Excel itself would produce.
The Blob is saved via a virtual <a download> click. Open it in Excel, Google Sheets, Numbers — anything that reads.xlsx. The data path was: SQL paste → JS memory →.xlsx Blob → download. No server, no log, no upload.
When you need data in a spreadsheet, fast.
A non-technical colleague needs the latest customer list as an Excel file. Run your SQL query, paste the results, get an.xlsx. No need to build an export feature, no compliance review for sending the data through a third-party tool.
Open a mysqldump file from a backup, find the relevant tables, see their content as readable rows. Often easier than spinning up a sandbox database.
Move a small table from one system to another by routing through.xlsx. Edit the data on the way (rename columns, add fields, fix typos) before re-importing.
Engineer pastes a customer's row from the database into the tool to debug a reported issue, with the data never leaving their laptop. The customer's row was sensitive — making sure it stays sensitive matters.
Database dumps usually contain real customer information — names, emails, addresses, sometimes hashed passwords or financial data. Most online SQL converters ask you to upload the file, which is exactly the wrong thing to do with PII. iKit parses everything in your browser, so the data never leaves your machine.
Mafunzo ya kina na ulinganishaji wa zana kutoka blogu ya iKit.
MySQL, PostgreSQL na SQLite CREATE TABLE / INSERT zote zinachanganuliwa kwa usahihi. Vitambulishi vinaweza kufungwa katika backticks, nukuu mbili au mabano ya mraba. INSERT ya safu nyingi (VALUES (...), (...), (...)) inasaidiwa.
Hapana. Uchanganuzi na uzalishaji wa.xlsx vyote vinafanyika kabisa ndani ya kivinjari chako kupitia JavaScript. Faili inayotokana huhifadhiwa moja kwa moja kwenye kifaa chako.
Hakuna kikomo kigumu cha upande wa seva. Kwa vitendo, vivinjari vya kisasa hushughulikia makumi elfu ya safu kwa urahisi. Kwa dampo za megabaiti nyingi zana ya CLI kawaida ni haraka zaidi.
Ndiyo. Ikiwa CREATE TABLE iko, tunatumia majina yake ya nguzo. Ikiwa INSERT INTO... (col1, col2) VALUES... tu iko, tunatumia majina hayo ya nguzo. Ikiwa INSERT haina orodha ya nguzo tunarudi kwa col1, col2 …
Hapana. Muhuri wa muda kama '2024-01-05 10:12:33' unasafirishwa kama maandishi rahisi ili kuepuka ubadilishaji wa otomatiki wa Excel. Katika Excel, chagua nguzo na tumia Format Cells → Date ikiwa unataka aina ya asili.