Import fictional practice records without losing their meaning

Inspect a tiny CSV sample, compare dates and preserve a working spreadsheet separately.

Create a tiny sample by hand

Make a plain-text exercise with a header and three records: reference, exercise date, description, quantity and training amount. Use fictional references P01, P02 and P03, and write full years in the dates. There should be no customer names or real transactions. For a Zimbabwean learning group, this is a safe way to practise exchanging simple records without circulating somebody’s till data.

Before opening the file in a spreadsheet, count how many columns each row should contain. Choose a consistent separator such as a comma and keep the sample simple. LibreOffice’s CSV documentation explains that text CSV represents rows and fields, and that import settings affect how the content is divided. A file extension alone does not tell you whether every row will be interpreted correctly.

Inspect the import preview

Open the sample using the spreadsheet’s text import process and examine the preview before confirming. Check that the reference, date, description, quantity and amount appear in the intended columns. If all the text lands in one column, investigate the separator rather than manually dragging pieces into place. If one row has extra fields, inspect that row in the original text.

Add a fictional description containing a comma, such as notebook, blue cover, using the quoting conventions supported by your chosen export and import settings. Test whether it stays in one description field. Compare the imported result with the plain-text original. The goal is to see how punctuation affects structure, not to memorise a single setting that you assume works for every system or locale.

Check dates and amounts explicitly

Choose a date that would be ambiguous if shortened, then write it in a clear full-year form in your original sample. After import, inspect how the spreadsheet interpreted it. LibreOffice’s date documentation explains that dates are stored as numerical values and displayed through formatting. A date-looking string and a recognised date value may behave differently when sorted or used in calculations.

Check a training amount with a fractional part and compare the stored value with the displayed value. Locale and import options can affect interpretation, so verify the actual result on your installation. Do not replace a misread amount with a convenient guess. Keep the original text file until the sample has been checked, and document which import settings produced the expected five-column result.

Preserve the exercise and its limits

Compare the number of records and a small control total before and after import. For instance, if fictional quantities are one, two and three, the quantity total should remain six. This catches some structural errors but does not prove every field is correct. Read all three rows individually while the sample is small enough to inspect completely and explain the evidence for your check.

Save an editable spreadsheet copy separately from the original CSV and note what each file is for. Do not assume a plain-text export preserves workbook formulas, formatting and multiple sheets. Record one import problem and how you diagnosed it. The tutorial supports data literacy using invented records; it is not a migration plan for a business system, a fiscal compliance procedure or permission to export private operational data.

Sources & further reading

Use these references to check the underlying guidance and any current local requirements. Practical worksheets and illustrative examples in this guide are original educational material.

  1. LibreOffice Calc: Opening and saving text CSV files
  2. LibreOffice Calc: Date and time functions
  3. LibreOffice Calc: Formatting numbers with decimals

This guide is general information. Source notes are not a claim of independent professional review.