CSV-rensare

Rensa, förhandsgranska och exportera CSV-data.

Importalternativ

Preview

Klistra in eller ladda upp CSV för att se rensade data.

Rader: 0

Operations

Kolumnnummer börjar på 1. Åtgärder körs uppifrån och ned; numren gäller det aktuella steget.

Omvandling av värden och datum är av från början. Normalisering ändrar även 1/0 till true/false.

  • Remove leading and trailing spaces from cells.
  • Choose case style and deduplicate header names.
  • Tar bara bort helt tomma rader och kolumner.
  • Select columns to treat as a unique key.
  • Tar bort BOM; felaktiga citattecken rapporteras utan gissningar.
  • yes/no → true/false; NA/null → empty or explicit null.
  • Omvandlar tidsstämplar med uttrycklig tidsförskjutning till UTC. Datum utan tid samt tvetydiga och ogiltiga värden bevaras.
  • Infer int/float/bool/date/string per column.
  • Literal or regex across columns.
  • Split by delimiter or merge with a template.
  • Hide or reorder columns before export.
  • See row errors with reasons and export a report.
Issues
Row
Col
Reason
Sample
—
Export

CSV-rensare

Clean and normalize your CSV files with our powerful data processing tool. Remove duplicates, fix encoding issues, normalize headers, and validate data integrity. Perfect for data migration, ETL processes, and database imports with reliability.

Funktioner

  • Client-side CSV cleaning; privacy-first (no uploads)
  • Header normalization, trimming, empty row/column removal
  • Deduplication by keys, value normalization, dates and types
  • Virtualized preview with Issues report export
  • Export with custom delimiter, LF/CRLF, and encoding

Hur man använder

  1. Drop or paste your CSV in the input area.
  2. Check delimiter, encoding, and whether the first row has headers.
  3. Toggle any operations you need under the Operations tab.
  4. Click Clean CSV to process in your browser.
  5. Review the Preview and Issues tabs; download the issues report if needed.
  6. Export the cleaned CSV with your preferred delimiter, line endings, and encoding.

Vanliga frågor

Do you upload my CSV?

No. All processing happens locally in your browser; nothing is sent to a server.

How are delimiter and encoding detected?

Delimiter is inferred from sample frequency/consistency; encoding uses BOM heuristics with UTF‑8 default. You can override both.

Will the output work with Excel?

Yes. Choose CRLF line endings and Windows‑1252 or UTF‑8 as needed; you can also include headers.

Can it fix quotes and BOM?

Tar bort BOM; felaktiga citattecken rapporteras utan gissningar.