Closed

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

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

Skills: Adobe InDesign, Data Entry, Data Processing, Excel, PDF

See more: indesign data merge export to pdf, indesign data merge not working, indesign data merge address labels, indesign data merge multiple records, mail merge illustrator, indesign data merge images, indesign data merge empty field names, indesign data merge catalog, vba html data convert excel, convert excel adobe bridge data, convert excel data md5 encryption form, stata data convert excel, quickbooks convert excel data, convert excel data stata, convert excel data stata data, convert standard oracle erp text reports excel format, visual basic data convert excel, convert number format string text format excel macro, simply accounting data file convert excel, convert excel data small program

About the Employer:
( 0 reviews ) United States

Project ID: #17637090

46 freelancers are bidding on average $103 for this job

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community ( More

$150 USD in 2 days
(648 Reviews)
8.3
deepbluetech

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
(179 Reviews)
7.3
sargardon

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
(80 Reviews)
6.6
avinav606lx

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. P More

$100 USD in 3 days
(162 Reviews)
6.4
SigmaVisual

Hi, I have extensive experience of working on similar data automation projects. I can help to develop an automated script to merge the excel files according to your requirements. Please let me know when you are availab More

$150 USD in 5 days
(33 Reviews)
6.0
periyannas

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
(72 Reviews)
5.9
axiomswb

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
(40 Reviews)
5.8
younus15

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 experi More

$300 USD in 3 days
(96 Reviews)
5.6
satishtl

- 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. - Rec More

$80 USD in 3 days
(49 Reviews)
6.0
whitehorsetechn

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 qua More

$200 USD in 3 days
(17 Reviews)
5.3
sumon355

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
(34 Reviews)
5.2
MoohHHooM

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
(26 Reviews)
5.3
designer504

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, Animatio More

$30 USD in 0 days
(35 Reviews)
5.0
khoddam

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
(19 Reviews)
4.8
serdaryalcin

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
(21 Reviews)
4.4
Jothisubash

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, pref More

$155 USD in 3 days
(14 Reviews)
4.6
kahilH

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 More

$100 USD in 3 days
(23 Reviews)
4.9
williams115

-Professional Data Entry, Data Processing, Excel, PDF expert ! Best Result in Time!------------------------------ Hello sir. I've really rich experience for your project, so your project is very interesting to me. I More

$30 USD in 3 days
(2 Reviews)
3.6
haleem0786

i can do this, i have good command over ms excel especially pivot table, charts, advance formulas, formatting etc. Please review my profile and inbox [login to view URL]

$150 USD in 2 days
(15 Reviews)
3.6
nanda1208

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 an More

$50 USD in 2 days
(14 Reviews)
3.3