Keeping Only the Columns You Need
Key points
- Choose the CSV
- Choose "Pick columns"
- Enter the column numbers
With Merge and Split CSV Files you can keep only the columns you need, such as name and address.
Steps
- Choose the CSV
- Choose "Pick columns"
- Enter numbers like "1,3,5-7" and save
Columns are counted from the left (1 is the leftmost).
Use "Merge, Split and Pick Columns from CSV" (free)
Tools that go well with this
- Convert CSV and JSON: Convert between CSV and JSON instantly.
- Convert CSV to Excel (.xlsx): Convert a CSV to an Excel (.xlsx) file.
- Convert Text Encoding (Fix Garbled Text): Convert text files between Shift_JIS, UTF-8, EUC-JP and more to fix garbled text.