CSV Creator has been updated with a new action: Create CSV from JSON. Why does this matter? Your CSV export options are now unlimited! You can export: Custom Column Names Nested Lists Dates in specific timezones Sums Counts Line item calculations Concatenated field values (i.e. this User’s First Name this User’s Last Name) This uses the new :formatted as text on a list operator to create a list of JSON objects but you can pass JSON from any source. It’s light and fast and, best of all… FREE :slight_smile: It’s also public so copy it, manipulate it, make it better, make it yours. Documentation: [image] Bubble - Visual Programming Build stuff without code and launch a startup without a tech-cofounder! Bubble is a visual programing language. Instead of typing code, use a visual editor to build applications. Get the plugin here: [image] 1T - CSV Creator Plugin for Bubble 1T - CSV Creator Plugin page on Bubble. Add 1T - CSV Creator in one click to your app. Bubble lets you build web apps without any code.

Currently stumped on how to achieve my desired output. This is how I want it to look: [image] Reading through the various posts, I determined that my setup should look like this: [image] However, this does not work as the JSON is broken: { "Total Sales": 2, "Gross Profit": 2, "Net Profit": 2, "Turnover": 2, { "Product Name": "Test Product 123567865768", "Category": "Games & Board games", "Quantity Sold": 4 },{ "Product Name": "Strawberry Cupcake", "Category": "Toys & Games", "Quantity Sold": 10 },{ "Product Name": "trhrth", "Category": "Games & Board games", "Quantity Sold": 3 }}} I presume because there is an object being inserted after the “Turnover” key. I could of course include everything with the :format as text portion, but ideally I’d rather not as it doesn’t look great at all. Can anyone offer insight as to how to solve? Thanks, **EDIT Ok I realised that I had curly braces in the :Format as text contents, hence why an additional object was being inserted, so I removed those so that it now looks like this: [image] However this has sprung up a new issue in that only one row of data is being output in the CSV - I guess because its overwriting the row on each iteration of the list items. So beginning to think it isn’t possible to output a CSV in the format I want to?

Hi, I can’t see the video too. can you help?

I am having an issue with Send JSON to CSVCreator. I am sending 4 rows of data but only the last row is exported. [Screenshot 2024-12-10 125653] [Screenshot 2024-12-10 125957] [Screenshot 2024-12-10 130046] Any help will be appreciated. Thanks

Hello, I need help understanding how to generate a CSV file from a JSON API response. The JSON structure is not a proper tree or list format, and I’m struggling to process it. The JSON contains a legend under key "0", which represents the column names, and the subsequent keys (e.g., "1", "2") contain row data. My goal is to create a CSV file where the column headers are derived from the legend ("0") and the rows correspond to the entries under keys like "1" and "2". JSON response example { "Tables": [ { "TableJson": { "0": { "0": "Column A", "1": "Column B", "2": "Column C", "3": "Column D", "4": "Column E" }, "1": { "0": "TEXT 1 A", "1": "TEXT 1 B", "2": "TEXT 1 C", "3": "TEXT 1 D", "4": "TEXT 1 E" }, "2": { "0": "TEXT 2 A", "1": "TEXT 2 B", "2": "TEXT 2 C", "3": "TEXT 2 D", "4": "TEXT 2 E" } } } ] } I want the resulting CSV to look like this: Column A,Column B,Column C,Column D,Column E TEXT 1 A,TEXT 1 B,TEXT 1 C,TEXT 1 D,TEXT 1 E TEXT 2 A,TEXT 2 B,TEXT 2 C,TEXT 2 D,TEXT 2 E Could someone guide me on how to transform this JSON structure into the CSV format? Thank you! [Untitled]

I need to generate a complex csv and I’m looking for guidance or a little contract from a certified developer with lots of experience with this plugin and with JSON. My app – Prograds – is for keeping track of graduate students’ milestones and requirements. Students are Users. [I’m handy enough in Bubble that I’ve been able to allow my admin users to get emailed a 1T CSV from JSON file with lots of info from the User record, using the iterative batching in @eli 's great video.] The program (i.e. PhD, MSc, MBA) defines milestones and requirements with both ideal dates and due dates, in months, relative to the student’s program start date. These are data types called Program Milestones and Program Requirements. When a student user is created in the app, we generate for them their own version of these Program Milestones and Requirements; they are another (two) data types called User Milestones and User Requirements, and the ideal date and deadline dates are calculated relative to the student’s entry date. As these are generated, they’re added to a list thing on the (student) User, so the User type has a list of that student’s User Milestones and a list of the student’s User Requirements. The User Milestone and User Requirement data types have fields like Completed(y/n), Completion date (date), Approved, Approved Date, Overdue (y/n), and so on. I’d like to be able to produce a csv file with each student as one row, with some info from their User record, and then separate columns for the status of their user milestones and requirements, with the header row showing the name of the corresponding Program Milestone and Requirements. Here’s what I’m trying to get. The first row of data is an example of what I want to show, which will involve a search with some find and replace conditionality I imagine. THe second row of data is just a generic description of what the cell will have, to make it clear that the cell is the status of the student’s usermilestone corresponding to the program milestone listed in the header. Name Prog Milestone 1 Prog Milestone 2 Prog Milestone 3 Prog Milestone 4 Prog Requirement 1 Prog Requirement 2 Prog Requirement 3 Prog Requirement 4 Student, A Completed 11/1/2022 Overdue Approved 1/1/2022 Due 5/12/2026 Completed 11/1/2022 Overdue Approved 1/1/2022 Due 5/12/2026 Student, B [status of this student’s user milestone whose program milestone is the program milestone in the header of this column] Student, C [status of this student’s user milestone whose program milestone is the program milestone in the header of this column] Thanks folks! Happy new year. Fred [image] Prograds.com – The Graduate Student Progress System!

OH, I should say that the user Milestone and user Requirement data type has a field noting which Program milestone or program requirement it is derived from.

@eli , please help How do I make the action "CSV Creator - New Private File from Base64 " wait until “Create CSV from JSON (SSA)” has completed running. The issue I am having is that the Final JSON field has not finished running, resulting in the action "CSV Creator - New Private File from Base64 " failing because it has no “content”, and appears that there is a timeout issue. I have tried using the “only When - Result of Create CSV from JSON (SSA) is not empty” but the workflow timesout and doesn’t finish the action. I know that the plugin works as I have used it on 250 records in dev environment and on a 100 subset in Live enviornment. However, the set I am trying to run it on is 1400 records and there will be even bigger sets that need to be exported and I need to get this working. In the screenshot, I have norrowed down the point that I believe the timeout is occuring: [image]

I’m having the same exact problem. It worked two weeks ago and now I guess those timeouts are killing it. My log gives the same result: [image] @julian.mcneill @eli

I’ve tried to move the create csv from base64 into yet another (step 4) api workflow, but I don’t know if the same problem exists, where the CSV from JSON action doesn’t finish before the 4th workflow is scheduled with the file (parameter) therefore not being passed from step 3 to 4. In fact the problem stays the same. The 4 step process works, but the same timeout kills it on the Create CSV from JSON step.

@prograds @julian.mcneill You are probably encountering the same issue where there is a timeout assembling the JSON. We do return an error message on the action if we encounter an error so you might look at creating a log in your database that stores the all the results of the Create CSV from JSON (SSA) including error, base64, etc. Also, keep in mind that if it works on 250 in dev or a subset in live but not the full list of records, you may have data that is breaking your JSON. This would be exposed in the error message that is returned. In this case you’ll need to be sure you are using format as JSON-safe on any values that could possibly contain a breaking character such as a double quote or new line. Otherwise, you will likely need to take the steps outlined in the following video to create your JSON first and then run the Create CSV workflow: [Bubble - CSV Creator - How to avoid timeouts by building your JSON using backend workflows.]

1T - CSV Creator 3.0

Showcase

mccjon November 18, 2025, 1:21pm 450

If you’re struggling to get the front-end ‘create CSV from JSON’ export right, try the below resources, and see screenshots of mine

https://www.nocodesaas.io/p/allowing-users-to-export-data-from-your-bubble-app-nocodesaas-issue-23-976328
https://www.youtube.com/shorts/0-pP6WycMWM

Convert JSON to CSV

CSV Export for a Field That is a List

Topic		Replies	Views
[New Plugin] CSV File to JSON Plugins	42	6063	February 9, 2025
🤌 Excel / XLSX Creator Plugins	15	3236	March 18, 2025
New Plugin: XLSX / CSV Export Plugins	46	10534	May 22, 2024
Repeating Group to CSV / XLSX - New Plugin from Zeroqode Showcase	101	10069	February 12, 2025
CSV File to JSON APIs	45	8467	December 28, 2020

1T - CSV Creator 3.0

Related topics