Invoice data extraction: turning CFDI invoices into a spreadsheet automatically
Every CFDI already arrives as structured data in its XML. Here is how to move invoices into Excel: which fields to extract, how to validate them and when a script is enough.
Mustapha Ukizuru · October 24, 2026
 infinite; } @keyframes mu-loop-2 { 0%25, 9.53%25 { stroke-dashoffset: 1000; opacity: 0; } 9.83%25 { opacity: 1; } 23.13%25, 75.00%25 { stroke-dashoffset: 0; opacity: 1; } 86.67%25, 100%25 { stroke-dashoffset: 0; opacity: 0; } } .p2 { animation: mu-loop-2 3.0s cubic-bezier(.5,0,.15,1) infinite; } @keyframes mu-loop-3 { 0%25, 20.87%25 { stroke-dashoffset: 1000; opacity: 0; } 21.17%25 { opacity: 1; } 37.87%25, 75.00%25 { stroke-dashoffset: 0; opacity: 1; } 86.67%25, 100%25 { stroke-dashoffset: 0; opacity: 0; } } .p3 { animation: mu-loop-3 3.0s cubic-bezier(.5,0,.15,1) infinite; } @keyframes mu-loop-4 { 0%25, 35.13%25 { stroke-dashoffset: 1000; opacity: 0; } 35.43%25 { opacity: 1; } 43.07%25, 75.00%25 { stroke-dashoffset: 0; opacity: 1; } 86.67%25, 100%25 { stroke-dashoffset: 0; opacity: 0; } } .p4 { animation: mu-loop-4 3.0s cubic-bezier(.5,0,.15,1) infinite; } @keyframes mu-loop-5 { 0%25, 39.67%25 { stroke-dashoffset: 1000; opacity: 0; } 39.97%25 { opacity: 1; } 49.87%25, 75.00%25 { stroke-dashoffset: 0; opacity: 1; } 86.67%25, 100%25 { stroke-dashoffset: 0; opacity: 0; } } .p5 { animation: mu-loop-5 3.0s cubic-bezier(.5,0,.15,1) infinite; } @media (prefers-reduced-motion: reduce) { .pen { animation: none !important; stroke-dashoffset: 0; opacity: 1; } } %3C/style%3E%3Cdefs%3E%3ClinearGradient id='a' x1='392.761' y1='731.332' x2='598.094' y2='731.332' gradientUnits='userSpaceOnUse'%3E%3Cstop offset='0' stop-color='%237c3aed'/%3E%3Cstop offset='1' stop-color='%23420060'/%3E%3C/linearGradient%3E%3ClinearGradient id='b' x1='100' y1='500' x2='867.725' y2='500' xlink:href='%23a'/%3E%3ClinearGradient id='c' x1='650.64' y1='632.979' x2='900' y2='632.979' xlink:href='%23a'/%3E%3Cmask id='pen-body' maskUnits='userSpaceOnUse' x='0' y='0' width='1000' height='1000'%3E%3Cpath class='pen p1' pathLength='1000' d='M100 322 C130 300 165 262 205 262 C222 300 219 330 219 380 L219 745 C219 770 260 778 300 778' stroke-width='150'/%3E%3Cpath class='pen p2' pathLength='1000' d='M290 360 C310 300 370 262 435 262 C500 262 471 330 471 380 L471 690' stroke-width='165'/%3E%3Cpath class='pen p3' pathLength='1000' d='M545 360 C565 300 625 262 690 262 C755 262 723 330 723 380 L723 650 C723 705 765 720 800 670 L870 485' stroke-width='165'/%3E%3C/mask%3E%3Cmask id='pen-wedge' maskUnits='userSpaceOnUse' x='0' y='0' width='1000' height='1000'%3E%3Cpath class='pen p4' pathLength='1000' d='M395 779 C455 773 508 745 540 700 C548 742 570 771 598 780' stroke-width='110'/%3E%3C/mask%3E%3Cmask id='pen-swash' maskUnits='userSpaceOnUse' x='0' y='0' width='1000' height='1000'%3E%3Cpath class='pen p5' pathLength='1000' d='M655 782 C720 772 770 752 805 712 C845 665 880 590 897 495' stroke-width='110'/%3E%3C/mask%3E%3C/defs%3E%3Crect width='1000' height='1000' fill='none'/%3E%3Cpath mask='url(%23pen-wedge)' d='M598.094,782.934H392.761c20.733-5.887,47.072-18.147,73.9-35.3,34.376-21.961,61.124-46.56,72.9-65.373q.844-1.266,1.536-2.534c-3.507,15.563.384,37.627,11.748,59.1C564.973,761.792,582.455,778.1,598.094,782.934Z' fill='%23FFFFFF'/%3E%3Cpath mask='url(%23pen-body)' d='M867.725,477.878c-8.37,21.219-35.63,66.883-70.978,117.692-1.869,2.687-3.712,5.35-5.58,7.96-22.218,31.586-43.335,59-59.691,78.043-1.151,1.331-2.278,2.637-3.378,3.891a1.049,1.049,0,0,0-.154.179,48.229,48.229,0,0,1-27,14.385,28.207,28.207,0,0,1-3.558.435,38.273,38.273,0,0,1-23.907-5.964q-.683-.441-1.34-.908A36.1,36.1,0,0,1,657.3,664.074V376.83c0-24.483-26.586-39.511-47.707-27.127q-6.4,3.752-12.674,8.078a195.114,195.114,0,0,0-35.144,30.92l-.27.3a88.321,88.321,0,0,0-21.947,58.57V561.786A131.263,131.263,0,0,1,500.528,655.5q-.309.3-.621.607c-.64.64-1.305,1.254-1.971,1.868-24.6,23.267-52.472,36.782-74.024,37.678h-.026l-.227.009a19.226,19.226,0,0,1-19.763-19.3V375.374c0-24.031-25.852-39.369-46.824-27.634q-8.146,4.56-16.117,10.041a196.01,196.01,0,0,0-34.223,29.9l-.243.271a80.154,80.154,0,0,0-20.336,53.659V702.359a78.911,78.911,0,0,0,23.111,55.8l24.78,24.779H176.224a23.378,23.378,0,0,1-23.378-23.376l-.024-374.491v-9.318a42.44,42.44,0,0,0,0-5.119v-.307a51.324,51.324,0,0,0-1.177-8.5c-5.375-24.009-26.8-40.595-51.6-42.234-1.126-31.3,19.991-61.405,52.779-76.43a107.247,107.247,0,0,1,21.552-7.269c49.555-11.083,97.343,13.9,106.711,55.774a64.584,64.584,0,0,1,1.382,9.291c14.923-31.79,50.834-60.97,97.675-75.278,71.132-21.731,140.524-.922,154.986,46.457a62.79,62.79,0,0,1,2.2,25.878c.691-1.382,1.433-2.765,2.227-4.121,16.637-29,50.629-54.981,93.989-68.214,71.132-21.731,140.523-.922,154.985,46.457a60.822,60.822,0,0,1,2.637,19.351V500.966a5.58,5.58,0,0,0,5.042,5.555h0c8.165.87,22.781-2.509,38.7-9.292,1.075-.461,2.15-.947,3.225-1.433C850.448,490.216,860.917,483.74,867.725,477.878Z' fill='%23FFFFFF'/%3E%3Cpath mask='url(%23pen-swash)' d='M864.526,672.461c-21.066,45.177-47.482,82.753-73.359,107.35h0a11.29,11.29,0,0,1-7.8,3.123H650.64l6.658-2.841a210.725,210.725,0,0,0,35.861-20.042c31.278-21.219,65.68-53.5,98.008-93.477q5.874-7.257,11.646-14.872c46.329-60.995,76.149-123.322,83.777-168.679C910.368,513.2,902.229,591.577,864.526,672.461Z' fill='%23FFFFFF'/%3E%3C/svg%3E)