You have an Excel file that looks right on your screen, but you need to send it as a PDF that won’t shift columns, cut off totals, or expose formulas. You may also need a clean CSV version for uploading into another system, importing into a database, or sharing raw table data without formatting. This guide shows the practical settings to use in Excel, Google Sheets, and online tools so your PDF and CSV exports come out correctly the first time.
PDF vs CSV: choose the right output before exporting
Excel files can hold formulas, multiple sheets, charts, filters, hidden columns, formatting, print areas, comments, images, and macros. PDF and CSV handle those things very differently.
Use PDF when the file is meant to be read, printed, approved, signed, attached to an email, or preserved visually. A PDF keeps page layout, fonts, borders, colors, headers, footers, charts, and page breaks. It is the right choice for invoices, financial summaries, schedules, price lists, reports, dashboards, and forms.
Use CSV when the file is meant to be imported into another app. A CSV is plain text with rows and columns separated by commas. It does not keep formatting, formulas, merged cells, multiple tabs, colors, charts, images, comments, or cell widths. It is best for contact lists, product catalogs, transaction exports, inventory data, analytics uploads, and database imports.
A simple rule: if a human needs to read the file exactly as designed, export to PDF. If software needs to process the rows, export to CSV.
Prepare your spreadsheet before converting to PDF
Most bad Excel-to-PDF exports happen before the export step. The sheet looks fine in normal view, but Excel prints based on page settings, not just what you see on screen.
Start by opening the workbook and going to View > Page Break Preview in Microsoft Excel. This shows exactly where pages will split. If a total column lands alone on a second page, drag the blue page break line to include it, or change the scaling settings.
Next, set the print area. Select only the range you want to export, then choose Page Layout > Print Area > Set Print Area. This is useful when your workbook has scratch calculations, notes, lookup tables, or old data off to the side. If you skip this step, Excel may include blank-looking pages because a stray value or border exists far outside your visible table.
Check these settings before saving as PDF:
For reports going by email, aim for readable pages rather than tiny all-in-one exports. A 12-column sales report is often better as two landscape pages with readable 10 or 11 pt text than one page with 6 pt text.
Convert Excel to PDF in Microsoft Excel
Microsoft Excel has the most reliable built-in PDF export because it understands print areas, page breaks, charts, and workbook structure.
On Windows
Alternatively, use File > Save As > PDF. Before saving, click Options and choose whether to publish the selection, active sheets, or entire workbook. This is where many people accidentally export one tab instead of the full file.
On Mac
On Mac, the print preview is especially important because hidden scaling choices can produce small text. If the preview looks cramped, return to Page Layout and set the width to 1 page and height to Automatic instead of forcing the entire sheet onto one page.
Using an online converter
If you do not have Excel installed, upload the workbook to a browser-based converter such as Excel to PDF. This is useful for quick conversions from `.xlsx` or `.xls` when you only need a PDF copy and do not want to install office software.
Before uploading, clean the workbook: remove private sheets, delete hidden notes, and save a copy with only the tabs you need converted. Online conversion works best with straightforward sheets: normal tables, basic formulas, charts, and standard fonts. If your workbook depends on macros, external data connections, or unusual add-ins, open it in Excel first and export from there.
Convert Excel to CSV without breaking the data
CSV export is simple, but it is easy to create a file that imports incorrectly. The key is remembering that CSV saves only one sheet at a time and converts cell values into plain text.
Export from Microsoft Excel
Choose CSV UTF-8 whenever the file contains names, addresses, accents, currency symbols, or non-English text. UTF-8 reduces character problems when the file is imported into web apps, databases, and modern software.
If you are exporting for a system that specifically requests “CSV comma delimited,” use that format. If the recipient is in a region where semicolons are common as separators, confirm the required delimiter before sending. A comma-separated file and semicolon-separated file may look similar in a text editor but import very differently.
Export from Google Sheets
Google Sheets is often more predictable for UTF-8 CSV output. It is a good workaround if Excel is producing strange characters, especially in files with names, cities, product descriptions, or multilingual text.
Check the CSV before uploading
Do not validate a CSV only by double-clicking it in Excel. Excel may auto-format dates, large numbers, and IDs, hiding problems or creating new ones. Instead, open the CSV in a plain text editor first.
Check for these issues:
If the CSV will feed a database or API, use clear column names with no merged cells. Good headers look like `first_name`, `last_name`, `email`, `order_total`, and `purchase_date`. Avoid headers like `Name (required!)`, `Total $`, or `Date???` unless the receiving system explicitly accepts them.
Common Excel to PDF problems and how to fix them
Columns are cut off in the PDF
Go to File > Print and check the preview. If the last column is missing, choose Landscape, then set scaling to Fit All Columns on One Page. If the text becomes too small, split the report into two logical sections instead of squeezing everything onto one page.
For example, export columns A–H as a summary PDF and columns I–P as a detail PDF, or create a separate printable sheet with only the fields the reader needs.
The PDF has extra blank pages
This usually means Excel thinks there is content outside your visible table. Press Ctrl + End on Windows or Cmd + End on Mac if supported, and see where Excel jumps. If it jumps far below or to the right of your data, delete the unused rows and columns, then save the workbook.
You can also reset the print area: Page Layout > Print Area > Clear Print Area, select the correct range, then choose Set Print Area again.
Headers appear only on the first page
Frozen panes help while editing, but they do not control printing. Use Page Layout > Print Titles and set Rows to repeat at top. For a table with headers in row 4, select `$4:$4`. For a report title in rows 1–3 and column headers in row 4, repeat `$1:$4` if you want all of that on every page.
Text is too small after export
Do not force a large sheet onto one page. In Page Layout, set width to 1 page and height to Automatic. This keeps columns together but allows the report to run across multiple pages vertically. Also consider reducing margins to Narrow and removing nonessential columns.
For readable business PDFs, keep body text around 9–11 pt. Anything below 8 pt becomes hard to read after printing or viewing on a laptop screen.
Charts or images shift position
Right-click the chart or image, choose Size and Properties, then check its positioning. Use Move and size with cells if the object should stay aligned with a table. Use Don’t move or size with cells for a logo or fixed header image. Then check the print preview again.
Common Excel to CSV problems and how to avoid them
Dates change format
Excel likes to reinterpret dates. If the receiving system needs `YYYY-MM-DD`, create a helper column with a formula such as:
`=TEXT(A2,"yyyy-mm-dd")`
Copy the helper column, then paste it as values before exporting. This prevents Excel from saving a date in a format the import tool rejects.
Leading zeros disappear
ZIP codes, SKUs, employee IDs, and account numbers often start with zero. Format those columns as Text before entering data. If the zeros are already gone, you will need to rebuild them with a formula.
For a five-digit ZIP code in cell A2, use:
`=TEXT(A2,"00000")`
Then paste the result as values before exporting to CSV.
Formulas export the wrong thing
CSV saves the displayed result of a formula, not the formula itself. If your formulas depend on external workbooks, volatile functions, or filters, recalculate the sheet first. Press Ctrl + Alt + F9 in Excel for Windows to force recalculation, then save a copy as CSV.
If accuracy matters, copy the final table and use Paste Special > Values into a new sheet. Export that clean sheet.
Commas inside cells break columns
A proper CSV wraps comma-containing text in quotes. Excel usually handles this automatically, but problems appear when files are edited manually or generated from messy sources. Product names like `Shirt, Blue, Large` should appear as:
`"Shirt, Blue, Large"`
If your import tool shows those as three separate columns, check whether the file was saved correctly and whether the importer is set to comma as the delimiter.
Multiple sheets do not export
CSV cannot store multiple tabs. Export each sheet separately and name them clearly, such as:
If the recipient expects one file, ask whether they want a combined table or a ZIP containing separate CSV files. Do not assume that saving the workbook as CSV preserves every sheet.
Best workflow for sharing both PDF and CSV
For many real projects, you need both formats: a PDF for review and a CSV for import. Do not make one from the other. Create both from the original Excel workbook.
Use this workflow:
This approach avoids the common mistake of trying to make one sheet serve two purposes. A good PDF sheet is formatted for humans. A good CSV sheet is structured for machines.
A clean Excel export comes down to preparation: set the print area and page scaling before making a PDF, and simplify the data before making a CSV. If you need a quick browser-based option, try the Excel to PDF tool and check the finished PDF preview before sending it.