To generate a QR code using Excel, first download the Excel template by clicking the "Download Excel Format" button. Fill in the required data in the Excel file, then upload and submit it. Once submitted, download the PDF by pressing Ctrl + P and saving the PDF file.