I have this button below. And a data frame named ‘df_download’. How can I function this button to download the ‘df_download’ as excel/csv file? download=st.button('Download Excel File') if download: 'Download Started!' liste= ['A','B','C'] df_download= pd.DataFrame(liste) df_download.col…

@randyzwitch thank you for the inspiration. I manage to solve it like : if download: 'Download Started!' liste= ['A','B','C'] df_download= pd.DataFrame(liste) df_download.columns=['Title'] df_download csv = df_download.to_csv(index=False) b64 = base64.b64encode(csv.encode()).decode()…

@Chad_Mitchell created something similar to this idea: [image] A download button with custom CSS 💬 Show the Community! [Update 2020-07-18] Revised the function to display a download button instead of a link after clicking a button, saving a UI step. The associated gist ha…

Very helpful, I have a requirement to download a zip folder. How may I achieve that using the above code?

Thanks. But what about excel files?

Hi @Alias4D , I extended the above code snippet to download .xlsx excel files with the help of two stackoverflow posts: java - How to decode an encoded excel file using python - Stack Overflow Setting mime type for excel document - Stack Overflow Here’s a working example and what it looks like: i…

Thanks very much for your attention and time. :pray:

Hi mate, is there a way to customize the link where the user will click? Like the image below… Download excel file [1221]

Hi @feliperoque , certainly! I’ll refer you to this thread by @Chad_Mitchell who creates a download button with custom CSS: A download button with custom CSS - #13 by jrieke A download function and examples app for Streamlit · GitHub Using Chad’s function in the code from this thread: import stre…

I had a problem with this function while i was trying to convert a csv to excel. Didn’t worked. Could i create just this part: button_uuid = str(uuid.uuid4()).replace('-', '') button_id = re.sub('\d+', '', button_uuid) custom_css = f""" <style> #{button_id} {{ …

@feliperoque I edited my previous answer such that it converts a dataframe to .xlsx instead of .csv :slight_smile:

[image] snehankekre: b64 = base64.b64encode(towrite.read()).decode() Thx you very much, i was looking for this my whole night rsrs.

How to add a download excel/csv function to a button?

Using Streamlit

randyzwitch July 24, 2020, 5:16pm 2

@Chad_Mitchell created something similar to this idea:

Topic		Replies	Views
How to download file in streamlit Using Streamlit file-download	95	73789	December 6, 2023
Download XLSX file with multiple sheets in Streamlit Using Streamlit pandas , file-download	2	7058	December 6, 2021
Download button for csv or xlsx file Using Streamlit pandas , file-download	3	45317	January 30, 2023
A download button with custom CSS Show the Community! file-download	20	12189	October 30, 2025
Download Button with Excel File Using Streamlit file-download	14	30158	May 10, 2024

How to add a download excel/csv function to a button?

Related topics