| :: |
| Author |
Message |
gnye207
Joined: 15 Mar 2011
Posts: 2
|
| Posted: Tue Mar 22, 2011 7:10 pm Post subject: How do upload an CSV file? |
|
|
Does anyone know how I load an csv file to the ecommerce hosting site if I'm using Open Office? I am using Compgallery.com as my supplier.
Thank You, Gary Nye |
|
| Back to top |
|
things4u
Joined: 21 Jan 2007
Posts: 1331
|
| Posted: Tue Mar 22, 2011 7:35 pm Post subject: Re: How do upload an CSV file? |
|
|
read here
http://vasc.ri.cmu.edu/old_help/Archiving/Cvs/cvs_tutorial.texinfo.html |
|
| Back to top |
|
gnye207
Joined: 15 Mar 2011
Posts: 2
|
| Posted: Tue Mar 22, 2011 9:52 pm Post subject: |
|
|
| I have bookmarked this site. I thank you very kindly. |
|
| Back to top |
|
mojavelyn
Joined: 25 Feb 2005
Posts: 8084
Location: Mojave Desert CA 120 miles from civilization
|
| Posted: Tue Mar 22, 2011 11:21 pm Post subject: |
|
|
if you are using Open Office spreadsheet, save it as a tab delimited instead of CSV. Tab delimited is easier to work with. And copy your spreadsheet as a tab delimited to a Notepad, by highlighting text areas only, and pasting to notepad.
If your item descriptions have any commas, it will throw your CSV off.
Set your notepad format to no-wordwrap. to make sure you have it correct, you can copy and paste from notepad to spreadsheet and it should be in the cells of the spreadsheet.
By using notepad, you don't have programming to contend, only tabs. |
|
| Back to top |
|
| |
