Skip to content
DocDesk

XLSX · CSV

Clean an Excel or CSV spreadsheet

Trim spaces, remove blank and duplicate rows, then check the resulting table before downloading an XLSX file.

Step by step

  1. Attach the XLSX or CSV file in Document Studio. Use the first row for column headers.
  2. Send the cleaning request. Expand the result table and check that distinct records are still present.
  3. Ask for table statistics on the previous result to check row counts and numeric totals. Download the processed workbook using Download Excel.

A prompt to try

Clean the table: trim whitespace, remove empty rows and deduplicate entire rows.

What to keep in mind

Deduplication compares whole rows after trimming. The same item with a different quantity stays in the table. Formulas use cached values. Save legacy XLS as XLSX before uploading.

Open workspaceSee formats and limits