Blog

The latest from Row Zero, the best spreadsheet for big data.

Group by Date in a Pivot Table - Month, Week, Quarter etc.

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

How to build a connected spreadsheet that auto-updates

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

How to Update a Spreadsheet with a New File

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

10 best spreadsheet features unique to Row Zero

2025-04-02 // Mark Tressler

See why Row Zero is the best spreadsheet for big data analytics. Explore top spreadsheet features and what makes Row Zero better than Excel and Google Sheets.

Read more

How to use MULTILOOKUP to lookup with multiple criteria

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

How to Run a Weekly Business Review - Insights from Amazon WBRs

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

Easily Open a Parquet File Online in a Spreadsheet

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

Work with NPI Data via Medicare Provider Enrollment Files

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

Calculate market penetration by country, state, city, or ZIP

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

Pivot is just a shorter, fatter group by

2025-02-18 // Greg Gates, Software Engineer

An explanation of pivot tables by way of their similarity to the group by operation.

Read more