Online CSV Editor & TSV Editor Online — Keep Leading Zeros & Original Bytes
Opening a CSV in traditional spreadsheet software often strips leading zeros from 00123, corrupts 18-digit order or account IDs into 1.23E+17, and rewrites dates or character encodings without asking. XJY’s online CSV editor and TSV editor online treats every field as exact text while highlighting data types with intuitive background colors — 100% locally in your browser with no file uploads.
Why use XJY as your CSV editor online
-
Zero silent type coercion (keeps
00123& 18-digit IDs): Leading-zero codes (00108), 64-bit numeric IDs, SKUs, dates and whitespace stay exactly as written. Unchanged rows are written back byte for byte. -
Semantic color-coding & sticky index column: The sticky row-number column (
#) is highlighted clearly, while cells are tinted for text (including leading-zero codes), canonical numbers, booleans, ISO dates and empty cells so you can spot malformed data at a glance. - Preserves encoding, BOM & CRLF/LF line endings: Automatically detects UTF-8, UTF-8 with BOM, UTF-16LE/BE and GBK/GB18030 with an instant encoding preview, and saves files back with their original encoding and line endings.
- Filter, find & replace, and 36 assisted batch-edit rules: Filter rows by column, search and replace across cells, insert or remove rows and columns, or make three similar edits in a column to automatically batch-transform the rest.
-
Convert CSV to XLSX, TSV, JSON, XML or YAML: Export your CSV to an Excel
.xlsxworkbook with text cells preserved so leading zeros stay intact even when opened in Microsoft Excel.
XJY Online CSV Editor vs. opening CSV in Excel
| Scenario | XJY Online CSV Editor | Opening CSV Directly in Excel |
|---|---|---|
Leading zeros (00123, ZIP codes, SKUs) |
Preserved as exact text (00123) |
Silently stripped to 123 |
| Long numbers (16–20 digit IDs / tracking numbers) | Preserved with full digit precision | Truncated to 15 digits & shown as 1.23E+17 |
Date-like strings (1-2, 2026/01) |
Kept exactly as written | Auto-converted into localized dates (Jan-2) |
| Original encoding (UTF-8, UTF-16, GBK) & CRLF | Detected with preview & preserved on save | Often overwritten or garbled without BOM |
Frequently asked questions (FAQ)
- How do I edit a CSV file online without losing leading zeros or corrupting long numbers?
-
Open your file in the XJY Online CSV Editor. Every cell is stored and edited as exact text rather than being coerced into floating-point numbers, so
00123and 18-digit identifiers are never altered. PressCtrl+Sin Edge or Chrome (or use the Windows right-click helper) to write straight back to disk. - How can I fix garbled characters (encoding issues) when opening a CSV online?
- Click “Parse settings” in the CSV toolbar to preview and switch between UTF-8, UTF-8 with BOM, UTF-16LE, UTF-16BE and GBK/GB18030, as well as comma, tab, semicolon or pipe delimiters.
- Can I convert a CSV to an Excel (.xlsx) file without Excel stripping leading zeros?
-
Yes. Click “Convert and export…” and choose
.xlsx. XJY Editor writes every CSV field as an explicit Excel text cell so Microsoft Excel preserves all leading zeros and long digits when opening the exported workbook. See CSV help for more details.