Loading

Microsoft Excel + Formatter by Zapier

Update dates and times for Microsoft Excel rows with Formatter by Zapier when rows are updated

Keep your Excel sheets up to date with accurate date and time formatting. When a row is updated in Microsoft Excel, this workflow reformats the date and time using Formatter by Zapier, ensuring consistency and accuracy in your records. Spend less time manually correcting date and time formats, and focus on more important tasks at hand.

Keep your Excel sheets up to date with accurate date and time formatting. When a row is updated in Microsoft Excel, this workflow reformats the date and time using Formatter by Zapier, ensuring consistency and accuracy in your records. Spend less time manually correcting date and time formats, and focus on more important tasks at hand.

  1. When this happens...
    Microsoft ExcelMicrosoft Excel
    Updated Row

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

    TriggerScheduled
  2. automatically do this!
    Formatter by ZapierFormatter by Zapier
    Date / Time

    Work with dates and times to change formatting or add/subtract time (with line-item support).

    ActionWrite
Start free with email
  • Free forever for core features
  • 14 day trial for premium features & apps

Supported triggers and actions

What does this mean?
    • Storage Source

    • FolderRequired

    • SpreadsheetRequired

    • WorksheetRequired

    Trigger
    Scheduled
    Try It
    • Storage Source

    • Folder

    • SpreadsheetRequired

    Trigger
    Scheduled
    Try It
    • Storage Source

    • FolderRequired

    • SpreadsheetRequired

    • WorksheetRequired

    Action
    Write
    • Storage Source

    • Folder

    • TitleRequired

    • Column Headers

    • Zap Step Id

    Action
    Write
    • Storage Source

    • FolderRequired

    • SpreadsheetRequired

    • WorksheetRequired

    • TableRequired

    Trigger
    Scheduled
    Try It
    • Storage Source

    • FolderRequired

    • SpreadsheetRequired

    • WorksheetRequired

    • Trigger Column

    Trigger
    Scheduled
    Try It
    • Storage Source

    • FolderRequired

    • SpreadsheetRequired

    • WorksheetRequired

    • TableRequired

    Action
    Write
    • Storage Source

    • FolderRequired

    • SpreadsheetRequired

    • WorksheetRequired

    • RowRequired

    Action
    Write
excel logo
excel logo

About Microsoft Excel

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.
Help

Related categories

  • Microsoft
  • Spreadsheets

Similar apps

OneDrive integrationsOneDrive integrations

OneDrive

File Management & Storage, Microsoft
Smartsheet integrationsSmartsheet integrations

Smartsheet

Spreadsheets
Quip integrationsQuip integrations

Quip

Documents
formatter logo
formatter logo

About Formatter by Zapier

Data isn't always in the format you need. Perhaps a date is in International format, but your app needs it in American format. Or maybe you need to Title Case a subject, truncate text for a Tweet, or turn Markdown text into HTML for your blog. Zapier's Formatter tool can help.

Related categories