Over 1 million tech questions and answers.

How to convert/save an Excel file to ASCII comma delimited text file

Q: How to convert/save an Excel file to ASCII comma delimited text file

I need convert/save Excel files into the ASCII comma delimited text files. It needs to be in this format in order to upload healthcare data to the CDC (NHSN).

Thank you.

RELEVANCY SCORE 200
Preferred Solution: How to convert/save an Excel file to ASCII comma delimited text file

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: How to convert/save an Excel file to ASCII comma delimited text file

File - Save As. Change Save as type option at the bottom...

Read other 3 answers
RELEVANCY SCORE 217.2

This format is necessary for importing data files into HandiLedger systems.

Can anyone please give me a step-by-step explanation of how to achieve this.
 

A:how to convert excel data to ASCII comma delimited text file

you should be able to save as CSV - Comma Separated Value . which will produce a comma delimited file

ASCII is how a computer uses characters
so a letter
A in ASCII can be a number of different codes , depending on what the computer uses
I used to work on computers that uses octal numbers
The octal numeral system, or oct for short, is the base-8 number system, and uses the digits 0 to 7.Click to expand...

and an "A" was 101
I dont know if you are trying to change the letters and numbers into ASCII code
this maybe HEX base 16
The hexadecimal numbers are 0-9 and then use the letters A-F.Click to expand...

Here is a table of ASCII codes
http://www.asciitable.com/

if you had
cell A1 with
H and
A2 with 20

did you want to show
H,20
or
change the H and the 20 to an ASCII code
say HEX
48,4
 

Read other 1 answers
RELEVANCY SCORE 188.8

I need to convert Excel data into ASCII comma delimited text file format. I know that if I save as csv. that the data can be pasted into Wordpad with the comma delimiter, but how do I get the quotes around the data fields?

Any help would be appreciated.

Thanks
 

A:Converting Excel data to ASCII comma delimited text file format

Read other 9 answers
RELEVANCY SCORE 132

I have used Eudora for many years and I'm now switching to Outlook 2003. I have about 200 addresses in Eudora and it has no export option. I have managed to get all the names and addresses into a comma delimited file by doing a manual search and replace. Here's the format:

FirstName,,LastName,,[email protected]

I did all of this on the assumption Outlook had a way to import a comma delimited text file into its address book. But, alas, I don't see any way to do it.

Anyone have any suggestions?

I don't mind abandoning this method for another if need be.
 

A:Import Comma-delimited Text File into Outlook 2003 Address Book?

I was just looking at a site for making a backup of Eudora's Address Book.
http://email.about.com/cs/eudoratips/qt/et111702.htm

Try Exporting the Contacts folder in Outlook, as a .csv file, first.
Then add the contacts from the Eudora Address Book to the .csv file and Import the .csv file back into the Contacts folder in Outlook
 

Read other 2 answers
RELEVANCY SCORE 131.2

Just found the site, amazing work.
I have a project where I need to export a comma and quote delimited text file. I am running W7 and O2007.
On Aril 8, 2007 Rollin_Again posted the code below. I see you are still active, could I impose on you for a couple of changes?
> One, if the field is blank there is no need for quotes.
> Two, I do not need Quotes on the first 2 fields/columns.
>Third, there is a space before and after every comma that is not needed.

My file only has 20-30 rows by 22 columns so cleaning this up is not a BIG deal, but since it is Christmas I thought I would ask.

TIA
Code:

Public Sub ExportText()

Dim fso
Dim aArray As Variant

Set fso = CreateObject("Scripting.FileSystemObject")
Set fsoText = fso.CreateTextFile("C:\Test.txt", True)

vCol = Left(Columns(Cells.Find(What:="*", After:=[A1], SearchOrder:=xlByColumns, _
SearchDirection:=xlPrevious).Column).Address(0, 0), 2 + (Cells.Find(What:="*", After:=[A1], _
SearchOrder:=xlByColumns, SearchDirection:=xlPrevious).Column < 27))

For i = 2 To Cells.Find("*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row

ReDim aArray(1 To 1, 1 To Cells.Find(What:="*", After:=[A1], SearchOrder:=xlByColumns, _
SearchDirection:=xlPrevious).Column)

aArray = Range("A" & i & ":" & vCol & i).Value

For x = 1 To Cells.Find(What:="*", After:=[A1], SearchOrder:=xlByColumns, _
SearchDirection:=xlPrevious)... Read more

A:Solved: Export Quote and Comma Delimited file from Excel

Read other 6 answers
RELEVANCY SCORE 126.8

I need to export data from an excel spreadsheet to be used by another program. This other program needs to the see the data in a .txt file that is comma delimited ascii. The values (or data in each cell) must have quotes around them to work in this other program, but I cannot figure out how to get quotes around the values when saving into .csv or other comma delimited formats. I only get data separated by commas.

Any help?
 

A:Solved: exporting excel data into comma delimited ascii with "quotes"

Read other 6 answers
RELEVANCY SCORE 124

I need to export data from excel into comma delimited text (ascii) file so that i can import it into another program. I've never done this before but here's what I did... I saved the excel file as a csv, opened the csv with wordpad and did a 'save as' from there to get the .txt extension. The data in the text file appears to be in the exact format I need
(0, "Text", 1, 3, 0) but the program I am trying to import it into doesn't like it ('invalid record' or something like that). Did I do something wrong in the process of arriving at my .txt file?
 

A:Comma delimited ascii files

Read other 14 answers
RELEVANCY SCORE 122

Hi, I am not particularly tech savvy and I'm trying to export contacts from an outdated Customer Management program into a csv file so I can upload them into a more current program. You can only export them into an ASCII format and I have no idea how to sort it out in excel. Any help is greatly appreciated.
Thank you in advance.
 

A:Unsure how to convert an ASCII file to an Excel file

Is this by chance a "Delimited text file"?
If so it will a comma between each entry of the contact. Each contact will be on a separate line.

This will be a plain text fine that can be opened in any plane text editor.

It may be helpful if you were to post an small file as an attachment?
 

Read other 1 answers
RELEVANCY SCORE 112.8

I'm trying to import physical inventory data on an excel spreadsheet into my business program. It must be in a quoted comma-delimited format. I haven't a clue how to accomplish this.
 

A:Solved: txt file to quoted comma-delimited format

Read other 16 answers
RELEVANCY SCORE 106.4

I'm using win-98, writing software in foxbase and compiling with clipper to make exe file under dos environment.

in some report, i make TEXT FILES to view reports.

I would like to export these TEXT files directly to excel, how can i do it ??

vkm
 

A:convert text file into excel file

If they are comma delimited files, use text-to-columns to separate the data into different columns.
 

Read other 1 answers
RELEVANCY SCORE 103.2

Hi again, probably an easy one.

I would like to export Excel data to a text file so that the text file is exported with both quotation marks and commas as delimiters.

Microsoft support page returns a relevant article but offers no answer.

Thank you
 

A:Export as comma delimited (Excel to Wordpad)

This is what I found in the help file for exporting to text file:

Convert bidirectional text files to ANSI
Language-specific information

The ConvText utility provides more support (additional code pages and visual text layout options) than the Microsoft Excel Text Import Wizard for converting right-to-left characters in bidirectional files to ANSI characters with logical text layout. ConvText is installed as part of Excel.

In the \Program Files\Microsoft Office\Office folder, double-click the ConvText.exe icon.
Click Convert To Windows ANSI Code Page.
Type file names in the Source and Target boxes, or click Browse.
Select the code page, text layout, file type, and file type parameters that match the source text file you are converting.
Click Load. You can also click Save to retain the conversion specifications.
Click Convert.
Follow the instructions in the Text Import Wizard.
All field names and records from the original worksheet are fully recreated in a new worksheet.
 

Read other 1 answers
RELEVANCY SCORE 102.8

Hi,

I've a question with Excel and appreciate all help given.

Question:

How do I convert an 100-row Excel 2003 Worksheet ( see attached Sample1.xls) to a text file where each column is separated by a new line (see attached Sample2.txt) ?

Thanks for your reply!
 

A:Convert excel to text file

I can't think of a simple single step solution but this two step process should do the trick ...

Save the Excel file as a "Text (Tab delimited) (*.txt)" file.

Open the text file in MS-Word (or other editor that allows find and replace of special characters in an entire document).

Find and replace all of the Tabs with Line Breaks.
 

Read other 1 answers
RELEVANCY SCORE 102.4

I'm trying to open in Excel 2010 a file with .exf extension that is always a pipe delimited text file. I have set, using Windows file associations, to open this type of file with Excel. But, I would like for it to recognize that it is pipe delimited, so that I don't have to click on Delimited, Other, "|" to import the file. Any ideas? I also thought about using a macro to save some steps as well. Thanks for your help!
 

A:Excel import pipe delimited file based on file extension

Hi, welcome tothe forum
Macro is the solution, just start the macro recorder, give it a name and do what you do, stop the recorder and you have the macro.
Simple as pie
 

Read other 3 answers
RELEVANCY SCORE 98.8

I need to open a file in escel as a delimited file, but the problem is I don't know how to do this So I was curious if anyone could tell me how to open a file as a delimited file and have : be the delimiter. all help is appreciated
 

A:Opening a file in excel as a delimited file

Read other 6 answers
RELEVANCY SCORE 98.4

Hope I can explain this situation: I have a program on my pc that is used accounting & billing in a medical practice. I am signing up now with an online service that can electronically file my billing to the different insurance companies. I have been told that all of data that is presently stored on the billing program (program #1) can be sent to the online electronic filing program (program #2) by copying the files as csv file format. When I asked the rep from program #1, they said I would need to copy the files as 'tab delimited text files'. I have never heard of that, and have no idea how, and if I can do that with all these data files. The only thing I have ever heard about csv files is I beleive that is the file format used in Outlook Express. This is an entire different thing. Program #1 is very strange to work with, in that it is not like a basic windows program with file/edit, etc. available to you. Hope that makes sense?Anyone out there have a clue what I am talking about? Thank you in advance for any help or suggestions.

A:"tab Delimited Text File" And Csv File

Until someone with more knowledge comes along, these might start you in the right directionhttp://desktoppub.about.com/od/textacquisi...abdelimited.htmhttp://www.usedbookcentral.com/back_end_faq/deliminated.htmlhttp://www.google.com/search?q=MS+EXCEL+TO...lient=firefox-a

Read other 5 answers
RELEVANCY SCORE 98

I have a very large tab-delimited text file that I want to bring into a program that will separate it into columns. Excel would usually be used for this but it can't handle files that span multiple sheets.
Any ideas?

Thanks,
Jeff
 

A:large tab-delimited text file

Read other 13 answers
RELEVANCY SCORE 96.8

Hi,
I'm using Access 2010 and wish to import a tab delimited text file containing the following data:

Mobile Called Known ChargeGroup Date Time Duration TimeBand Cost Count
01234567890 10987654321 654321 Mobile to Mobile Orange 29/10/2012 13:11 00:00:05 Daytime 0.020 1
01234567890 10987654321 654321 Mobile to Mobile Orange 29/10/2012 13:13 00:00:02 Daytime 0.010 1
01234567890 10987654321 654321 Mobile to Mobile Orange 29/10/2012 13:14 00:00:01 Daytime 0.010 1
01234567890 10987654320 654320 Mobile to Mobile 3 29/10/2012 13:15 00:06:17 Daytime 1.010 1
01234567890 10987654321 654321 Mobile to Mobile Orange 29/10/2012 13:21 00:00:04 Daytime 0.020 1

To import I'm selecting External Data> Text file and working through the Wizard.

When it completes with an error saying not all data could be imprted. The log table that is created has the following:

Error Field Row
Type Conversion Failure Mobile 1
Type Conversion Failure Called 1
Type Conversion Failure Mobile 2
Type Conversion Failure Called 2
Type Conversion Failure Mobile 3
Type Conversion Failure Called 3
Type Conversion Failure Mobile 4
Type Conversion Failure Called 4
Type Conversion Failure Mobile 5
Type Conversion Failure Called 5

I have done this many times before but it was always with Office 2003. Is it possible something has changed that I am unaware of?
Any advice on how I can get around this? All other fields appear to import fine.
Cheers

Paul
 

A:Access - Import From Tab Delimited Text File

The most likely cause of the problem is with the way that Access handles importing the field types, it takes the first record and applies whatever type of value it finds to the field type in the Import Table, which means that when it finds a Number in the first line it assumes the data is going to be numbers. If however some records have text in them you get a type conversion error.
You should be able to overcome this by importing in to a Table with all the fields set to Text and then correcting the data using the error list before setting the field types to the correct one.
Alternatively if you can open the text file you could make the changes to that prior to importing.
 

Read other 1 answers
RELEVANCY SCORE 96.8

I am trying to import a delimited text file and can't get the first and last names in the contact field. One or the other but not both. Any help would be appreciated.
 

A:ACT Database Importing Delimited Text File

mjam said:


I am trying to import a delimited text file and can't get the first and last names in the contact field. One or the other but not both. Any help would be appreciated.Click to expand...

When importing, you can map to First Name and Last name fields when creating the map... ACT! will then put them together for the Contact field.
 

Read other 1 answers
RELEVANCY SCORE 96

Hi
I'm trying to figure out how to make it so that a very long checklist, which includes checkboxes and text boxes, can be transferred to excel. (I'm working with the Microsoft Office 2007 suite.) I've been reading about how you're supposed to enable the "Save Data as Delimited Text File" in the advanced part section of the 'Tools' Options tab, and then save it as a text file to import into excel, but when I do that it doesn't save any information, just two zeros. I've been looking at other forum questions and messing around with how the forms are protected or not, but I can't get it to actually save any of what's entered in to the forms when I save it as a text file. Any help on this would be very much appreciated.
I've attached a zip folder (I hope) with a section of the checklist in case that might help. Thanks so much!
 

Read other answers
RELEVANCY SCORE 94

Can someone help me find a Windows(XP)-based program that I can use to delete records from text-delimited flatfile using a file of email addresses?

Actually, it could be a text-delimited, CSV or an XLS spreadsheet - I can put the data in several formats.

Problem:

I bought a list of several thousand "opt-in" email addresses, but had about 40% of them bounce. I also had a few request "opt-out". The task of deleting the individual records is staggering without a helper!

My background is a mainframe systems analyst. The only PC-based programming language I became good at was compiled (4.5 or 7.1) BASIC. I sure hate to have to try to find my BASIC compiler, re-install it (if the diskettes could even be read!) and write a program from scratch.

I have created a flatfile containing a list of all the "bounces" and "remove me" email addresses (8K+ records!) and need to use it as a "driver" to find the records in the flatfile and eliminate them.

If anyone can help... THANKS!

Sam SoRelle
[email protected]

SSI Texas
SacoTech LLC
SANS Global LLC
Houston Texas USA
 

A:How to Delete Records From Text-delimited Flatfile Using a File of Email Addresses

I could write a Bash script in a couple of minutes to do it but that would require you to run Linux.
 

Read other 2 answers
RELEVANCY SCORE 93.2

I have a group of email addresses that are lsted separated by columns. Here is an example:

[email protected], [email protected], [email protected],

When I import them into excel, they come out as one long string of rows.

Any ideas of how to fix that?

I want one long column.

bob
 

A:Importing comma delimted text file in a single column

Bob, are you telling Excel's Import Wizard that the File is Comma seperated?
When you say one column, can you show how you want your 3 examples to appear please?
 

Read other 2 answers
RELEVANCY SCORE 91.2

I have an Excel file which I have to convert into ASCII.

In the converted file, each record should consist of 296 characters, for e.g.,

Positions 1 - 30: Surname
Positions 31-50: First name
Positions 51: Initial
Positions 52 - 75: Address Line 1
etc.

My problem is that if the surname is less than 30 characters, it has to be padded with spaces and if it's a numeric field it has to be padded with zeros.

As I mentioned, I have an excel file. Is there any way I can format the excel file to automatically put in spaces or add zeros whichever the case may be and then I can just save the file in ASCII format? Is there any other program I could use to accomplish this task?

Any help would be much appreciated.
 

A:Converting Excel file to ASCII

I am sure you could do something with access to output a charachter string and pad them like you stated.
 

Read other 2 answers
RELEVANCY SCORE 90.8

Hi,

I have a spreadsheet that I have linked values to another excel file which is then saved in a .csv format for upload into a price engine. Most all values are correct, except some that have trailing commas. The data contains all the same formatting and I cannot figure out why this is happening. Here's a snapshot of the .csv file. As you can see some have the commas and some don't. Any ideas?

Thanks
ak

JA106LP-L,30,7.000,-2.375
JA106LP-L,30,6.875,-2.000
JA106LP-L,30,6.750,-1.750
JA106LP-L,30,6.625,-1.375
JA106LP-L,30,6.500,-0.875
JA106LP-L,30,6.375,-0.375
JA106LP-L,30,6.250,0.125,,,,,,
JA106L-L,30,7.000,-1.875,,,,,,
JA106L-L,31,6.875,-1.500,,,,,,
JA106L-L,32,6.750,-1.250,,,,,,
JA106L-L,33,6.625,-0.875,,,,,,
JA106L-L,34,6.500,-0.375,,,,,,
JA106L-L,35,6.375,-0.000,,,,,,
JA106L-L,36,6.250,0.375,,,,,,
JF30-S,15,6.625,-1.000,,,,,,
JF30-S,15,6.750,-1.375,,,,,,
JF30-S,15,6.875,-1.625,,,,,,
JF30-S,15,7.000,-2.000,,,,,,
JF30-S,15,7.125,-2.250,,,,,,
JF30-S,15,7.250,-2.500,,,,,,
 

A:Solved: excel file to .csv, trailing comma issue

Read other 6 answers
RELEVANCY SCORE 88.8

Hi community
I try to save an excel sheet with comma, but I always receive semicolon. I know that I have to change Format in Region to English USA, but it still remains semicolon. Can somebody tell me what I could do ?
I am using windows 10 and office 2013 on a HP Pavillon g7 and a few weeks ago this has worked.
Regards
pesche1

A:Excel 2013 saving of csv file comma instead of semicolon doesn't work

Have you seen this Microsoft page?

Read other 2 answers
RELEVANCY SCORE 87.6

A year ago my wife and I started an excel spreadsheet with our finances. It was a VERY BASIC spreadsheet. Each month we'd update it. I know, there are other programs out there that do it, but I love excel...until it turned on me. Sometimes I get a dialogue box asking if I want to try to solve the "delimited text problem" but it doesn't do ANYTHING to resolve it. Now I get this when I load the file (it's nothing but garbage):
hbinS2ѳ_]NҞEO9XYg+gC*XPهEoOx 0++ &UTN - DATACorp SGC>w!mJA= b0^0F_D P!*h_i0
 *H
01 0 UUS1 0 UUT10USalt Lake City10U
The USERTRUST Network1!0U http://www.usertrust.com10UUTN - DATACorp SGC0
990624185721Z
190624190630Z01 0 UUS1 0 UUT10USalt Lake City10U
The USERTRUST Network1!0U http://www.usertrust.com10UUTN - DATACorp SGC0"0
 *H
0
X+nUD.F .+ze
G_.pnVB.\#!v'OUc
SH);_LYhpS^PVo6JD_MNGnIJgצ6l3"d2?)*{NT|
\^>Gjq*_B F0r VmxaLi봌5(\:p3 wG0... Read more

A:Tab-delimited text in Excel???

The contents of that file do not suggest its anything to do with your budget spreadsheet anymore.

I would suggest that the file has become corrupted and cross-linked with a temporary internet explorer file or similar.

Look at the URL's littering the file (http://www.....), should they be in your file at all?

This being the case, your file may be unrecoverable.
As you have been using it for so long, you will have made backups right??
Storage on the Hard Disk only should be considered temporary, I have lost 3 HDD in 3 years. Backup to CD for maximum reliability.
 

Read other 1 answers
RELEVANCY SCORE 86.8

I'm sending someone data from an Excel spreadsheet that will be imported into another application. The guy is asking if I can send him a pipe "|" delimited file.

Does anyone know how I can change the delimiter character from a comma to a pipe? I'm saving the file as a CSV.
 

A:Solved: Excel Save As - Delimited

Hi there,

You could save as CSV, close, then open Notepad and do a Find/Replace (Edit menu), and replace , with | symbol. The only other way I would know how to do it would be via VBA (solely from within Excel that is).

HTH
 

Read other 3 answers
RELEVANCY SCORE 86

Convert Excel file to CSV file For free, If possible..

I need to do this So I am able to upload it to my webbased business,
which is run on netsuite.

Can anyone suggest a site that offers a free Exl to CSV converter
I have seen the converter run from with/in excel, that would be the best

let me know

Thank you Very much in advance.
 

A:Convert Excel file to CSV file (For free?)

F12 brings you into "Save as" and one of the options is for a CSV or comma separated values file format.
 

Read other 2 answers
RELEVANCY SCORE 84.8

I am trying to transfer information from one database to another via comma delimited ASCII format. The format I exported from the first database is "aaa", "bbb","ccc","ddd". But some records from the first database have empty fields, in which the quotation marks are omitted; that is, "aaa", , "ccc","ddd", where the bbb field is empty. The second (import) database requires the presence of the quotation marks in ALL fields and therefore rejects the comma-delimited file when trying to import.

How can I make the databases compatible so that the import will be accepted?
 

A:Comma Delimited Format

Read other 10 answers
RELEVANCY SCORE 83.6

Dear Sir,

We want to convert mp3 format files into txt format. Is their is someone knows about some software that will convert these files into txt and save time.

Please tell us that software we will be thankful to you

With Regards
Mandeep Kaur
 

A:Convert MP3 file to text?

Read other 5 answers
RELEVANCY SCORE 83.6

I have a series of lectures on mp3 that I would like to convert to text form.
Is dragonnaturally speaking the only way to do that?
 

Read other answers
RELEVANCY SCORE 82.8

i m new to this forum and have only initial knowledge of excel. I want to make prog similar to the given in screen shots attached , in which we are inputing two values and on pressing ok a message cpmes " a tfm file has been placed at c drive" . But I want to input three values . Can you help me in making this prog explaining in detail.
 

A:how to convert excel file into .txt file

Hi, welcome to the forum.
It is nice to look at thumbnails and screenshots but this doesn't explain at all what you want, need.
But now you expect anyone reading this to understand immediately what you need?
What kinf data is it, what do you need / want to achieve with it and not less iportan which version of Excel are you using?
The screenshot look like Excel 2003
A sample with dummy data and a clear and consice explanation makes it easier for someone wanting to help to do so.
 

Read other 3 answers
RELEVANCY SCORE 82.8

First of all, my apologies if this topic has been covered in a previous thread. I looked through various threads as well as did a "search", but did not locate one that was on point with my issue.

{I am working on a Gateway Netbook with an Intel Atom processor N270, 250GB HDD, 1G memory and running Windows Vista 32bit. I have (3) internet browsers right now: Internet Explorer, Mozilla FireFox and Google Chrome- I just downloaded FireFox/Google Chrome a couple of days ago. I am trying to figure out which browser works best for my needs but for now, I am running FireFox.}

So, here goes...

I have (4) .wma files that have people being interviewed that make up a total of approx. 6hrs of audio on them. (don't know if that info would even be relevant, but there it is anyway.

I need to, ultimately, have their words typed out in a Microsoft Word Document.

The above is the bare facts. Now...I am, obviously, needing to transcribe these audio files into a Word document (convert the .wma files into text files)

Here's what I think I know thus far...

* This is, virtually, an unobtainable task to accomplish.
* My financial situation will not allow me to purchase any software/products.
* Text files, such as Word documents, cannot be opened by Windows Media Player
* Audio files such as .wma files can ONLY be opened with Windows Media Player and NOT in Word

Here's what I wish to know...

* Is there someone out there reading this that may know of a way to do the... Read more

A:Convert .wma file to text (word doc)

Read other 7 answers
RELEVANCY SCORE 82.8

I need a simple way to convert text files (.txt and .doc) to JPEG. I have Printkey Pro and it does it very well. But it only does what is presently on the screen. It will not do files longer than one page. Most Graphics converter programs will not accept text files as input.
 

A:convert text file to jpeg

Scan it in!! Most scanner software will save in iny format you like. There are even sheet feed scanners for large jobs.
 

Read other 3 answers
RELEVANCY SCORE 82.8

In Excel 2010, I opened a Read-only file, made a lot of changes, and tried to File-Save As.

Nothing happens.

A web-search I got some info, maybe the MS Office update tool was recently installed? Not in my case.

go to explorer, the read-only file and check off Read-only in Properties. Can't, its not saved to anything, and Excel gives a message the file is read-only, please save under a new file name.

I tried File Save As, but nothing happens, no dialog box to input a new file name.

BTW, this is a large excel file, around 27 MB.
 

A:Excel file read-only, but can't File-Save as

Offhand, wondering if the Save As dialog box is opening behind the Excel program window. Maybe reducing the size of the excel window, then trying save as again? (it may be visible if that is happening) Also a possibility is to just try Save. That should produce a message and also offer the opportunity to Save As. Any additional info you can acquire will be helpful for resolving this.
 

Read other 3 answers
RELEVANCY SCORE 82

Hi There,

I am trying to convert a *.dwg file to pdf. Once the conversition is complete I am not able to search any text from the pdf that were originally from the dwg drawing file.

Used the ghostscript GUI and noticed that the fonts are missing as soon as the drawing file has been convert to postscript itself. However this does not happen if I were to convert a *.doc file.

Appreciate some assitance to keep me going on the above.

Regards,
Kumar
 

Read other answers
RELEVANCY SCORE 81.2

I had a bunch of graphics I wanted to make a collage out of, and some are animated gifs and some not. When I tried to make traditional collages in photo editing programs like picasa 3, and save the animation/gif no longer worked. So, I made this code for myspace:

<table>
<tr>
<td><img src="http://i46.photobucket.com/albums/f125/spyder66/isaidchristmas.gif" height="150" width="150" /></td><td><img src="http://i46.photobucket.com/albums/f125/spyder66/letitsnow.gif" height="150" width="150" /></td><td><img src="http://i46.photobucket.com/albums/f125/spyder66/karen1.gif" height="150" width="150" /></td><td><img src="http://i46.photobucket.com/albums/f125/spyder66/294962844_f86c6e6115_o-1.jpg" height="150" width="150" /></td>
</tr>
<tr>
<td><img src="http://i46.photobucket.com/albums/f125/spyder66/lunapic-122806188078908.gif" height="150" width="150" /></td><td><img src="http://i46.photobucket.com/albums/f125/spyder66/merryxmas48.gif" height="150" width="150" /></td><td><img src="http://i46.photobucket.com/albums/f125/spyder66/christmas_window.gif" height="150" width="150" /></td><td><img src="http://i46.photobuc... Read more

Read other answers
RELEVANCY SCORE 80.4

Good morning / Good afternoon
As a newbie I am making the first posting on your forum and I hope it is not a silly question.

I received a hard print of an excel spreadsheet with data in 9 columns (2 date formatted and 6 number formatted) of figures from my by bank and I wish 2 use them for further calculation. As I didn't get an electronic file from the bank I scanned the data sheet on the HP Scanner into text files ( rich text, plain text etc) and attempted to import the text into Excel; but I was unsuccessful. Have I attempted the impossible or did I do something wrong ?

If it is possible to do so how should I proceed ?
With thanks, anothernub
 

A:How 2 import text data into Excel from scanned text file ?

Read other 12 answers
RELEVANCY SCORE 80

I have a CD with a bunch of folders with a bunch of files and subfolders with a bunch of files on it.

Does anyone know of a free utility to capture those folder and file names into something that I can manipulate (Text, Excel, Word, etc.)? I have found a couple but the ones I found only do 1 layer at a time. I would like to get all the information in a tree structure format.
 

A:Solved: How to convert folder, subfolder and file names into text.

Read other 14 answers
RELEVANCY SCORE 80

There is a same Thread and its telling very clearly how to do this task but my problem is if file is in another Language then how to do this task. Thanks In Advance.
 

A:Solved: How to convert folder, subfolder and file names into text.

There is also a /A switch that uses ASCII instead of extended characters. This let's you redirect output directly to a text file. Not quite as nice looking, but easy to automate.

Tree E:\ /A /F >"%Userprofile%\Desktop\Tree.txt"
 

Read other 1 answers
RELEVANCY SCORE 80

With Office 2010 is it possible to scan a document to your computer and then covert it to an Excel file?

A:Convert to Excel File

What kind of a document? If you're talking about a Word doc with tables of data or something like that then it can probably be exported to a CSV file which can then be imported into Excel.

We would really need to know more about what doc and type of info you are wanting to convert to Excel.

After reading your post again, I think maybe you are talking about a paper document that you want to scan. This would require OCR (Optical Character Recognition) software that could convert the image into a text file. Once you have a text file, then there are ways to import the text it into Excel.

Read other 9 answers
RELEVANCY SCORE 80

With Office 2010 is it possible to scan a document to your computer and then covert it to an Excel file?

A:Convert to Excel file

You need OCR (optical character recognition) software, such as ABBYY FineReader.
 
Wikipedia: Comparision of OCR software

Read other 5 answers
RELEVANCY SCORE 80

Help! I need to open a Lotus 123 file with extension 123 (x.123 not WKx) -- Thanks for your help.
 

A:convert to Excel a .123 file

If you know anyone with QuattroPro 9 or later (part of Corel's WordPerfect suite), they should be able to open it for you. Then they could save in xls format.
 

Read other 3 answers
RELEVANCY SCORE 80

Windows 10, KIS and MalwareBytes.

My default Browser is Google Chrome and is fully up to-date.

As i believed I had a issue.with Chrome, I uninstalled it.

Still having IExplorer and MS Edge, one has Google as a browser and the other the default MS browser.

I browsed and downloaded from Google UK and Com the ChromeSetup.exe file in order to re-load Google Chrome as my default browser from IE and Edge. In both cases for whatever reason, the file would only be saved as a text file and not a .exe file. If I opened the file in notepad, it would all be gibberish as you would expect opening a application (.exe)file.

To solve this, I downloaded the same file on my Windows tablet, then saved on a flash drive. Using the flash drive on my laptop, I then re-installed Chrome with no issues of any kind from the flash drive.

Also if I copied the .exe file from the flash drive to save it in my documents for future, it still only saves it as a text.doc.

So why would this file not be saved as a .exe (application), even when all protections were turned off including Defender still in the background.

Some setting somewhere I think is causing this, but where.

I recall sometime ago somewhere seeing a list of various types of file formats that could be controlled, whether that was Windows, KIS or MalwareBytes. ??
 

Read other answers
RELEVANCY SCORE 79.6

About a week ago, I started having issues saving excel spreadsheets. If I try to save them, I get the message that file is currently in use, try again later. I can rename the file and save it, but when I open the new file again and try to save that, I get the same message again. No one else is using the files and I have done the following to try and resolve this:
- deleted my profile on my primary Windows XP SP3 PC
- went to a Windows 7 PC with the same results.
- Ran Process Explorer to see which service has the file in use and got the message non-existent process

This only appears to be happening in Excel 2007, Word and PowerPoint are fine and no other users are reporting this issue. Has anyone else seen this happen?

Thanks for your help!!
 

A:Cant save Excel file, file is in use

Read other 8 answers
RELEVANCY SCORE 79.2

Hi,
does anyone know of software or similar that makes it idiot proof for generating a google shopping xml feed from a .txt file? I currently do just upload a .txt file in the merchant centre, but I am doing something different with a local business aggregator site that has specifically said they need my info in google shopping xml feed format. Having looked around I am surprised I can't quickly find a tool that would do it. You might think google would provide one, but hey ho. Any help very greatly appreciated as always. Attached is a couple of lines of what I am trying to convert. We sell books by the way. Well, comics and graphic novels to be precise. I guess it should be relatively easy to just do it manually but I can't find particularly clear information on how to do the mappings, or decent sample xml feed examples on the google merchant help pages.
many thanks,
Jonathan
 

A:Easy way / software to convert text file to google shopping xml feed

Do you have an example of the xml needed?
 

Read other 1 answers
RELEVANCY SCORE 79.2

Hi there! Can anyone direct me to a way to convert HTML files to Excel or CSV, freeware o ron-line? Please!

Here's a short example of the files' contents

Code:
<?xml version="1.0" encoding="UTF-8"?>

-<CRC>


+<Sample Number="0">


-<Sample Number="1">

<Time>20/03/2014 11:02:42</Time>

<Downstream>0.0</Downstream>

<Upstream>0.0</Upstream>

<DrawBlank>False</DrawBlank>

</Sample>


-<Sample Number="2">

<Time>20/03/2014 11:03:42</Time>

<Downstream>0.0</Downstream>

<Upstream>0.0</Upstream>

<DrawBlank>False</DrawBlank>

</Sample>


-<Sample Number="3">

<Time>20/03/2014 11:04:42</Time>

<Downstream>0.0</Downstream>

<Upstream>0.0</Upstream>

<DrawBlank>False</DrawBlank>

</Sample>


-<Sample Number="4">

<Time>20/03/2014 11:05:42</Time>

<Downstream>0.0</Downstream>

<Upstream>0.0</Upstream>

<DrawBlank>False</DrawBlank>

A:Convert HTML file to Excel or CSV

On my machine all that's required is to rename a copy of the .html file with the .csv extension.

I say a "copy" so that you're not changing the properties of the original file!

Default software for reading html files on my machine is Cyberfox 64 bit.

Default software for reading csv files on my machine is SoftMaker FreeOffice (Planmaker)

I have other browsers and office suites that can handle the same files!
.

Read other 5 answers