| Index | Recent Threads | Unanswered Threads | Who's Active | Guidelines | Search |
 |
World Community Grid Forums
Category: Support
Forum: Website Support
Thread: Problem vith history.csv export in excel |
| No member browsing this thread |
|
Thread Status: Active Total posts in this thread: 5
|
|
| Author |
|
|
Buro87 [Lombardia]
Cruncher ITALY Joined: Mar 11, 2014 Post Count: 28 Status: Offline Project Badges: 
|
Hi all,
----------------------------------------I've tried to export result by downloading the .csv file After opening vit Excel, i've notice that all text in only in 1 column (A) rather of being separated into multiple columns instead There is a way to fix it thanks  |
||
|
|
Bryn Mawr
Senior Cruncher Joined: Dec 26, 2018 Post Count: 384 Status: Offline Project Badges: 
|
Hi all, I've tried to export result by downloading the .csv file After opening vit Excel, i've notice that all text in only in 1 column (A) rather of being separated into multiple columns instead There is a way to fix it thanks Check whether the Excel import routine allows you to change the field separator to a comma - it works fine if you do that. |
||
|
|
Crystal Pellet
Veteran Cruncher Joined: May 21, 2008 Post Count: 1403 Status: Offline Project Badges: 
|
Rename the .csv file to .txt and open that .txt file in Excel.
Excel will guide you with importing the different columns. |
||
|
|
Bryn Mawr
Senior Cruncher Joined: Dec 26, 2018 Post Count: 384 Status: Offline Project Badges:
|
Rename the .csv file to .txt and open that .txt file in Excel. Excel will guide you with importing the different columns. Thank you, too long since I’ve used Excel and I couldn’t remember how to get into the config set up. |
||
|
|
Sgt.Joe
Ace Cruncher USA Joined: Jul 4, 2006 Post Count: 7844 Status: Offline Project Badges: 
|
Also under the data tab is a "text to columns" entry. Highlight the first column and then access this tab. Follow the prompts and you will see the columns properly. Then save it it as an excel type format i.e .xls, xlsx, or ods (open data spreadsheet).
----------------------------------------Cheers,
Sgt. Joe
*Minnesota Crunchers* |
||
|
|
|