[Skip to main content](#vessel-content) # Convert Excel speadsheet to csv ## - **[charlesdh](/forum/user/33634-charlesdh "View charlesdh's Profile")** - [![charlesdh's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar33634.jpg)](/forum/user/33634-charlesdh "View charlesdh's Profile") Topic Author - [ Offline](/forum/user/33634-charlesdh) - Proficient with Excel Less More - Posts: 36 - Thank you received: 5 - - - - 11 years 8 months ago [\#192125](#192125) by [charlesdh](/forum/user/33634-charlesdh "View charlesdh's Profile") *[Convert Excel speadsheet to csv](/forum/9-commercial-jobs/875241-convert-excel-speadsheet-to-csv#192125 "Hello, If your looking for some one to help in converting a spreadsheet to csv format so you can upload it to "Hikashop". I may be able to help you. Attached you can see what I did for another user of Hikashop. You will note in the attachments this was not just a simple conversion. If interested please "PM" me with your request. The Example file is a short version of a spreadsheet that I converted. The other file is the csv file that was produced after coding.")* was created by *[charlesdh](/forum/user/33634-charlesdh "View charlesdh's Profile")* Hello, If your looking for some one to help in converting a spreadsheet to csv format so you can upload it to "Hikashop". I may be able to help you. Attached you can see what I did for another user of Hikashop. You will note in the attachments this was not just a simple conversion. If interested please "PM" me with your request. The Example file is a short version of a spreadsheet that I converted. The other file is the csv file that was produced after coding. *This attachment is hidden for guests. Please log in or register to see it.* *This attachment is hidden for guests. Please log in or register to see it.* Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzktY29tbWVyY2lhbC1qb2JzLzg3NTI0MS1jb252ZXJ0LWV4Y2VsLXNwZWFkc2hlZXQtdG8tY3N2P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[milesreid](/forum/user/37491-milesreid "View milesreid's Profile")** - [![milesreid's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/37491-milesreid "View milesreid's Profile") - [ Offline](/forum/user/37491-milesreid) Less More - Posts: 17 - Thank you received: 0 - - 11 years 4 months ago [\#206427](#206427) by [milesreid](/forum/user/37491-milesreid "View milesreid's Profile") Replied by *[milesreid](/forum/user/37491-milesreid "View milesreid's Profile")* on topic *[Convert Excel speadsheet to csv](/forum/9-commercial-jobs/875241-convert-excel-speadsheet-to-csv#206427 "Hello, If your looking for some one to help in converting a spreadsheet to csv format so you can upload it to "Hikashop". I may be able to help you. Attached you can see what I did for another user of Hikashop. You will note in the attachments this was not just a simple conversion. If interested please "PM" me with your request. The Example file is a short version of a spreadsheet that I converted. The other file is the csv file that was produced after coding.")* Hi Charlesdh Your demo CSV file is helpful, but what is really difficult to work out from the Hikashop documentation is how to import multiple attributes for a product - for example, images, categories, and above all, Variants. If I am selling a Dress that is available in two colours - blue and red, and each colour is available in two sizes - size 10, and size 12 how do I do this? Similarly, I might want to assign two categories to that dress - "Evening Wear" and "Dresses", and to relate two images to it "Image_1.jpg" and "Image_2.jpg" Any help would be gratefully received! Miles Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzktY29tbWVyY2lhbC1qb2JzLzg3NTI0MS1jb252ZXJ0LWV4Y2VsLXNwZWFkc2hlZXQtdG8tY3N2P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[charlesdh](/forum/user/33634-charlesdh "View charlesdh's Profile")** - [![charlesdh's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar33634.jpg)](/forum/user/33634-charlesdh "View charlesdh's Profile") Topic Author - [ Offline](/forum/user/33634-charlesdh) - Proficient with Excel Less More - Posts: 36 - Thank you received: 5 - - - - 11 years 4 months ago [\#206464](#206464) by [charlesdh](/forum/user/33634-charlesdh "View charlesdh's Profile") Replied by *[charlesdh](/forum/user/33634-charlesdh "View charlesdh's Profile")* on topic *[Convert Excel speadsheet to csv](/forum/9-commercial-jobs/875241-convert-excel-speadsheet-to-csv#206464 "Hello, If your looking for some one to help in converting a spreadsheet to csv format so you can upload it to "Hikashop". I may be able to help you. Attached you can see what I did for another user of Hikashop. You will note in the attachments this was not just a simple conversion. If interested please "PM" me with your request. The Example file is a short version of a spreadsheet that I converted. The other file is the csv file that was produced after coding.")* HI, The info I posed was using excel vba code that combined "Category" and "Sub Category". From what I understand if you already have the data in "HikaShop" you can export it. This will show you the "Csv" for the product. If you have a spreadsheet that needs to be converted you can "PM" me. You may also find this like helpful. [ www.hikashop.com/forum/import-export-csv...categories-tree.html](http://www.hikashop.com/forum/import-export-csv-xls/876305-import-of-categories-tree.html) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzktY29tbWVyY2lhbC1qb2JzLzg3NTI0MS1jb252ZXJ0LWV4Y2VsLXNwZWFkc2hlZXQtdG8tY3N2P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[milesreid](/forum/user/37491-milesreid "View milesreid's Profile")** - [![milesreid's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/37491-milesreid "View milesreid's Profile") - [ Offline](/forum/user/37491-milesreid) Less More - Posts: 17 - Thank you received: 0 - - 11 years 4 months ago [\#206478](#206478) by [milesreid](/forum/user/37491-milesreid "View milesreid's Profile") Replied by *[milesreid](/forum/user/37491-milesreid "View milesreid's Profile")* on topic *[Convert Excel speadsheet to csv](/forum/9-commercial-jobs/875241-convert-excel-speadsheet-to-csv#206478 "Hello, If your looking for some one to help in converting a spreadsheet to csv format so you can upload it to "Hikashop". I may be able to help you. Attached you can see what I did for another user of Hikashop. You will note in the attachments this was not just a simple conversion. If interested please "PM" me with your request. The Example file is a short version of a spreadsheet that I converted. The other file is the csv file that was produced after coding.")* The main issue is how to format the CSV file to import variants. Yes, I have looked at the exported CSV but I still don't understand the format for the import of variants Can you help please? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzktY29tbWVyY2lhbC1qb2JzLzg3NTI0MS1jb252ZXJ0LWV4Y2VsLXNwZWFkc2hlZXQtdG8tY3N2P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[charlesdh](/forum/user/33634-charlesdh "View charlesdh's Profile")** - [![charlesdh's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar33634.jpg)](/forum/user/33634-charlesdh "View charlesdh's Profile") Topic Author - [ Offline](/forum/user/33634-charlesdh) - Proficient with Excel Less More - Posts: 36 - Thank you received: 5 - - - - 11 years 4 months ago [\#206486](#206486) by [charlesdh](/forum/user/33634-charlesdh "View charlesdh's Profile") Replied by *[charlesdh](/forum/user/33634-charlesdh "View charlesdh's Profile")* on topic *[Convert Excel speadsheet to csv](/forum/9-commercial-jobs/875241-convert-excel-speadsheet-to-csv#206486 "Hello, If your looking for some one to help in converting a spreadsheet to csv format so you can upload it to "Hikashop". I may be able to help you. Attached you can see what I did for another user of Hikashop. You will note in the attachments this was not just a simple conversion. If interested please "PM" me with your request. The Example file is a short version of a spreadsheet that I converted. The other file is the csv file that was produced after coding.")* See PM Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzktY29tbWVyY2lhbC1qb2JzLzg3NTI0MS1jb252ZXJ0LWV4Y2VsLXNwZWFkc2hlZXQtdG8tY3N2P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[charlesdh](/forum/user/33634-charlesdh "View charlesdh's Profile")** - [![charlesdh's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar33634.jpg)](/forum/user/33634-charlesdh "View charlesdh's Profile") Topic Author - [ Offline](/forum/user/33634-charlesdh) - Proficient with Excel Less More - Posts: 36 - Thank you received: 5 - - - - 11 years 4 months ago [\#206552](#206552) by [charlesdh](/forum/user/33634-charlesdh "View charlesdh's Profile") Replied by *[charlesdh](/forum/user/33634-charlesdh "View charlesdh's Profile")* on topic *[Convert Excel speadsheet to csv](/forum/9-commercial-jobs/875241-convert-excel-speadsheet-to-csv#206552 "Hello, If your looking for some one to help in converting a spreadsheet to csv format so you can upload it to "Hikashop". I may be able to help you. Attached you can see what I did for another user of Hikashop. You will note in the attachments this was not just a simple conversion. If interested please "PM" me with your request. The Example file is a short version of a spreadsheet that I converted. The other file is the csv file that was produced after coding.")* Hi, Can you post the "Csv" file you downloaded? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzktY29tbWVyY2lhbC1qb2JzLzg3NTI0MS1jb252ZXJ0LWV4Y2VsLXNwZWFkc2hlZXQtdG8tY3N2P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[milesreid](/forum/user/37491-milesreid "View milesreid's Profile")** - [![milesreid's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/37491-milesreid "View milesreid's Profile") - [ Offline](/forum/user/37491-milesreid) Less More - Posts: 17 - Thank you received: 0 - - 11 years 4 months ago - 11 years 4 months ago [\#206554](#206554) by [milesreid](/forum/user/37491-milesreid "View milesreid's Profile") Replied by *[milesreid](/forum/user/37491-milesreid "View milesreid's Profile")* on topic *[Convert Excel speadsheet to csv](/forum/9-commercial-jobs/875241-convert-excel-speadsheet-to-csv#206554 "Hello, If your looking for some one to help in converting a spreadsheet to csv format so you can upload it to "Hikashop". I may be able to help you. Attached you can see what I did for another user of Hikashop. You will note in the attachments this was not just a simple conversion. If interested please "PM" me with your request. The Example file is a short version of a spreadsheet that I converted. The other file is the csv file that was produced after coding.")* *This attachment is hidden for guests. Please log in or register to see it.* Hi Charles: I am attaching the file (Hikashop_export1. *This attachment is hidden for guests. Please log in or register to see it.* csv)that I exported from Hikashop - a product which had two characteristics - "Dress Size" and "Colour". The exported file did not help much with the variants, but I managed to figure it out and I attach an excel version of the CSV that worked well (TesImport1.xlsx). I hope that this will help others Best wishes Miles Last edit: 11 years 4 months ago by [milesreid](/forum/user/37491-milesreid "View milesreid's Profile"). Reason: Omitted to attach second file Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzktY29tbWVyY2lhbC1qb2JzLzg3NTI0MS1jb252ZXJ0LWV4Y2VsLXNwZWFkc2hlZXQtdG8tY3N2P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[charlesdh](/forum/user/33634-charlesdh "View charlesdh's Profile")** - [![charlesdh's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar33634.jpg)](/forum/user/33634-charlesdh "View charlesdh's Profile") Topic Author - [ Offline](/forum/user/33634-charlesdh) - Proficient with Excel Less More - Posts: 36 - Thank you received: 5 - - - - 11 years 4 months ago [\#206557](#206557) by [charlesdh](/forum/user/33634-charlesdh "View charlesdh's Profile") Replied by *[charlesdh](/forum/user/33634-charlesdh "View charlesdh's Profile")* on topic *[Convert Excel speadsheet to csv](/forum/9-commercial-jobs/875241-convert-excel-speadsheet-to-csv#206557 "Hello, If your looking for some one to help in converting a spreadsheet to csv format so you can upload it to "Hikashop". I may be able to help you. Attached you can see what I did for another user of Hikashop. You will note in the attachments this was not just a simple conversion. If interested please "PM" me with your request. The Example file is a short version of a spreadsheet that I converted. The other file is the csv file that was produced after coding.")* HI, Thanks for letting us know. If you need code work for your file please contact me! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzktY29tbWVyY2lhbC1qb2JzLzg3NTI0MS1jb252ZXJ0LWV4Y2VsLXNwZWFkc2hlZXQtdG8tY3N2P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.068 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)