SmartQueryTools

Manage Columns in YAML Files Online

Drop or select specific columns from YAML files directly in your browser. No upload required.

How to manage Columns in YAML files

  1. Drop your file onto the upload area. Every column is listed as a chip with its detected type, and all are selected to start with.
  2. Click a chip to deselect a column you want to drop. It turns grey with a line through it. Click again to bring it back.
  3. Use Deselect all and then click the few columns you need when you only want to keep a handful.
  4. Click Apply to preview the result, then Download to save it in the same format you uploaded.

Your file is processed locally in your browser and is never uploaded. The free limit is 50 MB per file; larger files work if your device has the memory for them.

Worked example

An HR analyst needs to send a headcount list to a facilities team, without salary or national ID numbers.

Input (YAML)

- emp_id: 2041
  name: Maria Keane
  dept: Finance
  salary: 68000
  national_id: KX 44 91 02 C
- emp_id: 2042
  name: Dev Patel
  dept: Operations
  salary: 54500
  national_id: LM 20 17 88 A
- emp_id: 2043
  name: Sofia Brandt
  dept: Finance
  salary: 71200
  national_id: PR 63 05 19 D

Settings

  • Deselected: salary, national_id
  • Kept: emp_id, name, dept

Result

emp_idnamedept
2041Maria KeaneFinance
2042Dev PatelOperations
2043Sofia BrandtFinance

The two sensitive columns are removed entirely, not blanked, so they are absent from the downloaded file. The three kept columns stay in their original left-to-right order with their original types. Every row is kept, and no values change.

Frequently Asked Questions

Can I reorder columns with this tool?

No. Kept columns stay in their original left-to-right order. To change the order, use the SQL Query tool and list the columns in the order you want.

Does selecting columns change any values or types?

No. Kept columns are copied exactly, with the same types. Only the dropped columns are removed.

Can I drop every column?

No. At least one column must stay selected, and Apply is disabled until one is.

Related Tools