Limpeza CSV

Limpe, visualize e exporte dados CSV.

Opções de importação

Preview

Cole ou carregue CSV para ver a prévia limpa.

Linhas: 0

Operations

A numeração começa em 1. As operações seguem de cima para baixo; os números referem-se à etapa atual.

A conversão de valores e datas começa desativada. Normalizar valores também converte 1/0 em true/false.

  • Remove leading and trailing spaces from cells.
  • Choose case style and deduplicate header names.
  • Remove apenas linhas e colunas totalmente vazias.
  • Select columns to treat as a unique key.
  • Remove BOM; aspas inválidas são indicadas sem adivinhação.
  • yes/no → true/false; NA/null → empty or explicit null.
  • Converte para UTC datas com hora e deslocamento explícito. Datas sem hora e valores ambíguos ou inválidos são preservados.
  • 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

Limpeza CSV

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.

Recursos

  • 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

Como usar

  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.

Perguntas Frequentes

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?

Remove BOM; aspas inválidas são indicadas sem adivinhação.