Clean up data: split, Flash Fill, duplicates and validation
Updated November 13, 2026
Split text into columns
- Select the column and choose Data › Text to columns.
- Pick Delimited (split at commas, spaces or another character) or Fixed width, then follow the steps.
Flash Fill
- Type what you want for one or two rows next to your data, such as first names taken from full names. Then choose Data › Flash fill (Ctrl+E).
Remove duplicates
- Select the data and choose Data › Remove duplicates.
- Tick the columns that make a row a duplicate, then choose OK. Cloud Sheets says how many rows it removed.
Limit what can be typed
- Select cells and choose Data › Validation.
- Under Allow, pick Whole number, Decimal, List, Date, Time, Text length or Custom, and set the limits.
- Add an input message and an error alert if you like, then choose OK.
- Data › Circle invalid circles cells that break their rule.
A List can show its choices as coloured chips. See Checkboxes and status chips.