In Progress

Extract to Excel

I have a large number of files from which I want to extract some data and place into an excel table. I have attached an example of one of the files with the 4 pieces of data that I want extracted highlighted in red. I have also attached an excel sheet with how I want the data to look when it is extracted. It is important that the BSP column is in a number format.

There are 6900 of these files so obviously this is something which somebody will have to automate to extract the data.

Skills: Data Processing, Excel, Visual Basic

See more: excel extract text from middle of string, excel extract text from string between characters, how to extract certain text from a cell in excel, how to extract a word from a string in excel, excel extract text from cell after character, excel extract text from cell before character, how to extract numbers from a cell in excel, excel extract text from alphanumeric string, convert excel seet access sheet, create sheets excel using master sheet, vba excel automate toolpak, excel calorie counting sheet, excel formula call sheet, excel quality control sheet, excel dispatch spread sheet

About the Employer:
( 73 reviews ) Stevenage, United Kingdom

Project ID: #15374312

Awarded to:

kepler452tech

Hi, I am here for you. I'll write a script to extract the data automatically. I promise that the work will be done with the best quality. It will be my great pleasure if you contact me. Thank you! Relevant Skills and More

£50 GBP in 1 day
(9 Reviews)
3.8

59 freelancers are bidding on average £115 for this job

seaanddream

Hi, my name is Sevinc. I read your "Extract to Excel" project descriptions carefully before bidding. I checked your requirements, and attached sample text as well... I got what you need and ready to go ahead as soon More

£100 GBP in 3 days
(240 Reviews)
7.4
mirniyazuddin92

Dear Sir/Ma'am, I am a Web research, Data Entry & Web Scrapping expert. I checked and understood your requirements.I can extract some data and place into an excel table. Relevant Skills and Experience Data Process More

£200 GBP in 7 days
(210 Reviews)
7.2
saqibmunir55

sure i can extract these 4 fields from this docx,or rtf files into excel using coding Relevant Skills and Experience sure i can extract these 4 fields from this docx,or rtf files into excel using coding Proposed Mile More

£52 GBP in 1 day
(298 Reviews)
6.7
£150 GBP in 3 days
(137 Reviews)
6.5
MimiFL

Processing (automatically) the large number of files (6900) and extracting four pieces of data ("venue", "name", "openDate", "bsp"), while making sure that "bsp" filed is formatted as a numeric value. Relevant Skills More

£150 GBP in 1 day
(317 Reviews)
6.5
srikartiram

Hello, i can use regular expressions and get this data's for you in your desired format. I can't see the excel sheet you mentioned. However i understand the requirement. I will get this work done for you in 1-2 days More

£30 GBP in 5 days
(123 Reviews)
6.2
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 More

£100 GBP in 3 days
(35 Reviews)
5.7
furqanorpiv

Hi, I am FURKAN a CERTIFIED Data Processing, Excel, Visual Basic EXPERT . I would love to provide you Quality data by extracting data from Files that are highlighted in red and place into an Excel table AS P More

£20 GBP in 1 day
(24 Reviews)
5.5
sheikhakash786

Hi there, I'll extract data and place into an excel table. Please send me a message so that we can discuss more. Relevant Skills and Experience -My Upwork profile: [url removed, login to view] -Web Scraping -Data More

£30 GBP in 10 days
(19 Reviews)
5.2
zu02

Hi, I can code that rtf to Excel automation. Relevant Skills and Experience I'm in Ms Access/Excel/ vba programing since Ms Office 97 released Proposed Milestones £150 GBP - default I can do that via Ms Access app More

£150 GBP in 3 days
(27 Reviews)
5.6
dynamitewebsol

Hello, I read your requirements and understand very-well and ready to start work from now. Thank you Relevant Skills and Experience I have 7 years experience. Proposed Milestones £100 GBP - Milestone

£100 GBP in 5 days
(10 Reviews)
5.2
£20 GBP in 3 days
(58 Reviews)
5.1
renesontiongson

Pleasure to help you. Excel automation is my masterpiece in my accounting field. Feel free to message me to start the job. Thank you so much. Relevant Skills and Experience Excel automation Proposed Milestones £10 More

£100 GBP in 3 days
(56 Reviews)
5.2
tasleem83

I have gone through the description. I am very much interested to work on your project. I’ll provide you the work as per your requirement with in a particular time frame. So let’s start Stay tuned, I'm still working More

£50 GBP in 3 days
(87 Reviews)
5.3
vsprybhanu

Hi, I have checked your attached .rtf file. But you did not attach excel format here. I can develop a macro to extract data from many .rtf files and put into desirable excel format. Relevant Skills and Experience Expe More

£250 GBP in 3 days
(61 Reviews)
5.2
arveeindigo

I'm very interested to complete this task for your full satisfaction. I'm a PDF extraction expert to Excel and word output and completed many successful tasks which is similar to this task. Relevant Skills and Experie More

£150 GBP in 3 days
(17 Reviews)
4.2
swajantalukdar

hi no worry about the quantity of the data. if needed and if possible I'll automate it. otherwise I'll use my team to complete it within very short time. Regards Atiar T.

£200 GBP in 10 days
(17 Reviews)
3.8
liangjongai

Hi, sir I can build the program to extract data to excel. My price and period is negotiable. We can discuss the details via chat. Thanks. Relevant Skills and Experience I have much experience in data processing progra More

£166 GBP in 3 days
(4 Reviews)
3.7
sheikDev

A proposal has not yet been provided

£100 GBP in 5 days
(7 Reviews)
4.0
huongth

Hi. 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 Relevant Skills and Experience I am an expert i More

£23 GBP in 1 day
(14 Reviews)
3.4