This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](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(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
i Have a raw report extracted from website saved in csv file format
when i have inserted pivot table on the that csv file and saved it .
when i tried to reopen the saved csv file the original raw data is missing and pivot table appears to be normal table .
can this be resolved and show me both the raw data and the pivot table
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
This is because CSV files is a plain text file and only can store one sheet in it.
To avoid losing your raw data, you can save your file as an Excel workbook (.xlsx). This will allow you to keep both the pivot table and the raw data in separate files.