Did you know that a spreadsheet can look perfectly correct when you save it, yet lose the calculations that produced its answers? This happens when a class workbook is exported as a CSV file and then treated as though it were the original Excel workbook. The visible numbers may survive; the machinery behind them may not.
The answer is that CSV is a plain-text table format, not an Excel workbook format. In a typical Excel CSV export, the active worksheet’s displayed values are written as separated text, while live formulas, workbook formatting and additional worksheets are not preserved in that CSV. Keep an .xlsx copy if you need formulas or multiple sheets to remain editable.
Quick summary: identify whether you need a working workbook or a shareable table; keep the original .xlsx; export only the intended sheet to .csv; inspect the exported values and headers; and reopen both files separately before deleting anything.
Why the saved numbers can fool a careful student
A workbook is more than a rectangle of text. It may contain formulas, named ranges, validation rules, charts, formatting and several worksheets. A CSV file is intended to move tabular values between systems that agree on a text representation. It has no native concept of multiple Excel sheets or a formula engine. A value that once depended on another cell can become a fixed piece of text when exported.
Microsoft’s guide to Excel file-format limitations states that CSV saves text and values from the active worksheet and does not carry the other workbook features. Its file-format guide confirms the active-sheet limitation. These details matter when pupils share class results or teachers prepare sample datasets.
The subtle trap is that a CSV can still be opened in Excel. Seeing it in the Excel window does not restore the original formulas. The application used to view a file and the actual format of that file are different things.
Worked example: the total stops updating
Imagine a fictional homework spreadsheet on a computer. The sheet called Scores has columns A: Name, B: Test 1, C: Test 2 and D: Total. Row 2 contains Mira, 18, 22 and cell D2 contains =B2+C2. The correct total shown is 40 marks. Row 3 contains Ben, 14, 20; =B3+C3 displays 34 marks. These are invented examples, not actual pupils or their outcomes.
The original workbook also contains a second sheet named Notes, holding an explanation of how the scores were obtained. The teacher selects Scores and exports to CSV. In its ordinary value-display mode, the CSV data are equivalent to Mira,18,22,40 and Ben,14,20,34, with the column headings above. The number 40 is there; the instruction =B2+C2 is no longer an active formula in that exported file. The Notes sheet is absent.
Now reopen that CSV, change Mira’s Test 1 mark from 18 to 19 and inspect Total. The old 40 does not automatically become 41, because there is no longer a linked formula. In the retained workbook, by contrast, 19+22=41 would update D2 to 41. This simple comparison diagnoses the difference between a stored result and a live computation.
A six-step recovery method that protects student data
- 1. Stop overwriting. Make a copy of the current file. If the original
.xlsxexists, preserve it unchanged. - 2. Inspect the extension. Look at the actual filename and file type, not just whether an Excel window opens.
- 3. Inspect a formula cell. In the workbook, select the cell and look for a formula such as
=B2+C2in the formula bar. In the exported CSV, the cell normally contains the saved result. - 4. Check every worksheet. Count the workbook’s tabs before export. A CSV export represents a single worksheet, not the whole set.
- 5. Compare five sample rows. Check a heading, a number, a decimal, a blank cell and a row containing commas or quotations. Do not trust appearance alone.
- 6. Choose the correct deliverable. Send
.xlsxif the recipient needs recalculation, notes or multiple sheets. Send CSV only when they need a plain tabular exchange file.
Excel may display warnings when saving to a format that does not support workbook features. Read those warnings, but verify the file yourself. A warning dismissed in a hurry is not proof that a backup was made.
Diagnose the misunderstanding before doing more exercises
Ask the learner, ‘If I change 18 to 19, where will the total change automatically—and why?’ A child who answers ‘both, because both open in Excel’ is confusing a viewer with a file’s stored structure. A child who answers ‘the workbook, because the cell still contains an addition rule’ is identifying the mechanism.
A second diagnostic is to ask which of these is a result and which is an instruction: 40 versus =B2+C2. Students need to be able to say that both can display 40 under the right data, but only the latter continues to calculate when the inputs change.
The teacher should also ask what happens to the Notes sheet. If the learner assumes ‘Save As’ always copies the entire file in its former shape, show the two tabs in the workbook and the one-table export side by side.
From guided practice to independent checking
Guided: two numbers and one formula
Create a temporary workbook on dummy data only. Put 8 in B2, 12 in C2 and =B2+C2 in D2. Predict 20. Export the active sheet to CSV, reopen that CSV, and compare the formula bars. State what happened in one complete sentence: ‘The displayed value survived but the formula did not.’
Paired: add a second worksheet
Make a second sheet called Method and write ‘Total equals Test 1 plus Test 2’. Export while Scores is active. Ask a partner to find that sentence in the CSV. They cannot, because the second sheet was not part of the table export. Discuss whether the correct answer is to send an Excel workbook or two separate CSV tables.
Independent: choose the right file for three tasks
- A teacher wants colleagues to edit formulas and see them recalculate. Choose an XLSX workbook.
- A student needs to upload a single roster of fictional identifiers and numbers to a system that explicitly requests CSV. Choose the verified CSV export.
- A parent wants to inspect the explanation sheet as well as totals. Choose the original workbook or an appropriate shared read-only representation.
For an extra challenge, show the learner two files with identical visible totals but different formula bars. Ask which one they would trust for further editing and what evidence they would collect. The success criterion is not memorising ‘CSV bad’; it is selecting a format that matches the task and checking what was preserved.
What families and teachers can watch for
A helpful sign of progress is that the student names the format before sending the file, knows which original copy is authoritative, and verifies at least one calculation and one additional tab. The child should be able to explain why a CSV is useful for simple data exchange and insufficient for a multi-sheet calculating workbook.
For teachers, a clear assignment instruction could be: ‘Submit the editable XLSX workbook and, separately, a CSV export of the Scores sheet.’ For a class project, use fictional identifiers when demonstrating a technique, and follow school data-handling rules when working with genuine records. Do not upload class data to unfamiliar conversion sites.
Limitations and special cases
CSV implementations and spreadsheet import settings vary. Delimiters, decimal separators, character encodings, date conversion and automatic number interpretation can cause additional changes even when formulas are not involved. A CSV itself is not inherently corrupt; the problem is expecting it to preserve features it does not represent.
There is also a special display-mode nuance: when Excel shows formulas instead of their calculated results at export, its documentation notes that formula-looking strings may be exported as text. That is not the same as retaining functioning Excel formulas. A copied string that begins with an equals sign must not be assumed to be a live calculation.
Frequently asked questions
Can a CSV contain more than one worksheet?
No, not as Excel worksheet tabs within one ordinary CSV. Export each required table separately, or preserve multiple sheets in a workbook.
Can I get the original formula back from the exported number?
Not reliably. Many different formulas can yield the same result. Retrieve a saved workbook, version history or a known legitimate formula; do not invent one and claim it was recovered.
Should I avoid CSV entirely?
No. CSV is useful for exchanging simple tables with software that requests that format. Just do not mistake an export for a full fidelity backup.
Why did my student code change after reopening?
A spreadsheet program may automatically interpret a numeric-looking identifier as a number. Import identifier fields deliberately as text and compare them to the original source before continuing.
Learning that transfers to other tools
This lesson is about a distinction every learner meets: a displayed answer is not its underlying process. Once students learn to check file structure and formulas, the same discipline helps them test copied graphs, exported presentations and other digital schoolwork.
For adjacent lessons, see why Excel SUM can ignore numbers stored as text and how to preserve leading zeros in school codes. Explore the eduKate Education Hub and the immutable Clementi mathematics learning reference for diagnosis-first explanation, progressive practice and independent checking.