# PDF and Excel how-tos: merge, split, sign, convert

> Markdown version of https://stella.sh/how/pdf-excel for agents and LLMs.
> Merge, split, sign and edit PDFs, pull text and tables out of them, and get JSON, XML, text or Numbers files into Excel, with free tools or Stella (stella.sh).

Merge, split, sign or edit a PDF, get the numbers out of one, or turn an export Excel won't open into a sheet you can sort. Each guide shows the free route first, then Stella (stella.sh) doing it with a real file.

## Merge, split and tidy PDFs.

- [Merge PDF files into one, in the right order](https://stella.sh/how/pdf-excel/merge-pdf-files.md): Combine PDFs and photos into one file in the right order with Preview on a Mac or the free PDF24 Creator on Windows, or let Stella (stella.sh) follow a checklist.
- [Split a PDF into multiple files (one per document)](https://stella.sh/how/pdf-excel/split-pdf-into-multiple-files.md): Split one big scanned PDF into separate files, one per letter or bill, named for what each is: Preview, print to PDF, or Stella (stella.sh) on your own computer.
- [Extract pages from a PDF into their own file](https://stella.sh/how/pdf-excel/extract-pages-from-pdf.md): Save some pages of a PDF as their own file in Preview or the free PDF24 Creator, or tell Stella (stella.sh) whose pages you need and let it find them, receipts included.
- [Delete pages from a PDF (or a folder of them)](https://stella.sh/how/pdf-excel/delete-pages-from-pdf.md): Remove pages from a PDF in Preview or the free PDF24 Creator, or let Stella (stella.sh) drop the advert and terms pages from twelve bills at once and keep the rest.
- [Reorder the pages of a double-sided scan and remove the blanks](https://stella.sh/how/pdf-excel/reorder-pdf-pages.md): Scanned fronts, then backs? Interleave them, reverse the backs and drop blank pages in Preview or PDF24, or let Stella (stella.sh) fix the order by the page numbers.
- [Rotate PDF pages and save them so they stay that way](https://stella.sh/how/pdf-excel/rotate-pdf-pages.md): Turn sideways and upside-down pages of a scanned PDF upright so the fix sticks: Preview on a Mac, PDF24 on Windows, or Stella (stella.sh) finding the wrong pages for you.
- [Split PDF pages in half, so each page stands alone](https://stella.sh/how/pdf-excel/split-pdf-pages-in-half.md): Turn a scan of two-page spreads into single pages with mutool or Preview, or let Stella (stella.sh) split the spreads, keep covers whole and check the order.
- [Add page numbers to a PDF](https://stella.sh/how/pdf-excel/add-page-numbers-to-pdf.md): Number every page of a PDF at the bottom: Preview can't, so use the original file, a free offline tool, Acrobat's Header & Footer, or Stella (stella.sh).
- [Reduce PDF file size when it's too large to email](https://stella.sh/how/pdf-excel/compress-pdf-too-large-to-email.md): PDF too large to email? Reduce the file size on your own computer with Preview or Ghostscript, no upload needed, or let Stella (stella.sh) make a smaller, readable copy.

## Edit, sign and protect PDFs.

- [Edit text in a PDF when you don't have the original](https://stella.sh/how/pdf-excel/edit-text-in-pdf.md): Change a date or phone number in a PDF in the free LibreOffice Draw, or let Stella (stella.sh) replace the old text everywhere in the same font and size, not cover it up.
- [Add your signature to a PDF, from a photo of it](https://stella.sh/how/pdf-excel/add-signature-to-pdf.md): Place your handwritten signature on a PDF with Preview or PDF24, or let Stella (stella.sh) clean up a photo of it. A signature image, not a certified e-signature.
- [Fill in a PDF form for everyone on a spreadsheet](https://stella.sh/how/pdf-excel/fill-pdf-form-from-spreadsheet.md): Fill one copy of a fillable PDF form per person from an Excel list, with ticks and dates right: by hand in Preview or Edge, or with Stella (stella.sh).
- [Add a watermark to a PDF before you send it](https://stella.sh/how/pdf-excel/add-watermark-to-pdf.md): Watermark copies of a passport scan, payslip and bank statement before you send them, with the mark on top of scans too: PDF24, Preview, pdftk or Stella (stella.sh).
- [How to redact a PDF so the text is really gone](https://stella.sh/how/pdf-excel/redact-pdf.md): Black out SSNs and account numbers in a PDF so they're really gone, not just covered: Preview's Redact, PDF24 or Acrobat, or Stella (stella.sh), checked.
- [Remove the password from a PDF you already know](https://stella.sh/how/pdf-excel/remove-password-from-pdf.md): Make copies of password-protected PDFs, like bank statements, that open without the password: Preview's Export, print to PDF, qpdf, or Stella (stella.sh).

## Get text, tables and pictures out of PDFs.

- [Extract text from PDFs, including scanned ones](https://stella.sh/how/pdf-excel/extract-text-from-pdf.md): Get the text out of PDFs with Preview, Word or free OCR, or let Stella (stella.sh) do a whole folder, reading scans and two-column layouts in the right order.
- [Make a scanned PDF searchable](https://stella.sh/how/pdf-excel/make-scanned-pdf-searchable.md): Ctrl+F finds nothing in a scanned PDF? Add a text layer with OCR: OCRmyPDF, PDF24, Acrobat, or Stella (stella.sh) on your own computer, the scan kept as it was.
- [Extract a table from a PDF to Excel](https://stella.sh/how/pdf-excel/extract-table-from-pdf-to-excel.md): Get a multi-page PDF table into Excel with Tabula or Excel's Get Data, or let Stella (stella.sh) rebuild it as one clean sheet with prices as real numbers.
- [Extract the images from a PDF at full quality](https://stella.sh/how/pdf-excel/extract-images-from-pdf.md): Get the original photos out of a PDF at full size, not page screenshots, without uploading it: pdfimages, PDF24, or Stella (stella.sh) pulling them out for you.
- [Convert a PDF to JPG, one sharp picture per page](https://stella.sh/how/pdf-excel/convert-pdf-to-jpg.md): Turn each page of a PDF into a JPG sharp enough to read on a phone, without uploading it: Preview, PDF24 Creator, or Stella (stella.sh) doing every page at once.
- [Convert Excel to PDF without the columns being cut off](https://stella.sh/how/pdf-excel/convert-excel-to-pdf-without-cutting-off.md): Excel to PDF spilling columns onto extra pages? Set landscape and fit to one page wide on every sheet, or let Stella (stella.sh) make the PDF with each sheet fitted.
- [Convert an EPUB to PDF so you can print it](https://stella.sh/how/pdf-excel/convert-epub-to-pdf.md): Turn a DRM-free EPUB ebook into a printable PDF with the chapters, cover and pictures kept: Calibre, or Stella (stella.sh) on your own computer, no converter site.
- [Convert MOBI and AZW3 ebooks to EPUB](https://stella.sh/how/pdf-excel/convert-mobi-to-epub.md): Turn old Kindle-format .mobi and .azw3 ebooks into EPUB for Kobo and other e-readers with the free Calibre, or let Stella (stella.sh) install it and convert the batch.

## Get files into Excel, and back out.

- [Convert a JSON file to Excel you can actually read](https://stella.sh/how/pdf-excel/convert-json-to-excel.md): Open a JSON export in Excel with Power Query, or let Stella (stella.sh) flatten a nested shop export into one row per order, with local dates and totals that match.
- [Convert an XML file to Excel, totals and all](https://stella.sh/how/pdf-excel/convert-xml-to-excel.md): Open an XML file in Excel with Power Query, or let Stella (stella.sh) turn an iPhone Health export into a spreadsheet of daily step totals and weights, on your computer.
- [Convert a text file to Excel, each column in its own column](https://stella.sh/how/pdf-excel/convert-text-file-to-excel.md): Import a fixed-width text report into Excel with the Text Import Wizard, or let Stella (stella.sh) split it into clean columns with names, accents and minus signs intact.
- [Convert a Numbers file to Excel, even without a Mac](https://stella.sh/how/pdf-excel/convert-numbers-to-excel.md): Open an Apple Numbers file on Windows with the free LibreOffice and save it as .xlsx, or let Stella (stella.sh) convert it with every table, number and date intact.
- [Convert Word tables to Excel (from one document or many)](https://stella.sh/how/pdf-excel/convert-word-table-to-excel.md): Copy Word tables into Excel without split cells or phone numbers losing their 0, or let Stella (stella.sh) combine tables from many documents into one sheet.
- [Convert Excel to CSV, keeping leading zeros and dates](https://stella.sh/how/pdf-excel/convert-excel-to-csv.md): Save each Excel sheet as CSV without losing leading zeros or turning dates into numbers, or let Stella (stella.sh) export every sheet at once and check each cell.

## Split, combine and clean spreadsheets.

- [Split an Excel sheet into multiple files by column value](https://stella.sh/how/pdf-excel/split-excel-sheet-into-multiple-files.md): Make one Excel file per salesperson, region or client with filters, or let Stella (stella.sh) split the sheet with no macros and catch names typed inconsistently.
- [Split a CSV file into multiple files that open in Excel](https://stella.sh/how/pdf-excel/split-csv-file-into-multiple-files.md): A CSV over Excel's 1,048,576-row limit gets cut off. Split it into parts with the header in each, or let Stella (stella.sh) split it without breaking multi-line records.
- [Combine multiple Excel files into one sheet](https://stella.sh/how/pdf-excel/combine-excel-files-into-one-sheet.md): Merge a folder of Excel and CSV files into one sheet, even when the columns are in a different order: Power Query's From Folder, or Stella (stella.sh), checked.
- [Merge two Excel sheets based on one matching column](https://stella.sh/how/pdf-excel/merge-two-spreadsheets-by-matching-column.md): Add columns from one sheet to another by a shared ID, even when one side has leading zeros or spaces, with XLOOKUP or Stella (stella.sh), and mark rows that don't match.
- [Compare two Excel sheets and list what changed](https://stella.sh/how/pdf-excel/compare-two-excel-files.md): Find new, removed and changed rows between two Excel files, even when one was re-sorted: XLOOKUP by ID, Spreadsheet Compare, or Stella (stella.sh), checked.
- [Remove duplicate rows in Excel, including the ones it misses](https://stella.sh/how/pdf-excel/remove-duplicate-rows-in-excel.md): Remove Duplicates misses copies that differ by capitals or spaces. Normalise first with LOWER and TRIM, or let Stella (stella.sh) make a clean copy, one row per person.
- [Change dates in Excel from US to UK when they come out wrong](https://stella.sh/how/pdf-excel/fix-dates-in-excel.md): US-style CSV dates in a UK Excel come out swapped or stuck as text. Import them as MDY and show them as dd/mm/yyyy, or let Stella (stella.sh) make a clean Excel file.
- [Fix garbled characters in a CSV file](https://stella.sh/how/pdf-excel/fix-garbled-characters-in-csv.md): Repair names like JosÃ© and â€™ in a CSV, cell by cell, without breaking real accents, and save a copy Excel opens right by double-click. Excel, or Stella (stella.sh).
- [Summarize a spreadsheet by category and month, with totals](https://stella.sh/how/pdf-excel/summarize-spreadsheet-by-category.md): Total spending per category per month with a PivotTable, after fixing the categories and text amounts that make it wrong, or let Stella (stella.sh) build the summary.

## Statements, receipts and bills.

- [Convert bank statement PDFs to Excel](https://stella.sh/how/pdf-excel/bank-statement-pdf-to-excel.md): Turn bank statement PDFs into one clean Excel sheet of transactions: download a CSV, use Excel's PDF import, or let Stella (stella.sh) do it and check the totals.
- [Find every subscription and regular payment in your bank statements](https://stella.sh/how/pdf-excel/find-subscriptions-in-bank-statement.md): List every subscription and regular payment in a year of bank and card exports, with its yearly cost, in Excel or with Stella (stella.sh), without linking your bank.
- [Turn receipts into a spreadsheet for your expense report](https://stella.sh/how/pdf-excel/receipts-to-spreadsheet.md): Get a pile of receipt photos and PDFs into one Excel sheet with date, shop and total: by hand, with Excel's Data from Picture, or with Stella (stella.sh).
- [Split bills with roommates and settle up in the fewest payments](https://stella.sh/how/pdf-excel/split-bills-with-roommates.md): Work out who owes who from a shared house expenses spreadsheet, uneven splits and refunds included, with SUMIF or Stella (stella.sh), settled in the fewest payments.
