Ask Your Question
0

calc - import multiple csv files

asked 2016-11-06 13:09:14 +0200

DiesNuts gravatar image

I have a large number of .csv files that I want to import into one .ods file - each into its own sheet.

(No fancy value extraction or reordering of columns or any such, just import as is.)

How do I do that?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2016-11-06 13:35:00 +0200

m.a.riosv gravatar image

With version 5.1 or above:

Menu/Sheet/Insert sheet from file,
remember to mark the link option, if you want to have the option for update, when the csv is modified. It adds a new sheet, and must be done one by one.

edit flag offensive delete link more

Comments

I was assuming that "large number of .csv files" would make it ample clear that I'm not looking for a way to insert them "one by one".

DiesNuts gravatar imageDiesNuts ( 2016-11-06 13:45:08 +0200 )edit

Then maybe this thread on AOo forum can help Multiple import csv/txt to Calc - save as ods

m.a.riosv gravatar imagem.a.riosv ( 2016-11-06 15:31:10 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-11-06 13:09:14 +0200

Seen: 4,219 times

Last updated: Nov 06 '16