Advanced Excel/CSV Import/Export
Advanced Excel & CSV Import/Export is a powerful plugin that allows you to seamlessly import and export Excel (XLS/XLSX) and CSV files. Simplify your data management with an intuitive interface, flexible configuration, and optimized performance.
Features
✅ Import Excel (XLS/XLSX) and CSV files into your database ✅ Export database records to Excel with a single click ✅ Flexible column mapping for precise data organization ✅ Support for large files with optimized processing speed ✅ Compatible with various database structures ✅ User-friendly and highly customizable integration
Links
Demo page: https://foxocode.co/excel-csv-import
Demo page editor: https://bubble.io/page?version=live&type=page&name=excel-csv-import&id=chart-demo-54334
If you prefer, you can use the plugin's edit page as a reference for setup instructions. This will provide a hands-on guide to configuring and using the plugin within your Bubble.io application. By accessing this page, you can see how the plugin is set up, including element placements, workflow configurations, and best practices for importing Excel and CSV files efficiently.
Instruction
Import
Install the Plugin: Add the Advanced Excel/CSV Import plugin to your application.
Add Plugin Element: Locate the plugin in the visual elements section and place it on your app page. Ensure the element is visible during the design phase; it won't appear in the live preview.
Set Up Uploader and Button: Include an uploader element and a button on your page to facilitate file selection and initiate the import process.
Configure Plugin Action: Assign the 'Start' plugin action to the button to trigger data import.
Specify Uploader in Action: Within the plugin action settings, link the uploader containing the pre-loaded file to ensure proper data import.
Get the Result and Save it to the Database:
Create an API workflow in the Backend Workflow section.
When creating an object in the database, specify which column from the document you want to save and in which field.
Run the "Schedule API Workflow on a List" action using your newly created API workflow.
You need to add a short delay (pause) between the plugin action workflow and the Schedule API Workflow on a List execution. This ensures that the first workflow has enough time to process before launching the database-saving action.
By following these steps, you can effectively integrate the Advanced Excel/CSV Import plugin into your application, streamlining your data import processes.
Export
Add Plugin Element: Locate the plugin in the visual elements section and place it on your app page. Ensure the element is visible during the design phase.
You can create your own custom visual table or display the element’s built-in table.
2.1 If you want to create your own custom table, keep in mind that the element must remain visible. Make sure the “Create table” checkbox is disabled - this way, the table won’t appear in the preview. If you want to keep the element from interfering with your page layout, simply set its height to 1px.
2.2 If you want to use the plugin’s built-in table, simply check the “Create table” box.
2.3 You can customize the table's border width and color.
Data source: Retrieve the required table from the database.
For correct export, the table header titles must be displayed.
Install a button on your page to initiate the export process.
Configure Plugin Action: Assign the “Start” action to the button to trigger the data export.
By following these steps, you can effectively integrate the Advanced Excel/CSV Import/Export plugin into your application, streamlining your data export processes.
About Foxocode
Foxocode is a team of experienced Bubble developers specializing in template customization, custom plugin development, and full-cycle website creation from scratch.
What We Offer
Full website/app development from scratch
Customization of Bubble templates
Development of custom plugins
Integration with external APIs and services
Contact Us
📧 Email: contact.foxocode@gmail.com 🌐 Website: www.foxocode.co Let us know what you need — we’ll be happy to discuss your project!
Last updated