Skip to main content
All CollectionsUsing PDF2XLPDF2XL Basic Concepts
Converting Non- Columnar Data into Tables
Converting Non- Columnar Data into Tables
PDF2XL Support avatar
Written by PDF2XL Support
Updated over 2 years ago

Sometimes you might want to convert data that is not arranged neatly in columns into a table.The best tool to use for such conversions is associated fields, which are fields that are set to be displayed next to only one table. You can set a field to be associated with a table by right-clicking on that field and using the "In Conversion, Show Field" option.

Directions

  1. Select the line of data that will act as the table "Key". It will likely show as a blue field.

  2. Right-Click and "Change to Table".

  3. Select the remaining data in that section as separate "Fields".

  4. Select each Field by holding down your CTRL key and left-clicking on each one (do not click on the orange table Key).

  5. Right-click and select "In Conversion, Show Field > With Table". See how the data in the Page Preview pane is now lined up in a row?

  6. Select the orange table Key.

  7. Then, hold down your CTRL key and left-click on each blue field to select them all.

  8. Right-click and select "Copy Selection". 

  9. Move your cursor to the next section of data.

  10. Right-click and select "Paste Here". Note that if this option is disabled, it means that it's not able to paste in that section for some reason - usually because the pasted data will overlap other elements or it will extend past the edge of the page. Move around the sheet a little until you are able to click on the "Paste Here" option.

Did this answer your question?