Google Sheets for Data Analysts on Mac: Clean Data, Build Pivots, Ask Lazur

What analysts actually do in Google Sheets on a Mac

Most analysts do a few core jobs in Sheets. They clean raw exports, summarize the clean data with pivot tables, and share the result with people who never open the source system. Each job has its own failure point, so each one needs its own habit.

Sheets fits that work because sharing is built in. Google's product page lists co-editing, sharing controls, offline access, and revision history. The same page says you can edit Excel files in Sheets without making a copy.

The habit runs deep. A vendor-sponsored survey of 1,400 analysts found that most still prepare data in spreadsheets. Techzine reports the same figures from that survey.

Those numbers come from a company that sells data-prep software. Treat them as a signal, not a precise count. The useful part is the pattern. A large share of the work happens before any chart gets built.

Keyboard shortcuts for Google Sheets on a Mac

Shortcuts pay off faster than formulas. Google's keyboard shortcut table for the computer version lists these combinations on Mac. Learn the first few, then add more as the work asks for them.

• Ctrl + Space: select the whole column of the active cell
• Shift + Space: select the whole row of the active cell
• ⌘ + A: select all cells on the sheet
• ⌘ + Z: undo the last change, such as a paste that went wrong
• ⌘ + Shift + H: open find and replace
• ⌥ + /: open the Tool finder, which Google says was formerly Search the menus

Watch the Ctrl key on a Mac. Google's table uses Ctrl + Space for column selection. The ⌘ + Space combination opens Spotlight search on macOS, so it will not select your column.

How to make a pivot table in Google Sheets on a Mac

Pivot tables are the summary tool most analysts reach for first. Google's pivot page sets the rule that matters most. Each column in the source needs a header. Without headers, the side panel has no field names to drag.

1. Select the source cells, including the header row.
2. Choose Insert > Pivot table from the menu bar.
3. Pick where the pivot goes, then check that the side panel opened.
4. Drag fields into Rows, Columns, and Values in the side panel.
5. Compare one total in the pivot with the same total in the raw data.

Pivots refresh on their own. Google's page says the table updates any time you change the source cells it draws from. Check that your source range covers the rows you will add later.

Google can also suggest pivot tables. High-confidence suggestions insert automatically unless you turn that off under Tools > Suggestion controls. Check the sheet after you open a file that someone else built.

Calculated fields and the pivot mistakes people make

A calculated field adds a column that is not in the source. Google's page says a custom calculated field can use SUM or a custom formula. Google validates the formula before the field saves, so a typo shows up early.

Field names with spaces need quotation marks inside a custom formula. A field called Order Total must sit in double quotation marks inside the formula, or the formula fails.

Test each fix on a copy first. A pivot that looks right for one month can break when the next export arrives.

Google Sheets limits for big exports and Connected Sheets

Limits decide whether a file works at all. Google's limits page says a spreadsheet created in or converted to Google Sheets can hold up to 20 million cells or 100MB. The page does not say whether that cap covers all tabs together.

Some third-party guides quote a smaller figure. Use Google's page as the reference, and check it on the day you plan the work.

Connected Sheets changes the picture. Google's product page says it lets you work with billions of rows of BigQuery or Looker data in the grid, without writing SQL. The pivot limit still applies, so filter the data before you pivot it.

Cleaning data in Sheets without losing an afternoon

Start with a copy. Duplicate the raw tab before any change, so you can compare the raw and clean versions. Name the copy clean, and leave the export unchanged.

1. Trim extra spaces with =TRIM(A2), then fill the formula down the column.
2. Find repeats with =COUNTIF(B:B, B2). Any result above one means the value shows up more than once.
3. Convert text numbers and text dates before you build a pivot.
4. Bring values from another tab with =XLOOKUP, and check a few rows by hand.
5. Put your notes in a separate column, so the raw data stays clean.

Paste cleaned values over the formulas only after you check them. A formula that works on a sample can fail on the full export, so test the last rows too.

Where Lazur fits while you work in the sheet

Lazur is a voice assistant for the Mac. It lives in the notch, and you hold ⌥ ⌘ to ask about anything on screen. Lazur answers out loud, so your eyes stay on the grid.

Lazur is not a plugin or add-in for Sheets. It does not edit your sheet or click buttons for you. It sees your screen while you hold the shortcut, points at things, and explains what it sees.

Ask where something is and Lazur draws a circle and a label around it on your screen. Ask how to do something and Lazur guides you one click at a time. It waits for each click before the next step.

That covers the gap where analysts lose the most time. You know the goal, but you cannot find the setting. You also do not want to leave the sheet for a help page.

Explain Google Sheets errors and formulas out loud

Error values like #REF and #N/A show up in lookup and import work all the time. Select the cell, hold ⌥ ⌘, and ask what the error means. Lazur explains the cause out loud, and you decide the fix.

Google's product page lists formula writing and error fixing in plain language as Gemini features in Sheets. Those features are built in when your account has them. Some are limited to Workspace plans, so check what your account shows.

Use an explanation as a starting point. Test any fix on a copy, because an error often hides a bad range or a value stored as the wrong type.

Draft formulas and notes, then check every line

Lazur drafts text, so you can ask for a formula in plain words. Say: write a formula that flags repeated values in column B. Lazur drafts a COUNTIF formula and explains how to read the result.

Check the draft before it goes into a cell. Confirm the range, the reference cell, and the quotation marks. A formula can look right and still point at the wrong column.

• Ask for one formula at a time, not a whole workbook.
• Name the columns by their headers, so the draft uses the right range.
• Ask Lazur to explain each part before you paste it.
• Test the result on a few rows you can check by hand.

Dictate notes at the cursor in any app

Hold fn to dictate clean, formatted text at the cursor in any app. Dictation works in a cell comment, in a README tab, and in the email that goes with the file.

Dictation is unlimited on both paid plans. Snippets, a personal dictionary, and clipboard slots help with repeat text. Save your standard caveat as a snippet, so you never retype it.

Write the caveat while the work is fresh. Note what was missing, what you excluded, and why. A caveat written a week later is usually vague.

Research a data source while you work

Some questions need a web page, not memory. Research runs in Lazur's own Chrome tabs through the Lazur for Chrome extension. It comes back with a summary and a report.

Good uses include checking a vendor's current limits, comparing connector lists, and finding the definition of a metric. For Sheets limits, start with Google's own pages.

Treat research as a draft. Open the sources it cites, and check the date on each page before you put a figure in a report.

Timers and reminders for long cleaning sessions

Long cleaning sessions drift. Ask Lazur to set a timer for a short break, or to add a reminder to refresh the shared pivot before a meeting. Lazur handles timers, Apple Reminders, Calendar events, and notes by voice.

Refresh is the easy step to forget. The pivot updates when its source cells change, but a stakeholder may still be reading an old export from an email. Put the check on your calendar, and link the file in the event.

Privacy and team rules before you show a sheet to Lazur

Lazur listens and looks at the screen only while you hold the shortcut. Audio and the screenshot go to AI providers to answer, and they are not stored. Content is never used to train AI models.

Use Google's sharing controls to limit who can open a file. Lazur does not change sharing settings. Ask Lazur where the share button sits, and it circles the button so you can make the change yourself.

Google's own AI features in Sheets

Google has built Gemini features into Sheets. The product page lists formula writing and error fixing in plain language, Fill with Gemini to populate tables from adjacent data, and prompts that build native formulas, pivot tables, and charts.

The same page describes Sheets canvas for dashboards and heat maps, plus Connected Sheets for BigQuery and Looker data. Some features depend on your plan, and availability on personal accounts may differ.

Use Google's features when they fit the job. Lazur covers a different gap. It explains, points, guides, and drafts across apps, including your browser.

A weekly routine for analysts on a Mac

1. Duplicate the raw tab before any change.
2. Clean with TRIM, COUNTIF, and XLOOKUP, and check each step by hand.
3. Build the pivot, then compare one total with the raw data.
4. Set a reminder to refresh the shared file before the next review.
5. Write the caveats with dictation, and keep them beside the summary.

A routine catches the mistakes that a fast afternoon hides. Keep the same steps each week, so a change in the data stands out.

Google Sheets or Excel for data analysis

Some analysts keep both tools. Excel has its own strengths, and Sheets is easier to share across a team. Pick the tool your team already opens, and use the other one for imports only.

If your work lives in Excel, read our Excel for data analysts on Mac page for cleaning, pivots, and Power Query. Marketers who work in Sheets can read Google Sheets for marketers on Mac.

Next steps on your Mac

Open a real file in Sheets and try the pivot steps on it. Keep a copy of the raw data nearby while you test. When you want Lazur beside you, download it and start the free trial, which needs no credit card. Compare plans on the pricing page.