calc - import multiple csv files

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?

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.

1 Like

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

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