All Tools View Categories About Contact Privacy

Audit Log Formatter

Align raw audit lines into named columns, with CSV and JSONL export.

Runs entirely in your browser — your logs never leave this page.
0
records
0
skipped blanks
0
ragged rows

  

  

About Audit Log Formatter

Audit logs arrive in every shape — comma dumps from databases, pipe-delimited SIEM extracts, space-padded syslog-style lines, tab-separated exports from some internal tool nobody remembers the name of. Audit Log Formatter takes a field list and a delimiter, then restructures every line into a named, column-aligned table you can actually read at a glance, without writing a parser.

You define the field names once, in the exact order they appear in each line, and pick the delimiter that splits your input: comma, pipe, tab, or one-or-more whitespace characters. Each raw line is split on that delimiter and its parts are assigned in order to your named fields, so a five-field pipe-delimited line becomes a record with five clearly labeled columns instead of an anonymous list of values you have to count by hand. Fields where the value is a bare 10-digit number — the classic Unix epoch-seconds timestamp — are automatically converted to ISO 8601 UTC when the epoch option is on, while every other value, whatever field it lives in, passes through completely unchanged, so nothing you did not ask to be touched gets silently rewritten.

The same parsed records export cleanly in three shapes: a padded, column-aligned plain-text table for reading in the browser, a CSV file with a header row and proper quoting for values containing commas or quotes, or newline-delimited JSON (JSONL) with one JSON object per record for piping straight into a downstream ingestion tool. Lines that split into more or fewer fields than your field list are never silently dropped or mis-assigned — they are pulled out and reported separately, with their line number, the field count actually found, and the raw text, so a malformed record is something you notice and fix rather than something that quietly corrupts a column downstream.

Features

  • Named-field alignment — readable, padded tables built from your own field names, in your own field order.
  • Comma / pipe / tab / whitespace delimiters — pick the one that matches your source format.
  • Epoch-to-ISO timestamp conversion — any bare 10-digit field becomes an ISO 8601 UTC string when the option is enabled.
  • CSV export — header row plus RFC-4180-style quoting for values containing commas, quotes, or newlines.
  • JSONL export — one JSON object per line, fields in your defined order, ready for a pipeline.
  • Ragged-line reporter — lines with the wrong field count are listed with their line number and actual field count instead of being silently mangled.
  • Blank-line accounting — empty lines are skipped and counted, not treated as malformed records.
  • Local only — nothing uploaded, formatting and export both happen in your browser.

How to Use

  1. Paste your audit lines into the text box, one record per line.
  2. Set the field names as a comma-separated list in the exact order your data appears — e.g. timestamp,host,user,action,result.
  3. Choose the delimiter that splits your raw lines: pipe, comma, tab, or whitespace.
  4. Turn on epoch conversion if any of your fields carry 10-digit Unix timestamps you want shown as ISO 8601 UTC.
  5. Hit Format. The table, record count, blank-line count, and any ragged rows all appear at once.
  6. Copy the table for a quick read, or export CSV or JSONL for a spreadsheet, SIEM import, or ingestion pipeline.

Examples

Example 1 — Application audit. Lines like 1700000000|web01|alice|login|allow become a labeled five-column table with the timestamp shown as ISO UTC (e.g. 2023-11-14T22:13:20Z), while host, user, action, and result stay exactly as written.

Example 2 — SIEM extract. A comma-separated export is normalized into a named table, then exported as CSV with a header row and correct quoting around any field that itself contains a comma, ready for the compliance archive.

Example 3 — JSON pipeline. The same input serialized as JSONL, one object per line with your field names as keys in your defined order, feeds directly into a downstream ingestion tool without any additional transformation.

Example 4 — Catching a bad line. A one-off line like BAD_ROW|web03 only splits into two parts against a five-field definition. Instead of shifting every later field left by three columns, the formatter pulls that line into the ragged-rows report with its line number and field count, so the mistake is visible instead of hidden inside the table.

Benefits

  • Readable output — named, aligned columns instead of a wall of delimiter-separated text.
  • Multiple exports — read as a table, hand off as CSV, or stream as JSONL, all from the same parsed data.
  • Safe timestamp handling — 10-digit epoch values are converted automatically; everything else is left exactly as it was.
  • Explicit error handling — ragged lines are reported with their line number and field count, never silently mis-assigned into the wrong columns.
  • Consistent copy behavior — the Copy button always copies the table view that is on screen, matching what you see.
  • Private — all formatting and export is client-side, nothing is uploaded.

Frequently Asked Questions

What does this formatter do?
It turns raw, delimiter-split audit lines into a clean, column-aligned table with named fields — then optionally exports the same data as CSV or JSONL. You define the field names and the delimiter; it handles the layout.
What input shapes does it accept?
Comma-separated, pipe-separated, tab-separated, or whitespace-separated lines. Each line becomes one record, and fields are assigned in order to the names you provide.
Can it fix timestamps?
Yes. Ten-digit epoch timestamps are auto-detected and converted to ISO 8601 (UTC). Everything else is left unchanged, so your original values are never silently altered.
How are ragged lines handled?
Lines that have fewer fields than your list are flagged and reported separately with their field count, so you always know which entries did not conform.
Is my data uploaded?
No. Formatting and export both happen in your browser.