# Excel for ediscovery specialists on Mac: load files, review tracking and voice help

> Excel for eDiscovery specialists on Mac: how to open load files safely, stay under sheet limits, track reviewers and get voice help from Lazur.

URL: https://www.lazur.app/for/ediscovery-specialists/excel
Updated: 2026-11-08

Excel for eDiscovery specialists on Mac handles three common jobs: reading load files, sorting exported metadata and checking reviewer output. It works for those jobs, but it has hard sheet limits, and Microsoft says Power Query authoring is not available on Mac. This guide covers how to open load files without losing data, what the Mac limits mean for big productions, and where Lazur helps while you work.

## Quick answer

- Import ID columns as text, or the leading zeros in control numbers can disappear on the first save.
- A worksheet in Excel for Mac holds 1,048,576 rows and 16,384 columns, so split big productions first.
- Microsoft says Power Query authoring is not available in Excel for Mac, but refresh still works for text and CSV files.
- Purview review-set exports must be downloaded within 30 days of completion, so put that deadline in Reminders.
- Lazur points at columns, explains fields, dictates notes and drafts formulas while you work in Excel.

## What eDiscovery specialists do in Excel on Mac

Excel for eDiscovery specialists on Mac is a reading and checking tool. It is not a review platform. Your review tool holds the documents, the tags and the history of who coded what. Excel holds the copies you pull out. You open a load file, check the metadata, sort it, count it and summarize it for a supervising attorney or project manager.

That split matters. Lexbe says its XLSX load file can be opened, searched and analyzed outside a litigation review database. Nextpoint describes processed metadata as a spreadsheet-like database view that users can sort and filter. In both cases, Excel is a tool for reading and checking, not the system of record.

![Ediscovery specialist working in Excel on a Mac, checking exported metadata at a desk](https://images.lazur.app/content-images/role-app/ediscovery-specialists-excel/excel-for-ediscovery-specialists-on-mac-1-408975.jpg)

## Opening a load file without losing data

The most common damage happens on the first open. Excel reads a control number that starts with zeros and drops those zeros. Save the file, and they stay gone. Dates have a similar problem. Nextpoint says processing typically uses UTC timestamps, so the date in your sheet may not match the time a reviewer saw in the platform.

Nextpoint also says each file gets a DocumentID or control number, and that this is not a Bates number. Keep the two apart in your notes. Do not match or rename documents by Bates number unless your vendor confirms that field is in the load file.

### Steps for a safe first open

1. Copy the vendor file to a new folder. Work only on the copy.
2. Import the file instead of double-clicking it. If your copy shows Data > Get Data > From File > From Text/CSV, use it for plain text loads and set ID columns to Text.
3. Count the rows and compare the count to the document count in the vendor's transmittal letter.
4. Scan the ID and date columns for lost zeros and shifted dates before you sort anything.
5. Save under a new name, such as production_working_copy.xlsx, and leave the original alone.

> **Saved zeros do not come back:** Once Excel saves a converted column, the lost zeros stay lost. Keep the vendor original unchanged. Keep a text copy of every ID column you need for matching.

DAT and OPT files are plain text. Their field breaks are not simple commas, so a double-click can split columns in the wrong place. Lexbe says its production load file comes in DAT, OPT, DII and XLSX formats. Ask your vendor which one you received before you open it.

## Mac limits that matter for big productions

Microsoft's Excel specifications page lists the grid limits. A worksheet holds 1,048,576 rows and 16,384 columns. A single cell holds up to 32,767 characters. Those limits decide how you split work, so check them before a large open.

| Limit | Value | What it means for a load file |
| --- | --- | --- |
| Rows per worksheet | 1,048,576 | A production with more rows than this will not fit on one sheet. Split it by volume or date range first. |
| Columns per worksheet | 16,384 | Most metadata sets fit. Count your fields against the load file's field list if you have many custom fields. |
| Characters per cell | 32,767 | Long extracted text or message bodies can exceed one cell. Ask the vendor whether text comes in separate files. |

_Limits from Microsoft's Excel specifications page_

Do not rely on Excel to warn you. Some pages claim Excel drops rows past the limit without a message. Microsoft's specifications page does not say that, so treat any count as unverified until you check it yourself.

A row count is your proof. Click the first data cell in column A, then press ⌘↓ to jump to the last row. Compare that row number with the vendor's document count, allowing for the header row. A mismatch means stop and find out why before you go further.

Long text is the other trap. Find out which columns carry full text. Pick one suspicious cell and use LEN to see how many characters it holds. A value near the 32,767 limit deserves a second look before you trust the column.

![Desk with a laptop, papers and a notebook, the setting for spreadsheet work on document data](https://images.lazur.app/content-images/role-app/ediscovery-specialists-excel/excel-for-ediscovery-specialists-on-mac-2-700a71.jpg)

## Filtering and sorting exported metadata

Filtering takes most of your time. Turn on filters with ⌘⇧F, or go to Data > Filter. Click the arrow on any header to filter that field. Clear each filter before you move on, or the view stays narrower than you think.

Format the range as a table before you sort. Headers stay visible when you scroll, and formulas extend to new rows. Microsoft's October 2026 post says named tables at creation are now generally available on Mac, so you can name the table as you make it.

Here is a worked case. A supervising attorney wants every message from one custodian with a blank sent date. Filter the Custodian column to that name. Then filter the sent date column to blanks. Select the visible rows, copy them with ⌘C, and paste them into a new sheet with ⌘V.

> **Text dates sort wrong:** If a date column is stored as text, Excel sorts it alphabetically, not by time. Check the column format under Format > Cells before you sort. Convert the dates first, then sort.

Deduplication needs a decision before you start. Nextpoint says the vendor must confirm whether duplicates should be shown or removed. Get that answer first. Then use Data > Remove Duplicates on your working copy only. The command deletes rows from your sheet, and Excel's undo history does not survive a save and close.

## Tracking reviewer output without short counts

Your platform may already produce the productivity numbers. Lexbe says account admins can track each reviewer's daily productivity and generate an Excel report. The report can show document count, pages, activity or GB, at daily or hourly intervals.

Here is the catch. Lexbe says the report exports only from the Table display, and the export reflects what is on screen. Filters you set first carry into the report. Clear every filter before you export, or the totals cover only the rows you left visible.

Build your own check in Excel to match. Put a reviewer name in one cell and a date in the next. Then use COUNTIFS on the Reviewer and ReviewDate columns. Compare that total with the platform report. A gap usually means a leftover filter, a time zone shift or a reviewer name typed two ways.

- **1,048,576** rows per worksheet in Excel, the grid limit you check against first ([source](https://support.microsoft.com/en-us/office/excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3))
- **30 days** to download a Microsoft Purview review-set export after it completes ([source](https://learn.microsoft.com/en-us/purview/edisc-review-set-export))
- **41%** of 101 legal professionals named lack of time as an individual challenge ([source](https://www.nextpoint.com/ediscovery-blog/ediscovery-landscape-survey-2026))
- **58%** named document management, review and reduction as a firm-level challenge ([source](https://www.nextpoint.com/ediscovery-blog/ediscovery-landscape-survey-2026))

Time is the constraint. In Nextpoint's 2026 survey, 41% of respondents named lack of time as an individual challenge. Another 58% named document management, review and reduction as a firm-level challenge.

> **Who was surveyed:** The survey sampled 101 legal professionals, about 70% of them at law firms or legal services organizations. It covers legal professionals generally, not eDiscovery specialists alone, and it does not measure Excel use.

## Export deadlines and download windows

Exports run on clocks. Microsoft Purview says you must download content from an export within 30 days after the export completes. Export processes stay for the life of the case, so the download window is the one people miss.

![Legal professional reviewing documents at a desk during an ediscovery project](https://images.lazur.app/content-images/role-app/ediscovery-specialists-excel/excel-for-ediscovery-specialists-on-mac-3-ea4c66.jpg)

Purview also cancels any export that runs more than seven days without finishing. Microsoft recommends splitting large exports into smaller batches, or using date ranges and filters. Plan the batches before you start the export, not after it fails.

Pick the export option that fits your spreadsheet work. Export item report only creates the summary and item report, and hides the folder and path options. Export items with item report adds the documents, with optional text files, tags and redacted PDFs. If you need only metadata for Excel, the first option is the right one.

Keep the deadline outside Excel. Ask Lazur to remind you to download the export within 30 days, and it adds the reminder to Apple Reminders. Put the export name in the reminder so the right person checks it.

## Power Query on Mac: what works and what does not

Power Query is how many analysts clean repeated imports. On Mac, it is narrower. Microsoft's Power Query page says authoring in the Power Query Editor is not available in Excel for Mac.

Refresh still works. Microsoft says refresh covers text or CSV files, Excel workbooks, XML and JSON files, local tables and ranges, and folders. The same page does not mention Power Pivot or the data model. Do not plan around either one until you check your copy.

A practical split works well. Build the query on a Windows machine, or ask IT to build it, then open and refresh it on Mac. Check your build under Excel > About Excel. Microsoft's page cites version 16.69 in a note, but the wording does not say which feature it covers. Do not treat that number as a cutoff.

### What Microsoft ships for Mac

Microsoft's October 2026 post says the clean data skill and skill builder are rolling out to general availability on all platforms, including Mac. The skill recorder is still Insider-only on Mac. The interactive canvas is Windows only. Plan your Mac work around the first, and treat the other two as later.

## Formulas for checks, not for decisions

Most formulas in this work check the export. They do not decide anything about a document. Keep formulas on the working copy, and label every helper column so a colleague can read it.

- COUNTIFS counts rows that match two or more conditions, such as reviewer and date.
- LEN returns the number of characters in a cell. Use it to find long text near the cell limit.
- TRIM removes extra spaces that break filters and lookups.
- ISBLANK flags rows that are missing a field, such as a blank sent date.
- XLOOKUP matches an ID in one sheet to a row in another. Confirm your Mac version supports it first.

Here is a worked case. You want to flag rows where the text column is close to the cell limit. Add a helper column next to the text. Enter a LEN formula that points at the first text cell. Copy it down a few rows, check the results by hand, then fill the column. Sort the flags from largest to smallest.

Ask Lazur to draft the formula. Describe the goal in plain words, such as flag any row where the text column is longer than the cell limit. Lazur types the formula text. You still test it, because a formula that looks right can point at the wrong column.

## Common mistakes that cost time

- Saving the vendor file over the original, and losing leading zeros in control numbers.
- Trusting a row count without comparing it to the vendor's document count.
- Sorting dates stored as text, which puts them in alphabetical order.
- Exporting a productivity report from a filtered view and treating the totals as complete.
- Removing duplicates before the vendor confirms how duplicates should appear.
- Letting an export sit past its 30-day download window.

## Where Lazur helps while you work in Excel

Lazur is a voice assistant for the Mac. It lives in the notch, and it sees the screen only while you hold the shortcut. Hold ⌥ ⌘ to ask about anything on screen. Lazur answers out loud. Ask where a column is, and Lazur draws a circle and a label around it.

Ask how to do something, and Lazur guides you one click at a time. It waits for each click. It does not click buttons or edit your files for you. Lazur also drafts and types text, so a short note to your vendor can start as a draft that you read before you send it.

Hold fn to dictate. Your words land at the cursor as clean, formatted text in any app. That helps with reviewer notes and cell comments, where typing a full sentence is slow. Check the spelling of names and matter numbers before you save.

For more Excel help, see [Excel help for Mac](https://www.lazur.app/apps/excel). When you are ready to try it, [download Lazur](https://www.lazur.app/download) or compare [plans on the pricing page](https://www.lazur.app/pricing).

## When Excel is the wrong tool

Excel reads and checks. Review decisions belong in the review platform, where the tags and audit history live. A spreadsheet cannot repair a review set that was built wrong.

Lexbe says a review set cannot take new documents once it is activated, and documents cannot be removed once added. Review sets also cannot be split once review has begun. Plan the set before you activate it. If you need a change, that is a conversation with your vendor, not a formula.

## A checklist before a spreadsheet goes to counsel

1. Confirm the row count matches the vendor's document count.
2. Check control number and date columns for lost zeros and text dates.
3. Clear all filters before you run any productivity export.
4. Save the working copy under a new name and keep the vendor original.
5. Put the export download deadline in Apple Reminders.
6. Note which platform and export option produced each file.

## With Lazur

Lazur is a voice assistant for the Mac that lives in the notch. Hold ⌥ ⌘ and ask; it sees your screen, answers out loud, points at buttons and walks you through apps. Hold fn to dictate. Free for 3 days, then $18/month: https://www.lazur.app/download

- “Lazur, where is the custodian column?”: Lazur circles the Custodian header and labels it, so you can jump straight to the column. (Points at it)
- “Lazur, which column is the custodian field?”: Lazur circles the header and labels it, so you find the field without scrolling.
- “Walk me through filtering to one custodian with blank sent dates.”: Lazur names each menu and waits for your click before it moves to the next step.
- “Why are these control numbers missing their leading zeros?”: Lazur explains that Excel converted the column to numbers, and what to do with the vendor original.
- “Draft a COUNTIFS formula that counts rows per reviewer and date.”: Lazur types the formula text, and you test it on a few rows before you copy it down.
- “Dictate this into the notes column: privilege call pending with the supervising attorney.”: Your words appear as clean text in the cell you have selected.
- “Find the vendor's help page on load file formats and summarize it.”: Lazur runs the search in its own Chrome tabs and returns a summary and a report.
- “Remind me to download the export within 30 days.”: Lazur adds the reminder to Apple Reminders, so the deadline sits outside the spreadsheet.

## FAQ

### Can Excel for Mac open a Lexbe load file?

Lexbe says its XLSX load file can be opened, searched and analyzed outside a litigation review database. Its other production formats, such as DAT and OPT, are plain text. Those need an import step to split into columns. Ask your vendor which format you received.

### Why did my control numbers lose their leading zeros?

Excel treats a column of digits as numbers by default, and numbers do not keep leading zeros. Import the column as text, and keep the vendor original unchanged. Once Excel saves the converted column, the zeros do not return.

### How many rows fit on one Excel worksheet?

Microsoft's specifications page lists 1,048,576 rows and 16,384 columns per worksheet. Each cell holds up to 32,767 characters. Split a bigger production by volume or date range before you open it.

### Can I build a Power Query on a Mac?

Microsoft says authoring in the Power Query Editor is not available in Excel for Mac. Refresh works for text or CSV files, Excel workbooks, XML and JSON files, local tables and ranges, and folders. Build the query on Windows, or ask IT for help.

### How long do I have to download a Purview export?

Microsoft says you must download content within 30 days after the export completes. Export processes are kept for the life of the case. An export that runs more than seven days without finishing is canceled, so split large exports into batches.

### Can Lazur do the work in Excel for me?

No. Lazur does not click buttons or edit files for you. It circles things on screen, guides you one click at a time, answers out loud and types drafted text. You still make every change in your file.

### Should I run document review in Excel?

No. Excel is for reading and checking exported data. Review decisions, tags and audit history belong in the review platform. Lexbe says documents cannot be removed from a review set once they are added.

## Sources

1. [Excel specifications and limits](https://support.microsoft.com/en-us/office/excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3), Microsoft Support, checked 2026-11-08
2. [Import and shape data in Excel for Mac (Power Query)](https://support.microsoft.com/en-us/excel/import-and-shape-data-in-excel-for-mac-power-query), Microsoft Support, checked 2026-11-08
3. [What's New in Excel (October 2026)](https://techcommunity.microsoft.com/blog/excelblog/whats-new-in-excel-october-2026/4549758), Microsoft Tech Community, checked 2026-11-08
4. [Export items from a review set in eDiscovery](https://learn.microsoft.com/en-us/purview/edisc-review-set-export), Microsoft Learn, checked 2026-11-08
5. [Production Load File - Lexbe Help](https://help.ediscoveryplatform.com/home/technical-notes-available/production-load-file), Lexbe, checked 2026-11-08
6. [Review Sets - Lexbe Help](https://help.ediscoveryplatform.com/home/help/discovery-menu/review-sets), Lexbe, checked 2026-11-08
7. [More Data, Fewer Resources: What's Holding Ediscovery Back](https://www.nextpoint.com/ediscovery-blog/ediscovery-landscape-survey-2026), Nextpoint, checked 2026-11-08
8. [More Data, Fewer Resources: What 100+ legal professionals say is holding ediscovery back in 2026](https://edrm.net/2026/05/more-data-fewer-resources-what-100-legal-professionals-say-is-holding-ediscovery-back-in-2026/), EDRM, checked 2026-11-08
9. [4 Steps to an Efficient eDiscovery Data Processing Workflow](https://www.nextpoint.com/ediscovery-blog/ediscovery-processing-workflow-streamline-document-review), Nextpoint, checked 2026-11-08