Ask Your Question

Large CSV File (Multi-Tabs) - Multi Sheet

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

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 +0200 )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 +0200 )edit

1 Answer

Sort by » oldest newest most voted

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

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
Login/Signup to Answer

Question Tools

1 follower


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

Seen: 552 times

Last updated: Jun 28 '18