Closed

Google Script Editor for CSV Management

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.

Taidot: Ohjelmointi

Näytä lisää: (google AND (spreadsheets OR (apps AND script) OR forms OR sheets OR docs)) OR (PHP AND (integrate OR integration OR CRM AND or , google script editor, php script create csv file google csv format, auto import csv to google sheets, google apps script, import csv to google spreadsheet script, automatically import csv into google sheets, google scripts csv, google sheets parse csv, google sheets import csv from drive, google sheets script import, javascript, google app engine, google web toolkit, googlescripts, google calendar upload csv script, php script convert csv tab delimited, mysql script editor, script import csv access, script import csv mysql

Tietoa työnantajasta:
( 0 arvostelua ) United States

Projektin tunnus: #16966861

12 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

ineedWorkJob

Greetings sir, how are you today sir? hope fine. Sir, I have read your project details and i will develop a script that will generate a large spreadsheet with csv file name and 5 column of data from each csv fil Lisää

$200 USD 3 päivässä
(2 arvostelua)
3.8
aanvikm

Hello Sir, I am an expert with Google scripts and I can help you here with this project. Thanks Aanvik

$222 USD 5 päivässä
(3 arvostelua)
4.0
huongth

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, fo Lisää

$155 USD 7 päivässä
(8 arvostelua)
3.2
kanwalrafique

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 thin Lisää

$90 USD 3 päivässä
(1 arvostelu)
1.7
redincorpindia

Dear client I saw your requirements regarding the Google script for csv file manipulation application development. I can develop this application within a day maximum based on your requirements. I developed many appl Lisää

$180 USD 1 päivässä
(1 arvostelu)
0.0
khantek

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 Lisää

$155 USD 3 päivässä
(0 arvostelua)
0.0
Manu2022

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 4 päivässä
(0 arvostelua)
0.0
DimuDesigns

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 si Lisää

$194 USD 7 päivässä
(0 arvostelua)
0.0
mohamedkaram93

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 ar Lisää

$100 USD 2 päivässä
(0 arvostelua)
0.0
abramjos

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 l Lisää

$200 USD 4 päivässä
(0 arvostelua)
0.0
murtaza896

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 Sadri Lisää

$133 USD 5 päivässä
(0 arvostelua)
0.0
makhil2009

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 w Lisää

$70 USD 2 päivässä
(0 arvostelua)
0.0