Nablyx
Guides
Practical, tested guides connected to the Nablyx CSV & Data tools.
2026-09-29
Prepare a Product CSV for Shopify Import
Prepare product columns for Shopify import when your source file comes from WooCommerce or another storefront.
2026-09-29
Import Shopify Products from CSV After Field Mapping
Use a mapped WooCommerce product CSV as a reviewed starting point for Shopify product import.
2026-09-29
How to Map a WooCommerce CSV to Shopify
Map WooCommerce product-export columns to Shopify product CSV fields without rebuilding the file by hand.
2026-09-28
Upload Invoices to QuickBooks Online from CSV
Prepare, map, review, and upload invoice rows with QuickBooks Online’s native CSV import workflow.
2026-09-28
Prepare a QuickBooks Invoice Import CSV Field by Field
Understand the QuickBooks Online invoice CSV fields, Product/Service hierarchy, and batch limits before import.
2026-09-28
Prepare a Product CSV for WooCommerce Import Field by Field
Review the product, price, stock, category, parent, and attribute columns that matter before a WooCommerce CSV import.
2026-09-28
Prepare a Bank Statement CSV for Reconciliation
Build a repeatable pre-reconciliation CSV workflow that keeps bank-specific headers out of downstream matching logic.
2026-09-28
Import WooCommerce Products from CSV After Column Mapping
Prepare a WooCommerce-ready CSV, review variation-sensitive columns, and then hand the mapped file to the native importer.
2026-09-28
How to Normalize Bank Statement CSV Files
Normalize changing bank-export headers into one stable transaction schema before reconciliation or accounting import.
2026-09-28
How to Map a WooCommerce Product CSV to Native Import Format
Map supplier or legacy product headers to WooCommerce native product fields before using the built-in importer.
2026-09-28
How to Map an Invoice CSV to QuickBooks Online Format
Map invoice-export headers to QuickBooks Online invoice fields before using the native CSV importer.
2026-09-28
Bank CSV Field Mapping: Dates, Debit, Credit, and Narration
A practical field-mapping reference for turning heterogeneous bank CSV headers into a stable transaction layout.
2026-09-27
How to Record Payment Processor Payouts in QuickBooks
Turn a processor settlement into a balanced QuickBooks journal entry for the net deposit, processing fee, and gross amount.
2026-09-27
How to Reconcile Gross Sales, Processor Fees, and Net Payouts in QuickBooks
Understand the gross-minus-fee-equals-net check behind payment processor settlements and turn it into a balanced QuickBooks entry.
2026-09-27
QuickBooks Journal Entry CSV Import for Payment Processor Payouts
Prepare processor payout data for QuickBooks Online’s six-column journal-entry CSV format and avoid trying to encode splits in a bank CSV.
2026-09-27
How to Normalize Multi-Supplier CSV Feeds
Standardize SKU casing, map different column names, and merge supplier feeds without losing provenance. Normalize before you consolidate.
2026-09-27
How to Merge Multi-Supplier Stock Feeds by SKU
Combine inventory CSV feeds from multiple suppliers into a single SKU-level view. Resolve price and stock conflicts with explicit rules before importing into your store or ERP.
2026-09-27
How to Choose Supplier Price and Stock Priority
Set clear rules for which supplier wins when multiple feeds list the same SKU. Learn the tradeoffs between lowest price, highest stock, and explicit priority ordering.
2026-09-24
Shopify Inventory CSV Fields: Handle, Location, Bin Name, and On Hand
Learn what the key Shopify inventory CSV fields mean when reviewing stock beside a product export for store migration.
2026-09-24
Why Shopify Product Exports and Inventory Exports Are Separate
Understand why Shopify store transfers usually need both product and inventory CSV exports, and how to reconcile them before importing into a destination store.
2026-09-24
How to Match Shopify Product and Inventory CSV Rows by SKU
Use variant SKU as a stable key, preserve multiple locations, and find product-only or inventory-only rows before a Shopify migration.
2026-09-24
How to Set a Primary Company in HubSpot with a CSV Import
Build a HubSpot contact-to-company association CSV, mark the relationship Primary, and keep unmatched or ambiguous rows out of the import.
2026-09-24
HubSpot Contact–Company Association Import Errors and Fixes
Diagnose HubSpot CSV association problems such as the wrong object pair, missing identifiers, duplicate company keys, and Primary label mapping.
2026-09-24
HubSpot Company Matching: Domain vs Name vs Record ID
Choose a reliable key for matching HubSpot Contacts to Companies before a Primary Company association import.
2026-09-24
Common Google Ads Offline Conversion Import Errors
Fix mismatched conversion names, missing match identifiers, bad timestamps, duplicate events, currency problems, and legacy workflow confusion before import.
2026-09-24
Google Ads Offline Conversion CSV Format in 2026
Understand the Google Ads offline conversion fields for enhanced leads and legacy GCLID imports, then map a CRM CSV safely before upload.
2026-09-24
How to Prepare a GCLID Offline Conversion Upload for Google Ads
Map GCLID, conversion name, time, value, currency, and order ID from a CRM export for an existing Google Ads offline conversion import.
2026-09-23
What Pattern-Based PDF Redaction Can Miss
Pattern-based PDF redaction finds text shaped like SSNs, emails, card numbers, and dates. Learn how it works and what it misses: scans, names, and context.
2026-09-23
Shopify URL Redirect Best Practices for SEO Migrations
Plan Shopify URL redirects for an SEO migration: point legacy URLs directly to relevant final pages, avoid chains and loops, and verify the redirect map before launch.
2026-09-23
Fix Shopify Product Metafield CSV Import Errors
Troubleshoot invalid metafield headers, mismatched value types, list limits, duplicate columns, and missing product identifiers before import.
2026-09-23
Shopify Metafield CSV Format: Namespace, Key, and Types
Understand Shopify product metafield CSV headers, namespace/key rules, supported CSV types, lists, and value limits.
2026-09-23
Salesforce Lead Import Best Practices Before You Upload a CSV
Use a practical checklist for Lead imports: clean the CSV, choose stable matching keys, check existing Contacts, review collisions, and test the import safely.
2026-09-23
How to Handle Duplicate Salesforce Account Names Before Contact Import
Find ambiguous Contact-to-Account matches caused by duplicate Account names and switch to a safer key before importing Contacts into Salesforce.
2026-09-23
How to Match Salesforce Contacts to Accounts Before Import
Join Salesforce Contacts and Accounts CSV exports, append AccountId only for unique matches, and review missing or duplicate account matches before import.
2026-09-23
QuickBooks Account Naming Conventions for Journal Entry CSV Imports
Learn how to write parent accounts and subaccounts in QuickBooks journal-entry CSVs, including the Parent account: Sub Account format.
2026-09-23
Medical Document Redaction Best Practices
Best practices for reducing missed patient identifiers, avoiding reversible PDF overlays, checking hidden data, and verifying redacted medical documents before sharing.
2026-09-23
Legal Production PDF Redaction Checklist Before Disclosure
A practical review sequence for finding sensitive identifiers, checking proposed redactions, removing hidden PDF data, and verifying the final production copy.
2026-09-23
How to Redact Patient Information from Medical PDFs
A practical workflow for finding patient names, patient IDs, and MRNs, reviewing every proposed region, and creating a permanent redacted PDF before disclosure.
2026-09-23
How to Prepare Shopify Bulk URL Redirects
Prepare old and new URL pairs for Shopify, normalize paths, validate redirect graphs, and export the exact Redirect from / Redirect to CSV format.
2026-09-23
How to Prepare QuickBooks Journal Entries from a CSV
Map POS, vendor, and accounting exports to QuickBooks Online journal-entry columns, check debit/credit balance, and prepare a clean import CSV.
2026-09-23
How to Match Salesforce Leads Against Existing Contacts
Compare a Salesforce Lead CSV with an existing Contact export by Email or another exact key, review collisions, and export only new Leads.
2026-09-23
How to Import Shopify Product Metafields with a CSV
Prepare product identifiers and metafield columns, validate values, and import product metafields into Shopify with a CSV.
2026-09-23
HIPAA PDF Disclosure Checklist for Patient Information
A pre-disclosure checklist for reviewing patient identifiers, hidden PDF data, redaction quality, and the final disclosure copy in HIPAA-regulated workflows.
2026-09-23
Reviewing Court Privacy Fields Before Filing or Production
Use court privacy-field examples as a structured PDF review checklist, while checking the rule that actually applies to your court, case, filing, or production.
2026-09-23
Common Shopify Redirect Import Errors and How to Fix Them
Fix Shopify URL redirect CSV problems such as reserved paths, duplicate sources, conflicting destinations, chains, loops, empty cells, and malformed URLs.
2026-09-23
Common Salesforce Lead Import Collisions with Existing Contacts
Understand why Salesforce Lead imports collide with existing Contacts and how an exact-key preflight helps you review those records before import.
2026-09-23
Common QuickBooks Journal Entry CSV Import Errors
QuickBooks CSV import error on a journal entry file? Fix unbalanced journals, invalid dates, account-name problems, and amount errors before you import.
2026-09-23
How to Add AccountId to a Salesforce Contacts CSV
Prepare a Salesforce Contacts CSV by looking up Account record IDs from an Accounts export, while keeping missing and duplicate matches visible.
2026-09-22
How to Prepare a CSV for QuickBooks Online Invoice Import
Map, validate, and prepare invoice CSV files for QuickBooks Online's native import format — verify invoice numbers, dates, amounts, and line items before uploading.
2026-09-22
Common QuickBooks Invoice CSV Import Errors and How to Fix Them
Troubleshoot QuickBooks Online invoice import errors — missing columns, invalid amounts, row limits, and duplicate invoices.
2026-08-31
How to Merge PDF Files Locally Without Uploading Them
Understand what browser-local PDF merging means for privacy, what stays on your device, and when local processing should change your choice of tool.
2026-08-31
How to Merge Large PDF Files Without Uploading
Understand the real limits of a large PDF merge: the tested 5 GiB cap, measured memory and local-storage behavior, and what a failed run means.
2026-08-28
Excel CSV Leading Zeros: Why They Disappear and How to Preserve Them
Excel can change leading-zero IDs, long numbers, date-like codes, and formula-looking text when it opens a CSV. Learn how to keep those values safe.
2026-08-28
Why Does My CSV Open in One Column?
A CSV usually opens in one column because the reader chose the wrong separator. Confirm the file's real delimiter, then fix the import or the file.
2026-08-28
CSV UTF-8 BOM for Excel: How to Keep Characters Readable
Use a UTF-8 BOM when Excel misreads an otherwise-correct UTF-8 CSV. Export an Excel-friendly CSV on your device, with a 300 MB CSV limit.
2026-08-28
Remove Duplicates and Keep the First or Last Occurrence: Which Should You Choose?
Should you keep the first or the last duplicate row? Learn what each option actually means, how file order decides the outcome, and how to verify the choice.
2026-08-28
How to Validate a CSV File and Fix Common Problems
Check a CSV for broken rows, headers, quotes, separators, encoding problems, and other issues before you import it. Your file stays on your device.
2026-08-28
How to Rename and Reorder CSV Columns Before an Import
Rename headers, reorder columns, and drop the ones you do not need before a CRM, ecommerce, or database import — without opening a spreadsheet.
2026-08-28
How to Remove Hidden Data from a PDF Before Sharing It
Clean hidden document details, attachments, comments, and form fields from a PDF before sharing it. The file stays on your device, with a 256 MB limit.
2026-08-28
How to Remove Duplicate Rows from a CSV File
How to find and remove duplicate rows in a CSV export correctly — choosing the right match columns and deciding which copy to keep.
2026-08-28
How to Redact a PDF Without Leaking Hidden Data
Remove sensitive content from a PDF before sharing it. Mark the areas to redact, clear hidden document data, and create the cleaned PDF on your device.
2026-08-28
How to Profile a CSV File Before You Import It
Check a CSV column by column for missing values, mixed data, useful ranges, and repeated values. Your file stays on your device.
2026-08-28
CSV File Too Large for Excel: What to Do
Excel cannot fit every row from a very large CSV. Learn the 1,048,576-row limit, how to protect the original file, and how to split the CSV into usable parts.
2026-08-28
How to Map CSV Columns Between Two Systems Before an Import
Match source CSV columns to the destination system's expected field names when moving data between CRMs, stores, accounting, and marketing tools — no code.
2026-08-28
How to Join Two CSV Files on a Shared Column
Combine two CSV files by matching a shared column such as customer ID, email, or SKU. Your files stay on your device.
2026-08-28
CSV Strange Characters: How to Fix Them
Why CSV text turns into mojibake, how to identify the likely source encoding, and when changing encoding will not repair a structurally broken CSV.
2026-08-28
How to Edit a CSV File Without Uploading It
Decide whether a browser-local CSV editor is the right way to keep a CSV on your device, and when another CSV workflow is a better fit.
2026-08-28
How to Convert Nested JSON to CSV Correctly
Convert nested JSON to a useful CSV without coding. See how nested details and lists affect the table, then choose the result that fits your work.
2026-08-28
How to Compare Two JSON Files (and Find What Really Changed)
Compare two JSON files and see added, removed, or changed values without treating spacing or object key order as changes. Files stay on your device.
2026-08-28
How to Check a CSV Before Importing It
Use a simple pre-import checklist for CSV structure, required columns, dates, numbers, and other values. Your file stays on your device. Limit: 200 MB.
2026-08-28
CSV Semicolon vs Comma: Which One Should You Use?
Learn why some CSV files use semicolons instead of commas, when each separator makes sense, and how to convert between them without changing your data.
2026-08-19
How to Fix a Broken or Malformed CSV File
How to diagnose malformed CSV structure: uneven rows, duplicate headers, stray whitespace or empty rows, BOM issues, delimiter mistakes, and damaged quoting.
2026-08-19
How to Compare Two CSV Files (Without Excel)
A practical guide to comparing two CSV exports by key column, spotting added, removed, and changed rows without spreadsheet gymnastics.