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