This article shows you how to copy data from an invoice in PDF into an Excel spreadsheet.

Problem

  1. You have the following invoice in PDF:
  2. You want to copy the information from the invoice into an Excel spreadsheet:

Solution

  1. First make sure you have downloaded and installed UiPath Clipboard AI. As of now, you can still use it for free.
  2. Download a copy of the invoice if you want to follow along this workshop: sample_invoice01.pdf
  3. Open the PDF in Adobe Acrobat or any PDF viewer.
  4. Make sure the PDF is selected. Click the "Copy" button in the floating panel of UiPath Clipboard AI:
  5. Double check that the filename of the PDF is displayed correctly here. If not, repeat Step 4.
  6. Now create a new Excel workbook. Click the cell "A1".
  7. Make sure the contact form is selected. Click the "Paste" button in the floating panel of UiPath Clipboard AI.
  8. When the Clipboard Mapper appears, scroll to the bottom and check if you see this item "Table items (4 columns)". If you see this item, jump ahead to Step 12.
  9. Scroll to the top and click the "Change" button:
  10. Select the second extractor "Specific documents":
  11. Scroll to the bottom again and double check you can now see this item "Table items (4 columns)":
  12. Click the "Paste data" button:
  13. All the information from the invoice will now appear in the Excel spreadsheet, including the company information, invoice subtotal/GST/total and all the line items.

Getting the Invoice Data only without Line Items

What if you only want the invoice level information only, without the line items, as shown below:

  1. Follow step1 to 5 above.
  2. Download a copy of the Excel document if you want to follow along this workshop: invoice01.xlsx
  3. Open the downloaded Excel file. You will see the following with 3 rows of data:
  4. Highlight Cell A4 in the Excel spreadsheet:
  5. Make sure the Excel spreadsheet is selected. Click the up arrow on the right of the "Paste" button in the floating panel of UiPath Clipboard AI. Then click "Paste with mapper".
  6. Scroll to the top and click the "Change" button:
  7. Select the first extractor "Universal Extractor (preview)":
  8. However over the second field "Date". A "Transformation" button will appear (like a double arrow). Click on this button:
  9. Enter: DD-MMM-YY to DD/MM/YYYY and press Enter. This will automatically transform the date into Singapore date format dd/mm/yyyy
  10. Click the "Paste data" button:
  11. All the information from the level 1 invoice info will now appear in row 4 of the Excel spreadsheet. Note that the date is also in the correct Singapore date format.

Comments

1
CK
1 month ago
If you have an invoice that spans across multiple pages, please give it a try and share with us if it works across multiple pages. Tks!
Like Like Quote

Add comment

Submit