LibreOffice Calc learning centre
LibreOffice Calc Tutorials and Troubleshooting
Learn how to solve specific Calc problems with tested formulas, small practice datasets, and clear procedures. Start with CSV import issues, then explore formulas and data-cleanup workflows. These lessons complement the LibreOffice function A–Z directory.
New to the software? Begin with CSV files opening in one column or COUNTIF returning zero. Each tutorial links to the relevant official help documentation.
15 practical tutorials
CSV import
Fix CSV Files Opening in One Column in LibreOffice CalcChoose the right CSV delimiter in LibreOffice Calc, fix files opening in one column, and check quoted commas before importing.Beginner · LibreOffice Calc
Fix Garbled CSV Accents and Encoding in LibreOffice CalcRepair garbled UTF-8 CSV text in LibreOffice Calc. Choose the proper character encoding and confirm accented text during import.Beginner · LibreOffice Calc
Keep Leading Zeros in LibreOffice Calc CSV ImportsStop LibreOffice Calc from deleting leading zeros in CSV product codes, account identifiers and SKUs by setting import columns to text.Beginner · LibreOffice Calc
Stop CSV Codes Turning into Dates in LibreOffice CalcPrevent codes such as 03-04 from turning into dates when importing CSV into LibreOffice Calc, without losing the original text.Beginner · LibreOffice Calc
Data cleanup
Convert Text Dates into Real Dates in LibreOffice CalcConvert imported date text into usable LibreOffice Calc dates with DATEVALUE and ISO date examples. Avoid ambiguous date formats.Intermediate · LibreOffice Calc
Extract Numbers from Text Using REGEX in LibreOffice CalcExtract invoice IDs and numeric values from mixed text using the LibreOffice Calc REGEX function, including handling no-match cases.Intermediate · LibreOffice Calc
Fix Numbers Stored as Text in LibreOffice CalcConvert text numbers into values LibreOffice Calc can calculate using VALUE and ISNUMBER, while preserving codes with leading zeros.Beginner · LibreOffice Calc
Remove Duplicate Values in LibreOffice CalcRemove duplicate values in LibreOffice Calc with Standard Filter, No duplications and a copy-to destination.Beginner · LibreOffice Calc
Split Text into Columns in LibreOffice CalcSplit names, IDs and delimited values into columns using LibreOffice Calc Text to Columns, without overwriting important data.Beginner · LibreOffice Calc
Formula troubleshooting
Absolute and Relative Cell References in LibreOffice CalcUnderstand A1, $A$1, A$1 and $A1 in LibreOffice Calc. Copy formulas safely and lock the right parts of a reference.Beginner · LibreOffice Calc
Count Dates Between Two Dates with COUNTIFS in CalcUse COUNTIFS and DATE in LibreOffice Calc to count dates in a range, including dates with times and full calendar months.Intermediate · LibreOffice Calc
Fix LibreOffice Calc Err:502 (Invalid Argument)Understand LibreOffice Calc Err:502 and fix invalid function arguments, including mismatched COUNTIFS range sizes with tested examples.Intermediate · LibreOffice Calc
Fix LibreOffice Calc Err:509 (Missing Operator)Fix LibreOffice Calc Err:509 using examples of missing multiplication operators and malformed arithmetic formulas.Beginner · LibreOffice Calc
LibreOffice COUNTIF Returns Zero: Troubleshooting GuideFix COUNTIF returning zero despite matching cells in LibreOffice Calc. Check ranges, types, criteria, spaces and wildcard settings.Intermediate · LibreOffice Calc