DEV Community

Ravi Verma
Ravi Verma

Posted on

How to Convert Excel to PDF: Share Price Lists, Reports and Invoices That Anyone Can Open

You finish a price list in Excel, attach the .xlsx file, and the client replies that they cannot open it. Or they open it, change a number by mistake, and send the wrong quote back. A PDF fixes both problems: it opens on phones, tablets and office PCs, and the cells are not editable.

This guide shows how to turn an Excel workbook into a clean PDF table with the free Excel to PDF tool on PKD Ventures, what the options actually do, and the mistakes that leave people with a blank or truncated file.

When a PDF is better than a spreadsheet

Keep the .xlsx for your own work. Send a PDF when:

  • A client or vendor needs the numbers, not an editable sheet.
  • A portal or email only accepts PDF uploads.
  • A phone will open the file more reliably than Excel Online or Sheets.
  • You print a price list, attendance sheet or simple report and want consistent page breaks.

If you still need the other person to edit the data, keep sending the spreadsheet. PDF is for sharing a fixed view of the values.

What the tool actually does

The converter reads the values from each sheet of an .xlsx workbook and lays them out as tables on A4 pages. It does not try to clone Excel's look. That means:

  • Cell values and formula results appear in the PDF.
  • Colours, custom fonts, merged cells, charts and images are not carried over.
  • You choose portrait or landscape, whether the first row repeats as a header, and whether gridlines show.
  • Wide sheets are split into column groups so columns are not cut off at the page edge.

So treat the result as a clear data table, not a pixel-perfect print of your formatted workbook. For many price lists, stock sheets and simple reports, that is exactly what you want.

Step by step: convert Excel to PDF

  1. Open Excel to PDF.
  2. Add one .xlsx file (up to 25 MB). Older .xls files are not accepted; open them in Excel, Google Sheets or LibreOffice and save as .xlsx first.
  3. Under Sheets, choose Every sheet or First sheet only.
  4. Under Orientation, pick Landscape (more columns) or Portrait. Landscape fits more columns before the sheet is split into groups.
  5. Tick First row is a header (repeats on each page) when your top row is labels such as Item, Qty, Rate.
  6. Leave Gridlines on if you want table lines; turn them off for a cleaner look.
  7. Click Convert to PDF.
  8. When the result is ready, enter your name and email and choose Email me the result. Check spam if it does not arrive quickly.

The download name follows your original file with a .pdf extension, so march-prices.xlsx becomes march-prices.pdf.

Choosing the right options

Every sheet vs first sheet only

Use First sheet only when the workbook has helper sheets, raw data or a dashboard you do not want in the PDF. Use Every sheet for a multi-tab report (for example January, February, March) that should appear as consecutive sections. Each sheet starts on a new page and is labelled with the sheet name.

Landscape vs portrait

Landscape is the safer default for spreadsheets because tables are usually wide. Portrait works for narrow lists such as a single column of names or a short checklist. If you have more columns than fit on one page, the tool splits them into groups (up to 12 columns per group in landscape, 8 in portrait) and labels each group, for example Columns A–L, then Columns M–X. Nothing is silently cropped.

Header row and gridlines

Turn the header option on whenever row 1 is column titles. Those titles repeat at the top of each continued page, which makes long lists readable when printed. Gridlines help people read across rows; turn them off only when the PDF will sit inside a designed document and you want less visual noise.

Practical uses

Small business owners. Export a quotation sheet, dealer price list or stock summary as PDF before you WhatsApp or email it. The other person sees the numbers without opening Excel and without editing a cell by accident.

Students. Hand in a data table or assignment appendix as PDF so the layout is the same for the examiner on Windows, Mac or phone.

Sellers and marketplace sellers. Share a SKU list or rate card as PDF when a buyer or platform asks for a non-editable file. Keep the live .xlsx for your own updates.

Common mistakes (and how to avoid them)

Sending an old .xls file. The tool only accepts .xlsx. Re-save the file first. If you only have a CSV, convert it with CSV to XLSX and then run Excel to PDF.

Expecting colours, logos and charts. Those stay in Excel. If you need a branded one-pager, build it in Word or a design tool, or paste a chart as an image into a document and export that. This converter is for table values.

Hindi, Devanagari or Chinese text looking blank. The built-in PDF font does not cover those scripts. Keep those sheets in Excel for editing, or use a workflow that embeds a font that supports them. English and other Latin-script text are fine.

Dates looking unfamiliar. Date cells appear as YYYY-MM-DD (with time when present). That is deliberate so every reader sees the same order, not a locale-dependent day/month swap.

Wide sheets that feel "broken" into sections. That split is intentional. Prefer landscape, hide unused columns in Excel before export, or move a summary to a narrower first sheet and convert only that sheet.

Forgetting to check formula results. The PDF shows the last calculated values stored in the file. If a formula had not recalculated before you saved, the PDF will show the stale number. Open the workbook, confirm the totals, save, then convert.

Going the other way: PDF back to Excel

Sometimes you receive a PDF table and need rows you can sort and filter. The companion PDF to Excel tool rebuilds text-based tables into an .xlsx file. It works best on clear, selectable text tables, not scans. Always review the layout before you rely on the numbers.

For plain data interchange without PDF, XLSX to CSV and CSV to XLSX cover the common export and import path.

Quick checklist before you hit Convert

  • File is .xlsx, under 25 MB, one workbook at a time.
  • Extra sheets you do not want are either removed or you selected First sheet only.
  • Orientation matches the width of the table.
  • Header tick matches whether row 1 is labels.
  • Totals and dates look right in Excel before you convert.
  • You are fine with values-only tables (no charts or merged-cell layouts).

Wrap-up

Excel is for working with numbers. PDF is for sharing a fixed view of those numbers. Convert the sheet with Excel to PDF, pick landscape for wide tables, keep the header row on for long lists, and email yourself the result. When you need the reverse path or a CSV hand-off, the related tools on pkdventures.in cover that without retyping a single cell.

Top comments (0)