Convert data from .csv email attachment to a new line in a google sheet
$250-500 AUD
ชำระเงินเมื่อจัดส่ง
We have several stores that all use the same Point of Sale software (Junction 6). This software has been configured to generate and email a daily sales report once every 24 hours that attaches as a .csv breakdown of sales every day. We would like this dropped into a Google Sheet so that we can have an Automatic Daily updated report (dashboards are linked to this Google Sheet).
The output required is:
Column A: Date
Column B to F: Product Sales
Then each day, a new line gets added to the bottom of the Google Sheet when the email comes through
There are only 18 different products and this will not change
I only need the Data in Column B and Column E of this spreadsheet.
หมายเลขโปรเจค: #17816585
เกี่ยวกับโปรเจกต์
freelancer 46 คน กำลังเสนอราคาในงานนี้ โดยมีราคาเฉลี่ยอยู่ที่ $348
I can update Google sheet daily from taking 2 columns as required from csv. How many emails containing csv file each day we received.
I read and understood your requirements and would like to discuss more about the project. So i hope you would open a PM to discuss about the work . Regards, Ponsi
Hello, i have read your project details and i can help you with 100% quality and your satisfaction. I have delivered more than 400 project with client satisfaction. Please see my profile . I have more than 5 years o เพิ่มเติม
Hi there, I can convert data from .csv email attachment to a new line in a google sheet. If you have questions or doubts about anything, please feel free to ask me. Sincerely, Mir
Dear Buyer, Do you want the CSV product file to be designed in Google sheet in such a way that the Google sheet gets linked to the CSV so that you can get updated based the information. Please let me know if I am not เพิ่มเติม
Understood, Need to grab details of the products from the CSV file and save them into the Spreadsheet. Will get this done with complete attention to details..
Hi, I am Anna with more than 6 years experience in web and cross-platform app development including Hybrid, PHP, Laravel framework, Slim, CodeIgniter, MySQL, PostgreSQL, HTML, CSS, Javascript, jQuery, Vuejs, Ajax, เพิ่มเติม
Sir, I am well versed in these kind of jobs and can do your project as per your requirement. I am very much able to work on this. ***I am ready to start Message me for further discussion. Waiting to hear from เพิ่มเติม
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews, they speak for themselves. Best rega เพิ่มเติม
Dear Hiring Manager, I have read your job description carefully and I’m very considering your job such as these capabilities. I have fantastic experience in this fields such as Data Entry, Admin Task, Website Task, Co เพิ่มเติม
Hi, we already have done projects likes this one. What we offer is a Windows App where you select the .csv files, and then with 1 click, the information will be uploaded to the Google Sheet. Seting up the Google เพิ่มเติม
Hi, Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I can create google sheet from excel csv file through vba (macro). I have excellent knowledge and experience of Ma เพิ่มเติม
Hi, I can help setup the system so that your Junction 6 POS files can be dropped in as google spreadsheets and as a new line everyday. When do you need this done ? I'm among the top 2% freelancers here so you can e เพิ่มเติม