CSV Importer

DataLoom Free includes a robust, zero-dependency CSV parser built to handle real-world spreadsheet exports without crashing on special characters.

RFC 4180 Compliance

Standard CSV exports from Excel or Google Sheets wrap cells in double-quotes when they contain commas, newlines, or quote marks. Basic string-split algorithms break on these edge cases.

The Problem 

id,description,cost
sword_01,"A heavy sword, forged in fire.",100

A standard string.Split(',') call splits the description cell into two separate columns because of the comma, corrupting the layout mapping.

The Solution

DataLoom’s CsvParser evaluates the spreadsheet stream character by character.

  • It maintains a state machine tracking whether the parser is currently inside a quoted block.
  • Commas and newline characters inside quotation marks are preserved as part of the cell value.
  • Escaped double-quotes ("") are converted to standard single quotes.

Usage

Simply save your spreadsheet in .csv format from your editing tool and drag it into the DataLoom Control Panel.

This site uses Just the Docs, a documentation theme for Jekyll.