Find Jobs
Hire Freelancers

Script or converter to rearange and strip some columns from excel file and convert to csv txt

$30-250 USD

Completed
Posted about 6 years ago

$30-250 USD

Paid on delivery
We have an excel document that we use to keep track of ongoing orders. Our customer requires that we send a comma separated text file over to them on a daily basis so they can keep up to date on the status of the orders as well. There are some columns in the excel file that we maintain that we would not want our customer to see. For a time we were maintaining two separate excel documents but that resulted in doubling the amount of work that we do. We would like to take our existing excel file and be able to “convert it” to the format the customer needs, rearranging and stripping some columns. When it is “converted” some of the columns will need to be moved around and reformatted. The date needs to be switched from mm/dd/yyyy to yyymmdd for example. We want to keep the existing excel file intact but then create a new file as a comma separated .txt file and have a name of pl<mmmddyyy>.txt. Refer to fig1 for a sample of what our excel file looks like that we maintain. Refer to fig2 for the requirements for the output.
Project ID: 16613288

About the project

13 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hello from across the pond! I can create a VBA macro which will move the data, delete columns, manipulate the dates from a date format into the required YYYMMDD format and then export as a .txt (comma delimited) with pl<mmmddyy>.txt as the file name. I work full time as a Data Analyst and I use VBA every day for similar tasks, so i'm very accustomed to this kind of work. Please let me know if you have any questions. Thanks, Arran
$60 USD in 1 day
5.0 (13 reviews)
4.1
4.1
13 freelancers are bidding on average $69 USD for this job
User Avatar
Hi there, I do not see columns from the output in the input file, eg: Factory Order Number, Dealer Number. What are the field mappings (input => Output) ? I have a 99% project completion rate and a 4.99 reputation (out of max 5.0 from more than 1100 projects over 11 years. Thanks. I look forward to hearing from you Regards, Rajesh Soni.
$94 USD in 1 day
5.0 (984 reviews)
8.7
8.7
User Avatar
Hello, I can create php script to convert excel to csv based on screenshots you provided. I can deliver you script in 24 hours. If you don't have hosting, you can use my hosting no problem. You will upload .xls file and download .csv file online.
$80 USD in 1 day
5.0 (898 reviews)
8.3
8.3
User Avatar
Hello, I am excel expert, it should be easy for me, but can you explain a bit about the start point and length. Regards, Santos
$30 USD in 1 day
5.0 (189 reviews)
6.4
6.4
User Avatar
Hello, Can you please send me example files (I need to see exact format) and I will get you back demo script in Python. If it works as it should, you can award me for the project. Feel free to check my profile. Thanks, Stevan
$110 USD in 1 day
5.0 (12 reviews)
5.8
5.8
User 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
$35 USD in 1 day
4.7 (31 reviews)
4.5
4.5
User Avatar
Good morning/ afternoon. I am Excel expert. I have read through your proposal and checked the images you sent along. I am sure and confident I can format the data as per your requirement. Feel free to reach me via chat.
$55 USD in 1 day
4.7 (11 reviews)
3.4
3.4
User Avatar
Hey, my name is Philipp and I am a statistical programmer and data scientist. My roots are in quantitative finance, but ever since I became a freelancer I work on all kinds of data related jobs such as yours advertised. I am very experienced in Excel and VBA and will be able to help you creating the new txt files for your customer. Given the pictures, I have a rough understanding of what needs to be done, but I would prefer to take a look at the real files in order to see how the data relates. Anyways, I would suggest a VBA solution, which will run automatically after a button is clicked. Then the files are automatically created and saved in a specific directory or could also be sent out automatically - just as you desire. I am open to what ever you require for this job. Please contact me to discuss the details of this jobs, such as deadlines etc. Thanks. Philipp
$100 USD in 1 day
5.0 (2 reviews)
3.3
3.3
User Avatar
Available Immediately | MS Excel Expert | MBA | Assured accuracy and minimum turnaround time | Have done the transformation job successfully. please see my jobs history
$88 USD in 3 days
5.0 (8 reviews)
3.4
3.4
User Avatar
We write and design with our heart, and edit without it. The content and Design plays a very important role in deciding, whether a visitor, will bounce off, or return as a customer. Each word that we putin text is especially curated, keeping in mind the brand identity, and the aura of the product,which makes it attractive and difficult to forget.
$30 USD in 2 days
5.0 (4 reviews)
1.5
1.5
User Avatar
I have extensive knowledge and experience in data management and automation. I can also take care of performing a QA protocol that will ensure the data is consistent in format and category.
$111 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have very good experience in converting Excel file. I can provide you a command line tool. it takes the desire excel input file and convert it into expected out file. The conversion will be implemented in Java.
$45 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I do have a expertise in excel data mining with Excel VBA/Macro and Vbscript. Can provide you Vbscript + html offline page for this project. It will be simple and easy to use. Can show you the demo work which i done in past for my clients.
$55 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Council Bluffs, United States
5.0
10
Payment method verified
Member since Jul 11, 2014

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.