Topic hub

Spreadsheet file formats and open datasets

Pick XLSX to keep formulas and formatting, ODS if you work in LibreOffice, and CSV when a program will read the data. The table compares what each format keeps and how large the same workbook becomes. Below it: public datasets with their sources, plus guides and answers on opening, converting and citing them.

How do the five formats compare?

FormatWhat it keepsMedian size vs XLSXOpens in
XLSXFormulas, formatting, all tabs1.0× (median 15.6 KB)Excel, Google Sheets, LibreOffice Calc, Numbers
ODSFormulas, formatting, all tabs0.77×LibreOffice Calc natively; Excel and Google Sheets open it
CSVValues only; one file per tab, zipped0.26×Any text editor, database or script
XML (Excel 2003)Formulas and formatting, all tabs; no tab colours5.7×Excel and older tools; one plain-text file
NumbersValues only, all tabs6.7×Numbers on Mac, iPad and iPhone

Sizes: median over 54 workbooks, written by Sheet Reserve’s own browser writers and measured 9 Oct 2026. How the benchmark was run.

Which examples help you learn spreadsheet formulas?

Change the inputs in a worked example and follow the calculations. All formula examples.

TemplateSpreadsheet skills

AVERAGEIFS conditional mean worked example

Learn conditional averaging by computing unit price per order and using AVERAGEIFS to average order amounts for one selected category.

2 tabs · 187 formulas

TemplateSpreadsheet skills

Budget variance formula worked example

Learn amount and percentage variance formulas for an expense budget, with explicit treatment of a zero budget.

2 tabs · 186 formulas

TemplateSpreadsheet skills

Date and deadline formula example

Learn calendar-date subtraction and completion-aware overdue formulas using a fixed review date.

2 tabs · 186 formulas

TemplateSpreadsheet skills

INDEX MATCH price lookup example

Learn exact-match lookup by retrieving a price from a small product table using a selected SKU.

2 tabs · 127 formulas

TemplateSpreadsheet skills

Min-max normalization formula example

Learn how to clamp raw observations between lower and upper bounds and normalize them onto a zero-to-one hundred percent scale.

2 tabs · 247 formulas

TemplateSpreadsheet skills

SUMIFS sales summary worked example

Learn conditional summation by calculating order amounts and a sales total for one selected region.

2 tabs · 127 formulas

TemplateSpreadsheet skills

Text cleanup formula worked example

Learn TRIM, UPPER, LOWER, and LEN by preparing names and reference codes while preserving the original text.

2 tabs · 306 formulas

TemplateSpreadsheet skills

VLOOKUP exact-match worked example

Learn exact VLOOKUP by retrieving a department allowance from a keyed table with missing and duplicate-key checks.

2 tabs · 127 formulas

TemplateSpreadsheet skills

Weighted average formula example

Learn weighted averages by calculating each observation’s value times its weight and dividing the total by total weight.

2 tabs · 127 formulas

Which public datasets are on the shelf?

DatasetWater

Freshwater withdrawals by country

Freshwater withdrawals by sector, renewable resources and water stress for 186 countries, from the World Bank and FAO AQUASTAT.

5 tabs · 1,348 formulas

DatasetEconomy

GDP by country, 1990-2025

GDP, GDP per capita and growth for 217 countries and territories, 1990-2025, from the World Bank.

7 tabs · 889 formulas

Every dataset keeps its original units and names its source and licence. See Data sources and licences.

Which free tools convert spreadsheet files in the browser?

15 tools to convert, inspect, and prepare data on your own device, with nothing uploaded.

  • CSV to XLSX

    CSV in · XLSX outTurn a CSV, TSV or semicolon-separated file into an Excel .xlsx workbook in your browser. Numbers stay numbers, leading zeros stay text, nothing is uploaded.
  • XLSX to CSV

    XLSX in · CSV or ZIP outConvert an Excel .xlsx workbook to CSV in your browser. Each sheet becomes its own CSV, formulas are written as their last result, and nothing is uploaded.
  • CSV to JSON

    CSV in · JSON outConvert CSV to JSON in your browser: an array of objects or of arrays, numbers typed, no sign-up and no upload. Copy the preview or download the .json file.
  • Delimiter converter

    CSV in · CSV outChange a CSV delimiter between comma, semicolon, tab and pipe, and fix the file Excel opens in one column. Runs in your browser; nothing is uploaded.
  • Leading zeros

    CSV in · XLSX outStop Excel dropping the zeros in ZIP codes, account numbers and IDs. Convert a CSV to .xlsx with the columns you choose written as text. Free, in your browser.
  • JSON to CSV

    JSON in · CSV outConvert a JSON array of objects or arrays into CSV. Preview columns, preserve leading-zero strings, and download locally with no account or upload.
  • JSON to XLSX

    JSON in · XLSX outConvert flat JSON records to an Excel XLSX workbook in your browser. Preview the table, keep leading-zero IDs as text, and download without uploading.
  • Remove duplicate rows

    CSV in · CSV outRemove duplicate CSV rows while keeping the first occurrence and the header. Choose exact or case-insensitive comparison. Free, local, and no upload.
  • Trim and remove blank rows

    CSV in · CSV outTrim leading and trailing spaces in CSV fields and remove empty rows. Preview the result and keep IDs as text. Runs on your device with no upload.
  • Transpose rows and columns

    CSV in · CSV outTranspose CSV rows into columns and columns into rows. Preview the rotated table and download a new CSV locally. No sign-up or file upload required.
  • CSV to Markdown

    CSV in · Markdown outTurn CSV into a Markdown table for documentation. Escape pipe characters, preserve line breaks, and preview the source. Free and entirely in your browser.
  • Profile CSV columns

    CSV in · profile CSV outInspect CSV columns for empty cells, distinct values, numeric counts, minimum, maximum, and mean. Download a column profile with no upload or sign-up.
  • Sort CSV rows

    CSV in · CSV outSort CSV records by a column, as text or numbers, in ascending or descending order. Keep the header and tied-row order. Free, local, and no upload.
  • Split a CSV file

    CSV in · ZIP of CSVs outSplit a CSV into smaller files by row count, repeating the header in each part. Download a ZIP locally with no sign-up or upload. Quoted fields stay intact.
  • Escape formula-like fields

    CSV in · CSV outPrefix CSV fields starting with formula-like characters with an apostrophe. Preview changed fields before import. Runs in your browser without uploading.

All free spreadsheet tools

Which guides explain formats, formulas and data?

What do people ask about spreadsheet files and data?

Formats

Spreadsheet skills

Open data