Ask Your Question
0

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

Comments

2

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
0

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

Stats

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

Seen: 552 times

Last updated: Jun 28 '18