No data rows yet - type into the row marked ＋ or paste cells from a spreadsheet.
The CSV Editor shows the raw CSV and the table side by side. Edit a cell in the table and the editor changes exactly that field in the text - the other quotes, the separator and the line endings stay as they were. A click in the table shows the field in the text, and the cursor in the text shows its cell. That makes it quick to fix exports from shops, banks and databases, clean up address lists, or prepare data for import.
Everything runs in your browser. Files are not uploaded, there is no sign-up and no advertising.
Type into cells, move with the arrow keys and Tab, copy and paste ranges from and to Excel, LibreOffice or Google Sheets, add, delete and move rows and columns.
Comma, semicolon, tab or pipe as separator, detected by itself; with or without a header row; UTF-8 with or without BOM and Windows-1252; Windows and Unix line endings are kept.
Rows with a different number of fields, quotes that are never closed, empty and repeated column names - listed with their line, one click away.
Sort and filter the view without touching the file, or sort the data itself. The column panel shows the kind of values, empty and different ones, sum and average.
The table only draws the rows you see: files with 100 000 rows stay quick to scroll, filter and edit.
Excel workbook (XLSX), JSON, Markdown and HTML tables, TSV, or CSV with another separator and encoding - with protection against spreadsheet formulas.
Any https page (and localhost) can embed the editor with an <iframe> and ?embed=1 - no sign-up, no key. Embedded, the editor hides this text and shows a Save button. There are two ways to get the table in and out.
src= opens a file (your server must allow CORS), webhook= makes "Save" (Ctrl+S) send the document to that address. Add &token=… for an Authorization: Bearer … header and &auto to save after every change.
<iframe src="https://csv.giit.ch/?embed=1&src=https://your-site.com/data/products.csv&webhook=https://your-site.com/save.php"
allow="clipboard-write" style="width:100%;height:800px;border:0"></iframe>The webhook gets a POST with JSON { editor: "csv", event: "save", id, name, content, updated }. A small PHP script that stores it:
<?php
header('Access-Control-Allow-Origin: https://csv.giit.ch');
header('Access-Control-Allow-Headers: Content-Type, Authorization');
header('Access-Control-Allow-Methods: POST, OPTIONS');
if ($_SERVER['REQUEST_METHOD'] === 'OPTIONS') exit;
if (($_SERVER['HTTP_AUTHORIZATION'] ?? '') !== 'Bearer SECRET') { http_response_code(403); exit; }
$d = json_decode(file_get_contents('php://input'), true);
$name = preg_replace('/[^\w\- ]/u', '_', $d['name']);
file_put_contents(__DIR__ . "/data/$name.csv", $d['content']);
echo '{"ok":true}';The editor says csveditor:ready, your page answers with csveditor:load, the editor reports csveditor:loaded, csveditor:change on real edits and csveditor:save when the user saves. Your page may send csveditor:get (the current state) or csveditor:save (press Save). Saving then goes through your own login and session.
<iframe id="ed" src="https://csv.giit.ch/?embed=1" allow="clipboard-write" style="width:100%;height:800px;border:0"></iframe>
<script>
const ed = document.getElementById('ed');
const ORIGIN = 'https://csv.giit.ch';
addEventListener('message', async e => {
if (e.source !== ed.contentWindow || e.origin !== ORIGIN) return;
const m = e.data;
if (m.type === 'csveditor:ready') { // the editor is ready: hand it the document
ed.contentWindow.postMessage({
type: 'csveditor:load',
name: 'Products',
content: await (await fetch('/data/products.csv')).text()
}, ORIGIN);
}
if (m.type === 'csveditor:change') document.title = '● not saved'; // a real edit
if (m.type === 'csveditor:save') { // the user clicked "Save"
await fetch('/api/save', { method: 'POST', headers: { 'Content-Type': 'application/json' },
body: JSON.stringify({ name: m.name, content: m.content }) });
document.title = 'Saved';
}
});
// A save button on your own page: the answer comes as csveditor:save
function saveNow() { ed.contentWindow.postMessage({ type: 'csveditor:get' }, ORIGIN); }
</script>AI Assistant inside your page: it works in the frame too. With allow="clipboard-write" on the iframe, "Copy prompt" uses the clipboard directly (otherwise the editor falls back to the old copy command, or shows the prompt to copy by hand). A link the AI sends cannot reach an editor inside another website, so the editor tells the AI and the user to paste the AI's whole answer into the editor instead - or open the editor in a window of its own.
window.open("https://csv.giit.ch/?embed=window", "csveditor-17") opens the full editor in its own window and speaks the same messages with window.opener. Links from an AI reach it there. csveditor:load may also carry context: { host, title, rules } - the AI prompt then says where the document belongs and follows your rules - and hook: { url, token }, a webhook for this document only that is never stored. Closing the window with unsaved changes sends csveditor:closing.
Hand the editor your own prompt, an address on your site and a key for this editor session. The AI dialog then shows "Connected to" your site, what you tell the AI, and the choice change the current document or make a new one; Copy prompt puts it all together. The AI posts its result with the key to your server, and your page opens it in the editor - a new document opens separately and stays in the user's browser. One key per editor session: it stays valid while the editor is open, and only while it has none the editor asks for it with csveditor:key-request. The editor never sends the key itself and never stores it; the address must be https on your own host or a subdomain of it.
const key = async () => (await fetch('/api/ai-key.php?doc=17')).json(); // one key per editor session
const k = await key();
ed.contentWindow.postMessage({ type: 'csveditor:load', name: 'Products', content, ai: {
label: 'My Site', prompt: 'Keep the column names. Prices in CHF.',
endpoint: 'https://your-site.com/api/ai-result.php', key: k.key } }, ORIGIN);
// remember the id from csveditor:loaded and ignore change/save/closing with another id
// only while the editor has no key:
if (m.type === 'csveditor:key-request') { const k = await key(); ed.contentWindow.postMessage({ type: 'csveditor:ai', key: k.key }, ORIGIN); }
// while the editor is open, tell your server every minute; closing the editor or the page voids the key
setInterval(() => fetch('/api/ai-key.php?alive=' + k.key.slice(0, 8)), 60000);
// your server has a result (polling, SSE …): target is "current" or "new"
ed.contentWindow.postMessage({ type: 'csveditor:load', name: 'Products', content: draft, from: 'ai', target }, ORIGIN);Make keys with at least 128 random bits, store only their hash, bind each to the logged-in user, the document and this editor session, make one per session, keep it valid only while your page reports the session as open, and void it when the editor or the page closes.
The whole protocol is in llms.txt - give it to an AI and it builds the connection for your system. The other giit editors work the same way with their own prefix, for example the LaTeX Editor with latexeditor: - latex.giit.ch.
No. The editor runs entirely in your browser. Your files are never sent to a server, unless you set up a webhook to your own server yourself.
Only that cell. The editor writes the change into the CSV text exactly where the field is and leaves the rest as it was: the other quotes, the separator and the line endings stay. A field is put in quotes only when it needs them.
Yes. The editor detects comma, semicolon, tab and pipe as separator; you can also choose it under Format. Convert turns the file into another separator.
Export it as XLSX, or download the CSV with a byte order mark (BOM) - tick it under Format or choose "UTF-8 with BOM" in the export. Excel then reads UTF-8 correctly.
Yes. The table only draws the rows you see, so files with 100 000 rows stay quick to scroll, filter and edit.
Only in your browser. Click the folder button at the top left (My documents) to open, rename, duplicate, download or delete them. Clearing your browser's site data removes them, so download the ones you want to keep - or let the editor send them to your own server ("Save to server"). Very large files may not fit into the browser's storage; the editor tells you when that happens.
Yes, any AI - ChatGPT, Claude, Gemini, Copilot or the AI in your coding tool. Click "AI Assistant", then "Copy prompt", paste it into your AI and say what it should do. The AI answers with a link; click it and the table appears in your editor. "Undo" takes every change back.
No. The editor is free, without ads and without sign-up.