Browse categories:
2025-04-13 // Mark Tressler
See how to group by date in a pivot table in Excel, Google Sheets, and Row Zero. Make a pivot table group by month, week, quarter, etc. to summarize by date.
Read more →2025-04-07 // Mark Tressler
Create connected spreadsheets that auto-update with new data. Row Zero is a connected spreadsheet and big data alternative to Excel and Google Sheets.
Read more →2025-04-04 // Mark Tressler
Import an updated file and automatically update everything in your spreadsheet. Row Zero makes it easy to automatically update spreadsheets with new data.
Read more →2025-03-28 // Mark Tressler
See how to use MULTILOOKUP function in spreadsheets. MULTILOOKUP works like XLOOKUP or VLOOKUP on multiple conditions. Easily build multiple criteria lookups.
Read more →2025-03-14 // Nick End, Founder
Explore keys to a successful weekly business review, insights from WBRs at Amazon, and why Row Zero is the best WBR tool to set up a real-time WBR dashboard.
Read more →2025-03-13 // Mark Tressler
Row Zero lets you easily open and edit parquet files online for free in a supercharged spreadsheet. See how to open parquet files up to 1 billion rows.
Read more →2025-03-10 // Tom Ward, Software and Analytics Consultant
Look up NPI data in a spreadsheet. Work with the National Provider Identifier database and Medicare provider enrollment data as a free NPI registry lookup.
Read more →2025-02-28 // Mark Tressler
Use our free spreadsheet of population by country and U.S. states, cities, and ZIP codes to calculate market penetration by location using standard codes.
Read more →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 →