Automate raw .csv data to a table

I have an business renting homes on Airbnb and want a clean, easy to use table to view the revenues data in. When I download the csv from Airbnb I have these issues:

-the date format is unreadable and needs a manual fix each time

-i use the sum function and have to manually pick the rows for each listing

It shouldn't be too difficult to do on VBA, low budget

Compétences : Excel

en voir plus : python write to csv, import web data into google spreadsheet, python write csv example, csv to json python pandas, import api into google sheets, python csv, python read csv into list, csv reader, php create table csv data, script parse csv html table, import csv data sql server table, data table setup, parsing data table word document, retrieving data table display page php, data intepretation data analisis spss manual, csv data dating profiles, extract data table website, mysql read delimited csv data, website csv data feed reader, regular expression data table

Concernant l'employeur :
( 0 commentaires ) Montreal, Canada

Nº du projet : #17849857

Décerné à:


I am an Excel specialist with a lot of experience in creating complex formulas and macros. You may check some of my projects here: [login to view URL]

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% USD en 1 jour
(40 Commentaires)

2 freelance font une offre moyenne de $25 pour ce travail

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)