VGCollect Forum

VGCollect Site Stuff => Site Feedback => Topic started by: patocriollo on June 13, 2016, 04:08:52 pm

Title: Excel sheet is a mess, is this how it's supposed to be?
Post by: patocriollo on June 13, 2016, 04:08:52 pm

Hi! First topic here. Sorry if this is not the right place to talk about this.

I've only just opened an account here, and just for the heck of it tried exporting an Excel sheet to see how it'd look, how the info was displayed, but what I get is this:

(http://i.imgur.com/s7cqdbV.jpg)

Is that right? It's not readable. Should I change settings on Excel to have the list display correctly? Should I use a newer version (this PC has Office 2007)?

Any help you could give on this regard, to make the Excel list useable, would be appreciated.

Thanks in advance!

Title: Re: Excel sheet is a mess, is this how it's supposed to be?
Post by: rayne315 on June 13, 2016, 04:39:28 pm

Quote from: patocriollo on June 13, 2016, 04:08:52 pm

Hi! First topic here. Sorry if this is not the right place to talk about this.

I've only just opened an account here, and just for the heck of it tried exporting an Excel sheet to see how it'd look, how the info was displayed, but what I get is this:

Is that right? It's not readable. Should I change settings on Excel to have the list display correctly? Should I use a newer version (this PC has Office 2007)?

Any help you could give on this regard, to make the Excel list useable, would be appreciated.

Thanks in advance!

I cant help out much as I am not an excel guru but I believe you can modify the info to display only the info you want and then sort it through one of the tabs to be like in order of how much you spent on an item, when you added it to your collection, or just in alphabetical order.

For reference VGC id means the number of the listing you entered into your collection. Name is the title of the game. Platform is what platform you own it for. Notes just adds any notes you manually added upon entry. Cart, Box, Manuel, Other are either maked yes if you indicated you own it or no if you indicated you didn't. purchased price is what you manuely entered you bought the item for. purchase date is when you entered you bought it. and finally added is just the timestamp the server recorded when you entered it into your collection.

In other words you can just look directly after the first numbers to see your game title.

Title: Re: Excel sheet is a mess, is this how it's supposed to be?
Post by: desocietas on June 13, 2016, 05:23:07 pm

You'll want to choose a "delimited" excel sheet (when you import/open the list) and have it separate your data by commas. I believe that should make it into some nice columns for sorting.

Title: Re: Excel sheet is a mess, is this how it's supposed to be?
Post by: telly on June 13, 2016, 07:16:43 pm

Try highlighting the far left column in excel only, then going to data and select "text to columns" it should separate each line of characters into a separate column :)

Title: Re: Excel sheet is a mess, is this how it's supposed to be?
Post by: patocriollo on June 14, 2016, 12:45:22 am

Thanks, guys! Using "Data>Text and Columns>Delimited>Comma" allowed me to separate the info just fine, and I was able to get this:

(http://i.imgur.com/pyKJfgL.jpg)

Now I'm confident I'll have a nice Excel sheet once I've loaded all my games.

Thanks a lot!

Title: Re: Excel sheet is a mess, is this how it's supposed to be?
Post by: desocietas on June 14, 2016, 01:06:49 am

Yay! Glad you got it all sorted out :D