MajorGeeks Support Forums

Go Back   MajorGeeks Support Forums > ----------= PC, Desktop and Laptop Support =---------- > Software
Register FAQ Members List Calendar Casino Mark Forums Read

Software Software such as operating systems like Windows XP, Windows Vista, Windows 7 etc., or specific programs.


Reply
 
Thread Tools Display Modes
  #1  
Old 10-20-09, 17:12
proudtexan proudtexan is offline
Private E-2
 
Join Date: Oct 2009
Posts: 21
Thanks: 0
Thanked 0 Times in 0 Posts
Default converting text to csv file

i was wondering if there is any free tools that will let ya scan and covert a
scan file into lets say csv format to import in to a address book
Reply With Quote
Sponsored links
  #2  
Old 10-20-09, 17:16
studiot's Avatar
studiot studiot is offline
Major Geek
 
Join Date: Jan 2007
Location: Somerset UK
Posts: 4,188
Thanks: 4
Thanked 125 Times in 119 Posts
Default Re: converting text to csv file

A good free spreadsheet such as the one with Open Office will do this.

Perhaps you already have Excel this will also do this.
__________________
'If it ain't broke'
Fix it until it is'
Reply With Quote
  #3  
Old 10-20-09, 21:38
proudtexan proudtexan is offline
Private E-2
 
Join Date: Oct 2009
Posts: 21
Thanks: 0
Thanked 0 Times in 0 Posts
Default Re: converting text to csv file

well i have open office but what program in that suite works to convert to csv
Reply With Quote
  #4  
Old 10-21-09, 06:28
alan12345 alan12345 is offline
Private First Class
 
Join Date: Oct 2009
Location: Lancashire U.K.
Posts: 59
Thanks: 1
Thanked 3 Times in 3 Posts
Default Re: converting text to csv file

Calc is the Open Office equivalent to Excel.

Use that and import via
Insert => "Sheet from File ..."

That will import a text file and then it can be manipulated / sorted / etc and then saved as a *.csv.

To start with you need a text file from a Scan.

I prefer "SysExporter" which is free from http://www.nirsoft.net/
With that I can select any running application and capture its data into one of several data formatted text files, one of which is ready for Calc to import.
It is able to capture "The list of emails and contacts in Outlook Express".

SysExporter is VERY versatile
e.g. If I launch Task Manager and then minimise it to the task bar,
SysExporter can still see AND EXPORT every process that Task Manager knows of, even if there are too many processes to see without scrolling.

Alan
Reply With Quote
  #5  
Old 10-22-09, 18:16
proudtexan proudtexan is offline
Private E-2
 
Join Date: Oct 2009
Posts: 21
Thanks: 0
Thanked 0 Times in 0 Posts
Default Re: converting text to csv file

ok i scan saved it as a text filr with wordpad then imported it into open office calc and saved it as a excel document xls then used a program called convert xls. all the info for my contacts such as email phone numbers etc was there after i converted the document. but once i imported it to my address book nothing was there but phone numbers not even the contacts name. what can i be doing wrong. i follow all the steps
Reply With Quote
Sponsored links
  #6  
Old 10-23-09, 05:17
alan12345 alan12345 is offline
Private First Class
 
Join Date: Oct 2009
Location: Lancashire U.K.
Posts: 59
Thanks: 1
Thanked 3 Times in 3 Posts
Default Re: converting text to csv file

You started right but finished wrong.

I think I remember exporting an address book from Thunderbird as a *.csv file and importing to Gmail without difficulty.

SysExporter can export a TAB delimitted file that CALC etc can import, and then you can alter the order of the columns as required, and the CALC can "Save As" a CSV file which is what Gmail wants.

I see no point in creating a XLS document and having Convert.XLS change it to some other format

Alan
Reply With Quote
  #7  
Old 10-27-09, 05:48
proudtexan proudtexan is offline
Private E-2
 
Join Date: Oct 2009
Posts: 21
Thanks: 0
Thanked 0 Times in 0 Posts
Default Re: converting text to csv file

seems like converting the file as xls is the easiest way i cant figure out the sysexporter since the file im looking for doesnt show up with this program. its weird with the calc method how all the info like addresses emails etc shows up but once i import it to address book it doesnt show any info. man this is proven harder than i thought
Reply With Quote
  #8  
Old 10-27-09, 12:26
foogoo's Avatar
foogoo foogoo is offline
Major Geek
 
Join Date: Jul 2004
Location: SW Ohio
Posts: 2,469
Thanks: 1
Thanked 262 Times in 239 Posts
Default Re: converting text to csv file

A CSV or comma separated value file can be made with notepad.
Scan or whatever you need to get the data in to notepad. Arrage the data in the fields so they look correct same
first name, last name, address, phone, email..
first name, last name, address, phone, email..
first name, last name, address, phone, email..

save this as "address.csv"
Now open it in Excel (or like)
Now you can cut and move the columns of data in the order they will be imported say you need last name first. Maybe this is why the fields are not populating - they are not in order.

Then save it as an xls file and try importing. or save it as a CSV and import it.
Whatever you need.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Converting text Aragon Software 3 11-08-08 18:06
File Converting Mista Shadow Software 2 03-08-08 11:59
I need help with file converting... toastface5 Software 4 10-04-07 11:41
Converting Microsoft Word to Text British TV Nut Software 4 10-27-05 16:59
I'm having trouble converting a file Mickoo Software 0 09-24-05 01:57


All times are GMT -5. The time now is 03:26.

MajorGeeks.Com Menu

MajorGeeks.Com \ All In One Tweaks \ Android \ Anti-Malware \ Anti-Virus \ Appearance \ Backup \ Browsers \ CD\DVD\Blu-Ray \ Covert Ops \ Drive Utilities \ Drivers \ Graphics \ Internet Tools \ Multimedia \ Networking \ Office Tools \ NEW! PC Games \ System Tools \ Macintosh \ Demonews.Com \ Top Downloads

MajorGeeks.Com \ News (Tech) \ Off Base (Other Websites News) \ Way Off Base (Offbeat Stories and Pics)

Social: Facebook \ YouTube \ Twitter \ Tumblr \ Pintrest \ RSS Feeds


All content Copyright MajorGeeks.com source code Powered by vBulletin® Version 3.8.4
Copyright © 2009 vBulletin Solutions, Inc. All rights reserved.
Ad Management by RedTyger