ConditionalVisibility

new-products-promo

delete-blank-cells-excel-image5

delete-blank-cells-excel-image7

delete-blank-cells-excel-image6

delete-blank-cells-excel-image4

delete-blank-cells-excel-image1

delete-blank-cells-excel-image3

delete-blank-cells-excel-image2

App tutorials

Excel app tips hero image

Microsoft Excel

Blank rows happen, and they make your spreadsheet look terrible. They also might mess up your data. Here's how to get rid of blank cells in Excel Online, one at a time or en masse.

How to delete blank rows in Excel

Whether you're planning an event or gathering product feedback, your time doesn't have to be spent exporting those results to your spreadsheets just so you can really go through them—we can do that! After you've set up this automation, Zapier will capture new entries your Typeform receives, adding a new row to an Excel spreadsheet for each and every one with every response you need.

Typeform helps you ask awesomely online! If you ever need to run a survey, questionnaire, form, contest etc. Typeform will help you achieve it beautifully across all devices, every time, using its next generation platform.

Typeform

New Entry

Retrieves ALL file(s) of a given form that are uploaded as part of form submission.

Retrieve ALL Files

Lookup Responses

Create an Empty Form

Duplicates an Existing Form

Update Dropdown, Multiple Choice or Ranking Question Options

Custom Actions (Beta)

This is an advanced action which makes a raw HTTP request that includes this integration's authentication.

API Request (Beta)

Microsoft's Excel is a spreadsheet application used by millions of users across the world. It is part of the Office ecosystem and is considered the industry standard for spreadsheets. 

Only files on OneDrive for Business (available with Office 365 and Sharepoint server) are supported at this time with Zapier.

Triggers when a new row is added to a worksheet in a spreadsheet.

New Row

Triggers when a new row is added to a table in a spreadsheet.

New Row in Table

Triggers when a new worksheet is added to a spreadsheet.

New Worksheet

Triggers when a row is added or updated in a worksheet.

Updated Row

Finds a row by a column and value. Returns the entire row if one is found.

Find Row

Finds any rows that match a specific value in a given column.

Find Row(s)

Find or Create Row

Adds a new row to the end of a worksheet.

Add Row

Adds one or more rows to the end of a worksheet (with line item support).

Add Row(s)

Adds a new row to the end of a specific table.

Add Row to Table

Create Spreadsheet

Update Row

Add new Typeform entries as rows on an Excel spreadsheet 

After you've configured this Zap, it'll trigger with every new row added to a specified spreadsheet on Excel, automatically extracting that information and sending it to Mailchimp as a new or updated subscriber to any mailing list you specify.

Share your ideas with Mailchimp email newsletters—then use its landing page and form builders to grow your lists and take marketing further with drip and transactional emails.

Mailchimp

Triggers when a new campaign is created or sent.

New Campaign

Triggers when a recipient opens an email in a specific campaign.

Email Opened

Triggers when a recipient clicks a pre-specified link in your campaign.

Link Clicked

Triggers when a new audience is added to your MailChimp accounts.

New Audience

Triggers when a new customer is added to a selected store.

New Customer

Triggers when a new subscriber is added to an audience.

New Subscriber

New Order

Triggers when any current subscriber unsubscribes from an audience.

New Unsubscriber

Triggers when a subscriber is added to a Tag within a List.

New Subscriber With Tag

Triggers when a subscriber is added to a segment or tag within an audience.

New Subscriber in Segment or Tag

Triggers when a subscriber is added or updated in an audience.

New or Updated Subscriber

Find a Campaign

Find Customer

Find Tag

Searches for a new subscriber on your MailChimp audience.

Find a Subscriber

Find or Create Campaign

Find or Create Tag

Find or Create Subscriber

Archive Subscriber

Create Campaign

Get report details for a specific sent campaign.

Campaign Report

Get report details for a specific link clicks.

Click Report

Create Tag

Creates a custom event for an existing subscriber.

Create Custom Event

Creates a new audience in your MailChimp account.

Create Audience

Add a new subscriber to an audience of your choosing. Can be used to update an existing subscriber too.

Add/Update Subscriber

Unsubscribe or delete a contact by email address within an audience.

Unsubscribe or Delete Contact action

Removes a subscriber by email address from a tag within an audience.

Remove Subscriber from Tag

Sends a campaign to all subscribers in an audience, segment, or tag.

Send Campaign

Adds a new note to an existing subscriber.

Add Note to Subscriber

Add an email address to a tag within an audience. Note: the email address **must already be subscribed to the audience**, or this will fail.

Add Subscriber to Tag

Add or update Mailchimp subscribers from new rows on Excel

New data on your spreadsheet means there's work to do. Set up this integration and we'll help you tackle those new items as they come in. Whenever you add a row to your Excel spreadsheet, Zapier will automatically create a card on Trello, letting you track and tackle every item without wasting time copying information between the apps.

Trello is a team collaboration tool that lets you organize anything and everything to keep your projects on task.

Trello

New Board

New Card

Triggers when a Card is archived in Trello.

New Card Archived

Triggers when a Comment is added to a Card in Trello.

New Comment in Card

Triggers when there is activity in Trello.

New Activity

Triggers when a Card is moved to a List in Trello, [inside the same Board](https://zapier.com/apps/trello/help#common-problems-trello#not-triggering-on-card-moved-to-list-when-a-card-is-moved-from-another-board).

Card Moved to List

Triggers at a specified time before a card is due.

Card Due

Triggers when a Card is updated in Trello.

Card Updated

Triggers when a new checklist is created in Trello.

New Checklist

Triggers when a new label is created in Trello.

New Label

Triggers when a label is added in a Trello card.

New Label Added to Card

Triggers when a new list on a board is added.

New List

Triggers when a new member joins a board.

New Member on Board

Triggers when you get a new notification in Trello.

New Notification

Finds a label on a particular board by name.

Find Label on Board

Finds a list on a particular board by name.

Find List on a Board

Finds a checklist on a particular board or card by name.

Find Checklist

Finds a checklist item on a particular checklist by name.

Find Checklist Item

Finds a board in your Trello organization by name.

Find Board

Finds a card in your Trello organization by name, given a specified board and list. Does not search archived cards.

How to delete blank rows in Excel

Related articles

Improve your productivity automatically. Use Zapier to get your apps working together.