Find Jobs
Hire Freelancers

Google Script Editor for CSV Management

$30-250 USD

Avslutat
Publicerad nästan sex år sedan

$30-250 USD

Betalning vid leverans
I have a small project that I would like to get completed. I have hundreds of CSV files located in a specific Google Drive directory. These spreadsheets are formatted identically, however the data within them is unique. I am looking for a google script that can: 1. Take the CSV filename and append it to a column in the spreadsheet (otherwise I have no way of identifying the data, the filename is the only place where the name exists) 2. Remove multiple columns from the CSV (Currently there are 22 columns, of which I only require 5, I'd like to remove the unnecessary columns) and 3. Export to one large spreadsheet that combines all of the sheets from the directory.
Project ID: 16966861

Om projektet

11 anbud
Distansprojekt
Senaste aktivitet sex år sedan

Ute efter att tjäna lite pengar?

Fördelar med att lägga anbud hos Freelancer

Ange budget och tidsram
Få betalt för ditt arbete
Beskriv ditt förslag
Det är gratis att registrera sig och att lägga anbud på uppdrag
11 frilansar lägger i genomsnitt anbud på $147 USD för detta uppdrag
Använd avatar
Hello Sir, I am an expert with Google scripts and I can help you here with this project. Thanks Aanvik
$222 USD Om 5 dagar
4,9 (5 omdömen)
4,6
4,6
Använd avatar
Hi. I am an expert in VBA, VBScript, Visual Basic, C#, F#, C, C++, ASM, Delphi, Java, iMacros, Flash, ASP, ASP.NET, Access, MySQL, MSSQL, QuickBooks, Oracle. I can create auto scripts to scrape websites, auto click, format txt, csv, xls, xlsx, doc, docx, rtf, json, xml, database files as you request. I can start right now
$155 USD Om 7 dagar
5,0 (8 omdömen)
3,2
3,2
Använd avatar
Hello, I have experience in writing Google Apps Script for Google Sheets and other Google Apps. I can write an Apps Script for you that will allow you to combine all the CSV files into a single spreadsheet. Few things in your description are not very clear to me so I require some clarifications for those as well. Feel free to contact me if you'd like to discuss your project with me by sending me a message even while I'm offline. I get notified by Freelancer.com when someone sends me a message. I'll do my best to send you a reply as soon as I can. About Me ======== I'm a Software Developer having experience in Python, JavaScript and PHP. I also have experience in writing Google Apps Script for several Google Apps including Google Drive, GMail, and Google Sheets.
$90 USD Om 3 dagar
5,0 (1 omdöme)
1,7
1,7
Använd avatar
Hi Sir, I am very much interested to do the job. I am expert developer with more than 15 years of professional experience. I have gone through your job posting. I am quite sure that I can build the one huge CSV file from your other CSV files as per your requirements. I can do this with PHP. For that you'll need to send me all of your CSV files in zip file. I will run the script and generate the required CSV file and send you both CSV and PHP script. If you accept then please contact me so I get this done for you right away. Thanks, Hammad
$155 USD Om 3 dagar
0,0 (0 omdömen)
0,0
0,0
Använd avatar
I have worked with CSV files because of machine learning. I will do the job in python which is the best language for this needs. If you have any doubt just contact me.
$100 USD Om 4 dagar
0,0 (0 omdömen)
0,0
0,0
Använd avatar
Hello, Interested in the job. I am a Software Engineer specializing in end-to-end Web Development. I have extensive experience with Google's GSuite platform having created a number of scripts to automate tasks similar to what you've described in your job proposal. My only concern is the amount of data involved given that google sheets has a limit of 2 million cells per sheet. If your data can fit within that constraint then I can write a script to parse your CSVs and populate a sheet. However if your data exceeds those limits I can recommend alternative solutions. Thank you for taking the time to review my application and I look forward to discussing your project in greater detail. Regards, Damion Murray DimuDesigns
$194 USD Om 7 dagar
0,0 (0 omdömen)
0,0
0,0
Använd avatar
Hi there, I will be happy to help you with that. We can can create a Google Script that iterates over all csv files stored in the targeted Google Drive folder. For each file, it will read the required 5 columns you are looking for, then in the targeted spreadsheet where we will aggregate the data, it will add the corresponding csv file name in each row. The script will be designed to avoid any run time issues, it will be valid to read the data from thousands of csv files! I will be happy to address any of your questions! Sincerely, Mohamed
$100 USD Om 2 dagar
0,0 (0 omdömen)
0,0
0,0
Använd avatar
hey, my expertise in python and in pandas (data manipulation library) can help you with your project. Hopefully I can provide you a statistical analyze in the first CSV you mentioned which has name of every CSV file like the no of rows, etc.. I hope it will be of much help. regards, Abraham
$200 USD Om 4 dagar
0,0 (0 omdömen)
0,0
0,0
Använd avatar
Yours seems like a reasonable project, I have worked with many such GSuite management scripts and can visualise your need for the same. I will be more than happy to do this project for you. Regards Murtaza Sadriwala
$133 USD Om 5 dagar
0,0 (0 omdömen)
0,0
0,0
Använd avatar
I have quite a bit of experience in google script coding. Did many projects like 1) Project Management of a firm 2) Task Tracker for a organization 3) Automatic web scraper etc I believe I can do this project without any issues. Thanks
$70 USD Om 2 dagar
0,0 (0 omdömen)
0,0
0,0

Om kunden

Flagga för UNITED STATES
United States
0,0
0
Medlem sedan maj 14, 2018

Kundverifikation

Tack! Vi har skickat en länk för aktivering av gratis kredit.
Något gick fel med ditt e-postmeddelande. Vänligen försök igen.
Registrerade Användare Totalt antal jobb publicerade
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Laddar förhandsgranskning
Tillstånd beviljat för geolokalisering.
Din inloggningssession har löpt ut och du har blivit utloggad. Logga in igen.