Free Microsoft Excel 2013
Quick Reference
Free Microsoft 2013 Quick Reference Guide

Free Microsoft Excel 2013 Quick Reference

Convert Word Table to Excel Spreadsheet

I know how to use the mail merge feature from Excel to Word, but how
about from existing labels in Word to a usable Excel spreadsheet. My
approaches have been to save word as .txt and then get external data in
Excel. That works great accept I need to be able to have different
column fields like Name, Address, City, State etc. What is the best way
to go about doing this?
Any help?? Thank you in advance.


Post your answer or comment

comments powered by Disqus
I want to use excel to start logging calls, how do I copy the data that resides on a word table to a spreadsheet without losing the formatting. Are there any call log software out there to make this job easier?

Any help will be greatly appreciated.

I found this thread on the now defunct Google Answers that is spot on to my problem, but their solution didn't work:
http://answers.google.com/answers/threadview?id=319322

As you are probably aware, if you try to simply cut & paste a word table to excel, any carriage returns within a table cell will cause multiple rows in excel, and will cause the rest of the cells in that row that have no carriage returns to appear as merged cells.

In my case, I had a bunch of cells w/ soft carriage returns, but I was able to replace them using "^l" in the Find field in Word.

As described in the above thread, Excel does not recognize such codes as "^p" or "^l" in the Find/Replace fields, and anyway, I cannot simply use the Find/Replace function because I get a "Formula is too long." error.

Here is the code provided by aht-gt in the Google Answers thread:

Public Function ReplaceCharacter(ByVal s As String, ByVal oldchar As String, ByVal newchar As String) As String
Dim sVal As String

'Set the late binding objects
Dim rPart As Object

sVal = s

Set rPart = CreateObject("VBScript.RegExp")
rPart.Global = True
rPart.IgnoreCase = True
rPart.Pattern = oldchar

'replace all occurences of the pattern c with the
sVal = rPart.Replace(sVal, newchar)

Set rPart = Nothing

ReplaceCharacter = sVal

End Function

Sub MyReplace()
Dim s As String

On Error GoTo MyReplaceAbort

Application.DisplayStatusBar = True
Application.StatusBar = "Replacing Characters..."
Application.ScreenUpdating = False

For Each c In Selection.Cells
c.Value = ReplaceCharacter(c.Value, "~", Chr(10))
Next c

MyReplaceAbort:

Application.ScreenUpdating = True
Application.StatusBar = False
Application.DisplayStatusBar = True

End Sub

I used "qqq" as my dummy string, so I changed the "~" in his code to "qqq".
I ran the macro, and instead of replacing my dummy string w/ a line break, it replaced it with the string "^l". I also tried changing the "Chr(10)" in his code with "Chr(13)" and "Chr(10) & Chr(13)", and the results were the same.
How &^%$#@! asinine is that?
I have thousands of table rows, and it just isn't realistic fixing all of these carriage returns manually.

Can someone please suggest some alternatives here, or possibly explain why his code isn't working?

I'm running Excel 2003 SP 2.

Thanks.

I need help to transfert web tables to excel spreadsheet...

i need code to extract the tables from :

http://www.nhl.com/scores/htmlreport...9/PL020745.HTM

...and paste it into excel worksheet.

thanks in advance!

I am receiving the results of a Web-based test via e-mail. I am able to paste the e-mail's contents into an Excel spreadsheet and use it to manipulate the data as necessary, with one exception, namely an answer that requires the test taker to write a multi-paragraph e-mail response. I am able to identify which cells in Column A this answer occupies, for sake of argument, A60 to A70.

I want to have the contents of these cells appear in a single cell, B60, with linefeeds. I did find an Excel macro on this forum:

Sub FlexConcating()
Dim cell As Range
Dim r As Integer
Dim c As Integer
Dim Cnt As Integer
Cnt = -1
Dim strRslt As String
   For Each cell In Selection
       r = cell.Row
       c = cell.Column
       Cnt = Cnt + 1
       strRslt = strRslt & vbCrLf & cell
   Next cell
   Cells(r - Cnt, c + 1) = strRslt
End Sub
This works after a fashion, but there are undesirable leading spaces at the beginning of each paragraph.

If I instead copy the cells into a Word document, I notice that they come through as a table. If I convert the table to text in Word, then paste it back into the formula bar of B60, I get what I want.

My question is, can this be done wholly within Excel, without the need for Word?

Thanks in advance for any help on this.

Burt Spielman
Madison, NJ

I have an existing Word doc in table format. Some columns contain bulleted
items. How can I convert to Excel maintaining the bulleted format?

I know how to use the mail merge feature from Excel to Word, but how about
from existing labels in Word to a usable Excel spreadsheet. My approaches
have been to save word as .txt and then get external data in Excel. That
works great accept I need to be able to have different column fields like
Name, Address, City, State etc. What is the best way to go about doing this?
Any help?? Thank you in advance.

Is there a way to get a clean, formatted transfer of Word tables to
Excel? What I've done is do a Word Save-as to Web (HTML), and then
import this into Excel.

However, I'm going blind working in Excel fixing small errors, such as
values that were togther in a single Word table cell being rendered as
two cells, and cell tint being lost completely, and cell orientation
and justification. I have to manually resize rows and columns. Is there
a tool for doing this conversion, or methods I can use to minimize or
eliminate these problems?

I have a lot of information (mostly text) that has been provided to me in an MS Word document in a table. When I try to cut and paste it into excel I don't get the desired results (i.e. one table cell from the Word table is one cell in Excel).

I've tried several of the Special Paste options, but nothing is working.

Is there an easy way to get this information converted?

Ernie
(Munich)

I have several Word documents with large tables, filled with thousands of hyperlinks to Excel cells. I now need to add some rows to my Excel worksheet. However, my Word links now point to the wrong rows. I've been trying to find a way to update the hyperlinks in a way more efficient than resetting the hyperlinks (via Paste Special), or manually editing the row number in the field codes.

Better yet, is there a way to get these hyperlinks to dynamically (and, perhaps, automatically) follow the referenced Excel cell as it moves down in it's worksheet? If I have to re-engineer everything in the Word docs and/or the Excel spreadsheet, it's worth the investment of time and energy. Otherwise, maintenance of this data will be a nightmare going forward.

TIA to all you Excel/Word experts out there.

Another department sends out enormous status reports in the form of a 20-page
long Word table every week. (7 columns with headers, many rows). I've been
kind of laboriously copying/pasting/reformatting the thing into Excel so that
I can analyze the thing more effectively, but it's always rather painful.
(And there's no way they'll ever just convert the thing to Excel permanently.)

Is there a macro that would copy the contents of each cell from the table in
the Microsoft Word document into an equivalent cell in an Excel template that
I could just empty out and refill every week? Complicating things is the
format the table is in: Whoever puts this thing together insists on merging
all the cells in a row to make intermediate heads that appear throughout the
table.

Thx in advance, everyone!

I have a pdf file that I want to convert a table in the middle of the the document to excel 2007. The pdf table that I want to work with is in a users manual from my company's main customer. This user manual has page headers and page footers in it. The customer said the only way I will get the data for the work I need to complete is to convert the 297 pages from their pdf document to excel for me to work with. .
I work some a small company that does not have a budget for buying adobe acrobat. It looks like adobe acrobat would pull out all the tables I want to access easily. I have tried a few free online websites that convert a pdf file to excel, but they do not work. Do you know of any free website where I it would complete my goal of converting a pdf file to excel?
The only solution that I found that works but is a bad option is the following:
I select the part of the table I want for each page. (I need to repeat this process 297 times). I hit control c, I then have a word 2007 document and do a control v into the word document. From the word document I select what I just pasted into it, I then do a contol c from the word document into the excel 2007 excel sheet. I then do a control v into the excel document and that page of the data is formatted correctly.

I am willing to pay $300.00 USD for this solution.

I have hundreds of job description Word documents similar to the example attached "200001_LP_Housing_Program_Mgr_Job_Description" saved in folders.

Bottom line I need to convert them into either Excel or Access or any other way that will allow me to manipulate them in a spreadsheet similar to the example attached "Bot Outcome Example" that I manually created. vs. Individually opening each Word job description, pasting it into Excel or whatever and then manually labeling the sections/ order and job code #. All word documents are labeled to begin with the 6 digit job code so if there is a way that a bot or a macro or whatever type of converter could
automatically open the word docs from a folder and paste the content into a spreadsheet column C (in my example),
pull the job code from the file name and populate column A (in my example),
and then last populate column B with the order/ section of the description using the key words by section or Job Summary down to Essential Functions to Minimum Qualifications and last to Knolwedge, Skills & Abilities.

This would allow us to sort/ scrub in a database vs. having to do manually paste individually by job description. There are bullets and different formats in some descriptions that could potentially impact the quality of the transfer of the data. Further, in some cases the job description templates could be slightly different formats however.. they ALL have the same key words by section listed above including Job Summary down to Essential Functions to Minimum Qualifications and last to Knolwedge, Skills & Abilities.

We will be completing job descriptions in groups over time, so a solution that is set up that I could just apply to job description folders in batches as I go would be perfect (vs. I have all of them saved in 1 folder ready to go you take it and do it)

Hopefully my rambling directions made a bit of sense but let me know if you have any further questions.

Thanks for your time, Cheers!

Hey guy's

I've been searching the web for quite some time now, but i cant find it.

First off:
My skills: Limited ( first time using vba,, but search the web for hours, so i know some basic stuff what i've read)
My programs: Office 2010
My question:

I have an map full with .doc files and want to convert them to excel files.

The word file has an table in it with data, This data is from machine specs, and i want to import them in to an excel database.
I thought the best thing is save / export the word table to an excel file.
And later on make an (master) excel file and link the seperate files to this master file.

I've got an working macro to import table dat from word in to an excel spreadsheet (found it on the web)
But it is limited to one file ( i've got 200/300 files so it would be easy i've vba can do it for me )

Code:
New Text Document (6).txt

I want to automate the proces and let it save the workbook automaticly
And this code only get cells 3,2 and 4,2
I want many more ranges and data cells, these i've already got sorted in another excel file so i can copy them real quick
But it needs an additional bit that overrules the empty cells ( i've pasted my ranges and cells in the macro ) and that works, but i get an error on every empty cell ( i dont have that basic knowledge )

I think you guy's can help me!
So please do so.

Edit:
To make the macro working i've changed Dim wdDoc As Word.Document
the Word.Document to Object.

I have a word document that I need converted to an excel spreadsheet. can this be done? if so can anyone help me?

Thanks

Keith

I have an evaluation form I need to convert from word to excel; as to
implement formulas to make the scoring easier to maintain or more accurate.
I am having trouble since the original word doc has numerous tables and such.
I am not that excel savvy..HELP

I'm converting a Word table - based document to Excel and want 3 separate worksheets on the same printable page. How do I do this? I'd like to attach either the Word table file or my converted "new" Excel file that I'm struggling with but they both exceed the allowed file size.

i have one word file and needs to convert to excel.

I've got a system that is generating HTML documents with a table and then
opening them in Excel. This works just fine, Excel is converting the tables
into a spreadsheet without problem and preserving the HTML formatting.

But now I'm being asked to pass formulas into these sheets in certain places
instead of values. Is there any notataion that I can use in the HTML table to
pass a formula to Excel instead of a value?

Thanks in advance.

I'm sure there might be a solution, I just can't find it
now.....

I have a table in Word that might or might not
contain "returns." I want the table in Word to copy
EXACTLY as is into Excel.

If I have Don (hard return) Mike in one Word table cell.
It splits this into two cells in Excel. Any way to
prevent this. Pasting as a Word document is not an option

Thanks so much in advance.

I am trying to create a dynamic link between data in an MS Word and MS Excel
file. When I copy the table in MS Word and use the paste link command in MS
Excel the top couple of rows and left most column from the MS Word table are
the only items displayed. Is there an effective way of linking this data.

Hello, when I use MS Query to retrieve data from MS SQL Server 2005, the data is returned in a table format. The table format doesn't allow for subtotalling. (A simple example would be to retrieve sales figures for a time period, and then create a subtotal for each sales rep and then create subtotals for each customer within each rep.)
When I convert the table to a range, Excel tells me that it will permanently remove the query. Removing the query makes it a one-time use only file. I'd like to retain the query so that it could be refreshed periodically to update the report.
Is there a way to retrieve data from a database and do subtotals without losing the query?

Thanks

How can I convert a word address label document back into an Excel spreadsheet?

Thanks for the help.

G.

Hi guys,

I am trying to convert the attached Word document into Excel and retain the same formatting.

What I would like to build in is the calculation option for check boxes where by if a particular check box is selected, it will automatically calculate the points (mentioned underneth the check box) and return the total value of all check boxes under the section in "PAYROLL TAX" where it says total points.

It doesnt have to be check boxes, it could also be radio buttons. Whatever works easier.

Thanks in advance for your help!!!

I'm sure there might be a solution, I just can't find it
now.....

I have a table in Word that might or might not
contain "returns." I want the table in Word to copy
EXACTLY as is into Excel.

If I have Don (hard return) Mike in one Word table cell.
It splits this into two cells in Excel. Any way to
prevent this. Pasting as a Word document is not an option

Thanks so much in advance.


No luck finding an answer? You could always try Google.