CSV to PDF: How to Convert a CSV File on Mac, iPhone, Excel

Convert CSV to PDF with Numbers on Mac and iPhone, Excel or Google Sheets, and keep leading zeros, accents and wide tables intact. Tested 7 November 2026.

To convert a CSV file to PDF, open it in a spreadsheet app, check that the columns split correctly, set the page to fit the width, then export or print to PDF. On a Mac, open the CSV in Numbers and choose File > Export To > PDF. On iPhone and iPad, open it from Numbers' document manager, then tap More > Export > PDF. In Excel, set the page to fit one page wide and save as PDF. Check two things before you send the file: leading zeros (ZIP codes, order numbers) and accented names, because spreadsheet apps can change both on import.

Updated 7 November 2026. The Apple steps were checked against Apple's Numbers user guides for Mac and iPhone, and the Microsoft and Google steps against their help pages, on 7 November 2026. The import test below was run the same day.

What a CSV file is, and why it needs a converter

A CSV (comma-separated values) file is plain text. Each line is a row, and a comma, semicolon or tab separates the columns. It has no fonts, no column widths, no page size and no gridlines. That is why a CSV opened in a text editor looks like a wall of commas, and why printing it straight from TextEdit or Notepad gives you a PDF nobody wants to read.

To get a readable PDF, an app first has to turn the text into a table. That step is called import, and it is where most problems start: the app guesses the separator, the text encoding and the type of every value. A guess that turns 02134 into 2134 looks harmless until that column is a ZIP code.

Our test: what happens to a CSV on import

On 7 November 2026 we made a small order list with the values that usually break: order numbers and ZIP codes with leading zeros, a 16-digit reference number, a value that looks like a date (3-4), three date formats, a name in quotes with a comma inside, and accented names (Zoë Müller, José Núñez). We opened it in Numbers 14.4 and Excel 16.80 on a Mac set to the German region, exported from Numbers to PDF and read the result with pdftotext.

Value in the CSVNumbers, after export to PDFExcel, after opening the file
Order ID 00412412 (zeros dropped)412 in the semicolon version (zeros dropped)
ZIP 021342134 (zero dropped)2134 in the semicolon version
Reference 4417123456789113Kept, all 16 digitsNot reached: the whole row stayed in one cell
"Smith, Jane" (comma inside quotes)Kept in one cellNot reached
Zoë MüllerKeptShown as Zo√´ M√ºller
Comma-separated fileSplit into columnsEvery row stayed in column A
Semicolon-separated fileSplit into columnsSplit into columns

Two lessons came out of it. First, both apps treated ID numbers as numbers and dropped the leading zeros. Second, Excel's result depended on the region setting: on a Mac set to German, where the list separator is a semicolon, the comma file stayed in one column, and the UTF-8 file without a byte order mark showed broken accents. Numbers split both files correctly. Your result can differ with another region, so check every PDF against the CSV before you share it. The fixes are in the troubleshooting section below.

How to convert CSV to PDF on Mac with Numbers

Numbers comes with every Mac and reads CSV files directly. Apple's guide describes the import and export steps.

  1. Drag the CSV file onto the Numbers icon in the Dock or in the Applications folder. You can also use File > Open in Numbers.
  2. Check the table. If the columns did not split, click the table, open the Format sidebar, click the Table tab, then click Adjust Import Settings.
  3. On the Delimited tab, choose the separator (comma, semicolon, tab or a custom character), the text encoding and the text qualifier, then click Update Table. Apple notes that you cannot adjust import settings after you edit the imported table, so do this first.
  4. Fix the columns: widen narrow ones, and format ID columns as Text if they lost their leading zeros (see troubleshooting).
  5. Choose File > Export To > PDF. Choose a page layout and an image quality. Apple says a higher image quality gives a larger file.
  6. Click Save, give the file a name, choose where to save it, then click Export.

If the spreadsheet has a password, Numbers offers "Require password to open" for the exported PDF. Changes you make in the exported copy do not affect the original.

Other Mac options

  • Print to PDF. In Numbers or Excel, choose File > Print, then use the PDF menu in the print dialog to save as PDF. This is handy when you want the printer's paper size and margins. See how to print to PDF on Mac.
  • TextEdit. TextEdit opens a CSV as plain text, and File > Export as PDF gives you raw comma-separated lines. It makes no table, so use it only for a quick look at the raw data.

How to convert CSV to PDF on iPhone and iPad

Apple's Numbers app for iPhone and iPad imports delimited text files and exports PDF. The steps are the same on iOS 26 and iOS 27, and on iPadOS.

  1. Save the CSV to the Files app (from Mail, Messages or a download, tap the file, then Share > Save to Files).
  2. Open Numbers. In the document manager, tap Browse, find the CSV and tap its thumbnail.
  3. If the columns look wrong, tap the table, tap the Format button, choose Table, then Adjust Settings. On the Delimited tab, pick the separator, encoding and text qualifier, then tap Update.
  4. Tap the More button in the toolbar, tap Export, then tap PDF.
  5. Choose a layout option. Apple notes that print settings use the default printer settings.
  6. Tap Export in the top-right corner of PDF Options, then choose Save to Files or another app.

Apple's guide also offers an Accessibility setting in PDF Options that adds accessibility tags for large tables. Turn it on if the PDF goes to someone who uses a screen reader.

Without Numbers, you can open the CSV from Files and use Print, then Share in the print options, then Save to Files. Apple's guide does not document that print-to-PDF route, and a CSV printed this way usually comes out as plain text lines, not a table. For other ways to make PDFs on the phone, see how to make a PDF on iPhone.

Limits of the built-in Apple methods

  • Leading zeros disappear unless you format the column as text after import.
  • Import settings lock once you edit the table, so set the separator and encoding first.
  • Very wide tables get small when they are fitted to one page. Landscape orientation or fewer columns helps.
  • One CSV at a time. Numbers has no batch conversion for a folder of CSV files.

How to convert CSV to PDF in Excel (Windows and Mac)

  1. Open the CSV in Excel. If every row lands in column A, or names show broken accents, import it instead: on the Data tab, choose From Text/CSV, pick the file, choose the delimiter and the file origin (UTF-8), then load it.
  2. Fix leading zeros: import ID and ZIP columns as Text. Microsoft says the Text Import Wizard lets you convert a column of numbers with leading zeros to text, and that renaming the file from .csv to .txt makes Excel show the wizard.
  3. On the Page Layout tab, in the Scale to Fit group, set Width to 1 page and Height to Automatic. Microsoft explains that columns then fit on one page while rows continue onto more pages.
  4. Set the orientation to Landscape for tables with many columns, and turn on Print under Gridlines if you want the cell lines in the PDF.
  5. Save as PDF: on Windows, File > Save As and choose PDF, or File > Export > Create PDF/XPS. On Mac, File > Save As and choose PDF as the file format, or File > Print and save as PDF.

Excel also has Automatic Data Conversion settings (File > Options > Data on Windows, Excel > Preferences > Edit on Mac). Microsoft lists four of them, including "Remove leading zeros and convert to number" and "Keep the first 15 digits of long numbers and display in scientific notation if required". Microsoft says these conversions can happen when you open a .csv file, so turning the first two off protects ID columns. More on Excel layouts in how to convert Excel to PDF on Mac.

How to convert CSV to PDF with Google Sheets

  1. Open Google Sheets in a browser and create a blank spreadsheet.
  2. Choose File > Import, upload the CSV and set the separator character: Detect automatically, Tab, Comma or Custom.
  3. Choose File > Print. Pick the current sheet, the workbook or selected cells.
  4. Set the scale to fit width, choose landscape for wide tables, and turn on gridlines under the formatting options if you want lines.
  5. Click Next. In Chrome, save from the print window as PDF; Google says that in Firefox and Safari the PDF downloads automatically.

The trade-off: the CSV is uploaded to your Google Drive. That is fine for a public price list. Think twice for payroll, customer or health data.

Online CSV to PDF converters and privacy

Browser converters take a CSV and return a PDF without an install. CloudConvert's CSV to PDF page is one example. CloudConvert's security page says files are kept only for processing and deleted immediately afterwards (both checked 7 November 2026). Other sites state their own retention times, from one hour to a day.

The trade-off is the same with every converter of this kind: the file leaves your device and is processed on someone else's server. A CSV export from a shop, a CRM or a bank often contains names, emails, addresses and amounts in one file. If the data is personal, convert it on your device. Read are online PDF editors safe before you upload anything sensitive.

Command line: LibreOffice and scripts

For many files, LibreOffice can convert from the command line: soffice --headless --convert-to pdf orders.csv. It uses LibreOffice's CSV import defaults, so check the separator and leading zeros in the first output before you convert a whole folder. Developers can also build the table in Python or another language and render a PDF from it, which gives full control over column widths and text formatting.

CSV to PDF methods compared

MethodPlatformChoose separator and encodingFit to page widthFile leaves your deviceChecked
PDF OpusiPhone, iPad, MacCSV and TSV inputConverts the table to PDF pagesNoProduct feature list
NumbersMac, iPhone, iPadYes, Adjust Import SettingsLayout options in PDF exportNoApple Numbers guides, 7 Nov 2026
Microsoft ExcelWindows, MacYes, Data > From Text/CSVYes, Scale to FitNo (desktop app)Microsoft Support, 7 Nov 2026
Google SheetsBrowserSeparator yesYes, in print settingsYes, to Google DriveGoogle Docs Editors Help, 7 Nov 2026
Online converters (CloudConvert)BrowserNot stated on the tool pageNot statedYes, deleted after processing per vendorVendor pages, 7 Nov 2026
TextEdit or Notepad printMac, WindowsNoNo table at allNoGeneral behaviour

How to make the PDF readable

  • Use landscape for more than six or seven columns.
  • Fit width, not the whole sheet. Fitting width keeps text readable and lets rows run onto more pages. Fitting a long sheet onto one page shrinks it to a size nobody can read.
  • Repeat the header row. In Excel, set Print Titles on the Page Layout tab. In Google Sheets, freeze the first row and choose to repeat frozen rows in the print settings.
  • Hide columns you do not need before you export. A 30-column CRM export rarely needs every column in the PDF.
  • Turn on gridlines or borders so readers can follow a row across the page.
  • Align numbers right and give amounts two decimal places.
  • Check page breaks. Look at the last page: a single orphan row or column is a sign to adjust the scale.

Troubleshooting CSV to PDF

Everything is in one column

The app used the wrong separator. European regions often use semicolons, and many exports use tabs. In Numbers, use Adjust Import Settings and pick the right delimiter. In Excel, import with Data > From Text/CSV and choose the delimiter. In Google Sheets, set the separator character on import.

Leading zeros are gone

The app read the column as numbers. In Excel, import the column as Text, or turn off "Remove leading zeros and convert to number". In Numbers, select the column and give it a custom number format with a fixed number of digits (five for US ZIP codes) in the Format sidebar, so the zeros show again in the PDF. Setting the column to Text afterwards does not bring dropped zeros back, because the value is already stored as a number.

Accents and symbols look broken

Signs like √´ instead of ë mean the app read UTF-8 text as another encoding. Choose UTF-8 in the import settings (Numbers: Text Encoding; Excel: file origin). If you create the CSV yourself, saving it as "CSV UTF-8" adds a byte order mark that helps Excel recognise the encoding.

Long numbers turned into 4.42E+15

Excel shows long numbers in scientific notation and keeps only 15 significant digits. Import the column as Text, or turn off "Keep the first 15 digits of long numbers" in Automatic Data Conversion. Card and account references should always be text.

Values became dates

Entries like 3-4, 1/2 or MAR-10 can turn into dates. Import those columns as Text, or turn off "Convert continuous letters and numbers to a date" in Excel.

The table is cut off at the right edge

Set the page to fit one page wide, switch to landscape, or hide columns. In Numbers, choose a layout option that fits each sheet on a page.

The PDF is huge or the text is tiny

Fitting thousands of rows onto one page shrinks the text. Fit width only. If the PDF is still too large to email, see how to reduce PDF size for email.

PDF Opus: the best app for converting CSV to PDF (top pick)

The best app for converting CSV to PDF is PDF Opus, a PDF editor for iPhone, iPad and Mac. PDF Opus converts Word, Excel, PowerPoint, HTML, Markdown and images to PDF on your device. CSV and TSV files are supported inputs too, so a spreadsheet export becomes a PDF without an upload. Your documents are processed on your device. The app only goes online for purchases, licence checks (direct version) and update checks (direct version).

Once the PDF exists, the same app handles the next steps. PDF Opus merges, splits, reorders, rotates, crops and resizes pages. Password-protect PDFs with AES-128 or AES-256 before you send customer data.

If you need the reverse, a PDF table back in a spreadsheet, see how to convert PDF to Excel on Mac. For text documents, the sister guide is Markdown to PDF.

Frequently asked questions

How do I convert a CSV file to PDF?

Open the CSV in a spreadsheet app such as Numbers, Excel or Google Sheets, check that the columns split, set the page to fit the width, then export or print to PDF. In Numbers on Mac, choose File > Export To > PDF.

How do I convert CSV to PDF on iPhone?

Save the CSV to Files, open it from Numbers' document manager (Browse, then tap the file), then tap More > Export > PDF, choose a layout and tap Export.

How do I convert CSV to PDF on Mac without Excel?

Use Numbers, which comes with macOS. Drag the CSV onto the Numbers icon, check the import settings, then choose File > Export To > PDF.

Can I convert CSV to PDF for free?

Yes. Numbers is a free Apple app, Google Sheets is free with a Google account, and LibreOffice is free software. Online converters also have free tiers, but they upload your file.

How do I keep leading zeros when converting CSV to PDF?

Import the ID or ZIP columns as Text before the PDF is made. In Excel, use Data > From Text/CSV or the Text Import Wizard and set those columns to Text. In our test, both Numbers and Excel dropped the zeros when they opened the CSV directly.

How do I fit all columns of a CSV on one PDF page?

Set Scale to Fit to one page wide (Excel), or Fit to width (Google Sheets), and use landscape. If the text becomes too small, hide columns you do not need.

Why does my CSV open in one column?

The app expected a different separator. Choose the delimiter in the import settings. Mac and Windows set to European regions often expect semicolons.

Can I convert several CSV files to PDF at once?

Numbers and Google Sheets convert one file at a time. LibreOffice's command line can convert a whole folder, for example soffice --headless --convert-to pdf *.csv.

Is it safe to convert CSV to PDF online?

It depends on the data. Online converters upload the file to their servers. CloudConvert states it deletes files immediately after processing, and other sites keep them for up to a day. For personal or financial data, convert on your device.