---
title: "How to render data from Excel files with URLs"
canonical: "https://support.appfire.com/space/XL/76614160/How%20to%20render%20data%20from%20Excel%20files%20with%20URLs"
format: markdown
---
> Macro (aura-html)

<span style="color: #000000">This page illustrates how you can access your Excel files from a remote location directly using URLs in the </span><span style="color: #000000">*Excel*</span><span style="color: #000000"> macro editor. </span>

> ℹ️ <span style="color: #000000">If you intend to access Excel files from a specific location, or, use the same file across multiple pages, it is recommended to use </span><span style="color: #000000">*profiles*</span><span style="color: #000000">. </span>
> ℹ️ 
> ℹ️ <span style="color: #000000">Administrators create profiles which are a set of basic parameters used to access an external location. Users need only provide the relative path to the actual location of the files to be used with the specified profile. Refer to the </span><span style="color: #000000">[documentation](https://appfire.atlassian.net/wiki/spaces/XL/pages/76611721/Configuration+-+cloud#Configuration-Cloud-Configuration-Cloud-Profiles)</span><span style="color: #000000"> to know more about profiles and the </span><span style="color: #000000">[macro's page](https://appfire.atlassian.net/wiki/x/RwKRB)</span><span style="color: #000000"> to know how to use profiles and other parameters in your pages.</span>

## <span style="color: #000000">Define these parameters/values</span>

| <span style="color: #000000">*Output format*</span> | <span style="color: #000000">*html*</span> |
| --- | --- |
| <span style="color: #000000">*Page of attachment*</span> | <span style="color: #000000">empty</span> |
| <span style="color: #000000">*Name of attachment*</span> | <span style="color: #000000">empty</span> |
| <span style="color: #000000">*Profile*</span> | <span style="color: #000000">empty</span> |
| <span style="color: #000000">*URL of Excel file*</span> | <span style="color: #1155cc">[https://download.microsoft.com/download/5/b/d/5bd4a709-de6e-4586-883f-9701ab94e3e5/population.xlsx](https://download.microsoft.com/download/5/b/d/5bd4a709-de6e-4586-883f-9701ab94e3e5/population.xlsx)</span> |

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

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

![Excel macro_URL to Excel file.jpg](media://6032c238-4824-4de7-98c3-e7c176268af4)

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

![image](media://ff48b168-d16b-4079-9423-70c51d98f7dc)

## <span style="color: #000000">Helpful resources</span>

- <span style="color: #000000">[How to create a profile with URLs](https://appfire.atlassian.net/wiki/x/awiRB)</span>
- <span style="color: #000000">[Profiles](https://appfire.atlassian.net/wiki/spaces/XL/pages/76611721/Configuration+-+cloud#Configuration-Cloud-Configuration-Cloud-Profiles)</span><span style="color: #000000"> in the app's configuration settings</span>