---
title: "How to create a profile with URLs"
canonical: "https://support.appfire.com/space/XL/76613739/How%20to%20create%20a%20profile%20with%20URLs"
format: markdown
---
> Macro (aura-html)

> ⚠️ **Parameters removed**
> ⚠️ 
> ⚠️ - <span style="color: #000000">The </span><span style="color: #000000">*URL user*</span><span style="color: #000000"> and </span><span style="color: #000000">*URL user password*</span><span style="color: #000000"> parameters have been removed from </span><span style="color: #000000">*Excel for Confluence*</span><span style="color: #000000">. For more information, refer to</span><span style="color: #800000"> </span><span style="color: #000000">[Removed the URL user and URL user password parameters](https://bobswift.atlassian.net/wiki/x/AQDOn)</span><span style="color: #000000">.</span>
> ⚠️ - <span style="color: #000000">Use</span><span style="color: #800000"> </span><span style="color: #000000">*[Profile](https://bobswift.atlassian.net/wiki/x/mIBWSg)*</span><span style="color: #800000"> </span><span style="color: #000000">to access Excel data from a remote location.</span>

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

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

> ℹ️ ## <span style="color: #000000">Before you begin:</span>
> ℹ️ 
> ℹ️ - <span style="color: #000000">Know what is a complete URL. </span>
> ℹ️   - <span style="color: #000000">A typical path for looks like:</span>  
> ℹ️ `/something/another_thing/projects/files/file.ext`
> ℹ️   - <span style="color: #000000">If the host address begins with:</span>  
> ℹ️ `http://www.site.com`
> ℹ️   - <span style="color: #000000">The complete URL, in this example, looks like: </span>  
> ℹ️ `http://www.site.com/something/another_thing/projects/files/file.ext`
> ℹ️ - <span style="color: #000000">The process for adding a profile and using it in macros remains the same for other public repositories and external sources.</span>

> ⚠️ <span style="color: #000000">For illustrative purposes, set the </span><span style="color: #000000">*Output format*</span><span style="color: #000000"> to be </span><span style="color: #000000">*html *</span><span style="color: #000000">in the </span><span style="color: #000000">*Excel*</span><span style="color: #000000"> macro.</span>

# <span style="color: #000000">Methods to create a profile</span>

<span style="color: #000000">There are two ways to work with profiles and URLs where you can use:</span>

- <span style="color: #000000">An </span><span style="color: #000000">[absolute URL](https://appfire.atlassian.net/wiki/spaces/XL/pages/76613739)</span><span style="color: #000000"> in a profile</span>
- <span style="color: #000000">A </span><span style="color: #000000">[partial URL](https://appfire.atlassian.net/wiki/spaces/XL/pages/76613739)</span><span style="color: #000000"> in a profile</span>

## <span style="color: #000000">Using an absolute URL in a profile</span>

<span style="color: #000000">You can create a profile by providing the complete URL for the Excel content.</span>

1. <span style="color: #000000">Navigate to </span><span style="color: #000000">***Settings > ATLASSIAN MARKETPLACE > Excel Configuration > Profiles***</span><span style="color: #000000">.</span>
2. <span style="color: #000000">Click </span><span style="color: #000000">**Add Profile**</span><span style="color: #000000">.</span>
3. <span style="color: #000000">Enter the following values for the appropriate parameters:</span>
4. <span style="color: #000000">Click </span><span style="color: #000000">**Save profile**</span><span style="color: #000000"> to create the profile.</span>

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

1. <span style="color: #000000">Search for the </span><span style="color: #000000">*Excel*</span><span style="color: #000000"> macro and edit it.</span>
2. <span style="color: #000000">Enter </span><span style="color: #000000">**Population data repository**</span><span style="color: #000000"> in </span><span style="color: #000000">*Profile*</span><span style="color: #000000"> and then, click </span><span style="color: #000000">**Save**</span><span style="color: #000000">.</span>

![Excel macro_Profile name.jpg](media://65ef864b-03aa-4e61-978d-94a632d68ad1)

## <span style="color: #000000">Using a partial URL in a profile</span>

<span style="color: #000000">You can create a profile with a base URL for the external location and then, enter a relative path to the actual Excel file location 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">***Settings > ATLASSIAN MARKETPLACE > Excel Configuration > Profiles***</span><span style="color: #000000">.</span>
2. <span style="color: #000000">Click </span><span style="color: #000000">**Add Profile**</span><span style="color: #000000">.</span>
3. <span style="color: #000000">Enter the following values for the appropriate parameters:</span>

| ***Profile name*** | **Excel files repository** |
| --- | --- |
| ***Profile type*** | *URL* |
| ***URL*** | [http://www.principlesofeconometrics.com](http://www.principlesofeconometrics.com) |

![image](media://004204c8-c598-4895-872e-095ebad2a1f3)

4. <span style="color: #000000">Click </span><span style="color: #000000">**Save profile **</span>to create the profile.

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

1. <span style="color: #000000">Search for the </span><span style="color: #000000">*Excel*</span><span style="color: #000000"> macro and edit it.</span>
2. <span style="color: #000000">Enter </span><span style="color: #000000">**Excel files repository**</span><span style="color: #000000"> in </span><span style="color: #000000">*Profile*</span><span style="color: #000000"> in the editor.</span>
3. <span style="color: #000000">Enter the relative path to the</span> <span style="color: #000000">*/excel/airline.xls*</span> <span style="color: #000000">Excel file in the </span><span style="color: #000000">*URL to Excel file*</span><span style="color: #000000"> parameter.</span>
4. <span style="color: #000000">Click</span> **Save**<span style="color: #000000">.</span>

![Excel_Partial URL in Profile.jpg](media://42a43d0e-89c2-4793-a496-6d4b79f8c2e9)

> ℹ️ <span style="color: #000000">This method is recommended for use as it allows multiple users to access a profile across multiple pages and instances of the </span><span style="color: #000000">*Excel*</span><span style="color: #000000"> macro.</span>