Ask Your Question
0

How do I merge two separate csv files?

asked 2014-06-14 02:20:53 +0200

mpkettle gravatar image

updated 2014-06-14 15:10:24 +0200

bencomp gravatar image

How to merge 2 separate csv files updated from email

edit retag flag offensive close merge delete

Comments

What do you mean by "updated from email"? Should LibreOffice open the emails and do the work, or is it just files you receive as attachments but handle manually?

bencomp gravatar imagebencomp ( 2014-06-14 15:09:56 +0200 )edit

Received as separate attachments - Thanks

mpkettle gravatar imagempkettle ( 2014-07-02 05:48:33 +0200 )edit

6 Answers

Sort by » oldest newest most voted
0

answered 2016-12-20 10:27:55 +0200

Alexis gravatar image

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!

edit flag offensive delete link more

Comments

What a great program....wonderful thanks!

TSUM gravatar imageTSUM ( 2019-03-14 01:06:51 +0200 )edit
0

answered 2015-06-17 22:42:54 +0200

pbfoobar gravatar image

updated 2015-06-17 22:51:42 +0200

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.

edit flag offensive delete link more
0

answered 2014-06-14 07:57:10 +0200

ROSt52 gravatar image

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

edit flag offensive delete link more

Comments

Please add a link :)

bencomp gravatar imagebencomp ( 2014-06-14 15:07:42 +0200 )edit
0

answered 2014-06-15 13:07:40 +0200

RonJohn gravatar image

updated 2014-06-15 13:11:03 +0200

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.

edit flag offensive delete link more
0

answered 2014-06-14 04:45:13 +0200

mpkettle gravatar image

Obvious solution ! Upload CSV file, select, copy, and paste into file presently in Calc. mpkettle

edit flag offensive delete link more

Comments

What do you mean by "upload"? 'Open in Calc'?

bencomp gravatar imagebencomp ( 2014-06-14 15:11:02 +0200 )edit

Correct - Open ! Thanks

mpkettle gravatar imagempkettle ( 2014-07-02 05:44:41 +0200 )edit
0

answered 2014-06-14 11:15:21 +0200

Lupp gravatar image

updated 2014-06-14 15:37:49 +0200

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.)

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2014-06-14 02:20:53 +0200

Seen: 4,037 times

Last updated: Dec 20 '16