Insert header in a csv file with command line Windows

Question

I have a .csv file with some data, for example:

a | b | c | d | e
f | g | h | i | f

I would like to insert a header in this file to indicate each field:

h1 | h2 | h3 | h4 | h5
a | b | c | d | e
f | g | h | i | l

I would like to do it from the Windows command line, how can I do?

Stephan Bauer · Accepted Answer · 2022-09-08 12:21:37Z

3

First, write the header to a new text file (escape the pipe symbol | using ^)

echo h1 ^| h2 ^| h3 ^| h4 ^| h5 > combined.csv

Then append the original file to this newly created file:

type originalfile.csv >> combined.csv

At last, you overwrite the original file with the content of the new file (including the header line)

type combined.csv > originalfile.csv
--or--
move /Y combined.csv originalfile.csv

answered Sep 8, 2022 at 12:12

Stephan Bauer

9,2565 gold badges39 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

aborruso · Accepted Answer · 2022-09-09 09:54:00Z

1

You can use Miller and run

mlr --csv --implicit-csv-header --fs "|" label h1,h2,h3,h4,h5 input.csv

to have

h1|h2|h3|h4|h5
a|b|c|d|e
f|g|h|i|f

answered Sep 9, 2022 at 9:54

aborruso

5,8723 gold badges27 silver badges49 bronze badges