Previously, you wrangled data inside the UI (Part 4). Now, you’ll learn how to move data in and out of Cosmic Frog without breaking a sweat.
This chapter walks through a practical, real-world loop: export a demand table to Excel/CSV, make changes, then import it back. You’ll see the two import paths in action—Replace (wipe and reload) and Upsert (update existing rows, insert new ones)—and how Cosmic Frog keeps you honest with Model Activity cards, record counts, and clear success checks. By the end, you’ll know exactly when to use each method, how to avoid accidental data loss, and how primary keys decide what gets updated vs. created.
Key features explained 🏆
Exporting Data to CSV or Excel
Modifying Customer Demand Data to Replace a Table
Importing Data (REPLACE) from CSV or Excel
Checking Import Status in Model Activity
Preparing Customer Demand Data to Upsert into a Table
Importing Data (UPSERT) from CSV or Excel
What UPSERT Does: Updating Matches and Inserting New Records
Finding Primary Key Columns in Cosmic Frog Tables
Suggested Pre-Work 💻
Before starting this E-Webinar, please ensure that you have:
Get answers to your burning questions 🔥
Ask us questions at any time during your session through private 1:1 chat.
We are excited for you to start using our product and look forward to helping you take your first step on that journey!