Category: How-to

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

ZIP Code to State, County, Metro in a Spreadsheet

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

Open AWS Cost and Usage Reports (CUR) in a Big Spreadsheet

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

How To Open a Big CSV File

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

How to use COUNTIF and COUNTIFS - Examples and tips

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

Connect Excel to a Postgresql Database

2025-02-01 // Nick End, Founder

Step-by-step instructions for how to connect Excel to Postgres and the best ways to import Postgres data into a spreadsheet for dynamic real-time analysis.

Read more