Research brief: CSV or XLSX for a business handover by Hannah StrangeResearch brief: CSV or XLSX for a business handover by Hannah Strange

Research brief: CSV or XLSX for a business handover

Portfolio project
Hannah Strange
Self-initiated, AI-assisted research and writing sample. No client commission. Sources checked on 15 November 2026.
Question A small team needs an editable order review and a file for a third-party import. Should the handover use CSV or XLSX?
Recommendation Keep the editable workbook as the master and create a separate CSV only for the agreed import. This recommendation is my interpretation of the format limitations below. Confirm the destination system’s schema before exporting.
Evidence Microsoft’s text-format guidance says CSV saves only the active sheet and that text formats remove workbook formatting [1]. Its feature-loss reference says CSV contains displayed text and values from the active worksheet, with graphics and other worksheet features lost [2]. A CSV export therefore cannot replace a workbook that needs multiple review tabs or visual formatting.
Suggested handover Deliver the master workbook with a short explanation of its tabs and review flags. Export the required sheet as a separate CSV using the receiving system’s specified column order, delimiter and encoding. Label the files so colleagues know which is the working master and which is an import copy.
Quality check Compare exported headers, row counts and selected values with the agreed source. Check identifiers containing leading zeros in the destination import. Reconcile any agreed totals and keep unresolved records visible. These are proposed checks, not a compatibility test of a particular external system.
Limitations This brief addresses file-format handover only. It does not assess a specific software integration or provide financial advice. Confirm unusual formula, date and encoding requirements against the actual receiving system.
Sources [1] Microsoft Support, Save a workbook to text format (.txt or .csv) https://support.microsoft.com/en-us/excel/save-a-workbook-to-text-format-txt-or-csv [2] Microsoft Support, Excel formatting and features that are not transferred to other file formats https://support.microsoft.com/en-us/excel/excel-formatting-and-features-that-are-not-transferred-to-other-file-formats

0 likes · 0 views · Nov 15, 2026

Source-backed, AI-assisted research sample with a clear recommendation, practical handover checks and limitations.

Tags