We Value Your Privacy

We and our partners use technology such as cookies on our site to personalise content and ads, provide social media features, and analyse our traffic. Click below to consent to the use of this technology across the web. You can change your mind and change your consent choices at anytime by returning to this site.

Update Consent
Loading ...

How to Convert PDF to CSV

Database and spreadsheet applications access external data saved in a comma-separated value (CSV) format. CSV provides specific, basic formatting for fields and records. Information from a PDF can be exported as a text file (TXT format) that contains tab-delimited formatting before converting to a CSV data file. Common spreadsheet programs such as Microsoft Word or OpenOffice Calc import text files directly through the Open command. Similarly, these programs convert spreadsheets into CSV format through the Save As function. The spreadsheet application provides a useful intermediary step because data and formatting can be checked before converting to a CSV file.

Loading ...
  1. Open the desired PDF document in Acrobat Standard or Professional.

  2. Select "Export" under "File" and choose "Text." Some versions of Acrobat include options for "Text (accessible)" and "Text (plain);" choose "Text (accessible)" to preserve basic formatting.

  3. Type the file name for the converted document and click the "Save" button. Acrobat saves text files as tab-delimited files.

  4. Launch the spreadsheet application (such as Microsoft Excel or OpenOffice Calc) and select "Open" under "File" in the top menu bar.

  5. Select the text file created in Step 3 and click the "Open" button to launch an Import Wizard.

  6. Review the pages in the Import Wizard to select how the data is organised in columns and click the "Next" button to navigate through the wizard. For example, select "Delimited" to specify fields and click the option next to "Space" or "Comma" to specify how the fields are separated.

  7. Click the "Finish" button.

  8. Select the "Save As" function (usually under "File" in the top menu bar) and select the file type as "CSV (Comma-Separated Values)." Select "CSV (Windows)" instead of "CSV (MS-DOS)" if this option is displayed.

  9. Click the "Save" button.

  10. Tip

    Since Acrobat exports text files in a tab-delimited format, check whether your desired target application (such as database program) can import a text file accurately before proceeding with the added steps to convert the file to a CSV format.

Loading ...

Things You'll Need

  • Adobe Acrobat Standard or above
  • Spreadsheet application

About the Author

Regina Edwards has been a freelance writer since 1990. She has penned video scripts, instructional manuals, white papers and abstracts. She has also ghostwritten diabetes journals. Edwards is a scuba instructor and Usui and Karuna Reiki teacher. She holds a Bachelor of Science from Saint Joseph's University.

Loading ...