LOCACSV GUIDE
Start with what went wrong or what you need to finish. Each guide explains the check, the fix, and the relevant LocaCSV step without making you choose a tool first.
Fix garbled text, shifted columns, delimiter mismatches, and encoding problems between systems.
Updated:
Related tool: Repair CSV problems
Find shifted CSV columns, blank rows, inconsistent widths, and exact duplicate candidates before creating a separate corrected CSV.
Read the guideUpdated:
Related tool: Convert encoding & format
Fix strange characters in Excel and choose between UTF-8 with BOM, UTF-8 without BOM, and Windows-1252 for everyday CSV work.
Read the guideUpdated:
Related tool: Convert encoding & format
A practical global-office checklist for selecting, converting, and testing CSV encoding and delimiters.
Read the guideSplit by row count or target size, or create one file for each store, region, or other column value.
Updated:
Related tool: Split by rows or size
Choose a practical way to split a large CSV and avoid common row-count, delimiter, and encoding problems.
Read the guideUpdated:
Related tool: Split by value
Export from Tableau Prep, split by a sales-region column, and verify the ZIP before sharing files with regional teams.
Read the guideAppend files with identical columns, or add matching data from a second CSV by ID.
Updated:
Related tool: Merge vertically
Need to consolidate CSV files? Learn how to keep one header, preserve file order, and merge matching CSV files safely.
Read the guideUpdated:
Related tool: Join by key
Place the equipment register on the left, inspection results on the right, then choose whether to keep every asset or matched assets only.
Read the guideChoose the right workflow for duplicates, filters, column selection, and sorting.
Updated:
Related tool: Remove duplicates
Choose whole-row or key-column matching, keep the intended row, and verify every removed duplicate.
Read the guideUpdated:
Related tool: Filter rows
Combine text, numeric, and blank conditions with AND/OR, then confirm every input row is either kept or excluded.
Read the guideUpdated:
Related tool: Select columns
Remove unneeded fields and reorder the remaining CSV columns for a safe, predictable import.
Read the guideUpdated:
Related tool: Sort rows
Use up to three sort keys and configure text, numbers, direction, blanks, and letter case while keeping tied rows in their original order.
Read the guideGroup detail rows into totals, or convert between CSV and JSON data structures.
Updated:
Related tool: Group & summarize
Summarize detail rows with counts, sums, averages, minima, and maxima across up to three group keys.
Read the guideUpdated:
Related tool: Convert encoding & format
Convert between CSV and a list of JSON objects while preserving identifiers, values inside objects, and item counts.
Read the guidePLATFORM PLAYBOOKS
Start from the platform limit, choose the right CSV operation, and verify the file before you upload it.
SHOPIFY CSV IMPORT
A practical path from Shopify's 15 MB product CSV limit to verified upload files.
Read the guideSALESFORCE DATA IMPORT
Turn a large Salesforce export into 50,000-record import batches with count checks.
Read the guideGOOGLE CONTACTS IMPORT
Prepare Google Contacts batches of 3,000 or fewer without exposing contact data to a server.
Read the guideHUBSPOT CSV IMPORT
A 20 MB-aware HubSpot import workflow for contacts, companies, and deals.
Read the guideDYNAMICS 365 CSV IMPORT
Keep Dynamics 365 imports below 8 MB while protecting headers, delimiters, and required fields.
Read the guideMAILCHIMP CONTACT IMPORT
Prepare a Mailchimp contact CSV by removing repeated email records and checking the delimiter before import.
Read the guideJIRA CSV IMPORT
Find malformed quotes, line breaks, and header problems before a Jira CSV import.
Read the guideLOOKER STUDIO CSV UPLOAD
Check UTF-8, headers, separators, and row structure before a Looker Studio CSV upload.
Read the guideWOOCOMMERCE PRODUCT CSV
Convert and diagnose a WooCommerce product CSV before mapping fields and importing products.
Read the guideSERVICENOW IMPORT SET
Prepare a ServiceNow Import Set CSV by checking headers, charset, and row structure.
Read the guideTABLEAU PREP CSV
Set the Tableau Prep CSV encoding and delimiter before building a flow.
Read the guideBIGQUERY CSV LOAD
Align BigQuery CSV encoding and delimiters before a load job.
Read the guideSNOWFLAKE CSV LOAD
Align a Snowflake FILE FORMAT with the actual CSV bytes before loading.
Read the guideGOOGLE SHEETS CSV EXPORT
Turn a Google Sheets export into a destination-ready CSV without losing rows.
Read the guideSAP S/4HANA CSV
Check SAP CSV headers and encoding before handing data to an import job.
Read the guideORACLE CX SALES CSV
Align Oracle CX Sales headers and encoding before a data import.
Read the guidePOWER BI / TEXT CSV
Prepare a Power BI Text/CSV file with explicit encoding and delimiter settings.
Read the guideTABLEAU / TEXT FILE
Prepare a Tableau text file with a verified encoding, separator, and header row.
Read the guideQUICKBOOKS ONLINE / PRODUCTS
Split a QuickBooks Online products CSV into 1,000-row import batches.
Read the guideXERO / BANK STATEMENT
Split a Xero bank statement CSV into batches of up to 1,000 transactions.
Read the guideAIRTABLE / CSV IMPORT
Split an Airtable CSV into files below the documented 100 MB limit.
Read the guideNOTION / DATABASE IMPORT
Check headers, empty rows, and columns before a Notion CSV import.
Read the guideAMAZON SELLER CENTRAL / INVENTORY
Check Amazon Seller Central inventory template headers and rows before upload.
Read the guideSHOPIFY / ORDERS EXPORT
Understand Shopify order CSV line items and preserve quoted fields before processing.
Read the guideSALESFORCE / CONTACT IMPORT
Find and remove duplicate Salesforce contact records by email or external ID.
Read the guideASANA / PROJECT IMPORT
Select and order the columns required by an Asana project CSV import.
Read the guide