MARKETPLACE
PLUGINS
🀌 EXCEL / XLSX CREATOR
🀌 Excel / XLSX Creator logo

🀌 Excel / XLSX Creator

Published April 2023
   β€’    Updated today

Plugin details

Free

For everyone

3.0 stars   β€’   2 ratings
1.3K installs
This plugin does not collect or track your personal data.

Other actions

Platform

Web & Native mobile

Contributor details

Rico Trevisan logo
Rico Trevisan
Joined 2017   β€’   10 Plugins
View contributor profile

Instructions

𝟭. 𝗖π—₯π—˜π—”π—§π—˜ π—§π—›π—˜ π—”π—–π—§π—œπ—’π—‘
This uses the operator :𝗙𝗒π—₯π— π—”π—§π—§π—˜π—— 𝗔𝗦 π—§π—˜π—«π—§ on a list in Bubble. Get started by adding the 𝗝𝗦𝗒𝗑 π˜π—Ό π—«π—Ÿπ—¦π—« (𝗦𝗦𝗔) action to your workflow.

The JSON content field simply needs valid JSON and you are good to go. However, the idea is to do a search for the data you want to export and then use the :𝗙𝗒π—₯𝗠𝗔𝗧 𝗔𝗦 π—§π—˜π—«π—§ operator and create your JSON in that field as shown below.

Add a comma to the Delimiter field.

When you have a field that can contain newlines, quotes, and other special characters, It's a good idea to use the  :𝗙𝗒π—₯π— π—”π—§π—§π—˜π—— 𝗔𝗦 𝗝𝗦𝗒𝗑-π—¦π—”π—™π—˜ operator. When using that operator, you don't need to wrap it with double-quotes " -- the operator does that already.

Sample JSON

{
"πš‚πšŠπš•πšŽ π™³πšŠπšπšŽ": "πšƒπš‘πš’πšœ πš‚πšŠπš•πšŽπšœ'𝚜 π™Ύπš›πšπšŽπš› π™³πšŠπšπšŽ",
"πš‚πšŠπš•πšŽ 𝙸𝙳":"πšƒπš‘πš’πšœ πš‚πšŠπš•πšŽπšœ'𝚜 π™Ύπš›πšπšŽπš› 𝙸𝙳",
"π™ΈπšπšŽπš–πšœ":[πšƒπš‘πš’πšœ πš‚πšŠπš•πšŽπšœ'𝚜 π™ΈπšπšŽπš–πšœ: πšπš˜πš›πš–πšŠπšπšπšŽπš 𝚊𝚜 π™Ήπš‚π™Ύπ™½-𝚜𝚊𝚏𝚎],
"πšπšŽπšπš’πš˜πš—":πšƒπš‘πš’πšœ πš‚πšŠπš•πšŽπšœ'𝚜 πšπšŽπšπš’πš˜πš—'𝚜 π™½πšŠπš–πšŽ: πšπš˜πš›πš–πšŠπšπšπšŽπš 𝚊𝚜 π™Ήπš‚π™Ύπ™½-𝚜𝚊𝚏𝚎
}

If you want to export a nested list, simply add square brackets around the value as shown in the Items value in the JSON sample



π—¦π—”π—©π—œπ—‘π—š π—§π—›π—˜ π—™π—œπ—Ÿπ—˜

To save the file use 1T - CSV Creator's (https://bubble.io/plugin/1t---csv-creator-1582601241392x653181519983018000) save file.

See the demo page for more info



𝗗𝗒π—ͺπ—‘π—Ÿπ—’π—”π——π—œπ—‘π—š π—§π—›π—˜ π—™π—œπ—Ÿπ—˜

Use the Download file action from AirDev's File Downloader (https://bubble.io/plugin/file-downloader-1539124824422x194279356396994560)

Types

This plugin can be found under the following types:

Categories

This plugin can be found under the following categories:
Data (things)   β€’   Productivity   β€’   Technical

Resources

Support contact
Tutorial
Forum

Rating and reviews

Average rating (3.0)

It seems very complex, slow and kind of unreliable to me
March 15th, 2024
After working on it for a good hour, I finally made it work... But I don't think I can use this plugin in my app, here is why: you need to install 3 plugins to make it work. Basically, you need to generate a file on your bubble DB with a second plugin. The process of saving a file to your DB takes a long time, and the user has to wait quite a lot. After that, you can finally download that file - with a 3rd plugin - by making the user click again on another button, after waiting. In the end, you get a very basic excel file and you cannot specify data formats, or change column width, or add sheets. Essencially a csv... :) I also worry about possible bugs or changes in any of the 3 plugins, which would make it stop working anytime. Maybe this is good for school projects, but I don't think a professional app could rely on this.
Amazing! Allows me create an Excel file and save in db
April 4th, 2023
Then show it to the user in an iframe. Great work, and very helpful
Bubble