Excel Tools

Work with Excel/CSV files: add columns, formulas, charts, clean messy data, convert formats.

excel spreadsheet csv data-cleaning

When to use

Use when opening, reading, editing, or fixing an existing .xlsx, .xlsm, .csv, or .tsv file. Also use for creating a new spreadsheet from scratch or from other data sources, and converting between tabular file formats. The deliverable must be a spreadsheet file.

Examples

Clean a messy CSV

Fix formatting issues in a data export

Clean this messy CSV export. Fix the date formats, remove duplicates, and standardize the phone number column.

Add formulas

Add calculated columns to a spreadsheet

Add a column to this spreadsheet that calculates 90-day rolling average revenue. Use the existing date and revenue columns.

Create a spreadsheet from data

Build a structured Excel file from raw data

Create an Excel sales tracker from this JSON data. Include a summary sheet with totals and a chart of revenue by month.