Recent Articles

All JSON Snowflake XML
XML,

XML to Excel – Complete Guide to Convert & Import Files

Converting XML to Excel shouldn’t feel like solving a Rubik’s cube blindfolded. But if you’ve ever tried it, you know it can feel that way. Excel does support XML, but…
Maciek June 17, 2025
XML,
XML parsing guide for Spark and Databricks data integration solutions-min

How to Parse XML in Spark and Databricks [2026 Guide]

You’d think working with XML in Spark 4.0 or Databricks 14.3+ in 2026 would be easy. But it often isn’t. TL;DR: This blog post breaks down how to convert XML…
Maciek May 22, 2025
XML,

How to Use the Flexter XML to CSV/TSV Converter Online

In this guide, I’ll walk you through the online version of Flexter, a free XML to CSV converter that puts professional-grade XML conversion right at your fingertips. Keep reading if…
Maciek January 24, 2025
XML,

XML to Redshift – Parsing, Loading, & Schema Tips (Guide)

Working with XML data in Amazon Redshift feels like running a marathon in flip-flops—clunky, frustrating, and unsupported at every turn. Unlike its cousin, PostgreSQL, which offers an XML data type,…
Maciek January 2, 2025
SQL,
XML to database conversion

XML to Database Converter – Tools, Tips, & XML to SQL Guide

Manually converting XML to a database sucks. If you’re anything like me, you’ve probably burned countless wasted hours wrestling with deeply nested XML and data mappings, misinterpreted XML attributes and…
Maciek December 4, 2024
SQL,

Oracle EXTRACT & EXTRACTVALUE for XML (Guide & Examples)

When you need to extract and/or query an Oracle database for XML data, there are two SQL functions that come to mind, ‘EXTRACT’ and ‘EXTRACTVALUE’. I’m going to delve into…
Maciek October 21, 2024