Dummy Dataset Creation using Gemini

[Shourya_Tomar]

Audience: Beginner

Creating dummy data with Gemini is highly effective because it can generate structured, realistic records that fit your specific app schema.

Here are the two best ways to do this:

Method 1: Direct “Export to Sheets”

1. Prompt Gemini: Ask for your data in a table format.
   Example: “Create a dummy dataset for a construction project tracker. Include 20 rows with columns: Project Name, Site Manager, Start Date, Status (Planned, In Progress, Complete), and Estimated Budget. Format it as a table.”

2. Export: Once Gemini generates the table, look for the Google Sheets icon or the “Export to Sheets” button at the bottom-left of the table.

3. Finalize: A new Google Sheet will open in your Drive with the data perfectly formatted. You can then connect this Sheet to AppSheet as a data source.

Method 2: Create a CSV file

1. Prompt Gemini: Ask for a CSV-formatted code block.
   Example: “Generate a dummy dataset of 15 inventory items for a retail store. Provide it as a CSV code block with headers: Product_ID, Item_Name, Category, Stock_Level, and Reorder_Point.”

2. Copy the Code: Click the “Copy” button on the top-right of the code block Gemini provides.
   

   

3. Paste it into cell A1 of a new Google Sheet.

4. Select Column A.

5. Go to Data > Split text to columns.

Note: Utilize Method 2 whenever Method 1 is not displayed as an option in the generated response.

[Suvrutt_Gurjar]

This is useful tip. Thank you @Shourya_Tomar for sharing.