True PDF Software for you!
  2. Products
  3. PDF Printer
  4. Documentation
  5. ZUGFeRD4Excel – Easily print e-invoices from Excel / PDF Printer

ZUGFeRD4Excel – Easily print e-invoices from Excel / PDF Printer

📢 Important notice: ZUGFeRD conversion only after testing, request and availability.

Please first test the processing with your own suitable PDF invoices.

👉 ZUGFeRD4Excel – Prepare PDF/ZUGFeRD invoices from Excel in a controlled workflow

Generate ZUGFeRD e-invoice from Excel via PDF print Do you still create your invoices in Word or Excel? For suitable, machine-readable PDF invoices, our 7-PDF Invoice Extractor (KI Service) 🤖 can help prepare a review-required PDF/ZUGFeRD e-invoice. The solution complements existing workflows but does not replace invoicing, accounting or ERP software.

Thanks to our AI-assisted online service, the 7-PDF Invoice Extractor can detect suitable invoice data from machine-readable PDF invoices — from the issuer and line items to tax rates and totals. The prerequisite is that the layout and text flow are machine-readable and that the invoice data is complete, plausible and checkable. The generated result must be checked visually, professionally, formally and technically before it is forwarded.

✔ What are the options for creating a review-required PDF/ZUGFeRD invoice?

You can either use the following setup steps to build a controlled PDF print workflow from Excel and prepare suitable invoices directly from the Excel print dialog as PDF/ZUGFeRD files. Or, if the PDF invoice already exists, you can use 7-PDF Attach Extract and Remove to prepare suitable PDF invoices directly as review-required PDF/ZUGFeRD e-invoices. Alternatively, suitable PDF invoices can also be processed online via our ZUGFeRD Online Portal.

🖨️ Print workflow and setup steps: What is required?

Please do not reprint existing PDF invoices from a PDF viewer into the print workflow shown here. This can destroy the text structure through rasterization or binarization and may degrade recognition. Instead, process such files directly with 7-PDF Attach Extract and Remove, provided they are suitable and machine-readable.

💡 IMPORTANT: For reliable detection of the document type, the term "Invoice" or a suitable document label such as "Final invoice" or "Credit note" should be clearly and visibly included in the document, ideally near the beginning. Unusual or ambiguous labels such as "fee statement", "cost note" or pure service descriptions can make automatic detection more difficult and should be tested carefully before productive use.

🧾 Step by step: Set up and test the print workflow

  1. First, download and install the 7-PDF Printer Professional Edition to generate PDF/A-3b. Installation video available here.
  2. Also install 7-PDF Attach Extract and Remove, version 2.0 or higher, which is required to generate and embed the AI-assisted ZUGFeRD XML.

  3. Important: Start the program immediately after installation and check the box in the “Privacy” tab to enable Extractor usage.

    Then please close the program so the setting is saved.

  4. Open the 7-PDF Printer options via the Windows start menu.

  5. Create an option set “7-PDF Invoice Extractor”. This is only a user-defined name for storing your configuration. Make sure not to share the setting with other users. Important: Also enable the PDF/A-3 format under “Document”.

  6. Under the “Actions” tab, disable automatic PDF viewer launch after printing:

  7. Under “Execute”, insert the following command, which is executed only after a successful print:
    8. !"C:\Program Files (x86)\7-PDF\7-PDF Attach Extract And Remove Files\InvoiceExtractor.exe" "%1" ""

    Explanation: %1 is automatically replaced with the path to the generated PDF invoice. The empty second argument can later be filled with an API token. For initial tests, it can remain empty if a trial quota is available.
    ⚠️ Attention: Don't forget to set window mode to "Hidden".

  8. Save all settings by clicking “Apply” and then “OK”.
  9. Use our 📥 demo invoice or your own template. The important point is that all relevant invoice data, such as VAT ID or tax number, IBAN, line items, amounts and tax information, is complete, machine-readable and plausible.
  10. Now send your invoice from Word, Excel or an ERP system to 7-PDF Printer, select the “Invoice Extractor” OptionSet and save the PDF file.

    11. After printing, the extractor starts automatically. The following message indicates that a PDF/ZUGFeRD file with embedded XML has been prepared:

    ⏳ Note: Processing may take anywhere from a few seconds to several minutes, depending on the invoice's scope and complexity. A confirmation message or an error message will appear afterwards. Please be patient.

    ⛔ Please do not send existing PDF invoices through a PDF viewer such as Acrobat Reader into the print workflow shown here. This can break the text structure through rasterization or binarization and degrade recognition. Instead, process such files directly with 7-PDF Attach Extract and Remove, provided they are suitable and machine-readable.

  11. After clicking the "OK" button in the dialog, the default PDF viewer may open with the just-created PDF/ZUGFeRD document. This call is executed within the InvoiceExtractor.exe file and not by 7-PDF Printer itself.

    💡 Tip: Don't want the viewer to open? Use the -noviewer parameter. 
    !"C:\Program Files (x86)\7-PDF\7-PDF Attach Extract And Remove Files\InvoiceExtractor.exe" "%1" "" -noviewer

    ✅ The result

    In Acrobat Reader, you can see the PDF with the embedded factur-x.xml. Please check the file visually, professionally, formally and technically before forwarding it.

In case you do not receive a success message:

👉 Avoid uploading incomplete or unsuitable documents. For initial anonymous and non-binding tests, you can use our free sample invoice.

💡 Only suitable, complete and machine-readable invoices can be processed meaningfully.
If no success message appears, the invoice is often missing required information or contains arithmetic or formal inconsistencies, such as missing line items, unclear invoice totals, missing IBAN, VAT ID, tax number or customer data. A used-up trial quota may also be the cause.

Tip: For more information on what to consider when creating a PDF invoice document for robust PDF/ZUGFeRD processing, please visit our FAQ page for the 7-PDF Invoice Extractor.
In many cases, the cause is missing information, arithmetic inconsistencies or an unsuitable PDF structure.

For further use, an API token is required. API tokens are provided only after testing, request, review and subject to availability. The token can then be integrated into ...InvoiceExtractor.exe" "%1" "XYZ...".

🔍 How do I validate the e-invoice result?

Every PDF/ZUGFeRD file created with the 7-PDF Invoice Extractor should be checked visually, professionally, content-wise, formally and technically before being shared with third parties. For this, you can use our 7-PDF E-Invoice Validator or another suitable validator. With this software, you can open a human-readable view of the e-invoice data and generate a validation report that checks technical and formal aspects of the e-invoice format.

7-PDF E-Invoice Validator user interface

📌 Quick start

Technical and formal checking of an e-invoice is straightforward:

  • Open the 7-PDF E-Invoice Validator.
  • Drag & drop an e-invoice (.pdf or .xml) into the application window.
  • Alternatively, click the "…" button to choose a file.
  • Click "Validate e-invoice now" to start the check.

Note: You may also use any other validator of your choice. The important thing is to check the generated e-invoice before forwarding it.

💡 Transparency & Quality: Our PDF Invoice → PDF ZUGFeRD service is intended for users with a manual, controlled invoicing process and complements existing tools — it does not replace an ERP system. Because AI extraction may vary in individual cases, a professional review of every e-invoice for content, structure and plausibility is best practice. Responsibility rests with the invoice issuer.

Automation: Technically possible, for example via FastAPI/CLI, but only with mandatory validation chains: XSD/EN 16931 checks and content plausibility checks against your data, such as totals, tax rates, IDs, routing ID/Leitweg-ID, IBAN/BIC or order/reference numbers. Without these controls, we advise against fully automatic dispatch. AI-assisted processing may vary in individual cases; checking and responsibility remain with the user.

🎯 Conclusion

ZUGFeRD4Excel can help prepare a controlled PDF/ZUGFeRD workflow from Excel. The solution is intended for users who continue to create invoices in Office tools or existing systems and want to transfer suitable, machine-readable PDF invoices into a review-required PDF/ZUGFeRD workflow with AI assistance.

💶 Prices and availability

  • 🛒 7-PDF Attach Extract and Remove can be used as a desktop tool for manual and controlled PDF/ZUGFeRD workflows.
  • For the optional PDF/A-3 print workflow, 🛒 7-PDF Printer Professional may also be required.
  • For AI-assisted PDF-to-ZUGFeRD processing, an API token is required. API tokens are provided only after testing, request, review and subject to availability.
  • Further information on licensing, prerequisites and bundles can be found in the linked product and FAQ areas.

🏁 Conclusion: Please first test with your own representative invoices. Further use of AI-assisted processing is only possible after request, review and availability of an API token.

🎁 First test with suitable PDF invoices to see whether your templates are suitable for the AI-assisted PDF/ZUGFeRD workflow.

💡 ZUGFeRD XML – Notes for robust checkability

Please ensure that your invoice data and price calculations are correct and traceable. Negative invoice amounts, unclear tax logic, missing mandatory information or arithmetic discrepancies may result in no usable XML file being generated or in a later check failing. Your invoice templates, for example from Word or Excel, should include important information such as IBAN, BIC, and your VAT ID or W-ID number in the format DE123456789 without spaces, if this information is required for your invoice type. In certain cases, a tax number may also be relevant. Please check the professional and tax-related requirements for your invoices under your own responsibility or with your tax advisor.

Note: Please ensure that tax-exempt invoices, for example within the scope of intra-community trade in the EU, contain a clear note on the invoice, for example using terms such as non taxable or Reverse Charge. Whether and how such cases must be represented correctly depends on the specific invoice context and should be checked professionally.

Important: Avoid placing this information only as graphics in the header or footer of your template. Such information may not always be reliably detected, especially if the image quality of the submitted PDF is insufficient. Please ensure that these values appear as machine-readable text within the invoice document itself.

✅ Check your e-invoices visually, professionally, formally and technically before forwarding them using our 7-PDF E-Invoice Validator, another suitable validator or your own controlled review process. Optionally, an additional check can also be integrated directly into your print process.

🚨 Privacy & Security Notice

  • 🔒 Data is transmitted SSL-encrypted
  • ❌ Invoice data is not stored permanently as part of processing
  • 🇩🇪 Server-based processing takes place on servers located in Germany
  • 🏢 As a German sole proprietorship, we personally stand for careful product maintenance, data-protection-oriented processing and support.

🎁 Trial: Test suitable invoices first

✅ With the trial version of 7-PDF Attach Extract and Remove, you can first check whether your own PDF invoices are suitable for AI-assisted processing.

🔄 Further use of AI-assisted PDF-to-ZUGFeRD processing requires an 💳 API token. API tokens are provided only after testing, request, review and subject to availability.

🖨️ Note: Create PDF/A-3 files with 7-PDF Printer Professional

To create a PDF/ZUGFeRD document, the source document must be available in PDF/A-3b format. For this, 7-PDF Printer Professional can be used to convert suitable invoices to PDF/A by printing.

💡 Further information on licensing, bundles and prerequisites can be found in the respective product and FAQ areas.

Save 10% symbol in cart

🛒 Note: Watch out for this symbol 👆 in the cart to see available cross-selling offers.

📘 Note on special tax cases

The 7-PDF Invoice Extractor can detect certain invoice notes such as Reverse Charge from suitable, machine-readable PDF invoices and include them in the generated data if the information is clearly and plausibly contained in the document.

Special tax cases, such as intra-community B2B invoices, national reverse-charge cases or small-business regulations, should be tested with your own examples before productive use and checked professionally or with tax advice. These notes do not replace tax advice.

🖊️ Print ZUGFeRD compliant PDF invoices / PDF Printer

up

Sharing the PDF Writer on a Network / PDF Printer

Top