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.
Open the desired PDF document in Acrobat Standard or Professional.
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.
Type the file name for the converted document and click the "Save" button. Acrobat saves text files as tab-delimited files.
Launch the spreadsheet application (such as Microsoft Excel or OpenOffice Calc) and select "Open" under "File" in the top menu bar.
Select the text file created in Step 3 and click the "Open" button to launch an Import Wizard.
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.
Click the "Finish" button.
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.
Click the "Save" button.
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.
Tips and warnings
- 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.
Things you need
- Adobe Acrobat Standard or above
- Spreadsheet application