Hi,
I had to export 3,000 contacts from a black berry to excel. However when I exported them all the contacts are jumbled in the cvs file. It seems as though when a field was empty (ie car phone) data that should have been in the next column (ie cell phone) falls in the wrong column. Right now I am manually correcting this problem.
Is there a way to do the export so this does not happen? Is there a way to more easily fix this in excel without going row by row, column by column?
I am desperate!!!!!! Any feedback would be great! Thanks.
Copyright © 2024 Q2A.ES - All rights reserved.
Answers & Comments
Verified answer
if its exporting incorrectly, then theres not much you can do in Excel.
excel is not going to know where the extra commas should and shouldnt be.
open up the csv file in Notepad, and
take a look at the csv file, and look for a row that didnt work....look closely and count the commas.
- each column should be separated by a comma
- if a column has no data, then HOPE that you see 2 commas in a row
- if you only see 1 comma, then you are out of luck
- if you do see 2 commas, then you might be ok...
try this just in case you see 2 commas in a row
- open up Excel
- click file (if you have excel 2007 then Import is under the Data tab menu)
- click import
- import your csv file
- you should get the text import wizard
- click delimited then Next
- put a check mark next to comma...and make sure theres no checkmark next to "treat consecutive delimiters as one"
- click finish
hope that works.
since you have a blackberry and you have a Yahoo Email account.....
- have you tried to sync your blackberry and choose Yahoo when you Sync?
- then click on some of the contacts that you had trouble with in the csv file, and see if it looks ok
- then export from Yahoo to a csv
just a thought