Enhanced CSV Merger Tool

Enhanced Features

  • Formatted KMS: Displays as xx,xxx or xxx,xxx format
  • Formatted Price: Displays as $xx,xxx or $xxx,xxx format
  • Combined Title: Combines "Title" and "Trim" columns
  • Year-Based Finance Terms: Automatically calculates interest rates and terms based on vehicle year
  • Auto Cost of Borrowing: Calculates weekly payment and disclaimer based on vehicle price and year
  • Finance Rate Schedule: 2012-2013 (9.99%, 48mo), 2014 (9.99%, 60mo), 2015 (9.99%, 72mo), 2016 (9.99%, 78mo), 2017 (8.99%, 78mo), 2018 (8.99%, 84mo), 2019-2021 (8.49%, 84mo), 2022-2024+ (7.99%, 96mo)
  • Image Processing: Downloads and converts images to JPG format
  • ZIP Export: Packages CSV and images together
  • JSON Column: Facebook Messenger JSON format with title, stock, and URL
  • Primary Text: Simple format with title, price, km's, and stock
  • Secondary Text: Detailed format with list price, discount, your price, payment info
  • Tertiary Text: Clean format with title, price, km's, payment /weekly, and stock

Instructions

  • Choose input method: upload Excel file or manually enter Stock Numbers.
  • Upload the Units Overlay CSV file (.csv) - data will be fetched based on Stock# from your chosen input.
  • The tool will automatically format KMS, Price, combine Title+Trim, and calculate Cost of Borrowing based on vehicle year.
  • Images will be downloaded and converted to JPG format (including WebP images).
  • New columns include JSON (Facebook Messenger format), Primary Text (simple format), Secondary Text (detailed marketing format), and Tertiary Text (clean payment format).
  • All output files will be packaged in a ZIP file for easy download.
Row number containing column headers
Row number where actual data begins
Enter your domain (we'll add https://www. if needed)