Blog

The latest from Row Zero.

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

MRR Analysis Using Stripe Data

2025-02-12 // Tom Ward

Analyze Stripe MRR data using a template in Row Zero. Simply export Stripe data and import into the Stripe template spreadsheet to forecast MRR growth.

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

10 Common CSV Errors and Fundamental CSV Limits

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

Remove duplicates in a big spreadsheet and count uniques

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