Browse categories:
2025-02-18 // Greg Gates, Software Engineer
An explanation of pivot tables by way of their similarity to the group by operation.
Read more →2025-02-12 // Mark Tressler
Spreadsheet of all U.S. Zip Codes to State, County, Town, and Metro. Free zip code lookup from Row Zero. Explore ZIP code demographics and population data.
Read more →2025-02-11 // Mark Tressler
See how to open AWS Cost and Usage Reports in a spreadsheet. Row Zero makes it easy to open large AWS data exports to track and analyze AWS charges and usage.
Read more →2025-02-10 // Nick End, Founder
Row Zero makes it easy to open large CSV files online for free in a big data spreadsheet. Open CSV files up to 1 billion rows and filter, sort, pivot, and chart.
Read more →2025-02-03 // Mark Tressler
See how to use COUNTIFS function and explore COUNTIF examples from simple to advanced COUNTIFs, COUNTIF OR vs AND, pivot table countifs, and COUNTIFS on big data.
Read more →2025-01-28 // Mark Tressler
Explore 10 common CSV errors to troubleshoot why a CSV file won't import correctly. Explore the limits of CSV files and see how to open big CSV files.
Read more →2025-01-28 // Mark Tressler
See how to highlight and remove duplicates in a big file and show and count unique values with pivot tables, conditional formatting, and formulas in Row Zero.
Read more →2025-01-20 // Mark Tressler
See 10 ways XLOOKUP is better than VLOOKUP. Compare XLOOKUP vs VLOOKUP and see how to use XLOOKUP on big data and explore XLOOKUP examples.
Read more →2025-01-17 // Mark Tressler
See how to use XLOOKUP function with XLOOKUP examples from simple to advanced XLOOKUPs. See why XLOOKUP is better than VLOOKUP and how to XLOOKUP big data.
Read more →2025-01-09 // Mark Tressler
See how to COUNT UNIQUE in a pivot table across 3 popular spreadsheet apps - Excel, Google Sheets, and Row Zero with a built-in pivot table count unique option.
Read more →