Financial Data Tools Blog
Step-by-step tutorials and in-depth guides for getting the most out of every tool on FinancialDataTools.com.
This blog contains tutorials, guides, and practical explanations for working with browser-based data tools. The articles focus on real workflows: opening SQLite databases for review, inspecting financial data exports, understanding table structure, and exporting records to usable formats. All workflows described here run entirely in your browser — no software installation, no account, and no data sent to any server.
The SQLite Viewer is the primary tool covered in this blog. It supports .db, .sqlite, .sqlite3, and .db3 files, and handles the full range of tasks from simple table browsing to SQL querying and multi-format export. Privacy is built into the approach: your financial data stays on your device throughout the entire process.
Start with the SQLite Viewer tutorial for a complete walkthrough of opening and navigating a database, or jump to the SQLite Viewer guide for a reference-style breakdown of every feature. Both articles are written for readers who may be new to SQLite as well as those with existing database experience.
SQLite Viewer
How to Open and Browse a SQLite Database: Step-by-Step Tutorial
A complete walkthrough of using the free browser-based SQLite Viewer to open .db and .sqlite files, inspect tables, run SQL queries, and export your data.
SQLite Viewer: Complete Feature Guide & Reference
Everything you need to know about the FinancialDataTools.com SQLite Viewer — every feature explained, from table browsing and SQL querying to column filtering and multi-format export.
Access Viewer
How to Open & Browse a Microsoft Access Database: Step-by-Step Tutorial
Step-by-step walkthrough of the free Access Viewer — opening .mdb and .accdb files, browsing tables, filtering records, inspecting schema, and exporting data.
Access Viewer: Complete Feature Guide & Reference
Full reference for the Access Viewer — supported formats, filtering modes, schema inspection, pagination, and all export options for .mdb and .accdb files.
CSV Viewer
How to Open & Browse a CSV File: Step-by-Step Tutorial
Step-by-step walkthrough of the free CSV Viewer — opening .csv and .tsv files, sorting columns, filtering rows, viewing file info, and exporting data.
CSV Viewer: Complete Feature Guide & Reference
Full reference for the CSV Viewer — delimiter auto-detection, column type inference, filter modes, pagination for large files, and multi-format export.
IIF Viewer
How to Open & Browse a QuickBooks IIF File: Step-by-Step Tutorial
Step-by-step walkthrough of the free IIF Viewer — opening QuickBooks .iif files, browsing record type tabs, filtering rows, and exporting to CSV or Excel.
IIF Viewer: Complete Feature Guide & Reference
Full reference for the IIF Viewer — IIF format overview, record type tabs, column sorting and filtering, pagination for large files, and multi-format export.
IIF to CSV Converter
How to Convert a QuickBooks IIF File to CSV: Step-by-Step Tutorial
Step-by-step walkthrough of the free IIF to CSV Converter — loading an IIF file, previewing parsed records, running the conversion, and downloading the CSV output.
IIF to CSV Converter: Complete Feature Guide & Reference
Full reference for the IIF to CSV Converter — IIF format overview, TYPE column output, file naming, privacy, and financial data use cases.
CSV to IIF Converter
How to Convert a CSV File to QuickBooks IIF: Step-by-Step Tutorial
Step-by-step walkthrough of the free CSV to IIF Converter — preparing your CSV, choosing a record type, running the conversion, and importing the IIF into QuickBooks.
CSV to IIF Converter: Complete Feature Guide & Reference
Full reference for the CSV to IIF Converter — record type selector, IIF output structure, field naming, privacy, and QuickBooks import use cases.
IIF to Excel Converter
How to Convert a QuickBooks IIF File to Excel XLSX: Step-by-Step Tutorial
Step-by-step walkthrough of the free IIF to Excel Converter — loading an IIF file, previewing records, building the workbook, and downloading the XLSX file.
IIF to Excel Converter: Complete Feature Guide & Reference
Full reference for the IIF to Excel Converter — XLSX output format, auto column widths, workbook structure, privacy, and QuickBooks data use cases.
CSV to JSON Converter
How to Convert a CSV File to JSON: Step-by-Step Tutorial
Step-by-step walkthrough of the free CSV to JSON Converter — loading a CSV file, previewing source data, running the conversion, and downloading the JSON output.
CSV to JSON Converter: Complete Feature Guide & Reference
Full reference for the CSV to JSON Converter — input formats, JSON output structure, numeric coercion, null handling, output file naming, and privacy.
JSON to Excel Converter
How to Convert a JSON File to Excel: Step-by-Step Tutorial
Step-by-step walkthrough of the free JSON to Excel Converter — loading a JSON file, previewing source data, running the conversion, and downloading the Excel output.
JSON to Excel Converter: Complete Feature Guide & Reference
Full reference for the JSON to Excel Converter — supported JSON structures, envelope unwrapping, Excel output format, file naming, and privacy.
XML to Excel Converter
How to Convert an XML File to Excel: Step-by-Step Tutorial
Step-by-step walkthrough of the free XML to Excel Converter — loading an XML file, previewing source data, running the conversion, and downloading the Excel output.
XML to Excel Converter: Complete Feature Guide & Reference
Full reference for the XML to Excel Converter — supported XML structures, attribute handling, Excel output format, file naming, and privacy.
DBF Viewer
How to Open & Browse a dBASE DBF File: Step-by-Step Tutorial
Step-by-step walkthrough of the free DBF Viewer — opening dBASE .dbf files, browsing records, filtering fields, inspecting schema, and exporting to CSV or Excel.
DBF Viewer: Complete Feature Guide & Reference
Full reference for the DBF Viewer — dBASE version support, field type codes, deleted record handling, schema inspection, and all export options.
DuckDB Viewer
How to Open & Query a DuckDB Database: Step-by-Step Tutorial
Step-by-step walkthrough of the free DuckDB Viewer — opening .duckdb files, browsing tables, running SQL queries with DuckDB-Wasm, and exporting results.
DuckDB Viewer: Complete Feature Guide & Reference
Full reference for the DuckDB Viewer — DuckDB-Wasm internals, SQL panel with query examples, schema inspection, pagination, and all export options.
JSON Viewer
How to Open & Browse a JSON File: Step-by-Step Tutorial
Step-by-step walkthrough of the free JSON Viewer — opening .json and .jsonl files as tables, sorting, filtering, inspecting nested values, and exporting data.
JSON Viewer: Complete Feature Guide & Reference
Full reference for the JSON Viewer — JSON and JSONL format detection, nested value handling, column type inference, cell detail panel, and multi-format export.
XML Viewer
How to Open & Browse an XML File: Step-by-Step Tutorial
Step-by-step walkthrough of the free XML Viewer — opening .xml files, element auto-detection, browsing as a table, sorting, filtering, and exporting data.
XML Viewer: Complete Feature Guide & Reference
Full reference for the XML Viewer — element detection algorithm, attribute vs child columns, limitations, schema inspection, and all export options.
Parquet Viewer
How to Open & Browse a Parquet File: Step-by-Step Tutorial
Step-by-step walkthrough of the free Parquet Viewer — opening .parquet files with DuckDB-Wasm, browsing columns, filtering rows, inspecting schema, and exporting data.
Parquet Viewer: Complete Feature Guide & Reference
Full reference for the Parquet Viewer — DuckDB-Wasm Parquet reading, codec support, data type mapping, schema inspection, and full-file export options.
OFX Viewer
OFX Viewer Tutorial: Open, Filter & Export OFX Files
A complete walkthrough of using the free OFX Viewer — from opening a bank statement file to filtering transactions and exporting to CSV or Excel.
OFX Viewer: Complete Feature Guide & Reference
Everything you need to know about the OFX Viewer — every feature explained, from transaction browsing and column filtering to multi-format export options.
QFX Viewer
QFX Viewer Tutorial: Open, Filter & Export QFX Files
A complete walkthrough of using the free QFX Viewer — from opening a Quicken file to filtering transactions and exporting to CSV or Excel.
QFX Viewer: Complete Feature Guide & Reference
Everything you need to know about the QFX Viewer — every feature explained, from transaction browsing and column filtering to multi-format export options.
QBO Viewer
QBO Viewer Tutorial: Open, Filter & Export QBO Files
A complete walkthrough of using the free QBO Viewer — from opening a QuickBooks Online file to filtering transactions and exporting to CSV or Excel.
QBO Viewer: Complete Feature Guide & Reference
Everything you need to know about the QBO Viewer — every feature explained, from transaction browsing and column filtering to multi-format export options.
MT940 Viewer
MT940 Viewer Tutorial: Open, Filter & Export MT940 Files
A complete walkthrough of using the free MT940 Viewer — from opening a SWIFT bank statement to filtering transactions and exporting to CSV or Excel.
MT940 Viewer: Complete Feature Guide & Reference
Everything you need to know about the MT940 Viewer — every feature explained, from SWIFT tagged-field parsing and column filtering to multi-format export options.
CSV Duplicate Finder
How to Use the CSV Duplicate Finder Tool
Step-by-step walkthrough of the free CSV Duplicate Finder — loading a CSV file, choosing full-row or column-based detection, reviewing results, and exporting duplicate or unique rows.
How to Find Duplicate Rows in CSV Files
Complete guide to CSV duplicate detection — when to use full-row vs column-based mode, trim and case options, reading grouped results, exporting, and practical use cases for financial data.
CSV Sorter
How to Use the CSV Sorter Tool
Step-by-step walkthrough of the free CSV Sorter — loading a CSV file, selecting primary and tiebreaker sort columns, configuring data types and direction, and exporting the sorted result.
How to Sort CSV Files by Column
Complete guide to CSV column sorting — text, number, and date sort types, multi-level tiebreakers, auto-detection, ascending and descending direction, and exporting sorted CSV files.
CSV Merger
How to Use the CSV Merger Tool
Step-by-step walkthrough of the free CSV Merger — adding multiple CSV files, choosing header-match or strict mode, enabling source tracking, and exporting the merged result.
How to Merge CSV Files
Complete guide to CSV file merging — header-match vs strict mode, column union handling, source filename tracking, and practical use cases for consolidating financial data.
Start Here
If you are new to the site, the best place to begin is the SQLite Viewer — open it directly in your browser, drop in a .db or .sqlite file, and start exploring your data immediately. For a guided introduction, the articles on this blog walk through every step. You can also browse all available tools in the viewers section.
QBO to CSV Converter
How to Convert a QBO File to CSV: Step-by-Step Tutorial
Step-by-step walkthrough of the free QBO to CSV Converter — preparing your file, running the conversion, and downloading the result.
QBO to CSV Converter: Complete Feature Guide & Reference
Full reference for the QBO to CSV Converter — input format, output structure, file naming, privacy, and use cases.
QBO to Excel Converter
How to Convert a QBO File to Excel: Step-by-Step Tutorial
Step-by-step walkthrough of the free QBO to Excel Converter — preparing your file, running the conversion, and downloading the result.
QBO to Excel Converter: Complete Feature Guide & Reference
Full reference for the QBO to Excel Converter — input format, output structure, file naming, privacy, and use cases.
QBO to JSON Converter
How to Convert a QBO File to JSON: Step-by-Step Tutorial
Step-by-step walkthrough of the free QBO to JSON Converter — preparing your file, running the conversion, and downloading the result.
QBO to JSON Converter: Complete Feature Guide & Reference
Full reference for the QBO to JSON Converter — input format, output structure, file naming, privacy, and use cases.
QBO to XML Converter
How to Convert a QBO File to XML: Step-by-Step Tutorial
Step-by-step walkthrough of the free QBO to XML Converter — preparing your file, running the conversion, and downloading the result.
QBO to XML Converter: Complete Feature Guide & Reference
Full reference for the QBO to XML Converter — input format, output structure, file naming, privacy, and use cases.
QBO to OFX Converter
How to Convert a QBO File to OFX: Step-by-Step Tutorial
Step-by-step walkthrough of the free QBO to OFX Converter — preparing your file, running the conversion, and downloading the result.
QBO to OFX Converter: Complete Feature Guide & Reference
Full reference for the QBO to OFX Converter — input format, output structure, file naming, privacy, and use cases.
QBO to QFX Converter
How to Convert a QBO File to QFX: Step-by-Step Tutorial
Step-by-step walkthrough of the free QBO to QFX Converter — preparing your file, running the conversion, and downloading the result.
QBO to QFX Converter: Complete Feature Guide & Reference
Full reference for the QBO to QFX Converter — input format, output structure, file naming, privacy, and use cases.
QBO to MT940 Converter
How to Convert a QBO File to MT940: Step-by-Step Tutorial
Step-by-step walkthrough of the free QBO to MT940 Converter — preparing your file, running the conversion, and downloading the result.
QBO to MT940 Converter: Complete Feature Guide & Reference
Full reference for the QBO to MT940 Converter — input format, output structure, file naming, privacy, and use cases.
Excel to IIF Converter
How to Convert a Excel File to IIF: Step-by-Step Tutorial
Step-by-step walkthrough of the free Excel to IIF Converter — preparing your file, running the conversion, and downloading the result.
Excel to IIF Converter: Complete Feature Guide & Reference
Full reference for the Excel to IIF Converter — input format, output structure, file naming, privacy, and use cases.
JSON to IIF Converter
How to Convert a JSON File to IIF: Step-by-Step Tutorial
Step-by-step walkthrough of the free JSON to IIF Converter — preparing your file, running the conversion, and downloading the result.
JSON to IIF Converter: Complete Feature Guide & Reference
Full reference for the JSON to IIF Converter — input format, output structure, file naming, privacy, and use cases.
XML to IIF Converter
How to Convert a XML File to IIF: Step-by-Step Tutorial
Step-by-step walkthrough of the free XML to IIF Converter — preparing your file, running the conversion, and downloading the result.
XML to IIF Converter: Complete Feature Guide & Reference
Full reference for the XML to IIF Converter — input format, output structure, file naming, privacy, and use cases.
DBF to IIF Converter
How to Convert a DBF File to IIF: Step-by-Step Tutorial
Step-by-step walkthrough of the free DBF to IIF Converter — preparing your file, running the conversion, and downloading the result.
DBF to IIF Converter: Complete Feature Guide & Reference
Full reference for the DBF to IIF Converter — input format, output structure, file naming, privacy, and use cases.
OFX to IIF Converter
How to Convert a OFX File to IIF: Step-by-Step Tutorial
Step-by-step walkthrough of the free OFX to IIF Converter — preparing your file, running the conversion, and downloading the result.
OFX to IIF Converter: Complete Feature Guide & Reference
Full reference for the OFX to IIF Converter — input format, output structure, file naming, privacy, and use cases.
QFX to IIF Converter
How to Convert a QFX File to IIF: Step-by-Step Tutorial
Step-by-step walkthrough of the free QFX to IIF Converter — preparing your file, running the conversion, and downloading the result.
QFX to IIF Converter: Complete Feature Guide & Reference
Full reference for the QFX to IIF Converter — input format, output structure, file naming, privacy, and use cases.
MT940 to IIF Converter
How to Convert a MT940 File to IIF: Step-by-Step Tutorial
Step-by-step walkthrough of the free MT940 to IIF Converter — preparing your file, running the conversion, and downloading the result.
MT940 to IIF Converter: Complete Feature Guide & Reference
Full reference for the MT940 to IIF Converter — input format, output structure, file naming, privacy, and use cases.