3,915 questions
CSV file do not support multiple worksheets. When saving a workbook as a CSV file, the warning says to save each sheet in its own CSV file.
Excel - loosing data from the CSV file
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(179.20000000000002, 48%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFB%3C/text%3E%3C/svg%3E)
Filip B
0
Reputation points
When opening the CSV file, one of the tabs disappeared. It looks like CSV can lose a random tab in the file, although saved ones. Thoughts? I have tried: Mac, latest version A loss of data from the CSV file: The entire tab within Excel was deleted. via (pound)TMPDIR got into TemporaryItems no file there No TimeMachine backup. iCloud doesn't offer previous file versions. The file doesn't offer previous versions (files - Browse Version History,it's grey )
Microsoft 365 and Office | Excel | For business | Windows
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(172.8, 53%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
Barry Schwarz 3,746 Reputation points2024-01-12T19:10:13.58+00:00 When you say tab, do you mean worksheet?
-
Filip B 0 Reputation points
2024-01-14T11:52:42.5+00:00 Yes, sheet / worksheet!
-
Filip B 0 Reputation points
2024-01-14T11:53:15.38+00:00 Yes, sheet / worksheet.
-
Emi Zhang-MSFT 30,046 Reputation points Microsoft External Staff2024-01-15T02:40:05.4+00:00 Hi, Just checking in to see if the information was helpful. Please let us know if you would like further assistance. If the response is helpful, please click "Accept Answer" and upvote it.
-
Filip B 0 Reputation points
2024-01-15T20:42:35.9666667+00:00 I need further assistance.
Sign in to comment
2 answers
Sort by: Most helpful
-
Barry Schwarz 3,746 Reputation points
2024-01-14T18:07:40.5766667+00:00 -
Filip B 0 Reputation points
2024-01-15T20:43:55.8133333+00:00 Ah... How do I get the data back? (opening a previous version of the file - Mac)
Sign in to comment -
-
Olaf Helper 47,441 Reputation points2024-01-15T20:58:14.8133333+00:00 When opening the CSV file, one of the tabs disappeared
A CSV is one text file, it can not have multiple "sheets", that's impossible by design.