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.
Topic summary
A user encountered the error “Any value after quoted field isn’t allowed in line 1” when attempting to import a CSV file of products from a non-Shopify store.
Initial troubleshooting:
- Removing a leading space from the first line allowed Shopify to accept the file, but resulted in missing product titles and prices.
- The CSV structure appears incompatible with Shopify’s format, containing custom fields like “p_id”, “p_model”, “p_stock”, and various language-specific attributes not recognized by Shopify.
Root cause identified:
- The issue stems from inconsistent line endings in the CSV file. Shopify rejects files containing mixed CRLF (\r\n) line breaks.
- Files must use either CR (\r) or LF (\n) consistently throughout—never both.
- When CRLF appears (commonly after header rows), Shopify misinterprets the LF character as content, triggering the “quoted field” error.
Suggested solutions:
- Standardize all line endings to either CR or LF before importing.
- Export a sample Shopify product CSV to understand the required column structure and format the source file accordingly.
- Consider using third-party tools like Mixtable for bulk imports with a more flexible spreadsheet interface.
The discussion remains open with no confirmation of successful import.
1 Like
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
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
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 |
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.
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.