Workflows ยท Clean and combine ยท Opening soon
Clean and combine workflows
Remove duplicates, tidy names and addresses, fill the blanks, and merge files into one. Each one rebuilds its result every time your data refreshes.
Team
Data in
20 workflows
- Merge Excel or CSV filesOne tidy table with every file's rows, re-sent rows dropped, and a Period columnSee the workflow Template
- Remove duplicatesOne row of each, with a Copies column saying how many there wereSee the workflow Template
- Remove blank rowsRemove rows that are empty or only contain spaces from an Excel export, while keeping the rest of the sheet unchanged.See the workflow Built by the agent
- Multi-entity consolidationEvery entity's balances in one currency, by accountSee the workflow Template
- Duplicate invoice checkPairs of bills that look paid twice: same supplier, same amount, close dates or the same numberSee the workflow Template
- Standardise namesA Standard name for every row, so spellings of the same name group togetherSee the workflow Template
- Combine first and last nameCombine first and last name columns into one full name column, trim extra spaces, and keep department in the same row.See the workflow Built by the agent
- Split full names into first and lastSplit full names into first and last name, keep useful name parts, and flag rows that need a check in your exported spreadsheet file.See the workflow Built by the agent
- Split a column by delimiterSplit an Excel export by commas into separate street, city, state and zip columns in your customer list.See the workflow Built by the agent
- Validate email addresses in a listCheck a Mailchimp audience export for invalid, duplicate, and role-based email addresses, then flag the ones to remove.See the workflow Built by the agent
- Standardize addressesStandardize mailing addresses from your Excel export with consistent street abbreviations, state codes, zip codes, and capitalization.See the workflow Built by the agent
- Map fields between two systemsMap a HubSpot contacts export to Salesforce import columns with your field mapping sheet, and flag fields with no match.See the workflow Built by the agent
- Duplicate payments checkCheck for duplicate payments in QuickBooks exports by matching vendor payments to bills and flagging duplicate payment cases.See the workflow Built by the agent
- Clean up a mailing listClean a mailing list export from Mailchimp. Trim names, fix casing, drop duplicates and unsubscribed contacts, and label each row.See the workflow Built by the agent
- Unmerge and fill down cellsFill down blank cells under each group heading in an Excel export, so every row has its category.See the workflow Built by the agent
- Unpivot wide dataA long table: one row per label and period, with its valueSee the workflow Template
- Convert transactions to one currencyConvert bank transactions in euro, pounds, and cad to usd using a daily fx rate table and check which rows match.See the workflow Built by the agent
- Clean phone numbersClean phone numbers from an Excel export into one format with country code, and list numbers that are too short.See the workflow Built by the agent
- Extract numbers from textPull numbers out of descriptions in an Excel export and keep the rest of your columns unchanged.See the workflow Built by the agent
- Find missing valuesFind rows with missing values in required columns, mark complete rows, and count blanks by column in Excel exports.See the workflow Built by the agent
Don't see your job? Describe it.
Tell us the job and we'll email you when you can build it.