Find Jobs
Hire Freelancers

Convert Excel File Into Concatenated Text File with Headers and Data Lines and Embedded Style Tags for Indesign Import

$30-250 USD

Closed
Posted over 5 years ago

$30-250 USD

Paid on delivery
We need to convert two excel files which contains merge fields into two different text files that we can then import to Indesign using style tags. The Excel file is properly formatted. It needs to be merged into something like the following, where the Firm Name is displayed, followed by each person's name in the excel file associated with that firm name (break header). The resulting text file cannot have empty address lines <FirmListing>Sample Firm Name[tab](704) 234-5678 <FirmListingAddress>2222 Law Firm Address[tab]Fax: (704) 222-2222 <FirmListingAddress>More Law Firm Address[tab][login to view URL] <FirmListingAddress>City, State Zip <FirmMemberList3Column>Lastname, Firstname Middle <FirmMemberList3Column>Lastname, Firstname Middle
Project ID: 17637090

About the project

43 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
43 freelancers are bidding on average $103 USD for this job
User Avatar
Hi, I am interested in your project and I would like to know more details. Kindly drop a message so we can discuss. Thanks.
$30 USD in 1 day
5.0 (440 reviews)
7.8
7.8
User Avatar
Hi, I am an Excel automation expert and have been in this field for more than 10 years. Kindly share sample Excel file with data. Regards, Arul
$100 USD in 2 days
5.0 (180 reviews)
7.4
7.4
User Avatar
Hello sir/madam I am ready to do your job either by formulas or by Excel macros. I have over 10 years of experience in Excel. Please contact me if interested. Best regards, Tolib
$100 USD in 1 day
5.0 (91 reviews)
7.0
7.0
User Avatar
Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered twenty four excel vba projects in the past one twenty days. let me do. Willing to take up your project. Thank you, Regards.
$75 USD in 2 days
5.0 (185 reviews)
7.0
7.0
User Avatar
I have expertise in excel VBA. Client's satisfaction is my first priority and believe in long-term relationship with clients. Please communicate to discuss in details. Thank you..
$50 USD in 2 days
5.0 (46 reviews)
6.7
6.7
User Avatar
Hello there, This looks feasible and I can do this quickly. I have developed more than 500 VBA macros for Windows/MAC I am an expert in Excel/Word/PowerPoint/Outlook VBA/Python with over 5+ years of experience. Ping me to discuss project , timeline and budget. Thanks A
$100 USD in 3 days
4.9 (168 reviews)
6.5
6.5
User Avatar
Hello. I can do your project in less than 3 days according to your description with full delivery and without error. I would also complete your project with the highest precision and quality. I have extensive experience in Excel, Data processing and Data mining.
$300 USD in 3 days
4.9 (194 reviews)
6.6
6.6
User Avatar
Hello As a professional graphic designer with experience of seven years. I can do your task by Adobe indesign, if you want i can send you exemple of my works, but i prefer that we discuss about the project before Waiting for your response Salem
$155 USD in 3 days
4.8 (10 reviews)
6.1
6.1
User Avatar
I am expert in : POWERPOINT / PREZI, LOGO, VECTOR, PDF / EBOOKS, FULL CORPORATE IDENTITY, BROCHURE, POSTER / FLYERS / BOOK COVERS, INFOGRAPHICS, BUSINESS CARD, BANNERS, T-SHIRTS, PACKAGING / LABELS DESIGN, Animation / Video Project Every Single thi**** TOP RATED PERSON. GIVE ME 1 CHANCE TO AMAZE YOU **** I am SANJAY to Turn your Dreams into Reality. I have a Good command on English which gives me better option to understand your work easily. POWERPOINT ng in terms of graphic designing can be handled by me Softwares I have Good Command on Illustrator, Indesign, Photoshop (Adobe software suite) Word, PDF, Powerpoint (Microsoft office) CorelDraw, 2d animation, Video Projectc Why To Select Us : 1. Unlimited Revisions till you are Happy 2. Multiple Options to choose from 3. Understand Project to ensure Best Output 4. Regular Updates 5. 24 x 7 Available
$30 USD in 0 day
4.9 (68 reviews)
5.8
5.8
User Avatar
Hi there, I am Mehrzad an I use C# language to take control of Excel files and write your text file
$40 USD in 1 day
5.0 (38 reviews)
5.6
5.6
User Avatar
- Can get the two Excel files merged with the FirmName Each PersonsName as in Excel per the foramt and tabing as specified. - Have done similar Mail merging / Merging of data in Both Excel and MS Access. - Recently completed Contracts merging, both in Excel and MS Access. My Skills: - Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Extensively the macros/VBA to automate: - Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells - Data camparision using formulas, lookups and bringing up summaries., - Mathematical functions, scientific calculations, index, array, formula arrays which are advanced concepts - Have used them. - With summary data plotting graphs, bringing pivot tables Sample HighComplex Projects using Macros: (via Freelancer) - Complex Data anlaysis and graphing - Using Surface, Scatter Dynamically setting axis values, legennd colors(Excel 2013 to Excel 2016) - Heating Wire Design, Canada, - Identify the wiremodel running through multiple iterations. - System log generation (users logged in time, duration, days) between time period based on the text log files. Generate report. - Employee Tax, Canada - Calculations per hours,wage,provincial deductions, Federal deductions per reference tables. - Stocks Portfolio - Showing client portfolio stocks with various indicators, Momentum indicators based on portfolio. - University, US - Scoring the answer sheets ba
$80 USD in 3 days
4.7 (51 reviews)
6.1
6.1
User Avatar
Hi, Good Day! I can help you to complete this project. Feel free to message me anytime to discuss your full requirements. I am a VBA Macro developer and has strong knowledge in MS Excel formulas and functionality. I am also a PMO Analyst and my primary task is to generate and analyze a Financial Reports. You can check my reviews to help you decide. Thank you
$50 USD in 1 day
4.7 (78 reviews)
5.4
5.4
User Avatar
Hello, I can develop a program to convert the excel file to expected formatted text files. Let's discuss more. Thanks
$66 USD in 1 day
5.0 (42 reviews)
5.4
5.4
User Avatar
Hi, i will be happy to help you in this project, please send me a message to discuss more about it, i have a good experience with VBA macros that i am sure it will help here. regards.
$100 USD in 1 day
5.0 (26 reviews)
5.3
5.3
User Avatar
Hi I can provide you a quick turnaround. Do you have a sample file thus I can grasp how many hours it would take? Reggie
$30 USD in 3 days
5.0 (47 reviews)
5.5
5.5
User Avatar
Hello, Hope you are doing well. I can help with you in your project Convert Excel File Into Concatenated Text File with Headers and Data Lines and Embedded Style Tags for Indesign Import. I can assure you the quality job. I have good experience in Adobe InDesign, Data Entry, Data Processing, Excel, PDF. We have worked on several similar projects before! We have worked on 30+ Projects. Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion. I can assure the 100% job satisfaction. Thanks,
$200 USD in 3 days
4.8 (17 reviews)
5.4
5.4
User Avatar
Hello I am a highly skilled java developer i suggest to implement a simple GUI program to automate the process of converting the excel files to formatted text files could you please share a sample of the sheets you have Best Regards
$100 USD in 3 days
4.7 (27 reviews)
5.0
5.0
User Avatar
Welcome to SaatJo. 10 years experience in Graphic Design field. I am looking for some freelance jobs. Nature of my works: 1. Ability to work independently/collaborate with others. 2. Advanced print management, preflight, color profiling, press checks, ICC profiling, monitor calibration. 3. Advanced image manipulation, masking, color correction and restoration. 4. Website Management (Build a website and web designing). 5. Effective in meeting deadlines/budgets while remaining flexible with changing needs/demands. 6. Managing/developing projects from consumption to completion. 7. Marketing campaign/management; Print, Social and Digital 8. Proficient in using Adobe InDesign, Photoshop, Illustrator, Powerpoint and Instant Magazine 9. Project Management of small to large conceptual creative skills, vendor/client relations, business sense. 10. Specialist in designing interactive forms and PDFs. 11. Windows, MAC, Chrome platforms. 12. Typewriting Speed 70wpm. 13. IELTS 5 Band.
$155 USD in 3 days
4.8 (26 reviews)
4.9
4.9
User Avatar
Hello, Please send the data file, I will then write a macro to do what you want. I will also share with you the macro file, so that you will do it in the future yourself. Best regards, Serdar Yalcin
$60 USD in 3 days
5.0 (25 reviews)
4.7
4.7
User Avatar
Hi, I'm an Excel expert and a VBA programmer and I think I can help you on your project. I can make a VBA code that will help to clean the data and make the database as you wish. Feel free to contact me to discuss any further details on your project, then we can discuss my bid and deadline. Best Regards!
$50 USD in 2 days
5.0 (14 reviews)
3.4
3.4

About the client

Flag of UNITED STATES
Austin, United States
5.0
2
Payment method verified
Member since Aug 24, 2018

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.