Create Your QR Code

Generate codes for URLs, WiFi, SMS, and more. Instantly, QR Code Support Excel

Generator

📊 Using in Excel

Generate QR codes in Excel with the IMAGE function. Assume cell A1 has the content.

Default PNG (300x300): 

=IMAGE("https://qrexcel.pro/qr.php?d=" & ENCODEURL(A1) & "&size=300x300", "QR qrexcel.pro")

Black QR with White Background: 

=IMAGE("https://qrexcel.pro/qr.php?d=" & ENCODEURL(A1) & "&size=300x300&color=000000&bg=FFFFFF", "QR qrexcel.pro")

With URL Rewrite: 

=IMAGE("https://qrexcel.pro/qr?d=" & ENCODEURL(A1) & "&size=300x300", "QR qrexcel.pro")

💡 Tip: Use ENCODEURL (Excel 2013+). Adjust cell size to fit the QR code.

📈 Using in Google Sheets

Generate QR codes in Google Sheets with the IMAGE function. Assume cell A1 contains the text/URL you want to encode.

Default PNG (300×300): 

=IMAGE("https://qrexcel.pro/qr.php?d=" & ENCODEURL(A1) & "&size=300x300")

Black QR with White Background: 

=IMAGE("https://qrexcel.pro/qr.php?d=" & ENCODEURL(A1) & "&size=300x300&color=000000&bg=FFFFFF")

Custom size with IMAGE mode 4:

In Google Sheets, IMAGE(url, mode, height, width) supports mode = 4 to set exact pixel size.

=IMAGE("https://qrexcel.pro/qr.php?d=" & ENCODEURL(A1), 4, 300, 300)

Force refresh (avoid image caching):

Append a cache-buster so the QR updates immediately when data changes.

=IMAGE("https://qrexcel.pro/qr.php?d=" & ENCODEURL(A1) & "&size=300x300&cb=" & RANDBETWEEN(1, 10^9))

💡 Tips: Use ENCODEURL to safely pass content; adjust cell row/column size for best display. For bulk generation, fill the formula down the column or use ARRAYFORMULA.

📝 Optional: Apps Script helper (custom function)

Tools → Script editor, then add this function. Use it as =QREXCEL(A1, "300x300") and wrap with IMAGE().

/** @customfunction */
function QREXCEL(text, size) {
  var s = (size || "300x300").toString();
  var q = encodeURIComponent(text || "");
  return "https://qrexcel.pro/qr.php?d=" + q + "&size=" + encodeURIComponent(s);
}

Example:

=IMAGE(QREXCEL(A1, "300x300"))

📄 Using in Word

Insert QR codes directly in Word using the Insert Picture feature or a VBA macro.

Method 1: Insert Picture from URL

  1. Open Word and navigate to the slide where you want to insert the QR code.
  2. Go to Insert → Pictures → This Device (or Picture from File in older versions).
  3. Download your QR code from this tool (use the "Download QR" button).
  4. Select the downloaded qrexcel-qr.png file and insert it into your slide.
  5. Resize and position the QR code as needed.

Method 2: VBA Macro for Automation

  1. Open Word and press Alt+F11 to open the VBA editor.
  2. Go to Insert → Module, then paste the following code:
Sub InsertQR()
    Dim u As String
    u = "https://qrexcel.pro/qr.php?d=qrexce.pro&size=150x150"
    Selection.InlineShapes.AddPicture FileName:=u, LinkToFile:=False, SaveWithDocument:=True
End Sub
  1. Close the editor. Back in Word, press Alt+F8, select InsertQR, and run it.
  2. The QR code image will be inserted at the cursor position.

💡 Tip: Change the text after d= in the URL to generate a QR code for your own text, link, or data.
Example: https://qrexcel.pro/qr.php?d=YourCustomText&size=300x300

🎯 Using in PowerPoint

Insert QR codes directly in PowerPoint using the Insert Picture feature or a VBA macro.

Method 1: Insert Picture from URL

  1. Open PowerPoint and navigate to the slide where you want to insert the QR code.
  2. Go to Insert → Pictures → This Device (or Picture from File in older versions).
  3. Download your QR code from this tool (use the "Download QR" button).
  4. Select the downloaded qrexcel-qr.png file and insert it into your slide.
  5. Resize and position the QR code as needed.

Method 2: VBA Macro for Automation

  1. Open PowerPoint and press Alt+F11 to open the VBA editor.
  2. Go to Insert → Module, then paste the following code:
Sub InsertQR()
    Dim slide As Slide
    Dim url As String
    url = "https://qrexcel.pro/qr.php?d=YourCustomText&size=300x300"
    Set slide = ActivePresentation.Slides(ActiveWindow.View.Slide.SlideIndex)
    slide.Shapes.AddPicture url, msoFalse, msoTrue, 100, 100, -1, -1
End Sub
  1. Close the VBA editor. In PowerPoint, press Alt+F8, select InsertQR, and click Run.
  2. The QR code will be inserted on the current slide at position (100, 100). Adjust the position and size as needed.

💡 Tip: Replace YourCustomText in the VBA code with your desired text, URL, or data (e.g., https://qrexcel.pro/qr.php?d=https://example.com&size=300x300).

🎨 Color Reference Table

Click a swatch to copy its hex code to 'Color' or 'Background'.

Color Name Hex Code
Black #000000
White #FFFFFF
Red #FF0000
Lime #00FF00
Blue #0000FF

💡 Note: White sets the background; others set the QR color.

Simple, Fast, and Reliable

Quick Generation

Create QR codes in seconds with our intuitive tool.

Customizable Options

Adjust size, colors, and types to suit your needs.

Trusted Results

Reliable QR codes optimized for scanning.