Spreadsheets

Purpose

Build and repair spreadsheets, including the ones that arrive with headers on row 7, merged cells, and three tables on one sheet. Most spreadsheet work is cleaning, not computing.

When to Use

• Creating a spreadsheet from data.
• Reading or extracting data from an existing workbook.
• Cleaning a messy file into something a machine can read.
• Adding formulas, formatting, or charts.
• Converting between tabular formats.

Capabilities