CSV Kit Notes Tips and Examples

Illustrated infographic summarizing: CSV Kit Notes Tips and Examples

Nice thing to use when working with CSV-files is CSV Kit.

See the file statistics: csvstat -e UTF-16 test.csv

Merge all files in a folder: csvstack -e UTF-16 -t *.csv > all.csv

Save column 2 to output .csv: csvcut -c 2 -e UTF-8 all.csv > output.csv

Remove duplicates:

Sort the file first: sort -n output.csv > sorted.csv

Save only unique values: uniq -u sorted.csv > unique.csv

 

 

 

 

 

Importing CSV data with text content

  • Replace \" with ".
  • Replace line breaks with empty space: ^$ with "".
  • Use pipes "|" as field separator.
  • Build your own text field with concat strings.

Latest articles

Teamtailor is phasing out Riminder on 21 November 2026. Check your parser settings, contact fields and integrations, and make sure you have a process for deleting applicant data.

WordPress jobs running late? Learn how to separate scheduling problems, task errors and a growing backlog, then choose the right scheduler or runner.

Before changing an AI workflow, check that it still does the job. Use realistic examples, clear release criteria and a comparison with the version running today.

Sending an invoice does not mean it has arrived. Understand delivery statuses, the system requirements coming in 2027, and how focused AI support can help finance teams handle errors and follow-up.

Before scaling AI content, check the pages you already have. Verify claims, resolve overlapping coverage, and give WordPress reviewers control over publication.

Build a refund approval workflow in n8n and Stripe that shows reviewers the exact action, expires old approvals and tracks refunds through to completion.

A timeout can hide a successful job creation. Use stable operation IDs, destination API rules and a clear recovery process to prevent duplicate work.

Does your ChatGPT subscription cover website translation? Understand API credits, access and a WordPress workflow that turns approved Danish content into translation drafts.

An internal AI can keep quoting a deleted policy. Check document updates, indexed passages and cached answers to find where outdated guidance survives.

Codex drew all ten pages of my Ninjai comic from the script Claude wrote in the first test. What made that handover work, and what it cost.