Create a spreadsheet

Define the table first, then create and review a spreadsheet from source files.

Create a spreadsheet when information from one or more files needs to become rows and columns you can check. Define the table before asking Kuse to extract data.

Define rows, columns, and rules

Describe what one row represents, list the required columns, and say how missing or conflicting values should appear. Include a source column when the table needs to be audited later.

Select the files and generate

Choose Excel in New Task when it is visible, select the relevant files, and submit the table specification. Clean .xlsx and .csv files are easier to process than heavily formatted or very large spreadsheets.

Define the columns and missing-value rule, generate the spreadsheet, then open the result for review.

Review exceptions before totals

Open the result and check several rows against their sources. Review missing values, duplicates, and normalization decisions before using totals or charts.

Edit and save the workbook

Open a supported spreadsheet in the office editor to change cells, formulas, and formatting. Wait for saving to finish, then reopen or download the file and verify key formulas and totals. CSV files contain a single table: saving as CSV does not preserve multiple sheets or workbook styling. Use XLSX when those features matter.

If the preview fails, retry when the action is available or download the original. See file version history before restoring an earlier result.

Continue learning