Đang Thực Hiện

Import to Excel from CSV

This project is for importing data info from simple CSV lines to excel.

Example of the data file is attached.

1. step

In the Example file are measurements made with human body analizator weight/FAT% scale.

This DATA should be imported into excel and sorted by the date of the measurement taken that is found in CSV file.

The importing process should be able to batch import all *.CSV files from one directory/folder (the program should ask which folder to choose for source) into appropriate excel files or sheets within the same excel file in one run.

Each CSV file will have in each line three values that will be always the same, and on the same place so the program/macro will automatically know where (which excel file/sheet) these data should go to.

When importing CSV file with new version of these three values found, the program will ask in which excel file should the data be imported. Then it will remember this for the next time and will do it automatically.


If the same data was already imported the line would not be imported, but it would be skipped.

After import, the excel files/sheets that got new data will be opened in excel.

In the excel file will also be present some extra columns, that I will be fillingwith data/adding manually. These to, will be used in graphical charts...

2. step

The data should then be represented graphically with nice charts.

And there should be an option to choose the range of data (from which date to which date) that should be represented in the charts.

And also an user friendly click-able option to show only the charts for specific measurements.

+In excel there should be an option of goal settings. Like manually entering data, that we are pursuing with this measurments. That could look just like one line on the top or on the bottom of imported lines. Then the charts could be represented with final goal in mind. Something like this maybe. [url removed, login to view]

So when I'll look on the chart I will know where I am. A relative Progress Towards concrete Goals.

I might get some other ideas later, but for now please bid for current described project and if we will add additional options not mentioned in the project description we will setup a new project or just negotiate the price for extra options...

PUT the word 'elephant' somewhere in the bid, so I will know that You are serious and that You read project description thoroughly.

Thank You.

Kĩ năng: Excel

Xem nhiều hơn: excel import csv, import csv measurement data excel, import csv excel, csv import excel, www excel, we excel, sheets add, scale price, mind body , human scale, excel macro to word, ask excel, new excel, word to excel, to excel, simple csv, price excel, measurement, macro excel, macro + excel, line sheet, import excel, import csv, human body, fat bottom

Về Bên Thuê:
( 1 Nhận xét ) none, Slovenia

ID dự án: #1015284

Được trao cho:


I have over 7 years experience developing custom VBA code for Microsoft Products including Access and Excel. I am available to work on this project immediately. Elephant

$60 USD trong 3 ngày
(1 Nhận xét)

6 freelancer đang chào giá trung bình $82 cho công việc này


Hello, experienced Macro developer. Please check Elephant PM.

$110 USD trong 5 ngày
(3 Nhận xét)

Please check PMB

$35 USD trong 1 ngày
(0 Nhận xét)

lets start work now.

$35 USD trong 1 ngày
(0 Nhận xét)

its not an elpahant size work can be done

$100 USD trong 3 ngày
(0 Nhận xét)

I see that in order to avoid all the problem. it would be good to have a program that would export all the information to excel. i am willing to get you the program to work to suite your needs

$150 USD trong 15 ngày
(0 Nhận xét)