Remove Google Sheet rows and columns, crop, trim spaces, and unhide rows with data. Note: replaces "Remove Blank Rows (and more!)" add-on.
By:
Works with:
74K+
Overview
Need to quickly remove blank rows and columns? Need to crop your sheet with just data? Need to trim cells within a sheet? 

"Remove Rows and Files" provides a quicker way to get rid of those blank rows and columns, as well as, other helpful features.

Note: This add-on replaces "Remove Blank Rows (and more!)" add-on.

Note Domain Installation: According to Google, Workspace add-ons are not fully rolled out yet for all customers (completed about mid January 2021). However, you can switched to quick release cycle in the Admin Panel. Tip: if the Sheets right vertical icon panel displays the plus (+) sign, then you know its rolled-out. 

This add-on has been reviewed by Google and was developed by a GDE (Google Developer Expert). It is maintained by SW gApps LLC.

There is a free trial that expires after 7 button clicks. The subscription is billed annually starting from $0.25 USD per user per month ($3/year). Discounts for domains.

Options:
* Delete/Hide blank rows or columns. 
* Consider space characters as blanks.
* Crop ending empty rows/columns: This sheet tab. 
* Remove/trim spaces within cells: This sheet tab.
* Unhide if NOT blank.

Features coming soon:
* Delete/hide rows conditionally using date, string, number, or exist.
* Archive/move rows conditionally to another sheet tab.
* Process All Sheet Tabs
* DRIVE: Soon this add-on will work in Google Drive like removing blank files or old active files.

See "Latest News" at: www.SWgApps.com > Products > Remove Rows and Files
Additional information
PricingNot available
Developer
Trader status unspecified
Support
Privacy policy
Terms of service
ReportFlag as inappropriate
Remove Rows and Files will ask for the permissions shown below. Learn more
Remove Rows and Files will need access to your Google account
This will allow Remove Rows and Files to :
See, edit, create, and delete all your Google Sheets spreadsheets
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Stepan Matveev
December 10, 2023
Doesn't work
Is this review helpful?
Yes
No
Profile Picture
Gardien Lainagier
September 27, 2022
As has been pointed out it doesn't add an entry to the Extensions menu, only the sidebar. Not everybody uses the sidebar. I don't use the sidebar. This extension might be awesome but it's no use to me.
Is this review helpful?
Yes
No
Profile Picture
Md Abu Sufian
May 18, 2023
Very bad, the pop up or the window of this addon not showing how can I work with it?
Is this review helpful?
Yes
No
Profile Picture
Harbour Sport
March 26, 2023
Doesnt do anything when a row is selected and you want the blank cells hidden
Is this review helpful?
Yes
No
Profile Picture
James Spencer
February 28, 2022
It doesn't seem to have an option to apply to all sheets, only the one you are in, unlike the previous iteration (remove blank)
Is this review helpful?
Yes
No
Profile Picture
Kasey Carr
December 12, 2020
Worked easily and did a perfect job. Thank you so much.
Is this review helpful?
Yes
No
Profile Picture
MAYANK KUMAR SRIVASTAVA
March 6, 2021
good
Is this review helpful?
Yes
No
Profile Picture
Alan Allegra
February 8, 2021
Works quickly and perfectly!
Is this review helpful?
Yes
No
Profile Picture
Project Management
April 26, 2021
not showing in add on tool bar
Is this review helpful?
Yes
No
Profile Picture
Adimir Sakri Soemargono
May 11, 2021
tool bar is not working?
Is this review helpful?
Yes
No
1-10 of 11
Search
Clear search
Close search
Google apps
Main menu