# Reading in Excel Data from GitHub
**URL:** https://discourse.julialang.org/t/reading-in-excel-data-from-github/58055
**Category:** New to Julia
**Tags:** github, xlsx, io
**Created:** [March 26, 2021, 10:59pm UTC](https://discourse.julialang.org/t/reading-in-excel-data-from-github/58055 "2021-03-26T22:59:04Z")
**Posts on this page:** 10
**Page:** 1
I am preparing a Minimal Reproducible Example which involves reading in some data contained in an Excel file. I’m trying to figure out the best way to make the data easily accessible for anyone who wants to run my code. I’ve posted the data here: [sample\_data](https://github.com/MichaelBarmann/ParamEst_MRE/blob/main/sample_data.xlsx)
In Python for example, I can simply do
```julia
import pandas as pd
df = pd.read_excel("https://github.com/MichaelBarmann/ParamEst_MRE/blob/main/sample_data.xlsx")
```
and the data is placed into the DataFrame df.
In Julia I’ve tried `xl_file = XLSX.readxlsx("https://github.com/MichaelBarmann/ParamEst_MRE/blob/main/sample_data.xlsx")`, but unfortunately this doesn’t work.
Is there an analogous way of doing this in Julia? (using XLSX, or something similar?)
---
If you are willing to abandon excel in favor of CSV, CSV.jl can do that
See [here](https://csv.juliadata.org/stable/#CSV.jl-Documentation).
> To read a csv file from a url, use the HTTP.jl package, where the `HTTP.Response` body can be passed like:
>
> ```julia
> f = CSV.File(HTTP.get(url).body)
>
> ```
Maybe the same strategy works for excel actually?
---
I don’t think this works with `XSLX` out of the box, as the read methods expect a filepath (string), and `HTTP.get` returns a vector of UInts. The easiest thing would probably to just download the file to a temp dir and then read it in from there, but if it’s just some standard tabular data I agree with Peter that it would be better to move to a saner format than xlsx like csv, or maybe arrow.
---
Thanks, this is helpful! I had 3 spreadsheets in my Excel file, so I had to put each into an individual CSV file before attempting to implement your suggestion. Unfortunately, I get a weird error:
```julia
using HTTP, CSV
data_url = "https://github.com/MichaelBarmann/ParamEst_MRE/blob/main/sample_data.csv"
my_file = CSV.File(HTTP.get(data_url).body; header = 1)
```
```julia
┌ Warning: thread = 1 warning: parsed expected 1 columns, but didn't reach end of line around data row: 53. Ignoring any extra columns on this row
└ @ CSV C:\Users\Michael\.julia\packages\CSV\CJfFO\src\file.jl:606
┌ Warning: thread = 1 warning: parsed expected 1 columns, but didn't reach end of line around data row: 57. Ignoring any extra columns on this row
└ @ CSV C:\Users\Michael\.julia\packages\CSV\CJfFO\src\file.jl:606
┌ Warning: thread = 1 warning: parsed expected 1 columns, but didn't reach end of line around data row: 149. Ignoring any extra columns on this row
└ @ CSV C:\Users\Michael\.julia\packages\CSV\CJfFO\src\file.jl:606
┌ Warning: thread = 1 warning: parsed expected 1 columns, but didn't reach end of line around data row: 163. Ignoring any extra columns on this row
└ @ CSV C:\Users\Michael\.julia\packages\CSV\CJfFO\src\file.jl:606
┌ Warning: thread = 1 warning: parsed expected 1 columns, but didn't reach end of line around data row: 178. Ignoring any extra columns on this row
└ @ CSV C:\Users\Michael\.julia\packages\CSV\CJfFO\src\file.jl:606
┌ Warning: thread = 1 warning: parsed expected 1 columns, but didn't reach end of line around data row: 179. Ignoring any extra columns on this row
└ @ CSV C:\Users\Michael\.julia\packages\CSV\CJfFO\src\file.jl:606
178-element CSV.File{false}:
CSV.Row: ( = "",)
CSV.Row: ( = " ",)
CSV.Row: ( = " ",)
CSV.Row: ( = " ",)
CSV.Row: ( = " ",)
CSV.Row: ( = " ",)
CSV.Row: ( = " ",)
CSV.Row: ( = " ",)
CSV.Row: ( = " ",)
CSV.Row: ( = " ",)
CSV.Row: ( = " ",)
CSV.Row: ( = " ",)
CSV.Row: ( = " ",)
⋮
CSV.Row: ( = "",)
CSV.Row: ( = " ",)
CSV.Row: ( = "",)
CSV.Row: ( = " ",)
CSV.Row: ( = " ",)
CSV.Row: ( = " ",)
CSV.Row: ( = " ",)
CSV.Row: ( = "