Ask Your Question

Large CSV File (Multi-Tabs) - Multi Sheet

asked 2015-02-05 21:30:47 +0100

Sledjunkie gravatar image

I was merging 3 large files CSV with roughly 4000 rows and 600 columns

I copied all three documents into one WorkBook - so I had 3 tabs and could just bounce between them.

After a full days work, I went to save and it would not save the work and all it said was it could only save 1 sheet.

I wasnt sure what was going and I do not know how to save my entire workbook.

Can you tell me how to do that please? I have lost all my work and need all these together

Any input?

edit retag flag offensive close merge delete



Save your file as .ODS file which can handle many sheets, formatting, formulae etc.

Rugslug gravatar imageRugslug ( 2015-02-05 21:40:35 +0100 )edit

A CSV file can by definition save only 1 sheet - Please follow the advice of @Rugslug.

ROSt52 gravatar imageROSt52 ( 2015-02-06 07:32:03 +0100 )edit

2 Answers

Sort by » oldest newest most voted

answered 2018-06-28 13:17:09 +0100

erAck gravatar image

Repeating the comment by @Rugslug (credits to him/her) as answer:

You are attempting to save a multi-sheet file as .csv (probably stemming from importing one .csv file), save as .ods instead.

edit flag offensive delete link more

answered 2018-06-28 12:29:58 +0100

My wish is to be able to open / view a CSV-file that comes from an another application. Sometimes it is possible to load all rows from the CSV file to LO Calc, other times an error message occurs. (Do not know if it has with OS or with LibreOffice version to do) If the content of the cells is to be handled with formulas, Calc becomes quite slowly... (But it is an another "problem" :-) )

edit flag offensive delete link more


Your "three wishes" may be spent, in specific those you would need a Jinn to grant them. Also:
This is not an answer. Please use add a comment for comments.
"...other times an error message occurs." Please quote error messages exactly!
"But it is an another problem." Yes, and therefor it should be posted in another thread (if at all).
What do you expect to happen here?
Ask a question like: What can be the reason if an attempt to open/import a csv with Calc fails with the message ...?

Lupp gravatar imageLupp ( 2018-06-28 12:54:46 +0100 )edit

This is not an answer to the question (and Ask is also not a forum software to post arbitrary things unrelated to the original question). If you have a different question then please create a different question (and if you mention "error message" then at least state the error message)). It would be best if you deleted your answer here.

erAck gravatar imageerAck ( 2018-06-28 12:56:43 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-02-05 21:30:47 +0100

Seen: 497 times

Last updated: Jun 28 '18