---
title: "What IntoSQL fixes"
description: "Every change IntoSQL makes to a file before writing SQL, why it makes it, and how each one appears in the conversion report."
canonical: https://intosql.com/docs/fixes
last_updated: 2026-10-15
---

# What IntoSQL fixes

Real files carry habits a database doesn't share: a title above the header, dates written day-first, decimal commas, `N/A` for empty, a total under the data. IntoSQL handles each one, and every change it makes appears in the report with the row or column it touched, so nothing changes without a trace.

The messages below are the ones the report shows, with example values. In the converter each fix also gets a number, marked on the cell or column where it happened.

> **Note:** When a fix is wrong for your file, change it: pick the header row, the date order or the separator in the options, or keep a column as text. The [converter guide](/docs/converter) shows where.


## Where the data is

### `header_found`

The header is on row 4; the rows above it were left out.

### `no_header_found`

The first row holds data, so the columns are named column_1, column_2 and so on.

### `total_row_skipped`

Row 9 ("TOTAL") is a total, so it was left out.

### `note_row_skipped`

Row 12 ("Fuente: sistema de ventas") is a note below the table, so it was left out.

### `unclosed_quote_read`

Row 41 opens a quote that never closes, so the quote is kept as a character.

## Reading values

### `dates_day_first`

15/02/2024 proves the dates in "Alta" are day-first, so 03/02/2024 is read as 2024-02-03.

### `dates_month_first`

02/15/2024 proves the dates in "Signup" are month-first, so 02/03/2024 is read as 2024-02-03.

### `excel1904_dates`

The workbook counts dates from 1904, so its dates were read that way.

### `decimal_comma_read`

Numbers in "Saldo" use a decimal comma: 1.234,50 is read as 1234.50.

### `formatted_numbers_read`

Numbers in "Price" carry symbols: $1,234.50 is read as 1234.50.

### `read_by_locale`

"Monto" reads two ways, so it was read the es-MX way: 1.500 is read as 1500.

### `boolean_words_read`

"Activo" holds yes and no words (sí, no), stored as boolean.

### `null_markers_read`

N/A in "Saldo" read as empty (1 of 4 values).

### `leading_zeros_kept`

Leading zeros kept in "Nº Cliente": 00127 stays 00127, stored as text.

### `code_kept_as_text`

"SKU" holds codes such as 0012-A, so it's stored as text.

## Encoding

### `text_transcoded`

The file was written in windows-1252; it was converted to UTF-8.

## Column names

### `column_renamed`

Column "Nº Cliente" is named no_cliente so PostgreSQL reads it without quotes.

### `unnamed_column_named`

Column 3 has no name, so it's named column_3.

### `duplicate_column_renamed`

A second column called "Fecha" is named fecha_2.

### `reserved_word_renamed`

"order" is a reserved word in MySQL, so the column is named order_.