CSV / Excel– category –

"I want to add stock quantities to a product list" or "Combine a price list with a product master." Use product codes shared by two files to join their data horizontally. Copying and pasting by row order can attach stock or prices to the...

Have you tried importing a CSV and received "The maximum number of records per import has been exceeded"? Growing product, customer, or sales CSVs may exceed an import system's limits. Splitting them into a specified number of records pe...

CSV merging helps combine a year's monthly sales, product lists from multiple stores, or exports from different systems into one file. Simply pasting files below one another can leave repeated headers inside the data or swap product-name...

Have you opened a CSV in Excel and seen a long reference number become "1.23457E+15", product code "1-2" turn into a date, or its final digits differ from the original? These changes occur when the application automatically interprets CS...

Need to correct a few product names in a CSV, remove unwanted rows or columns, or replace repeated words? A browser-based CSV editor can help. You can view and edit CSV data as a table even without Excel. An editor that treats values as ...

Have you opened a CSV in Excel and seen product code 00123 become 123, or postal and phone numbers lose their leading zeros? This happens when digit sequences are treated as numbers. For product and postal codes, leading zeros are import...

Japanese text remains unreadable after changing the CSV encoding. A repair tool cannot restore some characters. Saving again in Excel makes the display worse. Before repeating conversions, check the file's state. When garbled CSV text wi...

Have you opened a downloaded CSV in Excel only to find that Japanese text becomes unreadable? It may display correctly in another application but become garbled in Excel. A common cause of garbled CSV text is a mismatch between the encod...