Loading tool…

Preparing the browser-side workspace

Loading Datio workspace…

Preparing the browser-side engine

Herramienta • Transformar y filtrar

Transformar y filtrar

Modifica y filtra tus datos con potentes transformaciones locales.

Carga un conjunto para transformar

Sube un CSV o Excel para empezar a transformar.

Aceptados:.csv.tsv.xlsx.xlsMáx. 5 MB

100% en memoria del navegador

Acerca de esta herramienta y cómo usarla

Acerca de esta herramienta

Transform & Filter is a lightweight CSV filter for quick column edits and row filtering. Pick one column and apply UPPERCASE, lowercase, Title Case, Trim Whitespace, or Trim & UPPERCASE, or filter rows with a case-insensitive search that keeps any row containing the value in any cell.

Column transforms: case changes and whitespace trim
Row filter: case-insensitive substring match across cells
Live preview of the first 50 rows
CSV export of the result

¿Para quién es?

Useful for quick normalization jobs — for example, uppercasing a status column — and for narrowing a file to the rows you actually need before profiling or charting.

Cómo usarla

Choose a CSV, TSV, TXT, or Excel (.xlsx, .xls) file (up to 5 MB).
Select a column, choose a transform, and choose Apply Transform.
Type a filter value and choose Filter to keep only matching rows.
Export the result as CSV, or choose Clear to return to the full preview.

Ejemplo

customer,status,total
Alice,paid,120
Bob,pending,80
Cara,PAID,45
filter: paid → Alice + Cara (case-insensitive)

Filtering for “paid” keeps matching rows from any column:

Formatos y flujo

Accepted: .csv, .tsv, .txt, or Excel (.xlsx, .xls); everything runs locally in memory.
Transforms apply to the selected column only; filtering scans all cells.
Export: CSV download of the transformed or filtered rows.

Use this after an initial clean for targeted fixes, then verify quality or build a chart from the filtered result. Limpiador CSV, Analizador, Visualizador.

Preguntas comunes

How do I filter CSV rows online?

Load the file in Datio's Transform & Filter, type the value, and choose Filter. Matching is a case-insensitive substring search across every cell, so “berlin” keeps any row containing Berlin in any column. Export the filtered rows as CSV.

How do I uppercase a CSV column?

Select the column, choose UPPERCASE (or Trim & UPPERCASE to also strip padding), and choose Apply Transform. Lowercase, Title Case, and Trim Whitespace work the same way — one column at a time, previewed before export.

Can I filter by number ranges or combine conditions?

No — filtering is a simple contains-match on text, not numeric ranges, regex, or multi-condition queries. For whole-file fixes like deduplication and blank-row removal, use the CSV Cleaner instead.

Transform & Filter or CSV Cleaner — what's the difference?

Transform & Filter edits one selected column and narrows rows by search value. The CSV Cleaner fixes the whole file at once: exact-duplicate removal, blank-row removal, all-cell trimming, and casing — with diagnostic counts. Use the Cleaner for file-wide cleanup and this tool for targeted tweaks. Limpiador CSV →

Limitaciones

One column transform at a time, and filtering is a simple contains-match — not numeric ranges, regex, or multi-condition queries. For whole-file deduplication and blank-row removal, use the CSV Cleaner.

Herramientas y guías relacionadas