Skip to content

Free CSV Repair Tool & Excel Export

Fix CSV formatting issues, preserve leading zeros and IDs, preview repairs, and export Excel-ready XLSX files.

Drop a CSV file to inspect and repair

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

Start with a sample

Each sample shows a common Excel problem. All samples are fictional.

No file openPress Ctrl K (⌘ K on Mac) for commands Processed in your browser

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

Why Excel changes CSV values.

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.

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.

Long IDs lose digits

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.

Codes turn into dates

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.

Everything lands in one column

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

Fix your CSV. Keep your data intact.

  1. 01

    Inspect

    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.

  2. 02

    Repair with a preview

    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.

  3. 03

    Export what Excel expects

    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.

Formula-like cells are flagged, never run.

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.

When “café” turns into “café”.

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

What this tool won’t do.

  • Recover lost data. If zeros or digits were removed before the file reached you, only the source system has them.
  • Open workbooks or PDFs. It reads CSV, TSV and delimited text, optionally inside a .gz or single-file .zip. XLSX, XLS, PDF and images are refused with an explanation.
  • Guess your intent. Types, padding lengths, date formats and row removals are suggestions until you apply them, and every applied step can be undone.
  • Keep your work. Your data isn’t stored after you close the tab. Export the repaired file, and save a recipe (column rules only) if you repeat the same cleanup every week.

RELATED GUIDES

Go deeper on CSV and Excel problems.

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

CSV repair FAQ.

Why did Excel remove the zeros from my ZIP codes?

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.

Why does my CSV open in one column?

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.

Can this tool recover zeros that are already gone?

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.

Are my files uploaded to ByteVerse?

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.

What is the largest file I can use?

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.

Why should I export XLSX instead of CSV?

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.

What is formula injection in a spreadsheet?

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.

Why is a 16-digit ID showing up as 5.43E+15?

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.