Đã Hủy

Fill in Excel worksheet with data from 4 separate text files

I have an Opencart 2.x website for selling books and I need to create a comprehensive category structure. The good news is that this doesn't have to be done manually as Opencart has an export/import tool and this means I can import all categories in one single operation from a Microsoft Excel spreadsheet.

Therefore I need a freelancer to take the data from these 4 text files and put it into the attached Excel spreadsheet. The data (in the text files) is delimited by commas and will need formatting before being imported into Excel. Additionally, the freelancer will need to fill the other columns within the spreadsheet such as the category id, parent category id, sort order and the SEO keyword for that category.

I have already entered a number of categories manually into this Opencart then exported as an Excel spreadsheet which is attached. Please inspect so you can understand.

To have a better understanding of the category structure, the website has 4 top-level categories:

- Business, Technical and Professional

- Children's

- Fiction

- Non-Fiction

Each of the above top-level categories have sub-categories so for example, "Business, Technical and Professional" has 7 sub-categories:

- Business and Economics

- Computers

- Education

- Law

- Medical

- Psychology

- Technology

Then each of the above also has their own sub-categories so there are 3 levels. For example, "Business, Technical and Professional" has the sub-category "Business and Economics" which in turn has the sub-category "Accounting". This gives you the following:

Business, Technical and Professional > Business and Economics > Accounting

Notes

- Most of the bottom level categories in the text files start with a category called "General". Instead, I want the category structure purely alphabetical.

Finally before mindlessly bidding for this project, please do actually open up the zip file and look at the contents.

Kĩ năng: Excel

Xem nhiều hơn: auto fill forms data excel worksheet, fill excel spreadsheet data, excel worksheet data, convert text file to excel 2013, how to convert notepad to excel 2013, importing text file into excel using vba, convert txt to excel online, change delimiter in excel, convert text file to excel 2016, how to convert notepad to excel with columns, text import wizard, data entry, excel, excel worksheet data download, excel data scraping text files, offer data extraction services text files, excel worksheet data comparision macro, search text files excel, excel macro export text files, sorting text files excel

Về Bên Thuê:
( 44 nhận xét ) York, United Kingdom

ID dự án: #15333702

27 freelancer đang chào giá trung bình $24 cho công việc này

zekovicm

Hi there,I am Miljan,IT expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it within the agree Thêm

$30 USD trong 1 ngày
(25 Nhận xét)
5.5
sajibdigital

Hi, I am interested in your project. Hope you will fully satisfied after completing this project with me. Relevant Skills and Experience Excel Proposed Milestones $20 USD - project

$50 USD trong 1 ngày
(46 Nhận xét)
5.4
liveexperts123

please ignore the bid amount we will discuss the price later in the chat after we have discussed the project thoroughly Relevant Skills and Experience: . Proposed Milestones: 30 - . Hi yorweb! Please drop a message to Thêm

$30 USD trong 2 ngày
(1 Nhận xét)
3.9
Mahdi0199

sir I want to work for you,, thanks Relevant Skills and Experience Excel Proposed Milestones $15 USD - Fill in Excel worksheet with data from 4 separate text files

$15 USD trong 0 ngày
(16 Nhận xét)
3.4
$49 USD trong 2 ngày
(9 Nhận xét)
3.1
$25 USD trong 1 ngày
(3 Nhận xét)
3.0
kyosra

Hi the task is easy I did a C2I training I am a computer engineer student I did similars tasks I agree to do a test work to convince you before hiring me thanks

$15 USD trong 2 ngày
(5 Nhận xét)
2.9
startechoffshore

Hi there! your project looks interesting for us we are experience team and perfect match for this job with 100% accuracy on time. thanks. Relevant Skills and Experience Excel Proposed Milestones $25 USD - on complet Thêm

$25 USD trong 1 ngày
(8 Nhận xét)
2.5
bktk

hi sir i have come to know that you want to convert data from attached note pad to excel ,sir i am offering you free demo Relevant Skills and Experience sir i have a skill of copy typing ,data entry and collecting d Thêm

$25 USD trong 2 ngày
(12 Nhận xét)
2.5
integrahup

I will fill Excel worksheet with data from 4 separate text files Relevant Skills and Experience Excel , Data Entry Proposed Milestones $20 USD - Fill Excel worksheet with data from 4 separate text files

$20 USD trong 1 ngày
(1 Nhận xét)
0.0
engmiro777

i am an engineer good dealing with excel word pdf and others belong to engineering i will do your job in accuracy quality quickly Relevant Skills and Experience excel word pdf Proposed Milestones $15 USD - work

$15 USD trong 1 ngày
(2 Nhận xét)
0.0
WebExcelPro99

I can help you with data extraction and web scraping. Anything is possible - from simple websites to a large custom project with millions of URLs to scrape! Relevant Skills and Experience Regardless of the size of a p Thêm

$25 USD trong 1 ngày
(0 Nhận xét)
0.0
Ahmed2150

Hi, My name is Ahmed Hussain. & I m from Pakistan live in Saudi Arabia Riyadh. Recently I have done my certificate in CII. Specialist in underwriter & claim handling. I m wait for your response. Relevant Skills and E Thêm

$25 USD trong 1 ngày
(0 Nhận xét)
0.0
aamirassistant

I offered my service to mentioned company for 1 year & plus. I feel that i have some satisfying skills. I believe on quality product. I want to render you my services. Marshmallow Aamirassistant Relevant Skills and E Thêm

$25 USD trong 1 ngày
(0 Nhận xét)
0.0
Elhalwaniii

I will do this work in one day or less Relevant Skills and Experience good command of Microsoft Excel to do this work Proposed Milestones $25 USD - i will do this work for 25$ only

$25 USD trong 1 ngày
(0 Nhận xét)
0.0
sbabar

good day, I have been working with excel worksheets and micro soft office on a whole for a local construction company for the last 3 years and am very adept in the processes of the entire program.

$10 USD trong 1 ngày
(0 Nhận xét)
0.0
happyman2014

Hi, I understand what do you want. I will start work right away. thanks Relevant Skills and Experience Excel

$10 USD trong 1 ngày
(1 Nhận xét)
0.2
waelhaiba

I have 7 experience in financial reporting. professional accountant and bookkeeper. I'm working on MS Excel day by day . Monitor for petty cash daily and Bank Reconciliation monthly. Relevant Skills and Experience I Thêm

$17 USD trong 2 ngày
(0 Nhận xét)
0.0
olaitandavid50

I'm an expert in Excel

$25 USD trong 2 ngày
(0 Nhận xét)
0.0
jaimemontilla

Hello... I can do your job in one day, I already understood what you want and it will surely be satisfactory for you ... Habilidades y experiencia relevante excel Htos propuestos $35 USD - excel document with Thêm

$30 USD trong 1 ngày
(0 Nhận xét)
0.0