FileMixer / Guides
Spreadsheet guides
How to do the common jobs by hand in Excel, where that's easy, and with FileMixer where it isn't.
How to merge Excel files into one
Copy and paste, Excel's Get Data, or FileMixer. How to handle files whose columns don't line up, and how to tag each row with its source.
How to do a VLOOKUP without Excel
Match two lists on an ID, email or SKU and bring columns across. Plus the five reasons rows don't match.
How to remove duplicates from a CSV file
Decide what a duplicate is, keep the right copy, and check what you removed before you trust the result.
Open a CSV in Excel without losing leading zeros
Why Excel changes 02134 to 2134 and long IDs to 1.23E+15, and three ways to stop it.
How to split a CSV that's too big for Excel
Excel stops at 1,048,576 rows. How to split a big file into parts, or by a column, and keep the header in each.