When you combine exports, the same record can appear several times. That can inflate a row count or distort a total. SheetCommand removes later copies of rows whose values match across every column, while keeping the first occurrence.
What counts as a duplicate?
The command compares complete rows. If two rows have the same Product, Price, and Stock values, one is removed. If their product names match but their prices differ, both rows stay.
Finding repeated email addresses or product IDs in a single column is a different task. This command does not deduplicate by one selected column. Check that distinction before using it on transaction data where the same customer may have several valid entries.
Remove duplicates in three steps
Upload an XLSX, XLS, or CSV file. Enter the command below and run it. Review the number of removed rows, then compare the processed preview with the original preview.
If the result looks right, download the new XLSX file. You can combine supported changes with ‘then’ in one request; preview shows the outcome after all steps.
How to do it
- Upload your file and check the column headings.
- Run Remove duplicate rows.
- Check the removed-row count and preview before downloading.
Remove duplicate rowsThings to check first
Rows with different spacing, spelling, or capitalization are not exact matches. For example, Acme and ACME may remain as separate text values. Inspect inconsistent source data before assuming every apparent duplicate will disappear.
Your download is a new spreadsheet. The original preview remains available for comparison during your session, so you can confirm that meaningful records were not removed.
Frequently asked questions
Can I remove duplicates based only on one column?
Not with this command. It compares the full row, so two records with one matching field but other differences are kept.
Does the command keep one copy?
Yes. It keeps the first row in each set of identical rows and removes later copies.
SheetCommand
Try it on your file
Try the supported cleanup, sorting, and summary commands on your file. Use formula and script examples in their respective applications.