Category: How-to

Parquet File Format 101 + Opening Parquet Files

2025-07-11 // Mark Tressler

See how to open parquet files in a spreadsheet and explore the basics of the parquet file format. Compare parquet vs CSV and view parquet use cases.

Read more

How to build a waterfall chart

2025-07-07 // Mark Tressler

See how to create a dynamic waterfall chart in a big spreadsheet. Row Zero makes it easy to create auto-updating waterall charts connected to your data.

Read more

How to automatically remove duplicates in connected spreadsheets

2025-07-01 // Mark Tressler

See how to automatically remove duplicates in spreadsheets. You can delete duplicates from massive files or automate removing duplicates as new data updates.

Read more

10 Tips for Cleaning Big Data in Spreadsheets

2025-06-25 // Mark Tressler

Row Zero makes it easy to clean big data in spreadsheets. Connect to your data source to clean database tables, preprocess data, and automate big data cleaning

Read more

Best Keyboard Shortcuts for Spreadsheet Power Users

2025-05-20 // Mark Tressler

Top 10 spreadsheet keyboard shortcuts and advanced hot keys for power users including Alt shortcuts on Windows and Mac Opt key shortcuts in Excel and Row Zero.

Read more

Best parquet software tools to view and analyze parquet

2025-05-19 // Mark Tressler

Explore top parquet software tools including Row Zero, a powerful spreadsheet that opens parquet files, parquet python libraries, and SQL parquet query tools.

Read more

Pivot table slicers - Dynamic filters in big spreadsheets

2025-05-07 // Mark Tressler

See how to add slicers to pivot tables, charts, and dashboards. Unlike Excel slicers, Row Zero slicers are full-featured filters across millions of rows.

Read more

Open Large TSV files in a Spreadsheet

2025-05-05 // Mark Tressler

Row Zero makes it easy to open large TSV files online in a spreadsheet 1000x bigger than Excel's limits. Use as a TSV editor and open tsv.gz files directly.

Read more

Connect BigQuery to Google Sheets or a Big Spreadsheet

2025-05-04 // Mark Tressler

See how to connect Google Sheets to BigQuery using Connected Sheets and how to connect BigQuery to Row Zero, an enterprise-grade spreadsheet for big data.

Read more

How to use TEXT function to custom format numbers and dates

2025-04-23 // Mark Tressler

Use the TEXT function in spreadsheets to custom format numbers, dates, and times as text. View the list of custom format codes to convert numbers to text.

Read more