FastBankConvertFastBankConvert home

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.

  1. 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

  2. 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

  3. 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

  4. 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

  5. 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

  6. 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

  7. 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

  8. 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

  9. 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

  10. 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

  11. 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

  12. 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

  13. 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

  14. 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

  15. 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

  16. 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

  17. 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

  18. 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

  19. 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

  20. 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

  21. 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

  22. 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

  23. 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

  24. 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

  25. 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

  26. 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

  27. 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

  28. 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

  29. 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