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:
Open a Google Sheet.
Go to Tools > Macros > Record macro.
Perform the tasks you want to be repeated.
Click Save.
Check out the data cleaning example in the video below 
Credit: Giacomo Melzi on LinkedIn