Skip to content
  • Home
  • About
  • No Access
  • Privacy Policy
Bits of .NET
Bits of .NET
  • Asp.Net Core
  • C#
  • SQL
  • JavaScript
  • CSS
  • About
  • ErcanOPAK.com
  • No Access
  • Privacy Policy

Bits of .NET

Daily micro-tips for C#, SQL, performance, and scalable backend engineering.

  • Asp.Net Core
  • C#
  • SQL
  • JavaScript
  • CSS
  • About
  • ErcanOPAK.com
  • No Access
  • Privacy Policy
AI

AI Prompt: Transform Data Between Formats (CSV, JSON, XML, SQL)

- 22.03.26 - ErcanOPAK

🔄 Convert Any Data Format Instantly

CSV to JSON? XML to SQL? Excel to API payload? AI transforms data between formats in seconds.

The Universal Data Transformer Prompt

Transform this data from [SOURCE FORMAT] to [TARGET FORMAT]:

[Paste data]

Requirements:
- Preserve all data (no loss)
- Use proper data types
- Format for [USE CASE: import/API/database/etc]
- Add any necessary headers/metadata
- Handle special characters properly
- Make it production-ready

If any ambiguity, ask for clarification.

Real-World Examples

📊 CSV → JSON

Prompt: "Convert this CSV to JSON array"

Input:
name,age,email
John,25,john@ex.com
Jane,30,jane@ex.com

Output:
[
  {"name":"John","age":25,"email":"john@ex.com"},
  {"name":"Jane","age":30,"email":"jane@ex.com"}
]

🗄️ JSON → SQL INSERT

Prompt: "Convert to SQL INSERT for users table"

Input:
[{"name":"John","age":25}]

Output:
INSERT INTO users (name, age) 
VALUES ('John', 25);

📄 XML → JSON

Prompt: "Parse this XML to JSON"

Input:
John

Output:
{"user":{"name":"John"}}

📋 Excel → API Payload

Prompt: "Convert to REST API POST body"

Input: [paste Excel cells]

Output:
{
  "users": [...]
}

Advanced Transformations

🔧 Complex Reshaping

Prompt: "Reshape this flat data into nested structure"

Flat CSV:
user_id,user_name,order_id,product
1,John,101,Laptop
1,John,102,Mouse

Nested JSON:
{
  "users": [
    {
      "id": 1,
      "name": "John",
      "orders": [
        {"id": 101, "product": "Laptop"},
        {"id": 102, "product": "Mouse"}
      ]
    }
  ]
}

🎯 Use Cases

  • Data migration: Legacy system → New database
  • API integration: Their format → Your format
  • Reporting: Database → Excel for stakeholders
  • Import/Export: Between different tools
  • Data cleanup: Fix formatting issues during transform

💡 Pro Tips

  • Sample first: Test with 2-3 rows before full dataset
  • Specify types: “age should be number, not string”
  • Handle nulls: “Empty cells should be null, not empty strings”
  • Validate output: Ask AI to validate the transformed data

“Client sent 10,000 rows of Excel data in wrong format. Needed it as JSON for API import. AI transformed all in 2 minutes with perfect data types. Would’ve taken me hours manually.”

— Data Engineer

Related posts:

The AI Prompt That Turns Your Car's Owner's Manual PDF Into a Quick-Reference Card for Every Dashboa...

The AI Prompt That Turns Your Car's Owner's Manual PDF Into a Quick-Reference Card for Every Dashboa...

AI Prompt: Create Comprehensive README for GitHub Project

AI Prompt: Create Comprehensive README for GitHub Project

AI: Optimizing Large Context Windows for Massive Codebases

AI: Optimizing Large Context Windows for Massive Codebases

Views: 18

Post navigation

AI Prompt: Generate Complete API Documentation from Codebase
AI Prompt: Learn New Technology with Personalized Curriculum

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

November 2026
M T W T F S S
 1
2345678
9101112131415
16171819202122
23242526272829
30  
« Oct    

Most Viewed Posts

  • How to make theater mode the default for Youtube (1,055)
  • Get the User Name and Domain Name from an Email Address in SQL (981)
  • How to add default value for Entity Framework migrations for DateTime and Bool (977)
  • Get the First and Last Word from a String or Sentence in SQL (858)
  • How to select distinct rows in a datatable in C# (854)
  • How to enable, disable and check if Service Broker is enabled on a database in SQL Server (653)
  • Add Constraint to SQL Table to ensure email contains @ (609)
  • Average of all values in a column that are not zero in SQL (570)
  • How to use Map Mode for Vertical Scroll Mode in Visual Studio (547)
  • Find numbers with more than two decimal places in SQL (475)

Recent Posts

  • C#: Fix a ConditionalWeakTable Entry Vanishing Too Soon
  • Docker: Fix a Stale COPY Layer After Editing .dockerignore
  • Photoshop: Fix a Pattern Overlay Scaling Wrong on a High-DPI File
  • SQL Server: Fix a Computed Column Index Skipped by Implicit Cast
  • HTML5: Fix a required Input Inside a Hidden Tab Blocking Submit
  • SQL Server: Fix ROW_NUMBER Ties Reordering Between Identical Runs
  • C#: Fix an Enum HasFlag Returning True for the Zero Value
  • WordPress: Fix Featured Images Vanishing After a CDN Migration
  • Photoshop: Fix Content-Aware Fill Smearing a Repeating Pattern
  • Asp.Net Core: Fix Antiforgery Tokens Rejected Behind a Reverse Proxy

Most Viewed Posts

  • How to make theater mode the default for Youtube (1,055)
  • Get the User Name and Domain Name from an Email Address in SQL (981)
  • How to add default value for Entity Framework migrations for DateTime and Bool (977)
  • Get the First and Last Word from a String or Sentence in SQL (858)
  • How to select distinct rows in a datatable in C# (854)

Recent Posts

  • C#: Fix a ConditionalWeakTable Entry Vanishing Too Soon
  • Docker: Fix a Stale COPY Layer After Editing .dockerignore
  • Photoshop: Fix a Pattern Overlay Scaling Wrong on a High-DPI File
  • SQL Server: Fix a Computed Column Index Skipped by Implicit Cast
  • HTML5: Fix a required Input Inside a Hidden Tab Blocking Submit

Social

  • ErcanOPAK.com
  • GoodReads
  • LetterBoxD
  • Linkedin
  • The Blog
  • Twitter
© 2026 Bits of .NET | Built with Xblog Plus free WordPress theme by wpthemespace.com