Category: How-to

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

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

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

How to connect Google Sheets to Databricks

2025-04-01 // Mark Tressler

See how to connect Google Sheets to Databricks using the Databricks Connector and see why Row Zero is better for big Databricks datasets and automating updates.

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