CSV, JSON and text output
Excel is not always the destination. This category covers the other files a PDF can become: CSV for other apps, JSON for developers, plain text, Word and PowerPoint tables, HTML, Markdown and databases. It also explains the traps in each format, from UTF-8 accents and delimiters to leading zeros, line breaks and CSV injection. Read Convert PDF to CSV: One Table, One Clean File first.
View CSV File Without Excel and Keep It Unchanged
How to view a CSV file without Excel changing it: text editors, browser previews and free viewers, and why opening in Excel can alter data.
Published October 17, 2026csvviewerstext editors
TSV vs CSV: Tabs or Commas for Statement Data?
TSV vs CSV for statement data: why tabs avoid the comma trap in payee names, which apps open each, and how to switch between the two.
Published October 17, 2026tsvcsvdelimiters
Transaction JSON Schema for Converted Statements
A transaction JSON schema for converted statements: required fields, date and amount types, optional balances, and validating each record.
Published October 17, 2026json schemavalidationtransactions
Store Money Amounts in JSON Without Rounding Errors
How to store money amounts in JSON: decimal strings vs numbers vs minor units, currency codes, and the floating-point errors to avoid.
Published October 17, 2026jsonmoneydata types
PDF to XML: When a System Wants Tagged Data
When you need PDF to XML: systems that want tagged records, how a table maps to elements, and why most people want CSV or JSON instead.
Published October 17, 2026xmldata exchangefile formats
PDF to TXT: Plain Text With or Without Layout
Convert PDF to TXT as plain text: keep the layout with spaces or let lines flow, handle page breaks, and know when a text file helps.
Published October 17, 2026txtplain textpdf text
PDF to SQL: Load Statement Rows into a Database
Get PDF data to SQL: convert to CSV, design the table with date and decimal types, bulk load it, and stop duplicates on the next load.
Published October 17, 2026sqlpostgresqldata loading
PDF to JSON: Structured Data Out of a Page
What PDF to JSON conversion gives you: records instead of cells, nested fields, numbers vs strings, and when JSON beats a spreadsheet.
Published October 17, 2026jsonstructured datadevelopers
PDF to HTML Table You Can Paste into a Page
Turn a PDF table into an HTML table: header cells, number alignment, accessible captions, and why a picture of the table is worse.
Published October 17, 2026htmltablesaccessibility
PDF to Access Database: Import Converted Rows
Get PDF data to an Access database: convert to Excel or CSV, import with the right field types, and append next month's rows without duplicates.
Published October 17, 2026microsoft accessdatabase importexcel
PDF Table to Word: An Editable Table, Not a Picture
Move a PDF table to Word as an editable table: open in Word, copy from a spreadsheet, or rebuild from text, and keep column widths sane.
Published October 17, 2026wordpdf tablesediting
PDF Table to PowerPoint as an Editable Table
Move a PDF table to PowerPoint as an editable table, not a screenshot: via Excel, pasting options, and trimming it to fit a slide.
Published October 17, 2026powerpointtablesslides
PDF Table to Markdown for Notes and Docs
Turn a PDF table to Markdown for notes, wikis or chat: pipe syntax, aligning numbers right, escaping pipes in text, and long tables.
Published October 17, 2026markdownpdf tablesnotes
Negative Numbers in CSV: Signs, Brackets, Columns
How negative numbers in CSV files should look: a leading minus, no brackets or CR marks, or separate debit and credit columns, and why it matters.
Published October 17, 2026csvnegative amountsimport
Keep Leading Zeros in CSV Files Opened in Excel
Keep leading zeros in CSV files when Excel opens them: import columns as text, why the zeros are still in the file, and what to never re-save.
Published October 17, 2026csvleading zerosexcel import
JSON vs CSV: Which Format for Statement Data?
JSON vs CSV for statement data: flat rows vs nested records, file size, what each app reads, and when to pick each for your converted file.
Published October 17, 2026jsoncsvfile formats
JSON to Excel: Load Records as Rows with Power Query
Load JSON to Excel as rows with Power Query: open the file, expand records and lists, set column types, and refresh when a new file arrives.
Published October 17, 2026jsonpower queryexcel
JSON to CSV: Flatten Records into Rows
Convert JSON to CSV by flattening records into rows: nested fields into columns, arrays into extra rows, and a header row from the keys.
Published October 17, 2026jsoncsvflattening
Fixed Width Text to Excel: Set the Column Breaks
Bring fixed width text to Excel: set column breaks in the import wizard, keep codes as text, and handle lines whose fields drift.
Published October 17, 2026fixed widthtext importexcel
Excel Save as CSV: What You Lose on the Way
What Excel save as CSV keeps and drops: only the active sheet, formats, formulas, leading zeros and long numbers, and which CSV type to pick.
Published October 17, 2026excelcsvexport
CSV Without Header Row: Add Names Before Import
What to do with a CSV without a header row: add column names, tell the import tool, and avoid losing the first transaction as a header.
Published October 17, 2026csvheadersimport
CSV UTF-8 Excel Fix: Stop Accents Turning to Junk
Why accented payees turn to junk in a CSV in Excel, how UTF-8 and the byte order mark fix it, and how to save CSV UTF-8 from Excel.
Published October 17, 2026csvutf-8encodingexcel
CSV to JSON: Turn Rows into Records
Convert CSV to JSON records: header names become keys, numbers stay numbers, empty cells become nulls, and quoted commas stay in one field.
Published October 17, 2026csvjsondata formats
CSV Opens in One Column? Fix the Delimiter
When a CSV opens in one column in Excel: semicolon vs comma delimiters, regional list separators, and importing with the right setting.
Published October 17, 2026csvdelimiterexcel import
CSV Line Breaks in Cells: Why Rows Split Apart
Why CSV line breaks in cells split one record across rows, how quoting keeps a multi-line description in one cell, and how to remove the breaks.
Published October 17, 2026csvline breaksquoting
CSV Injection: Formulas Hiding in a Converted File
What CSV injection is: cells starting with = or + that run as formulas when opened, why payee text can trigger it, and how to neutralize it.
Published October 17, 2026csvsecurityformulas
Convert PDF to CSV: One Table, One Clean File
Convert PDF to CSV when you need plain rows for another app: picking the table, a header row, delimiters, encoding, and checking the file opens.
Published October 17, 2026csvpdf tablesfile formats
Convert CSV to Excel Without Changing the Data
Convert CSV to Excel without it changing dates, zeros or long numbers: import with From Text, set column types, then save as a workbook.
Published October 17, 2026csvexcelimport
Bank Statement to JSON: Fields Developers Expect
Turn a bank statement to JSON with fields developers expect: account, period, opening and closing balances, and a transactions array.
Published October 17, 2026jsonbank statementdevelopers