Excel Macro for comparing text files

This project received 24 bids from talented freelancers with an average bid price of $68 USD.

Get free quotes for a project like this
Project Budget
$30 - $250 USD
Total Bids
Project Description

I need .xlsm Excel file that can import and process one or more TSV files (TAB separated values) and compare the values with previously imported data and dump the results in CSV files.

All of these points must be met:

- There must be a "settings" sheet that will contain different variables.

- The files must be imported automatically, file names/paths will be listed in the Settings sheet

- The TSV can contain one or multiple columns

- The values need to be compared (exact match - although not Case Sensitive)

- The results will be exported into 2 text files: "Identical" and "Different" in a new folder (Folder name = Date Time - eg.: D:\[url removed, login to view] 1730)

- In the "[url removed, login to view]" file, I want to have the names of the files that were identical after comparison

- In the "[url removed, login to view]" file I want to have the following values: "filename,original_text,new_text"

Skills Required

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online