Use this Google Sheets trick to format your spreadsheet in seconds

You’ve scraped data and got a messy Google Sheet?

Stop manually cleaning and formatting your Google Sheets.

Save hours by doing it automatically with this Google Sheets feature ↓

Here’s the quick guide:
:one: Open a Google Sheet.
:two: Go to Tools > Macros > Record macro.
:three: Perform the tasks you want to be repeated.
:four: Click Save.

Check out the data cleaning example in the video below :arrow_heading_down:


Credit: Giacomo Melzi on LinkedIn


This is super awesome

1 Like