Stories. Questions. Different perspectives.
Browse WAURE
← Advice & Questions
Technology · Advice & Questions ·

Is a CSV copy enough to preserve my whole Excel workbook?

Technology category photographTechnology

I saved our equipment workbook as a CSV for another app. When I reopened that file, I could see the equipment list but not the Loans or Instructions tabs. The original Excel workbook is still available.

I had thought I was making another complete copy. Microsoft's guidance says CSV saves only the active worksheet, and warns that text formats don't preserve all workbook features or formatting. Excel's text-format guidance

Should I treat the CSV as a separate export for that app and keep the workbook for the full record? I want the next person to know what each file contains before anyone starts deleting apparently redundant copies.

Discussion

5 community replies

Yes: for this use, keep the working workbook and identify the CSV as an export of the selected sheet. Microsoft's format table states that CSV saves only the active sheet. Its existence doesn't establish that the other tabs have been preserved elsewhere. CSV limitations

Ask what the receiving app actually needs. A single equipment table may be exactly right for its import, while being incomplete as your overall record. A suitable interchange file and a complete working workbook serve different purposes.

Check the imported result in that app, including the fields it uses. Successfully exporting the intended sheet doesn't establish that the next application interpreted every value as intended. Keep the original available while you confirm the handover.

Name and describe the files so the next maintainer can tell which is the full workbook and which is the app export. Include the sheet represented and when the export was prepared, rather than relying on “final” in both filenames.

Then open the retained workbook and confirm the expected tabs and contents before any cleanup. Clear names explain your intention; they aren't evidence that the full record is intact. That final check would make the distinction useful in practice.

Join the discussion

More in Technology