FastBankConvertFastBankConvert home
BlogSign inConvert in seconds

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. 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 10, 2026csvnegative amountsimport

  2. 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 7, 2026markdownpdf tablesnotes

  3. 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 September 16, 2026csvdelimiterexcel import

  4. 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 September 5, 2026csvline breaksquoting

  5. 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 September 2, 2026htmltablesaccessibility

  6. 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 August 31, 2026json schemavalidationtransactions

  7. 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 July 31, 2026csvexcelimport

  8. 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 July 21, 2026fixed widthtext importexcel

  9. 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 July 14, 2026jsonstructured datadevelopers

  10. 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 July 3, 2026csvviewerstext editors

  11. 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 June 26, 2026tsvcsvdelimiters

  12. 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 June 5, 2026csvheadersimport

  13. 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 May 23, 2026csvpdf tablesfile formats

  14. 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 May 12, 2026sqlpostgresqldata loading

  15. 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 April 27, 2026jsonpower queryexcel

  16. 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 March 19, 2026csvjsondata formats

  17. 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 March 12, 2026csvutf-8encodingexcel

  18. 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 February 28, 2026jsoncsvfile formats

  19. 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 February 17, 2026jsonbank statementdevelopers

  20. 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 January 17, 2026jsoncsvflattening

  21. 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 August 26, 2025csvleading zerosexcel import

  22. 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 July 5, 2025jsonmoneydata types

  23. 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 June 10, 2025txtplain textpdf text

  24. 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 April 21, 2025powerpointtablesslides

  25. 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 April 14, 2025wordpdf tablesediting

  26. 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 April 2, 2025microsoft accessdatabase importexcel

  27. 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 March 14, 2025excelcsvexport

  28. 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 February 2, 2025xmldata exchangefile formats

  29. 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 23, 2024csvsecurityformulas