To move a table from a PDF into a spreadsheet on a Mac, first check whether Preview can select its text. For a text based PDF, copy one column at a time in Preview, then paste each column into a separate spreadsheet column. This keeps column boundaries under your control and makes it easier to spot rows that shifted. If the PDF is a scan, use Preview’s documented Embed Text option when it is available, then check the recognized text carefully before using it as data.

Why copy one column at a time?

A PDF is designed to display a page, not to preserve a spreadsheet’s rows and cells. A table can look perfectly aligned on the page while its text is stored as separate runs. Selecting the whole table may therefore copy text in an order or layout that does not match the visual grid. Copying each column separately is a practical way to retain the table’s visual row order while avoiding reliance on a single large paste. This is a workflow recommendation based on Preview’s column-selection control, not a guarantee that every PDF encodes tables consistently.

Preview supports selecting text and copying a vertical portion of text: choose Tools > Text Selection, hold Option while selecting, then choose Edit > Copy. Apple notes that this is useful for copying a table column. Select and copy text in a PDF in Preview on Mac

Prepare the PDF and spreadsheet

Open the PDF in Preview. Find the page containing the table and note its first and last rows, including whether the header row is part of the data you want. Make a new sheet or choose a blank area in the target spreadsheet so the import cannot overwrite existing values.

In the spreadsheet, create or identify one destination column per PDF column. Add headers if useful, and leave any adjacent columns clear. Decide whether to include the PDF’s header row in the copied data; if you type headers separately, begin selecting the PDF at the first data row. Keeping that choice consistent across columns helps the resulting rows line up.

Before transferring the full table, try copying one short column. Paste it into the first destination column and check that each line lands in its own row. If it arrives as a single block in one cell, confirm that you clicked a cell once rather than entering its editing mode. Apple documents pasting copied content into Numbers cells; spreadsheet paste behavior can vary with the source and app. Enter text and numbers in Numbers on Mac

Copy and paste each PDF column

  1. In Preview, choose Tools > Text Selection if text selection is not already active.
  2. Hold Option and drag vertically through the first table column. Include the header only if you intend to include it in every column.
  3. Choose Edit > Copy or press Command-C.
  4. Click the top destination cell for that column in the spreadsheet and paste with Command-V.
  5. Return to Preview and repeat for the next PDF column, pasting into the next spreadsheet column.
  6. Compare the first and last data rows in every pasted column with the PDF. Check that each column has the same number of rows before relying on row-by-row relationships.

The Option-drag selection is the key control: it selects text vertically, which Apple identifies as useful for copying a table column. Copying each column separately also means you can place it directly into its intended destination instead of hoping the PDF’s layout becomes a complete grid on paste. Select and copy text in a PDF in Preview on Mac

A simple illustration: if a PDF table has “Item,” “Quantity,” and “Price” columns, copy the item names into one spreadsheet column, quantities into the next, and prices into the third. Then compare a distinctive row in the PDF—such as the final item—with the same row in the sheet. This example describes a checking method; it does not imply that Preview or a spreadsheet automatically validates the values.

Check the pasted data before using it

Look for symptoms of a shifted column: a header appearing in the middle of a list, one column ending earlier than the others, a value attached to the wrong row, or line breaks inside a cell where the PDF shows one entry. Compare a few rows near the top, middle, and end with the original page. Pay particular attention to wrapped text, footnotes, subtotals, and rows that continue across a page break.

Keep identifiers and numbers as printed until you have checked them. PDF extraction can confuse characters such as 0 and O or omit punctuation. A quantity, date, account code, or decimal point that looks plausible can still be wrong. If the selection includes text outside the table, undo the paste and repeat the selection more narrowly rather than deleting ambiguous pieces from the middle of a column.

If Preview cannot select the PDF text

First make sure Tools > Text Selection is active. A PDF may also require its password before text can be selected or copied. Apple’s Preview troubleshooting guide identifies both the selection tool and password protection as possible causes. If you can’t select or copy text in a PDF in Preview on Mac

If the page is an image scan, Preview has a documented File > Export > Embed Text option. Apple says Preview can recognize text in an image based PDF and embed it so the text can be selected in a PDF viewer; the option appears only when text has not already been recognized. After exporting, open the resulting PDF and try selecting a short passage. Recognition can misread characters, so compare the pasted table with the scan rather than assuming the recognized values are exact. Embed text in a PDF

If text recognition does not produce selectable text, or the scan is too unclear to verify, there is no reliable copy-and-paste shortcut to promise. Use a trusted OCR or PDF-to-spreadsheet tool available to you, then validate its output against the page. Avoid treating a pasted result as accurate merely because its columns look tidy.

When to use a spreadsheet import feature

If you use Google Sheets and already have delimited text in cells, its Data > Split text to columns command can split clearly defined data, such as comma-separated text. It depends on a consistent separator; it does not reconstruct a table from a PDF page by itself. Split text, remove duplicates, or trim whitespace

Excel’s Mac Power Query documentation lists supported sources such as text/CSV, XML, JSON, and others, but its Mac source list does not list PDF. Microsoft’s separate PDF import instructions describe a PDF connector and a .NET requirement, while its version matrix lists PDF support for certain Windows Excel editions and not for Excel for Microsoft 365 for Mac. So do not assume Data > Get Data on a Mac will import a PDF; check the available sources in your installed Excel version. Import and shape data in Excel for Mac (Power Query), Power Query data sources in Excel versions

Keep the source and spreadsheet easy to check

Leave the PDF open beside the spreadsheet while you verify rows. If you are already managing several open Mac windows and to-dos around this task, Wallo can organize existing windows and to-dos locally by goal, with keyboard focusing. It does not extract PDF tables; the transfer and checking still happen in Preview and your spreadsheet.

The dependable Mac workflow is to select one PDF column at a time in Preview, paste each column into its matching spreadsheet column, and verify row alignment against the source before using the data. When the PDF is scanned, attempt text recognition only when Preview offers Embed Text, and treat the result as text that needs checking.

Sources