Header

How to Merge Multiple CSVs into a Single File

Here's an ultra-easy solution to the challenge of merging multiple CSV files into a single file. I'm on a Mac OSX and used Terminal or iTerm

  1. Move all the CSV files into the same folder
  2. Open Terminal or iTerm or your favourite command-line app
  3. cd path-to-the-csv-folder 
  4. cat *.csv > ../result.csv 

This combines all your CSVs into result.csv

In my case, I needed to combine around 140 CSVs and this method took seconds.

The merged file will have multiple records of the headers from each of your CSVs. If you need to clean this up, open result.csv with your favourite text editor and use search and replace.

 

How to make hyperlinks work…

How to make hyperlinks work when exporting InDesign to a PDF If you've added hyperlinks…

Custom Aspect Videos with…

How to Insert Custom Aspect Ratio Videos with Elementor Video Widget At this time…

Test Internet Explorer and…

Cross-browser testing on Mac OSX: Emulate Internet Explorer, Android and Window phones…

Track WordPress Contact Form…

How to Track WordPress Contact Form 7 (CF7) form submission with Google Tag Manager (GTM)…

Configure MX for a subdomain…

How to Configure MX records for a subdomain on ProtonMail If you are configuring a…

Joomla error "1030 - Got…

Joomla error "1030 - Got error 28 from storage engine" If you get this Joomla 1030 error…

Sublime shortcut to wrap…

Sublime shortcut to wrap selected text in a tag This is a super-useful Sublime shortcut…

How to enable GA enhanced…

How to enable GA enhanced link attribution in GTM Enabling enhanced link attribution in…

Optimising images and…

Optimising images and reducing file sizes It's sometimes difficult to create fast loading…

How to fix microdata or…

How to fix microdata or structured data errors in Joomla Microdata or Structured Data was…

Joomla error 500 - Unable to…

Joomla error 500 - Unable to load renderer class If you get a Joomla error 500 - Unable…

Using system font stack for a…

Using system font stack for a website This is an interesting idea that I'm seeing more…

How to open winmail.dat files…

How to open winmail.dat files on Mac OSX If you are on Mac OSX, you may occasionally…

CSS wildcard selectors with…

How to use wildcard CSS selectors with LESS If you are using LESS and need to use a…

How to fix a missing Admin…

How to fix a missing Admin Toolbar at the top of a WordPress page Working on an a…

How to add a CiviCRM…

How to add a CiviCRM extension to Joomla As you probably know, CiviCRM comes bundled with…

How to configure MailGun and…

How to configure MailGun and Google Business Apps in CiviCRM When configuring SMTP mail…

Warning JUser: :_load:…

Joomla Warning JUser: :_load: Unable to load user with ID: 62 If you see a Joomla warning…

How to prevent duplicate URLs…

How to prevent duplicate URLs with sh404SEF If you use sh404SEF and can't solve problems…

What is the 'Itemid' in a…

What is the 'Itemid' in a Joomla URL? If you examine the non-SEF url of a typical page on…

JLIB_APPLICATION_ERROR_COMPONE…

After upgrading from Joomla 3.5 to Joomla 3.6.0 I suddenly got a…

How to Launch Sublime Text…

How to Launch Sublime Text from Terminal or iTerm in OSX I've been working a lot with…

Customise a Joomla template…

How to customise a Joomla template based on article ID Working on a custom Joomla…

2013 - The Year of Responsive…

2013 -The Year of Responsive Web Design Some trends come and go. Others gather momentum…
No Internet Connection