Which boundary does Microsoft document?

Microsoft's support page explains that CSV saves displayed text and values from the active worksheet and loses formatting, graphics, objects and other worksheet content. If cells are displaying formulas, those formulas become text. This is not preservation of a functioning multi-sheet workbook.

Returnables Agency is independent and is not affiliated with Microsoft. Check the actual Excel version, CSV variant and recipient import requirements. This guide does not override a tender's prescribed file format or recommend sending extra files without permission.

Sources: Microsoft: Microsoft Support: Excel formatting and features not transferred to other formats

What should the delivery-format check record?

Keep the approved native source unchanged while preparing the required output. Identify the sheet and cells intended for the recipient rather than assume that a successful Save operation exported every tab.

What should the delivery-format check record?
Deliverable featureNative source evidenceCSV check
WorksheetsRequired sheet list and revisionWhich single active sheet was exported?
CalculationApproved formulas and reviewed resultsAre exported values current and correct?
PresentationApproved notes and formattingWhich meaning relies on appearance?
AttachmentsRequired embedded or linked evidenceWhat is absent from the text export?
Text encodingActual recipient requirementDo identifiers and characters survive?
ReleaseApproved format and submission listIs the intended file actually selected?

How can a correct-looking export omit required evidence?

Illustrative example. A fictional tender workbook contains three tabs: Price, Assumptions and Evidence. The operator exports Price to CSV. Its rows and totals look correct, but that file does not contain the two other worksheets or the native workbook's calculation behaviour.

The reviewer checks the authority's required submission format and resolves the missing evidence through the permitted process. Renaming the CSV extension to XLSX does not restore omitted worksheets. A separate snapshot of values may be appropriate only where the actual instructions allow it.

How should the released file be checked?

Reopen the actual output using the intended import settings and compare its fields with the approved source. Confirm row and column boundaries, significant identifiers, special characters and reviewed totals. Retain the source revision and export decision together.

CSV conversion is not a confidentiality or redaction process. Review the actual content for authorised disclosure and select only the files the tender instructions require.

Common questions

What else should the bid team know?

Does CSV retain every workbook tab?

No. Confirm the active sheet and actual output.

Does a formula written as text retain workbook calculation behaviour?

No. Text and a functioning workbook formula are different.

Should every tender receive both CSV and XLSX?

Only where its actual instructions permit or require those files.

Primary sources

  1. Microsoft Support: Excel formatting and features not transferred to other formatsMicrosoft