How do I merge two separate csv files?

edit

I often had the same problem so i decided to write a little php site which does the job. You can find it at http://merge-csv.com. Any feedback is welcome!

None of these provide a simple way to do the requested function. Even very old ms excel provides this functionality.

As long as you are doing extra work, it's probably easiest to just do it with the shell.

For example, in windows you can say

copy *.csv allfiles.csv

or, in unix, you can use 'cat' similarly.

Then, import the combined file to calc.

Of course, that assumes that all the csv files have consistent formatting and columns.

see also my answer in your other question about combining csv-files in Calc.

Open both documents. (We will call them A & B.) Open a new document. Go to document A. "Select All" and "Copy". Go back to the new document. "Paste" Go to document B."Select All" and "Copy". Go back to the new document. "Paste".

Viola: merged documents.

Might 'Insert Sheet' > 'From file' > (BROWSE csv-file) 'OK'> (set import specifics) 'OK'

meet your needs?

(See also my answer to your other recent question. Now inserted here.)