Completed

Macros needed to process csv files

This project was successfully completed by domenicoF79 for $30 USD in a day.

Get free quotes for a project like this
Employer working
Completed by:
Project Budget
$30-$250 USD
Completed In
1 day
Total Bids
12
Project Description

I need macro that would do the following:

1. Let me navigate to folder with data to import
2. Select files to import
* Files can be either *.csv or *.txt
* Files are either coma, space or tab delimited
3. Import selected files to one worksheet (either the one which is opened or a new one, doesn't matter). Import each file the following way:
* delimited data imported to two adjacent columns
* if original data is in unicode format, it should be imported as ASCII to avoid problems with Excel importing special characters and recognizing data as text instead of numbers
* add one row on the top of both columns
* put letter "Y" in the cell over the first column
* in the cell over the second column, of given imported file, put the name of the imported file (but without extension)
4. Generate automatically a combined graph for imported data in form of scatter plots with straight lines and without markers, where each "first" column is Y and corresponding second column is X

Some examples of csv files are attached.

Please let me know how fast you can do this job and what will it cost.

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