Did you know that a science table can look identical on two screens yet change meaning when it is saved in a different file format? A class may measure plant growth carefully, then accidentally lose a formula or change an observation code during export. The experiment was fine; the data handover was not.
The practical distinction is that CSV and TSV are delimited text formats used to exchange tabular values, while XLSX is an Excel workbook format that can preserve sheets, formulas, charts and formatting. Vocabulary such as export, delimiter, field, workbook and import helps a student select the right file and test whether meaning survived.
A realistic classroom handover
Imagine four fictional Secondary 2 students collecting temperature readings for an experiment. Their spreadsheet has a raw observations sheet, a second sheet calculating daily averages, and a chart. Mei needs to send the teacher the full working file; Irfan needs to send a clean table to a simple graphing tool. They should not automatically choose the same format.
Mei would usually keep an XLSX workbook if the class is using compatible spreadsheet software, because its formulas and chart remain available for inspection. Irfan may export a CSV of the raw table because a separate program needs rows and columns of values. If a text field contains commas that make the exchange inconvenient, a tab-delimited format may be appropriate when both sides support it.
The important word is usually. A program’s import rules may use a different delimiter, regional settings or character encoding. There is no universal guarantee that double-clicking a CSV file will display every value correctly.
Look at the same data three ways
| File type | What it carries well | What to check |
|---|---|---|
| CSV | Rows of plain text data, usually separated by commas | Delimiter, encoding, leading zeros, dates; no workbook charts or formatting |
| TSV | Rows of text with tab-separated fields | Whether the recipient expects tabs and supports .tsv |
| XLSX | Excel workbook structure, multiple sheets, charts, formulas and formatting | Compatibility, sharing permissions, formula behaviour and metadata |
Consider this entirely invented four-row extract: sample_id,temperature_c,observation, then 001,28.4,clear, 002,29.1,cloudy, and 003,28.7,cloudy. The header names each column. The field is one value, such as 28.4. The record is the complete row for sample 001. The sample identifier is a label, not a number to add or average.
If spreadsheet software imports sample 001 as the number 1, the printed table may appear almost right but the identity field has changed. Explicitly treating the identifier column as text during import can preserve leading zeros. Likewise, the text 03/04/2026 may be read as different dates by different settings. For sharing data internationally, agree on a date convention and inspect it after import rather than trusting appearances.
Words that prevent avoidable mistakes
- Save: store the working file; save a copy: make a separate version; export: produce data in a specified outside format.
- Import: bring an external file into a program. It does not mean the source file’s structure will be understood perfectly.
- Delimiter: a character dividing fields, such as a comma or tab; encoding: how characters are represented digitally.
- Formula: a calculation expressed in a spreadsheet cell; value: the data or calculated result that a text export may carry.
- Worksheet: one tab or grid; workbook: the container that may hold several worksheets.
- Validate: check the transferred content against a known reference, not merely glance at the filename.
The surprising mistake: a nicely formatted CSV is still just data
A student colours high readings orange and bolds an important note in the spreadsheet. In XLSX that styling can be part of the workbook. In CSV, the colour and cell formatting are not preserved. Microsoft explicitly warns that exporting to text formats removes formatting and may remove other workbook features. A teacher receiving the CSV may still see the measurements, but not the orange emphasis. If the colour encoded an important category, that category must become an explicit text column instead.
Try the sentence conversion: “The red rows were abnormal.” becomes “Records with status=review need checking.” The second version carries the meaning in the actual values, not in a colour that may disappear. That is an example of semantic preservation—keeping the intended meaning across formats.
A seven-minute verification routine for students
- Make a copy of the source workbook and give it a descriptive name including the experiment and date.
- Identify what the receiver actually needs: raw values, formulas, charts or several sheets.
- Export a small test file in the requested format. Open it in a different program, not just the one that created it.
- Compare number of rows and columns, units, blank values, leading zeros, unusual punctuation and date formats.
- Check at least two ordinary records and one edge case, such as a missing reading or a comma in an observation.
- Record in a note which file is the editable source and which is the exchange copy.
For Primary Science, a parent can simplify this to a hand-drawn table with column headers and units. Older students can apply it to fieldwork, school surveys, coding activities and eventually workplace reporting. Reading a column correctly is part of literacy as much as data handling.
How this connects to Science, Mathematics and language
Mathematics depends on keeping numbers attached to the correct units and categories. Science requires observations to remain traceable. English matters when students write headers, describe limitations and explain the difference between missing, zero and not measured. The same precise word can prevent a technical error across all three subjects.
For related, non-competing background, read eduKateSG’s article on timestamps, sampling intervals and missing sensor data; that page teaches what time-based observations mean, while this article covers how a table changes during file exchange. You can also follow the vocabulary learning route to practise terms across contexts.
Questions parents and teachers can ask
Does a CSV contain a chart? No, it stores text values and delimiters, not the workbook’s chart object. Recreate the chart from the data if needed.
Does a TSV file always end in .tsv? No. Some software writes tab-delimited text with the extension .txt. Check its actual format and the receiving program’s expectations.
Is XLSX always better? Not when a tool needs a simple, documented data interchange file or cannot read a workbook. Match the format to the recipient and verify it.
The best habit is to read the file type as an instruction about what may be preserved. A small check before submission can save a large argument about whose numbers are correct.
Verified references
- Microsoft: save a workbook to text or CSV—limitations when exporting.
- Microsoft: import or export text files—commas, tabs and delimiters.