How can I resolve a CSV import error on my online store?

[LukasMcLean]

I tried to upload a csv file with products from a different shop I have (not Shopify). When I upload it I get this error: "Any value after quoted field isn't allowed in line 1."

I don't know how to fix it.

[Ecommpremium]

kindly open csv in excel and chage the csv format accordngly like by looking at exporting one shopify product of your store csv template so all values in the top should be same like handel id etc @LukasMcLean 

[Ablestar_Daniel]

Hi Lukas,

Could you check the CSV file and see if there's any extra spaces at the end of the lines? If a line looks like this most spreadsheet programs will open it but Shopify might reject it:

"Product title","Variant price"[SPACE]

If that doesn't work could you attach the first couple lines of the file and I can take a look?

Best,

Daniel

[LukasMcLean]

I had a space at the start of the first line and deleted it and then shopify accepted the file, but I dont think this will work with my csv file. Once it loaded there was no product title neither a price. I guess I cant import it like this from my other shop.

These are the first lines:

XTSOL|"p_id"|"p_model"|"p_stock"|"p_sorting"|"p_startpage"|"p_startpage_sort"|"p_shipping"|"p_tpl"|"p_opttpl"|"p_manufacturer"|"p_fsk18"|"p_priceNoTax"|"p_priceNoTax.1"|"p_priceNoTax.2"|"p_priceNoTax.3"|"p_tax"|"p_status"|"p_weight"|"p_ean"|"code_isbn"|"code_upc"|"code_mpn"|"code_jan"|"brand_name"|"p_disc"|"p_date_added"|"p_last_modified"|"p_date_available"|"p_ordered"|"nc_ultra_shipping_costs"|"gm_show_date_added"|"gm_show_price_offer"|"gm_show_weight"|"gm_show_qty_info"|"gm_price_status"|"gm_min_order"|"gm_graduated_qty"|"gm_options_template"|"p_vpe"|"p_vpe_status"|"p_vpe_value"|"p_image.1"|"p_image.2"|"p_image.3"|"p_image"|"p_name.en"|"p_desc.en"|"p_shortdesc.en"|"p_checkout_information.en"|"p_meta_title.en"|"p_meta_desc.en"|"p_meta_key.en"|"p_keywords.en"|"p_url.en"|"gm_url_keywords.en"|"rewrite_url.en"|"p_name.de"|"p_desc.de"|"p_shortdesc.de"|"p_checkout_information.de"|"p_meta_title.de"|"p_meta_desc.de"|"p_meta_key.de"|"p_keywords.de"|"p_url.de"|"gm_url_keywords.de"|"rewrite_url.de"|"p_cat.en"|"p_cat.de"|"google_export_availability"|"google_export_condition"|"google_category"|"p_img_alt_text.en"|"p_img_alt_text.1.en"|"p_img_alt_text.2.en"|"p_img_alt_text.3.en"|"p_img_alt_text.de"|"p_img_alt_text.1.de"|"p_img_alt_text.2.de"|"p_img_alt_text.3.de"|"p_group_permission.0"|"p_group_permission.1"|"p_group_permission.2"|"p_group_permission.3"|"specials_qty"|"specials_new_products_price"|"expires_date"|"specials_status"|"gm_priority"|"gm_changefreq"|"gm_sitemap_entry"|"p_qty_unit_id"|"p_type"|"Zusatzfeld: OpelNr.: .de [3]"|"Zusatzfeld: OpelNr.: .en [3]"|"Zusatzfeld: Siemens - Teilenummer.de [5]"|"Zusatzfeld: Siemens - Teilenummer.en [5]"|"Zusatzfeld: Siemens - Nr..de [6]"|"Zusatzfeld: Siemens - Nr..en [6]"|"Zusatzfeld: TRW - Nr..de [7]"|"Zusatzfeld: TRW - Nr..en [7]"|"Zusatzfeld: Bosch - Nr. .de [8]"|"Zusatzfeld: Bosch - Nr. .en [8]"|"Zusatzfeld: Neu - Preis.de [9]"|"Zusatzfeld: Neu - Preis.en [9]"|"Zusatzfeld: Mercedes - Nummer.de [10]"|"Zusatzfeld: Mercedes - Nummer.en [10]"|"Zusatzfeld: Mobis - Nr..de [11]"|"Zusatzfeld: Mobis - Nr..en [11]"|"p_property_image_list_id"|"Zusatzfeld: Becker - Nr. .de [12]"|"Zusatzfeld: Becker - Nr. .en [12]"|"Zusatzfeld: Artikel Nr..de [13]"|"Zusatzfeld: Artikel Nr..en [13]"|"Zusatzfeld: Ersatz-Teilenr..de [14]"|"Zusatzfeld: Ersatz-Teilenr..en [14]"|"Zusatzfeld: Siemens Nr..de [15]"|"Zusatzfeld: Siemens Nr..en [15]"|"Zusatzfeld: Autoliv Nr..de [16]"|"Zusatzfeld: Autoliv Nr..en [16]"|"Zusatzfeld: BMW Nr..de [17]"|"Zusatzfeld: BMW Nr..en [17]"|"Zusatzfeld: Verfügbarkeit:.de [18]"|"Zusatzfeld: Verfügbarkeit:.en [18]"|"Zusatzfeld: Zustand:.de [19]"|"Zusatzfeld: Zustand:.en [19]"|"Zusatzfeld: Temic-Nr.de [20]"|"Zusatzfeld: Temic-Nr.en [20]"

XTSOL|"3"|""|"0.0000"|"0"|"0"|"0"|"1"|"standard.html"|"default"|"0"|"0"|"50.3361"|""|""|"1:45.7563"|"1"|"1"|"1.0000"|""|""|""|""|""|""|"0.00"|"2016-07-14 13:20:34"|"2024-03-14 16:58:38"|"1000-01-01 00:00:00"|"557.0000"|"0.0000"|"0"|"1"|"0"|"0"|"0"|"1.0000"|"1.0000"|"default"|"0"|"0"|"0.0000"|""|""|""|"Sim_mercedes_allgemein_shop.jpg"|""|""|""|""|""|""|""|""|""|"product-3"|""|"Mercedes-Benz C-Klasse W203/S203 - Simulator für defekte Sitzbelegungsmatte für alle C-Klasse Modelle"|"<span style=""font-size:14px

XTSOL|"11"|"20300"|"0.0000"|"0"|"0"|"0"|"1"|"standard.html"|"default"|"0"|"0"|"40.2521"|""|""|""|"1"|"1"|"0.0000"|""|""|""|""|""|""|"0.00"|"2016-08-05 04:18:35"|"2024-03-11 18:07:12"|"1000-01-01 00:00:00"|"143.0000"|"0.0000"|"0"|"1"|"0"|"0"|"0"|"1.0000"|"1.0000"|"default"|"0"|"0"|"0.0000"|""|""|""|"bmw_sim_20300_11_0.jpg"|""|""|""|""|""|""|""|""|""|"product-10-11"|""|"BMW 3er E36 - Simulator für defekte Sitzbelegungsmatte"|"<span style=""font-size:14px

XTSOL|"15"|"SitzSim_W463"|"0.0000"|"0"|"0"|"0"|"1"|"standard.html"|"default"|"0"|"0"|"50.3361"|""|""|"1:45.7563"|"1"|"1"|"1.0000"|""|""|""|""|""|""|"0.00"|"2016-08-06 06:41:00"|"2024-03-12 10:43:54"|"1000-01-01 00:00:00"|"129.0000"|"0.0000"|"0"|"1"|"0"|"0"|"0"|"1.0000"|"1.0000"|"default"|"0"|"0"|"0.0000"|""|""|""|"Sim_mercedes_allgemein_shop_0.jpg"|""|""|""|""|""|""|""|""|""|"product-3-15"|""|"Mercedes-Benz G-Klasse W463 - Simulator für defekte Sitzbelegungsmatte"|"<span style=""font-size:14px

XTSOL|"15"|"SitzSim_W463"|"0.0000"|"0"|"0"|"0"|"1"|"standard.html"|"default"|"0"|"0"|"50.3361"|""|""|"1:45.7563"|"1"|"1"|"1.0000"|""|""|""|""|""|""|"0.00"|"2016-08-06 06:41:00"|"2024-03-12 10:43:54"|"1000-01-01 00:00:00"|"129.0000"|"0.0000"|"0"|"1"|"0"|"0"|"0"|"1.0000"|"1.0000"|"default"|"0"|"0"|"0.0000"|""|""|""|"Sim_mercedes_allgemein_shop_0.jpg"|""|""|""|""|""|""|""|""|""|"product-3-15"|""|"Mercedes-Benz G-Klasse W463 - Simulator für defekte Sitzbelegungsmatte"|"<span style=""font-size:14px

[BenSmith1]

If you are still looking, take a look at Mixtable. Mixtable's Excel-like spreadsheet allows you to  import products to your Shopify store in bulk   from a convenient and familiar spreadsheet interface. You can also easily select which products to edit.

[MacRicow]

I got the same issue and found the reason: as soon as you have only one line with a CRLF (\r\n) in your file, Shopify doesn't interpret it correctly. You need to ensure that your file has only CR (\r) or LF (\n) in it, never both. If the error says that the error is in line 2, that's probably because you added a header line with a CRLF at the end (that was my case): then Shopify will see the CR (\r) first then will consider the LF (\n) in the beginning of the second line as a content character which is not between quotes.

I never saw such a specification for CSV in Shopify documentation (maybe there's some missing information here…) and it took me a while to understand the issue.