Leading zeros disappear
ZIP codes, employee numbers and SKUs such as 02115 or 000123 become 2115 and 123. CSV Studio flags these columns and protects them as text.
Fix CSV formatting issues, preserve leading zeros and IDs, preview repairs, and export Excel-ready XLSX files.
CSV or delimited TXT. Processed in your browser.
Or press Ctrl V anywhere on this page to paste a table.
Up to 25 MB100,000 rows500 columns.csv .tsv .txt .gz .zip
Each sample shows a common Excel problem. All samples are fictional.
Processed in your browserFiles are processed in your browser. ByteVerse does not receive your spreadsheet contents in this tool’s normal workflow.
Your original stays untouchedRepairs change a working copy with undo and a change log. The file on your device is never modified.
Lost zeros can’t be restoredIf leading zeros are already missing from the file you uploaded, this tool cannot invent them.
WHERE CSV DATA GETS DAMAGED
A CSV file stores text and nothing else. When Excel opens one directly, it guesses a type for every value. Most guesses are right; the wrong ones quietly change identifiers. Microsoft documents this behavior in its guide to keeping leading zeros and large numbers.
ZIP codes, employee numbers and SKUs such as 02115 or 000123 become 2115 and 123. CSV Studio flags these columns and protects them as text.
Excel keeps 15 significant digits. A 20-digit account number turns into 4.00012E+19, and the digits after the 15th become zeros. Text cells keep every digit.
Values like 1/2, Mar-26 or 3-4 can become dates. CSV Studio marks date-like text and only writes real dates when you choose a date type and format.
A semicolon file on a comma system, or a tab file named .csv, opens as one long column. The detector checks which delimiter splits rows consistently and tells you why.
HOW CSV STUDIO WORKS
Drop a file and CSV Studio reads its encoding, delimiter, quotes and line endings, then checks every column. Each finding says what is wrong, where it is, and what fixing it would change.
Trim spaces, rebuild header names, remove blank or duplicate rows, split and merge columns, or find and replace. Every repair shows before and after values first, and every step can be undone.
The XLSX export writes text and ID columns as text cells, and numbers or dates as typed cells only in columns you set to those types. It then reads the workbook back to verify it before the download starts.
Spreadsheet apps can treat a cell that begins with =, +, - or @ as a formula. A crafted value can pull data from other cells or prompt a warning that people click through. OWASP describes this as CSV injection.
CSV Studio lists every formula-like cell. The XLSX export stores all cells as values, so nothing is written as a formula. The spreadsheet-safe CSV option prefixes those cells with an apostrophe while leaving signed numbers like -12.50 alone. That reduces risk, but no CSV setting is safe in every spreadsheet app.
CSV files don’t record their encoding. A UTF-8 file read as Windows-1252 shows é instead of é; the reverse shows �. CSV Studio checks the byte-order mark and whether the bytes are valid UTF-8, then explains what it found.
When it can’t be sure, the Encoding Lab decodes the same original bytes several ways side by side, so you pick the version where names and currency symbols read correctly. Choosing one re-reads the original bytes; nothing is guessed silently.
HONEST LIMITS
RELATED GUIDES
Comparing two exports instead of repairing one? Use the CSV diff checker to match rows by ID. Starting from an API response? Convert it with JSON to CSV, then repair the result here.
QUESTIONS
A CSV file is plain text with no column types, so Excel guesses. A value like 02115 looks like a number, so Excel stores 2115. CSV Studio flags columns with leading zeros, lets you keep them as text, and writes them as text cells in the XLSX export so they open as 02115.
Excel splits a CSV using your system’s list separator. A semicolon file opened on a comma system, or the reverse, lands in a single column. CSV Studio detects the delimiter by checking which character splits the rows consistently and explains its choice. Exporting XLSX avoids the separator problem entirely.
No. If leading zeros are already missing from the file you uploaded, this tool cannot invent them. When you know the correct fixed length, such as five-digit ZIP codes, you can pad digit-only values to that length yourself and review every change before applying it.
No. Files are processed in your browser. ByteVerse does not receive your spreadsheet contents in this tool’s normal workflow. The page loads like any website, but this tool page does not load ads, analytics or the site chat, and saved recipes keep column rules only, never cell values.
Up to 25 MB of text (after unpacking a .gz or .zip), 100,000 data rows, 500 columns and 5 million cells. A single field can hold up to 1 million characters, but an Excel cell holds at most 32,767, so longer values must be shortened before an XLSX export. Files over 5 MB can feel slow on phones.
An XLSX file stores each cell’s type. Text columns stay text, so leading zeros, long IDs and date-like codes open exactly as shown. A CSV has no types, so Excel guesses again every time it opens the file. The XLSX export also adds a frozen header, filters, and optional sheets for the validation summary and applied changes.
Cells that begin with =, +, - or @ can be run as formulas when a CSV is opened in a spreadsheet, and a crafted formula can leak data or trigger warnings users click through. CSV Studio flags formula-like cells. The XLSX export writes every cell as a value, never a formula. The spreadsheet-safe CSV option adds an apostrophe, which helps but is not a universal guarantee.
Excel keeps numbers to 15 significant digits and shows large ones in scientific notation, so digits after the 15th become zeros. If your file already contains 5.43E+15, the original digits are gone and only the source system can supply them. For intact IDs, keep the column as text and export XLSX.
Built by ByteVerse. CSV parsing follows RFC 4180 conventions, with clear reports where real files break them. No claim of recovering lost data or certifying spreadsheet safety. Privacy details.
Compare CSV exports by ID or composite key. Review changed cells, catch duplicate keys and save local CSV or JSON reports without uploads.
Convert JSON or JSON Lines to CSV locally: choose rows, flatten nested fields, expand one array and preview columns with formula-risk protection.
Extract summary fields from selectable-text invoice PDFs, review each invoice and export XLSX or CSV locally. No OCR.
Format, validate and minify JSON with syntax error feedback and adjustable indentation.