Guides: batch jobs on Excel files for Mac
Plain, step-by-step guides for doing batch jobs on Excel files on a Mac: merging, splitting, comparing, cleaning, replacing and converting. Each guide starts with what you can do yourself in Excel for Mac, for free, including where Power Query and macros fall short on a Mac, and only then explains where Gridhand, the Mac app we make, is faster.
Merge and combine
- How do you merge Excel files on a Mac?
- How do you combine multiple Excel files into one sheet on a Mac?
- How do you combine multiple CSV files into one Excel workbook on a Mac?
- Can you use Power Query on a Mac to merge Excel files?
Split
- How do you split an Excel workbook into one file per sheet, or every N rows, on a Mac?
- How do you split Excel data into one file per customer, region or month on a Mac?
Compare
Clean, find and replace
- How do you remove duplicates across multiple Excel files?
- How do you clean data in many Excel files at once on a Mac?
- How do you find and replace in multiple Excel files on a Mac?
Convert
- How do you batch convert CSV files to XLSX on a Mac?
- How do you convert XLSX to CSV on a Mac, for every sheet and many files?
Alternatives and comparisons
- Is there a Kutools for Mac, and what are the alternatives?
- Is there an ASAP Utilities for Mac, and what can you use instead?
- Gridhand vs XLclick vs XLWizard: which Excel tool for Mac?
By Kayabyte. Questions or corrections: support@kayabyte.dev.
Microsoft and Excel are trademarks of the Microsoft group of companies. Gridhand is made by Kayabyte and is not affiliated with or endorsed by Microsoft.