Split a QuickBooks Online products CSV into 1,000-row batches

Count data rows, not the header, in each batch

A products CSV that is larger than the documented import size is easier to recover when each file contains at most 1,000 data rows. Keep the original order and the same header in every file.

• QuickBooks accepts the first file but fails partway through a large upload
• A later file has no header or a different column order
• The number of products created does not match the source export

• Split a large CSV into traceable batches →Keep the header and reconcile every output row.
• Diagnose CSV column counts and quoted fields →Review structural findings before changing a value or header.

Plan for retries and existing products

The row limit is an import workflow constraint, not a license to duplicate products. Decide whether the import updates existing SKUs or creates new items before retrying a failed batch.

• Exclude the header from the 1,000-row count
• Name files with a stable sequence such as 001, 002, and 003
• Do not resend an accepted batch without checking SKU matching

• Remove duplicate CSV records by a selected key →Define the business key before removing a duplicate.
• Select the columns required by the template →Remove export-only fields while keeping all data rows.

Build the batches with LocaCSV

LocaCSV preserves product values and row order. QuickBooks remains responsible for SKU, price, inventory, and account validation.

1. 1Open a copy of the QuickBooks products export and diagnose its columns
2. 2Choose row splitting and set the batch size to 1,000 data rows
3. 3Download the numbered files and inspect their headers and counts
4. 4Upload one test batch, then continue in sequence while saving results

Reconcile every QuickBooks batch

• Every output repeats the exact header row
• No output contains more than 1,000 data rows
• The sum of batch rows equals the source rows
• Accepted batches are marked so they are not uploaded twice

• Split a large CSV into traceable batches →Keep the header and reconcile every output row.
• Diagnose CSV column counts and quoted fields →Review structural findings before changing a value or header.
• Remove duplicate CSV records by a selected key →Define the business key before removing a duplicate.

If QuickBooks rejects a batch

Use the returned error row to distinguish a column or encoding problem from an invalid SKU, price, or account value. Correct only the rejected batch when possible.

• Diagnose CSV column counts and quoted fields →Review structural findings before changing a value or header.
• Select the columns required by the template →Remove export-only fields while keeping all data rows.
• Check the CSV character encoding →Choose the source encoding from the preview instead of guessing from the country.

Create QuickBooks import batches