• All Community
    • All Community
    • Forums
    • Ideas
    • Blogs
Advanced

Not what you are looking for? Ask the experts!

Kudos0

sort csv file from identity safe

I am having problems sorting everything correctly from identity safe. Can some one help?

Labels: Logins

Replies

Kudos0

Re: sort csv file from identity safe

What are you trying to sort? How are you viewing the csv file?

Things happen. Export/Backup your Identity Safe data.
Kudos0

Re: sort csv file from identity safe

I have opened it up in an Excel but can't figure out how to sort all the data. I tried in Notepad but that made no sense. I know a little about Excel but don't work with it all the time. Any help would be great.

I believe it starts like url,username,password,name,grouping,extra

the next several lines are data matching above in CSV ex. http : / / helpme . com, Iam,password,iam2, you get the picture. Any suggestions on how to sort data like this?

Kudos0

Re: sort csv file from identity safe

You need to use the data formatting features of Excel to do this. Use the Excel Help function to figure out the process.

Things happen. Export/Backup your Identity Safe data.
Kudos0

Re: sort csv file from identity safe

Hi cmedina,

The following info may be helpful:

https://community.norton.com/en/comment/7483941#comment-7483941

Kudos0

Re: sort csv file from identity safe

I think cmedina is trying to format the output in Excel in a different order than it is presented from the csv file. Maybe alphabetically??? 

I know it can be done with Excel, but I have not done it for many years now, so I would only be quoting the Excel help files.

Things happen. Export/Backup your Identity Safe data.
Kudos0

Re: sort csv file from identity safe

This is how it should be done. Trust me it took awhile to figure this out.

tep 1. Excel: Import Your CSV file into a Spreadsheet

In Excel, create a new workbook. Then select the Import option from the Filemenu.

A dialog box will pop up. Make sure CSV file is selected and click the Importbutton.

You can now select your CSV file from where you have saved it.

Step 2. Excel: Confirm Your Data is ‘Delimited’

In Excel, you will now be asked to confirm that your data is delimited. That is, your CSV file is filled with data separated only by a comma. Excel should be able to automatically tell that this is correct. Now click the Next button.

Step 3. Excel: Confirm Your Data Columns

In Excel, you will now be shown a preview of how your data will be sorted into columns, based on the fact that your data is separated by commas, and text items may be enclosed in “inverted commas”. Check the data preview, and select or deselect delimiter options and text qualifier options until the preview reflects how you expect the data to look. In most of these cases, this will be chosen for you automatically. For example, Excel will know that all text data has a text qualifier of inverted commas, so it will let you know it plans to remove the inverted commas when it imports the data. When you are happy with how the data will be imported, click the Next button.

Step 4. Excel: Confirm Data Types

In Excel, you will now be asked to select what type of data is in each row. Select General for all columns now (we will customize each column of data after it is imported). Double-check the advanced setting to ensure your data reflects standard conventions for numbers in their thousands and for decimal places.

So depending on your original data source, you may need to change these settings.

Now click the Finish button to import the CSV data into your Excel spreadsheet.

This thread is closed from further comment. Please visit the forum to start a new thread.