177 guides
Data Format Guides
In-depth tutorials on CSV, Excel, JSON, XML, SQL, AI data prep, ecommerce imports, and finance files. Written for people who work with data every day—and need conversions that do not corrupt values.
Category
CSV Basics & Conversion
10 guides
What Is a CSV File? Format, Uses, and Practical Examples
Learn what a CSV file is, how the format works, and how to open, edit, and convert CSV data safely—with clear examples for Excel, JSON, and databases.
Read guideHow to Open and Edit CSV Files Online
Open a CSV file in your browser, preview rows as a spreadsheet, fix common issues, and download clean results—no desktop install required.
Read guideTSV vs CSV: Differences, Use Cases, and Conversion
Compare TSV and CSV formats. Learn when tabs beat commas, how Excel treats each, and how to convert between delimited text files.
Read guideHow to Convert CSV to TSV (Tab-Separated Values)
Convert CSV to TSV cleanly. Learn when tabs beat commas, handle quoting correctly, and export a TSV file that databases and scripts accept.
Read guideHow to Convert an HTML Table to CSV Online (Complete Guide)
Convert HTML tables to CSV for Excel, Google Sheets, and databases. Copy a web table, upload HTML, fix colspan issues, clean columns, and download UTF-8 CSV—step by step with examples, troubleshooting, and FAQs.
Read guideHow to Convert CSV to PDF Online (Complete Guide)
Convert CSV to PDF for sharing, printing, and archiving. Prepare clean tables, choose readable layouts, avoid cut-off columns, and download a PDF report—with workflows, troubleshooting, and FAQs.
Read guideConvert Fixed-Width Files to CSV (Mainframe & Legacy Exports)
Turn fixed-width and positional text files into CSV for Excel and databases. Map column widths, handle padding, and avoid off-by-one splits common in US and UK legacy feeds.
Read guideConvert GeoJSON to CSV for Maps, Excel, and GIS Joins
Flatten GeoJSON FeatureCollections to CSV with longitude, latitude, and properties. Prepare map exports for Excel, BI tools, and US/UK/AU/EU GIS workflows.
Read guideConvert KML to CSV for Google Earth Placemarks and Excel
Extract KML and KMZ placemark names, coordinates, and descriptions to CSV. Prepare Google Earth and Maps exports for Excel, CRM, and GIS joins.
Read guideExtract HTML Links to CSV for Audits, SEO, and Research
Convert HTML anchor links into a CSV of URLs, anchor text, and attributes. Build link audits for US/UK/EU sites without messy copy-paste into Excel.
Read guideCategory
Excel & Spreadsheets
26 guides
CSV vs Excel: Which Format Should You Use?
Compare CSV and Excel (.xlsx) for sharing, analysis, and imports. Learn what each format keeps, what it loses, and when to convert between them.
Read guideHow to Convert Excel (XLSX) to CSV Correctly
Export Excel to CSV without losing critical values. Learn sheet selection, encoding, delimiter pitfalls, and a clean browser-based conversion workflow.
Read guideHow to Convert CSV to Excel Online Instantly
Turn CSV files into downloadable Excel workbooks. Fix delimiter and encoding issues first, then convert to .xlsx for filters, formatting, and sharing.
Read guideHow to Import CSV Into Excel Without Breaking Data
Import CSV into Excel the reliable way. Avoid delimiter guesses, protect leading zeros, fix encoding, or convert to .xlsx online first.
Read guideHow to Edit CSV Files Without Excel
Edit CSV files without Excel using a browser-based spreadsheet editor. Fix headers, rows, and formatting online without installing software.
Read guideWhy Does My CSV Open in One Column? (Fix Guide)
Fix CSV files that open as one giant column in Excel or Sheets. Detect the delimiter, handle encoding, and export a spreadsheet-ready file.
Read guideHow to Preserve Leading Zeros in CSV Files
Stop Excel from stripping leading zeros in CSV IDs, postal codes, and phone numbers. Learn safe export and import workflows.
Read guideHow to Save Excel as UTF-8 CSV (Without Broken Characters)
Export Excel workbooks as UTF-8 CSV so accents, currency symbols, and non-English text survive. Compare Save As options and BOM behavior.
Read guideSemicolon vs Comma CSV: Which Should You Use?
Understand semicolon vs comma CSV files, why Excel locales change delimiters, and how to convert between them without breaking data.
Read guideWhy Excel Breaks CSV Files (and How to Stop It)
Understand why Excel silently corrupts CSV files—leading zeros, dates, scientific notation, encoding—and how to import safely without losing data.
Read guideXLS vs XLSX: Differences, Compatibility, and When to Convert
Compare XLS and XLSX Excel formats. Learn file size, security, macros, and compatibility so you know which format to keep or convert.
Read guideExcel vs Google Sheets: Which Should You Use?
Compare Excel and Google Sheets for CSV, collaboration, formulas, and automation. Pick the right tool for reports, apps, and everyday data.
Read guideUTF-8 CSV vs ANSI CSV: What’s the Difference?
Understand UTF-8 vs ANSI (legacy Windows) encoding for CSV files. Learn which to use, why characters break, and how to convert between them safely.
Read guideBest Practices for Working with CSV in Excel
Stop losing data in Excel. Follow a proven checklist for CSV import, editing, and export to protect IDs, dates, encoding, and formulas.
Read guideEuropean Excel CSV: Germany, Semicolons, and Decimal Commas
Work with German and European Excel CSV files. Fix semicolon delimiters, decimal commas, UTF-8 encoding, and handoffs to US, UK, Canadian, and Australian systems.
Read guideExcel Data Validation for Cleaner CSV Exports
Use Excel data validation to keep CSV exports clean. Restrict dates, numbers, emails, and picklists before you convert or import anywhere else.
Read guideGoogle Sheets and CSV: Import, Export, and Avoid Broken Data
Import and export CSV in Google Sheets without breaking IDs or dates. Learn File → Import settings, download options, and cleanup tips.
Read guideHow to Convert an HTML Table to Excel (XLSX) Online — Complete Guide
Convert HTML tables to Excel (.xlsx) without broken columns. Paste webpage tables or upload HTML, preview rows, fix types and IDs, and download a clean workbook—with workflows, troubleshooting, and FAQs.
Read guidePower BI CSV: Import, Refresh, and Avoid Data Type Traps
Load CSV files into Power BI the right way. Fix delimiters, locales, dates, and UTF-8 encoding for US, UK, AU, CA, and EU datasets — and keep refreshes stable.
Read guideApple Numbers to CSV: Export, Import, and Excel Handoffs
Export Apple Numbers spreadsheets to CSV that Excel, Google Sheets, and Windows teams can open. Fix UTF-8, dates, and multi-table sheets for US, UK, AU, and CA users.
Read guideTableau CSV: Connect, Clean, and Avoid Locale Pitfalls
Load CSV into Tableau Desktop and Tableau Cloud the right way. Fix delimiters, dates, UTF-8 encoding, and US vs UK/EU locales so extracts refresh cleanly.
Read guideLooker Studio CSV: Connect File Uploads Without Breaking Dates
Use CSV uploads and file connectors in Google Looker Studio (Data Studio). Fix delimiters, locales, and UTF-8 for US, UK, AU, CA, and EU reports.
Read guideLibreOffice Calc CSV: Import, Export, and UTF-8 Without Excel Traps
Open and save CSV correctly in LibreOffice Calc. Fix delimiters, UTF-8, and locales for US, UK, AU, and EU spreadsheet users.
Read guideFix Excel Scientific Notation in CSV (IDs, UPCs, TINs)
Stop Excel from converting long CSV IDs into scientific notation. Protect UPCs, TINs, tracking numbers, and account IDs for US, UK, CA, and DE teams.
Read guideGoogle Sheets CSV Export Locale Issues (US/UK/EU)
Fix Google Sheets CSV exports when locale turns commas into semicolons or reformats dates. Settings for US, UK, Canadian, and German collaborators.
Read guideWindows Excel CSV UTF-8 with PowerShell (US & EU)
Produce UTF-8 CSV from Windows Excel using PowerShell and modern Excel export options. Fix ANSI/Windows-1252 mojibake for names and Umlaute.
Read guideCategory
Developers
10 guides
How to Read a CSV File in JavaScript (Browser and Node.js)
Read CSV files in JavaScript reliably. Use FileReader in the browser, streams in Node.js, and CSV libraries that respect quoting and encoding.
Read guideHow to Parse CSV in Python (csv Module and pandas)
Parse CSV in Python with the csv module or pandas. Handle headers, encoding, quoting, and large files with reliable, idiomatic code.
Read guideHow to Parse CSV in Node.js (Streaming and Sync)
Parse CSV in Node.js with csv-parse, papaparse, or fast-csv. Use streams for large files and sync for small scripts, with clean error handling.
Read guideHow to Read a CSV File in React (Upload + Preview)
Read CSV files in a React app. Wire up a file input, parse with Papa Parse, and render a preview table with typed rows and clean error handling.
Read guideBest JavaScript CSV Libraries in 2026
Compare the top JavaScript CSV libraries for browsers and Node.js. See strengths, tradeoffs, and how to pick between Papa Parse, csv-parse, and fast-csv.
Read guideConvert CSV to Markdown Tables for Docs, GitHub, and Notion
Turn CSV files into Markdown tables for README files, PRs, Notion, and wikis. Fix alignment, escaping, and large sheets so US/UK/EU docs stay readable.
Read guideExcel to Jira Table: Paste Spreadsheets into Jira Issues
Convert Excel and CSV grids into Jira wiki markup tables for issues, comments, and Confluence-style pastes. Keep columns aligned for US/UK/EU engineering teams.
Read guideConvert CSV to Word Tables for Reports and Client Docs
Turn CSV data into Microsoft Word tables for proposals, SOPs, and client reports. Keep UTF-8 text intact for US, UK, AU, and EU document workflows.
Read guideCSV to QR Codes: Batch URLs, Coupons, and Asset Tags
Generate QR codes from CSV rows for URLs, promo codes, and inventory tags. Prep clean columns for US, UK, AU, and EU marketing and ops teams.
Read guideJira CSV Import and Export: Issues, Fields, and Migrations
Import and export Jira issues with CSV. Map projects, issue types, and custom fields for US, UK, AU, and EU engineering teams — separate from wiki table pastes.
Read guideCategory
JSON & YAML
14 guides
How to Convert CSV to JSON Online (Step-by-Step)
Convert CSV to JSON for APIs and apps. Learn the mapping rules, fix nested-key issues, and export a clean JSON array without writing code.
Read guideHow to Convert JSON to CSV Without Coding
Flatten JSON arrays into spreadsheet-ready CSV. Learn how nested keys become columns, fix common errors, and export clean files for Excel and Sheets.
Read guideYAML vs JSON: Which Format Should You Use in 2026?
YAML vs JSON compared for config, APIs, and DevOps. See syntax, safety, tooling, and when YAML or JSON is the better fit.
Read guideHow to Convert JSON to Excel (XLSX) Online and With Code
Convert JSON to Excel (XLSX) fast. See browser and script workflows, how to flatten nested JSON, preserve leading zeros, and avoid Excel’s type traps.
Read guideHow to Convert Excel (XLSX) to JSON Online and With Code
Convert Excel (XLSX) to JSON reliably. Browser, Python, and Node workflows with nested output, type-safe conversion, and no lost leading zeros.
Read guideHow to Validate JSON: Syntax, Schema, and Real-World Checks
Validate JSON syntax and structure. Use online tools, JSON Schema, and code examples to catch errors before your API or database does.
Read guideHow to Pretty-Print JSON (Browser, CLI, and Code)
Pretty-print JSON in the browser, terminal, and code. Learn the two-space rule, editor formatters, jq, and language APIs for readable output.
Read guideHow to Minify JSON (Smaller Payloads, Faster APIs)
Minify JSON to shrink payloads and speed up APIs. Learn browser, CLI, and code techniques and when minification actually helps.
Read guideJSON Best Practices: Design, Naming, and Data Types
JSON best practices for APIs, config, and data exchange. Naming, types, dates, nulls, versioning, and schemas—the rules that keep JSON safe at scale.
Read guideCommon JSON Errors and How to Fix Them
Fix the most common JSON errors: trailing commas, bad quotes, encoding issues, and shape mismatches. Diagnose fast with clear examples.
Read guideJSON for Beginners: Syntax, Types, and Real Examples
JSON explained for beginners. Learn the syntax, six data types, and how JSON powers APIs, config, and data exchange—with copy-paste examples.
Read guideHow to Flatten Nested JSON to CSV
Flatten nested JSON into CSV rows and columns. Handle arrays, objects, dot-notation headers, and practical conversion workflows for Excel and analytics.
Read guideHow to Convert YAML to CSV Online (Complete Guide)
Convert YAML lists of records to CSV for Excel, Sheets, and data pipelines. Flatten keys, fix nesting limits, clean headers, and download UTF-8 CSV—with examples, DevOps workflows, troubleshooting, and FAQs.
Read guideJSON vs CSV: When to Use Each Format for Data Exchange
Compare JSON and CSV formats for data exchange. Learn the strengths, weaknesses, and best use cases for each format in APIs, spreadsheets, and data pipelines.
Read guideCategory
XML
11 guides
JSON vs XML: Differences, Use Cases, and When to Pick Each
JSON vs XML compared for APIs, config, and data exchange. See syntax, size, tooling, schema, and when each format wins in real projects.
Read guideXML vs CSV: When to Use Each Format for Data Exchange
XML vs CSV compared for data exchange. See structure, nesting, file size, tooling, and when each format wins for APIs, spreadsheets, and enterprise feeds.
Read guideHow to Convert CSV to XML (Online and With Code)
Convert CSV to XML for partner imports and enterprise feeds. Learn browser steps, Python/Node examples, element naming, and how to avoid invalid markup.
Read guideHow to Convert XML to CSV (Flatten Nested Data)
Convert XML to CSV for Excel and analytics. Learn how to flatten repeating elements, map attributes to columns, and avoid empty or duplicated rows.
Read guideHow to Validate XML: Well-Formed Checks and XSD Schemas
Validate XML for well-formed markup and XSD schema compliance. Learn browser, CLI, and code workflows so partner imports stop failing silently.
Read guideHow to Format and Pretty-Print XML Cleanly
Format XML for readability and safe diffs. Learn pretty-print tools, indentation rules, attribute layout, and when to keep XML compact.
Read guideHow to Parse XML in Python, JavaScript, and the Browser
Parse XML reliably in Python, Node.js, and the browser. Handle namespaces, attributes, large files, and convert results to CSV or JSON when you need tables.
Read guideXML Schema (XSD) Explained: Types, Validation, and Examples
Learn XML Schema (XSD): elements, types, attributes, and how to validate documents. Practical examples for partner feeds and CSV-generated XML.
Read guideCommon XML Errors and How to Fix Them
Fix common XML errors: mismatched tags, unescaped characters, namespaces, encoding, and schema failures. Diagnose fast with clear examples.
Read guideXML for Beginners: Tags, Attributes, and Simple Examples
XML explained for beginners. Learn tags, attributes, nesting, and how XML compares to CSV and JSON—with copy-paste examples and conversion tips.
Read guideWorking with XML Data: Formats, Conversion, and Best Practices
A practical guide to XML data formats, when to use XML vs JSON or CSV, and how to convert XML records into spreadsheet-ready rows.
Read guideCategory
SQL & Databases
10 guides
How to Import CSV Into MySQL (Step-by-Step)
Load CSV data into MySQL safely. Prepare headers and types, choose LOAD DATA or INSERT workflows, and avoid encoding and delimiter failures.
Read guideHow to Import CSV Into PostgreSQL with COPY
Import CSV files into PostgreSQL using COPY or \copy. Prepare UTF-8 data, map columns, and avoid delimiter and header mistakes.
Read guideHow to Convert CSV to SQL INSERT Statements
Turn CSV rows into SQL INSERT statements for MySQL, PostgreSQL, and more. Clean data first, preview output, and avoid quoting mistakes.
Read guideSQL Bulk Insert from CSV: Fast Loads Without Pain
Bulk insert CSV into SQL databases the right way. Compare INSERT batches, LOAD DATA, and COPY—plus prep steps that prevent encoding and type failures.
Read guideHow to Export SQL Query Results to CSV
Export SQL results to CSV from MySQL, PostgreSQL, SQL Server, and SQLite. Get clean UTF-8 files ready for Excel, BI tools, and sharing.
Read guideBulk Import CSV into a Database (Staging, Validate, Load)
Bulk import CSV into MySQL, PostgreSQL, and other databases safely. Use staging tables, validation, and the right load command for each engine.
Read guideDatabase CSV Best Practices for Imports and Exports
Best practices for CSV with databases: encoding, headers, types, nulls, delimiters, and round-trips that survive Excel and production loads.
Read guideMigrate Data Between Databases with CSV
Use CSV as a bridge to migrate data between databases. Plan exports, schema mapping, staging loads, reconciliation, and cutover with minimal downtime.
Read guideCommon CSV Database Import Errors and Fixes
Fix common CSV database import errors: wrong delimiter, encoding, type casts, duplicate keys, header issues, and LOAD DATA / COPY failures.
Read guideHow to Convert SQL INSERT Statements to CSV Online (Complete Guide)
Convert SQL INSERT dumps to CSV for Excel, Sheets, and analysis. Parse column lists and VALUES rows, fix quoting issues, clean headers, and download UTF-8 CSV—with examples, troubleshooting, and FAQs.
Read guideCategory
AI & Machine Learning
10 guides
How to Use ChatGPT with CSV Files (Safely and Effectively)
Use ChatGPT with CSV data for analysis, cleanup, and formulas. Learn prompting patterns, privacy limits, and when to convert files before you paste.
Read guideCSV for Machine Learning: Prepare Datasets That Train Well
Prepare CSV datasets for machine learning. Handle headers, missing values, types, leakage, train/test splits, and export habits that keep experiments reproducible.
Read guideHow to Format Data for AI Tools and LLM Workflows
Format CSV and JSON for AI tools and LLMs. Structure prompts, samples, and datasets so models can parse columns, labels, and instructions reliably.
Read guideHow to Clean Data for AI and Analytics Pipelines
Clean CSV and tabular data for AI and analytics. Fix headers, duplicates, types, outliers, and leakage before models or LLMs see your file.
Read guidePrepare CSV Data for LLM Fine-Tuning and Eval Sets
Prepare CSV datasets for LLM fine-tuning and evaluation. Structure prompts, completions, labels, and splits so training jobs stay reproducible.
Read guideHow to Prepare Excel Files for AI Tools and LLMs
Turn Excel workbooks into AI-ready data. Export sheets to CSV/JSON, clean headers, redact PII, and structure samples so ChatGPT and other models can use them.
Read guideAI Data Best Practices: Quality, Privacy, and Reproducibility
Best practices for AI data: privacy, labeling, versioning, eval sets, and CSV/JSON hygiene so models and LLM workflows stay trustworthy.
Read guideStructured vs Unstructured Data: Differences and AI Uses
Structured vs unstructured data explained for analytics and AI. See examples, conversion paths (CSV/JSON), and when each type fits machine learning and LLMs.
Read guideWhy AI and Machine Learning Still Use CSV Files
Why AI and ML workflows still rely on CSV: portability, human review, tooling, and simple schemas—plus when to graduate to Parquet or databases.
Read guideCommon AI Data Mistakes (and How to Avoid Them)
Avoid common AI data mistakes: leakage, bad labels, Excel corruption, train/eval contamination, and messy CSV that silently ruins model quality.
Read guideCategory
Finance & Accounting
18 guides
CSV for Accounting: Imports, Chart of Accounts, and Clean Books
Use CSV for accounting imports and exports. Format dates, amounts, accounts, and vendors so QuickBooks, Xero, and ledgers accept your file the first time.
Read guideConvert a Bank Statement to CSV (PDF, OFX, QFX, QIF)
Convert bank statements to CSV for Excel and bookkeeping. Handle PDF text, OFX/QFX/QIF exports, dates, and amounts so reconciliation stays accurate.
Read guideOFX vs QFX vs QIF: Bank File Formats Explained
OFX vs QFX vs QIF explained for banking and bookkeeping. See what each format is for, how they differ, and when to convert them to CSV or Excel.
Read guideQuickBooks CSV Import and Export: Bank, Expenses, and Customers
Prepare CSV files for QuickBooks Online and Desktop. Fix dates, amounts, accounts, and bank downloads so imports succeed in the US, Canada, UK, and Australia.
Read guideXero CSV Import and Export: Bank, Invoices, and Contacts
Build Xero-ready CSV files for bank transactions, invoices, bills, and contacts. Fix UK and Australian date formats, GST columns, and Excel export issues.
Read guideConvert IIF to CSV for QuickBooks Review and Cleanup
Convert QuickBooks IIF files to CSV so you can inspect lists and transactions in Excel. Understand IIF sections, common errors, and when to keep native IIF imports.
Read guideHow to Convert a PDF Table to CSV
Convert PDF tables to CSV for Excel and analysis. Use text-based PDFs, bank statement tools, and cleanup steps when columns misalign.
Read guideHow to Convert OFX and QFX to CSV Online (Complete Guide)
Convert OFX and QFX bank downloads to CSV for Excel, Google Sheets, and bookkeeping. Map transactions, reconcile totals, fix date/amount issues, and export clean UTF-8 CSV—with workflows, troubleshooting, and FAQs.
Read guideStripe CSV Exports: Payments, Payouts, and Reconciliation
Download and clean Stripe CSV reports for Excel, QuickBooks, and Xero. Fix fees, refunds, payout timing, and multi-currency rows for US, UK, AU, CA, and EU accounts.
Read guidePayPal CSV Download: Transactions, Fees, and Bookkeeping
Download PayPal CSV transaction history and clean it for Excel, QuickBooks, and Xero. Handle fees, currency, Gross/Net columns, and US vs UK/AU/EU date formats.
Read guideSage CSV Import and Export: UK, AU, CA, and US Ledgers
Prepare CSV files for Sage Accounting and Sage 50. Fix UK date formats, VAT columns, customer lists, and Excel exports so imports succeed first time.
Read guideDATEV CSV and Excel: German Bookkeeping Export/Import Basics
Prepare CSV and Excel files for DATEV-oriented German bookkeeping workflows. Handle semicolon CSV, decimal commas, SKR accounts, and handoffs to tax advisors.
Read guideFreshBooks CSV Import and Export: Clients, Invoices, and Expenses
Export and import FreshBooks CSV for clients, invoices, and expenses. Fix dates, taxes, and Excel issues for US and Canadian bookkeeping handoffs.
Read guideWave Accounting CSV: Customers, Invoices, and Transactions
Export and import Wave CSV for customers, invoices, bills, and transactions. Prep clean files for US and Canadian freelancers and small businesses.
Read guideNetSuite CSV Import: Customers, Transactions, and Saved CSV Imports
Prep NetSuite CSV imports for customers, items, and transactions. Fix date formats, external IDs, and Excel issues for US, UK, AU, CA, and EU finance teams.
Read guideMYOB CSV: Import Cards, Invoices, and Bank Feeds Without Locale Pain
Import and export MYOB CSV for AU/NZ accounting. Fix dates, tax codes, and UTF-8 so Australian and New Zealand files open cleanly in Excel and MYOB.
Read guideFreeAgent CSV: Bank Imports, Invoices, and UK Self-Employed Exports
Import bank CSV to FreeAgent and export invoices cleanly. Fix UK dates, VAT, and UTF-8 for freelancers and small UK limited companies.
Read guideFinance File Formats Explained: OFX, QFX, QIF, IIF, and Bank Statements
Understand common finance and accounting file formats. Learn the differences between OFX, QFX, QIF, IIF, and bank statement formats and when to use each converter.
Read guideCategory
Business & Ecommerce
40 guides
Payroll CSV Files: Formats, Imports, and Common Errors
Work with payroll CSV exports and imports. Format employee IDs, pay dates, earnings, and deductions so HRIS and payroll systems accept your file.
Read guideShopify CSV Import and Export: Products, Customers, and Orders
Use Shopify CSV files the right way. Import products and customers, fix common matrix errors, and clean exports for Excel, inventory, and migrations.
Read guideWooCommerce CSV Import and Export for Products and Orders
Import and export WooCommerce CSV files for products, customers, and orders. Fix common mapping errors and prepare clean UTF-8 catalogs for WordPress.
Read guideAmazon Seller CSV Files: Listings, Inventory, and Reports
Work with Amazon Seller Central CSV and flat files. Prepare listings and inventory updates, avoid common feed errors, and clean reports for Excel analysis.
Read guideGoogle Merchant Center Product Data CSV Guide
Build and fix Google Merchant Center product CSV/TSV feeds. Meet required attributes, avoid disapprovals, and keep IDs stable for Shopping ads.
Read guideCRM CSV Import and Export: Contacts, Deals, and Clean Data
Import and export CRM data with CSV. Map contacts and deals, prevent duplicates, and keep emails, phones, and owners clean across HubSpot, Salesforce, and more.
Read guideSalesforce CSV Import: Data Loader, Wizard, and Field Mapping
Import CSV into Salesforce the right way. Use Data Loader or Import Wizard, map fields, handle Record IDs, and avoid common validation failures.
Read guideHubSpot CSV Import: Contacts, Companies, and Deals
Import CSV into HubSpot correctly. Map properties, dedupe on email, fix common import errors, and prepare clean contact and deal files.
Read guideMailchimp CSV Import: Audience Fields, Consent, and Cleanup
Import CSV into Mailchimp the right way. Map email and merge fields, respect consent, fix duplicates, and prepare clean audience lists.
Read guideEtsy CSV Files: Listings, Orders, and Stock Exports
Use Etsy CSV tools for bulk listings, order exports, and inventory. Fix Excel encoding, variation rows, and US/UK/AU/EU shop workflows before you re-upload.
Read guideSquare CSV Exports: Transactions, Items, and Catalog
Download Square CSV reports for sales, items, and customers. Clean fees, tips, and taxes for Excel, QuickBooks, and Xero across US, UK, CA, and AU sellers.
Read guideeBay CSV Files: Listings, Orders, and Seller Reports
Use eBay CSV and file-exchange style exports for listings, orders, and reports. Fix Excel encoding, SKUs, and US/UK/AU/DE seller workflows before re-upload.
Read guideAirtable CSV Import and Export: Bases, Views, and Linked Records
Import and export Airtable CSV the right way. Handle linked records, attachments, dates, and Excel handoffs for US, UK, AU, and EU teams.
Read guideGoogle Ads CSV: Editor Uploads, Reports, and Bulk Changes
Work with Google Ads CSV and Google Ads Editor exports. Fix UTF-8, formulas, and locale decimals for US, UK, AU, CA, and DE account bulk uploads.
Read guideKlaviyo CSV: Profiles, Lists, and Event Imports
Import and export Klaviyo CSV for profiles, lists, and historical events. Fix consent fields, emails, and Excel encoding for US, UK, AU, and EU ecommerce teams.
Read guideMeta Ads CSV: Ads Manager Exports and Bulk Spreadsheet Uploads
Export and upload Meta (Facebook/Instagram) Ads CSV and Excel sheets. Fix UTF-8, decimals, and locale issues for US, UK, AU, CA, and DE ad accounts.
Read guideNotion CSV Import and Export: Databases Without the Mess
Import and export Notion databases as CSV. Handle relations, multi-selects, dates, and Excel handoffs for US, UK, AU, and EU workspace teams.
Read guideBigCommerce CSV: Products, Customers, and Order Exports
Import and export BigCommerce CSV for products, customers, and orders. Fix SKUs, variants, and Excel encoding for US, UK, AU, and CA stores.
Read guideZendesk CSV: Tickets, Users, and Organizations Export/Import
Export and import Zendesk CSV for tickets, users, and organizations. Fix UTF-8, custom fields, and Excel ID issues for US, UK, AU, and EU support teams.
Read guidemonday.com CSV: Import Boards and Export Items Cleanly
Import and export monday.com CSV for boards and items. Map columns, statuses, and dates so US, UK, AU, and EU teams avoid duplicate messes.
Read guidePipedrive CSV: Import Deals, People, and Organizations
Import and export Pipedrive CSV for deals, people, and organizations. Fix pipelines, stages, and Excel encoding for US, UK, AU, and EU sales teams.
Read guideMagento CSV Import/Export: Products, Customers, and Advanced Pricing
Use Magento CSV for product import/export, customers, and pricing. Fix SKUs, store views, and Excel encoding for US, UK, AU, and EU merchants.
Read guideZoho CRM CSV: Import Leads, Contacts, and Deals
Import and export Zoho CRM CSV for leads, contacts, accounts, and deals. Fix field mapping, UTF-8, and Excel ID issues for US, UK, AU, and EU sales teams.
Read guideAsana CSV: Import Tasks and Export Projects Cleanly
Import and export Asana CSV for projects and tasks. Map assignees, sections, and due dates for US, UK, AU, and EU product and ops teams.
Read guideTikTok Ads CSV: Reports, Bulk Edits, and Spreadsheet Uploads
Export TikTok Ads CSV reports and prep bulk spreadsheet uploads. Fix UTF-8, decimals, and ID issues for US, UK, AU, CA, and DE advertisers.
Read guidePrestaShop CSV Import: Products, Categories, and Combinations
Import PrestaShop CSV for products, categories, and combinations. Handle UTF-8, semicolons, and multi-language shops for FR/DE/EU and UK merchants.
Read guideClickUp CSV: Import Tasks and Export Lists Cleanly
Import and export ClickUp CSV for tasks and lists. Map statuses, assignees, and due dates for US, UK, AU, and EU product and ops teams.
Read guideLinkedIn Ads CSV: Campaign Reports and Bulk Spreadsheet Edits
Export LinkedIn Campaign Manager CSV reports and prep bulk sheets. Fix UTF-8, decimals, and ID issues for US, UK, AU, CA, and EU B2B advertisers.
Read guideMicrosoft Ads CSV: Editor Exports, Reports, and Bulk Uploads
Work with Microsoft Advertising (Bing Ads) CSV and Editor files. Fix UTF-8, decimals, and locale issues for US, UK, AU, CA, and DE search campaigns.
Read guideIntercom CSV: Export Contacts and Import User Lists
Export and import Intercom CSV for contacts and companies. Fix consent fields, emails, and Excel encoding for US, UK, AU, and EU support and growth teams.
Read guideTrello CSV: Export Boards and Import Cards from Spreadsheets
Export Trello boards to CSV and import cards from spreadsheets. Map lists, labels, and due dates for US, UK, AU, and EU teams.
Read guideTypeform CSV Export: Responses, Hidden Fields, and Clean Analysis
Export Typeform responses to CSV for Excel and BI. Fix multi-select columns, hidden fields, and locales for US, UK, AU, and EU research teams.
Read guideLinear CSV: Export Issues and Import Backlogs Cleanly
Export Linear issues to CSV and prep backlog imports. Map teams, statuses, and labels for US, UK, AU, and EU product engineering orgs.
Read guideSmartsheet CSV: Import Sheets and Export Rows Without Breaking Columns
Import and export Smartsheet CSV for project sheets. Map columns, dates, and attachments metadata for US, UK, AU, and EU ops teams.
Read guideDynamics 365 CSV: Import Entities and Export Clean CRM Extracts
Import and export Dynamics 365 CSV for accounts, contacts, and leads. Map fields, option sets, and locales for US, UK, AU, and EU CRM teams.
Read guideWix CSV: Products, Contacts, and Store Imports That Actually Work
Import and export Wix CSV for products and contacts. Fix SKUs, images URLs, and locales for US, UK, AU, and EU Wix stores.
Read guideGoogle Analytics CSV (GA4): Export Reports Without Breaking Metrics
Export GA4 reports to CSV for Excel and BI. Fix sampling, date formats, and joins for US, UK, AU, and EU marketing analytics teams.
Read guideSquarespace CSV: Products, Orders, and Mailing List Imports
Import and export Squarespace CSV for products and contacts. Fix SKUs, variants, and consent fields for US, UK, AU, and EU Squarespace stores.
Read guideFreshdesk CSV: Import Tickets and Contacts Without Duplicate Chaos
Import and export Freshdesk CSV for tickets and contacts. Map agents, statuses, and custom fields for US, UK, AU, and EU support teams.
Read guideGoogle Forms CSV: Download Responses and Clean Them for Sheets/Excel
Export Google Forms responses to CSV for Excel and BI. Fix multi-choice columns, timestamps, and locales for US, UK, AU, and EU teams.
Read guideCategory
Troubleshooting & Best Practices
28 guides
How to Fix CSV Encoding Errors (UTF-8 and Special Characters)
Fix mojibake, broken accents, and currency symbols in CSV files. Learn UTF-8 vs legacy encodings and how to re-export clean, portable CSV.
Read guideCSV Delimiters Explained: Comma, Semicolon, Tab, and Pipe
Learn how CSV delimiters work, why Excel locales change commas to semicolons, and how to detect and fix delimiter problems before import.
Read guideHow to Merge Multiple CSV Files Into One
Combine CSV files safely. Align headers, avoid duplicate rows, and produce one clean table for Excel, databases, or uploads.
Read guideHow to Split a Large CSV File Into Smaller Files
Split oversized CSV files by row count or logical groups. Keep headers on every part and prepare chunks for uploads, email limits, or browser tools.
Read guideCSV Validator Guide: How to Check CSV Files Before Import
Validate CSV structure before uploads fail. Catch missing headers, jagged rows, bad quotes, encoding issues, and type problems early.
Read guideCSV Formatter Guide: Clean and Standardize CSV Files
Format messy CSV data for reliable imports. Standardize headers, quoting, whitespace, and encoding before Excel, JSON, or database loads.
Read guideCSV Viewer Guide: Preview CSV Files in Your Browser
Use an online CSV viewer to inspect columns, catch delimiter issues, and verify data before editing, converting, or importing.
Read guideBest Free CSV Tools in 2026 (Editor, Viewer, Converter)
A practical guide to free CSV tools for viewing, editing, validating, and converting files—plus when to use Convert CSV Online for browser workflows.
Read guideHow to Remove Duplicate Rows in a CSV File
Remove duplicate rows in CSV files safely. Compare full rows or specific keys, verify counts, and export a clean CSV for uploads and analysis.
Read guideHow to Sort CSV Files by Column (Online or with Code)
Sort CSV files by one or more columns. Handle numbers, dates, and text correctly, then export a clean, stable, sortable file.
Read guideHow to Filter CSV Data (Rows and Columns)
Filter CSV data by column values, ranges, and patterns. Reduce rows before Excel, JSON, or database imports for cleaner results.
Read guideHow to Clean CSV Data Before Import or Analysis
Clean messy CSV data step-by-step. Trim whitespace, normalize case, fix nulls, and prepare a reliable file for Excel, databases, or AI.
Read guideHow to Convert CSV Without Data Loss
Convert CSV to Excel, JSON, or SQL without losing data. Protect leading zeros, encodings, dates, and special characters with a reliable checklist.
Read guideFile Encoding Explained: UTF-8, ANSI, and BOM for CSV
File encoding explained for CSV and data files. Learn UTF-8 vs ANSI/Windows-1252, what a BOM does, and how to fix mojibake before you convert.
Read guideCSV MIME Type Explained (text/csv) for Downloads and APIs
Learn the CSV MIME type (text/csv), when to use charset=utf-8, Content-Disposition for downloads, and common mistakes in APIs and browsers.
Read guideCSV File Size Limits: Excel, Browsers, and Practical Workarounds
Understand CSV file size limits in Excel, Google Sheets, browsers, and databases. Learn when to split files, stream, or switch formats.
Read guideTroubleshoot CSV Conversion Errors: A Practical Playbook
Troubleshoot CSV conversion errors step by step. Fix delimiter, encoding, header, Excel, JSON, and database load failures with a clear diagnostic checklist.
Read guideSeparator vs Delimiter in CSV: What’s the Difference?
Separator vs delimiter explained for CSV files. Learn how commas, semicolons, tabs, and pipes work—and how to pick the right one for Excel and imports.
Read guideCSV Export Best Practices for Apps, Reports, and APIs
CSV export best practices for developers and analysts. Cover encoding, headers, delimiters, quoting, nulls, and Excel-friendly downloads that do not corrupt data.
Read guideCSV Date Formats: US vs UK, Australia, Canada, and Germany
Stop CSV date swaps between MM/DD/YYYY and DD/MM/YYYY. Learn safe ISO dates, Excel pitfalls, and how US, UK, Australian, Canadian, and German files differ.
Read guideCSV Headers Best Practices: Naming, Order, and Stability
CSV header best practices for imports and APIs. Name columns clearly, keep order stable, avoid duplicates, and version breaking changes.
Read guideHow to Remove Blank Rows from a CSV File
Remove blank rows from CSV files before import. Clean empty lines from Excel exports using online tools, spreadsheets, or a few lines of code.
Read guideCSV UTF-8 BOM: When Excel Needs It (and When It Breaks Imports)
Understand the UTF-8 BOM in CSV files. Fix Excel mojibake for £/ü/é and avoid BOM-related import failures in US, UK, AU, CA, and EU systems.
Read guideConvert Tab-Delimited TXT/TSV to CSV Correctly
Convert tab-delimited TSV/TXT exports to CSV without breaking quoted fields. Common for US banks, UK portals, and legacy ERPs.
Read guidePhone Numbers in CSV: International Formats & Excel Damage
Store US, UK, Canadian, and German phone numbers in CSV without Excel dropping leading zeros or plus signs. E.164 guidance for CRM imports.
Read guideCSV Date-Time & Timezone Normalization Across Markets
Normalize CSV date-time fields across US, UK, Canada, and Germany. Fix timezone offsets, midnight boundary bugs, and ambiguous DD/MM vs MM/DD stamps.
Read guideFix Mojibake in CSV: UTF-8, Latin-1 & Windows-1252
Diagnose and fix CSV mojibake (ü, ’, £). Recover Umlaute, accents, and pound/euro symbols for US, UK, Canadian, and German files.
Read guideSpreadsheet Data Best Practices for Clean Imports and Exports
Practical tips for preparing clean spreadsheet data before conversion, import, or sharing. Avoid common data quality issues that cause import failures.
Read guideConvert next
Ready to convert a file?
Use Convert CSV Online tools in your browser—no account required for everyday conversions.