---
title: "Create a profile with a URL"
canonical: "https://support.appfire.com/space/XL/76613133/Create%20a%20profile%20with%20a%20URL"
format: markdown
---
> ⚠️ **Parameters removed**
> ⚠️ 
> ⚠️ - <span style="color: #0e101a">The </span><span style="color: #0e101a">*URL user*</span><span style="color: #0e101a"> and </span><span style="color: #0e101a">*URL user password*</span><span style="color: #0e101a"> parameters have been removed from </span>*<span style="color: #0e101a">Excel for Confluence</span>*<span style="color: #0e101a">. For more information, refer to </span>[<span style="color: #0e101a">Removed the URL user and URL user password parameters</span>](https://appfire.atlassian.net/wiki/x/jwqRB)<span style="color: #0e101a">.</span>
> ⚠️ - <span style="color: #0e101a">Use </span><span style="color: #0e101a">*Profile*</span><span style="color: #0e101a"> to access Excel data from a remote location.</span>
> ⚠️ - <span style="color: #0e101a">Parameter removal is effective and available in </span><span style="color: #0e101a">*Excel for Confluence - *</span><span style="color: #0e101a">Server (version 7.3.0 and above).</span>

# <span style="color: #000000">Description</span>

<span style="color: #000000">This article illustrates how to create a profile</span><span style="color: #000000"> using a URL</span><span style="color: #000000"> in the </span>*<span style="color: #000000">Excel</span>*<span style="color: #000000"> macro.</span>

> ℹ️ ## <span style="color: #000000">Before you begin:</span>
> ℹ️ 
> ℹ️ - <span style="color: #000000">Before you enter the URL for a repository, ensure that it </span><span style="color: #000000">is a raw URL</span>.  
> ℹ️ <span style="color: #000000">A raw URL is defined as the part of the URL following the domain information and </span><span style="color: #000000">includes the query string, if present. </span><span style="color: #000000">For example, in the URL string </span>*<span style="color: #000000">http://www.contoso.com/articles/recent.aspx</span>*<span style="color: #000000">, the raw URL is </span>*<span style="color: #000000">/articles/recent.aspx</span>*<span style="color: #000000">. </span>
> ℹ️ - <span style="color: #000000">Know what is a complete URL. </span>
> ℹ️   - The complete URL, in this example, looks like:   
> ℹ️ https://bitbucket.org/bobswift-test/testfiles/raw/1366d872db9bef51f030a36c94a6b19ba5079c33/SheetJSTableExport.xlsx
> ℹ️ - <span style="color: #000000">For illustrative purposes, a public</span> <span style="color: #000000">Bitbucket public repository is used</span>. <span style="color: #000000">Use URLs to add to profiles and in macros as per your requirement and your instance.</span><span style="color: #333333"> </span><span style="color: #000000">The process for adding a profile and using it in macros remains the same for other repositories and external sources.</span>


<span style="color: #000000">You can work with URLs in two ways where you can:</span>

- <span style="color: #000000">Use </span>[<span style="color: #000000">an absolute URL</span>](#CreateaprofilewithaURL-xl_URLProfile_absURL)<span style="color: #000000"> in the profile</span>
- <span style="color: #000000">Use </span>[<span style="color: #000000">a partial URL</span>](#CreateaprofilewithaURL-xl_URLProfile_partialURL)<span style="color: #000000"> in the profile</span>

# > Macro (anchor)

<span style="color: #000000">Use an absolute URL</span>

<span style="color: #000000">You can create a profile by providing the absolute URL to access the Excel content from a remote location.</span>

1. <span style="color: #000000">Navigate to </span>**<span style="color: #000000">CONFLUENCE ADMINISTRATION ></span>**<span style="color: #000000"> </span>***<span style="color: #000000">General Configuration > </span>*****<span style="color: #000000">BOB SWIFT CONFIGURATION > </span>****<span style="color: #000000">Excel > Profiles.</span>**
2. <span style="color: #000000">Click </span>**<span style="color: #000000">Add Profile.</span>**
3. <span style="color: #000000">Enter a unique name for the profile in the </span>*<span style="color: #000000">Profile name</span>*<span style="color: #000000"> text box.</span>
4. <span style="color: #000000">Select </span>*<span style="color: #000000">URL</span>*<span style="color: #000000"> from the options in </span>*<span style="color: #000000">Profile type</span>*<span style="color: #000000">. </span>
5. <span style="color: #000000">Enter the relevant absolute URL of the location to be accessed</span> <span style="color: #000000">in the </span>*<span style="color: #000000">URL</span>*<span style="color: #000000"> text box.</span>
6. <span style="color: #000000">Click </span>**<span style="color: #000000">Save profile</span>**<span style="color: #000000"> to create a profile.</span>

![image](media://aed58dd4-ef4e-4416-a8af-f892a23072e3)

<span style="color: #000000">To use this profile in a Confluence page:</span>

1. <span style="color: #000000">Add the </span>*<span style="color: #000000">Excel</span>*<span style="color: #000000"> macro, or edit an existing macro on a page.</span>
2. <span style="color: #000000">Select the newly created profile from the </span>*<span style="color: #000000">Profile</span>*<span style="color: #000000"> drop-down, and click </span>**<span style="color: #000000">Save</span>**<span style="color: #000000">.</span>

![image](media://d756f0fd-5f40-4d9b-b664-fbee09b3818a)

# > Macro (anchor)

<span style="color: #000000">Use a partial URL</span>

<span style="color: #000000">You can create a profile by providing a partial URL for the Excel content, and enter the relative path to the Excel file in the </span>*<span style="color: #000000">Excel</span>*<span style="color: #000000"> macro.</span>

1. <span style="color: #000000">Navigate to </span>**<span style="color: #000000">CONFLUENCE ADMINISTRATION ></span>**<span style="color: #000000"> </span>***<span style="color: #000000">General Configuration > </span>*****<span style="color: #000000">BOB SWIFT CONFIGURATION > </span>****<span style="color: #000000">Excel > Profiles.</span>**
2. <span style="color: #000000">Click </span>**<span style="color: #000000">Add Profile.</span>**
3. <span style="color: #000000">Enter a unique name for the profile in </span>*<span style="color: #000000">Profile name</span>*<span style="color: #000000">.</span>
4. <span style="color: #000000">Select </span>*<span style="color: #000000">URL</span>*<span style="color: #000000"> from the options in </span>*<span style="color: #000000">Profile type</span>*<span style="color: #000000">. </span>
5. <span style="color: #000000">Enter</span> <span style="color: #000000">the base URL</span> <span style="color: #000000">in the </span>*<span style="color: #000000">URL</span>*<span style="color: #000000"> text box. </span><span style="color: #000000">A base URL is a part of the path that specifies the location that the macro must access.</span>
6. <span style="color: #000000">Click </span>**<span style="color: #000000">Save profile</span>**<span style="color: #000000"> to create a profile.</span>

![image](media://6632568a-c3d4-42cb-ae14-3216a3a68629)

<span style="color: #000000">To use the profile in a Confluence page:</span>

1. <span style="color: #000000">Add the </span>*<span style="color: #000000">Excel</span>*<span style="color: #000000"> macro, or edit an existing macro on a page.</span>
2. <span style="color: #000000">Select the newly created profile in </span>*<span style="color: #000000">Profile</span>*<span style="color: #000000"> in the macro editor. </span>
3. <span style="color: #000000">Enter the relative path of the Excel file</span><span style="color: #000000"> </span><span style="color: #000000">in the </span>*<span style="color: #000000">URL to Excel file</span>*<span style="color: #000000"> parameter</span><span style="color: #000000">. The relative URL is appended to the base URL specified in the profile to create an absolute path to the file to be rendered.</span>
4. <span style="color: #000000">C</span><span style="color: #000000">lick </span>**<span style="color: #000000">Save</span>**<span style="color: #000000">.</span>

![image](media://0f01992a-2550-48d3-800e-5a19cc13b7de)

> ℹ️ **Points to remember!**
> ℹ️ 
> ℹ️ - <span style="color: #000000">Only raw URLs must be given in the</span><span style="color: #000000"> </span>*<span style="color: #000000">URL</span>*<span style="color: #000000"> </span><span style="color: #000000">field in profiles.</span>
> ℹ️ - <span style="color: #000000">It is recommended to specify absolute URLs to access files from public locations and to use profiles to access files from private sources. For example, a raw URL that can access an Excel file in a public Bitbucket repository is valid. But to render an Excel file located in a private repository, we recommend using a profile.</span>
> ℹ️ - <span style="color: #000000">Profiles are a means to access and retrieve contents from external applications such as Bitbucket. </span><span style="color: #000000">A profile already contains the base URL and the required credentials (user credentials or an access token) to access the relevant application.</span>
> ℹ️ - <span style="color: #000000">This method allows multiple users to access a profile across pages and instances of the macros.</span>