[av_section min_height=” min_height_pc=’25’ min_height_px=’500px’ shadow=’no-border-styling’ bottom_border=’no-border-styling’ bottom_border_diagonal_color=’#333333′ bottom_border_diagonal_direction=” bottom_border_style=” padding=’default’ custom_margin=’0px’ custom_margin_sync=’true’ av-desktop-custom_margin=” av-desktop-custom_margin_sync=’true’ av-medium-custom_margin=” av-medium-custom_margin_sync=’true’ av-small-custom_margin=” av-small-custom_margin_sync=’true’ av-mini-custom_margin=” av-mini-custom_margin_sync=’true’ svg_div_top=” svg_div_top_color=’#333333′ svg_div_top_width=’100′ svg_div_top_height=’50’ svg_div_top_max_height=’none’ svg_div_top_opacity=” svg_div_bottom=” svg_div_bottom_color=’#333333′ svg_div_bottom_width=’100′ svg_div_bottom_height=’50’ svg_div_bottom_max_height=’none’ svg_div_bottom_opacity=” fold_type=” fold_height=” fold_more=’Read more’ fold_less=’Read less’ fold_text_style=” fold_btn_align=” color=’footer_color’ background=’bg_color’ custom_bg=” background_gradient_direction=’vertical’ background_gradient_color1=’#000000′ background_gradient_color2=’#ffffff’ background_gradient_color3=” src=” attachment=” attachment_size=” attach=’scroll’ position=’top left’ repeat=’no-repeat’ video=” video_ratio=’16:9′ overlay_opacity=’0.5′ overlay_color=” overlay_pattern=” overlay_custom_pattern=” custom_arrow_bg=” fold_overlay_color=” fold_text_color=” fold_btn_color=’theme-color’ fold_btn_bg_color=” fold_btn_font_color=” size-btn-text=” av-desktop-font-size-btn-text=” av-medium-font-size-btn-text=” av-small-font-size-btn-text=” av-mini-font-size-btn-text=” fold_timer=” z_index_fold=” css_position_z_index=” av-desktop-css_position_z_index=” av-medium-css_position_z_index=” av-small-css_position_z_index=” av-mini-css_position_z_index=” id=” custom_class=” template_class=” aria_label=” av_element_hidden_in_editor=’0′ av_uid=’av-4gyvff1′ sc_version=’1.0′]
[av_heading heading=’Solve CSV file UTF-8 Encoding issue’ tag=’h1′ style=’blockquote modern-quote’ subheading_active=” show_icon=” icon=’ue800′ font=’entypo-fontello’ size=” av-desktop-font-size-title=” av-medium-font-size-title=” av-small-font-size-title=” av-mini-font-size-title=” subheading_size=” av-desktop-font-size=” av-medium-font-size=” av-small-font-size=” av-mini-font-size=” icon_size=” av-desktop-font-size-1=” av-medium-font-size-1=” av-small-font-size-1=” av-mini-font-size-1=” color=” custom_font=” subheading_color=” seperator_color=” icon_color=” margin=” margin_sync=’true’ av-desktop-margin=” av-desktop-margin_sync=’true’ av-medium-margin=” av-medium-margin_sync=’true’ av-small-margin=” av-small-margin_sync=’true’ av-mini-margin=” av-mini-margin_sync=’true’ headline_padding=” headline_padding_sync=’true’ av-desktop-headline_padding=” av-desktop-headline_padding_sync=’true’ av-medium-headline_padding=” av-medium-headline_padding_sync=’true’ av-small-headline_padding=” av-small-headline_padding_sync=’true’ av-mini-headline_padding=” av-mini-headline_padding_sync=’true’ padding=’10’ av-desktop-padding=” av-medium-padding=” av-small-padding=” av-mini-padding=” icon_padding=’10’ av-desktop-icon_padding=” av-medium-icon_padding=” av-small-icon_padding=” av-mini-icon_padding=” link=” link_target=” title_attr=” id=” custom_class=” template_class=” av_uid=’av-4453mml’ sc_version=’1.0′ admin_preview_bg=”][/av_heading]
[/av_section]
[av_section min_height=” min_height_pc=’25’ min_height_px=’500px’ shadow=’no-border-styling’ bottom_border=’no-border-styling’ bottom_border_diagonal_color=’#333333′ bottom_border_diagonal_direction=” bottom_border_style=” padding=’default’ margin=” custom_margin=’0px’ av-desktop-custom_margin=” av-medium-custom_margin=” av-small-custom_margin=” av-mini-custom_margin=” svg_div_top=” svg_div_top_color=’#333333′ svg_div_top_width=’100′ svg_div_top_height=’50’ svg_div_top_max_height=’none’ svg_div_top_flip=” svg_div_top_invert=” svg_div_top_front=” svg_div_top_opacity=” svg_div_top_preview=” svg_div_bottom=” svg_div_bottom_color=’#333333′ svg_div_bottom_width=’100′ svg_div_bottom_height=’50’ svg_div_bottom_max_height=’none’ svg_div_bottom_flip=” svg_div_bottom_invert=” svg_div_bottom_front=” svg_div_bottom_opacity=” svg_div_bottom_preview=” fold_type=” fold_height=” fold_more=’Read more’ fold_less=’Read less’ fold_text_style=” fold_btn_align=” color=’main_color’ background=’bg_color’ custom_bg=” background_gradient_direction=’vertical’ background_gradient_color1=’#000000′ background_gradient_color2=’#ffffff’ background_gradient_color3=” src=” attach=’scroll’ position=’top left’ repeat=’no-repeat’ video=” video_ratio=’16:9′ video_mobile_disabled=” overlay_enable=” overlay_opacity=’0.5′ overlay_color=” overlay_pattern=” overlay_custom_pattern=” scroll_down=” custom_arrow_bg=” fold_overlay_color=” fold_text_color=” fold_btn_color=’theme-color’ fold_btn_bg_color=” fold_btn_font_color=” size-btn-text=” av-desktop-font-size-btn-text=” av-medium-font-size-btn-text=” av-small-font-size-btn-text=” av-mini-font-size-btn-text=” fold_timer=” z_index_fold=” css_position_z_index=” av-desktop-css_position_z_index=” av-medium-css_position_z_index=” av-small-css_position_z_index=” av-mini-css_position_z_index=” av-desktop-hide=” av-medium-hide=” av-small-hide=” av-mini-hide=” id=” custom_class=” template_class=” aria_label=” av_element_hidden_in_editor=’0′ av_uid=’av-3kw9hyl’ sc_version=’1.0′]
[av_one_third first min_height=” vertical_alignment=’av-align-top’ space=” row_boxshadow=” row_boxshadow_width=’10’ row_boxshadow_color=” custom_margin=” margin=’0px’ av-desktop-margin=” av-medium-margin=” av-small-margin=” av-mini-margin=” mobile_breaking=” mobile_column_order=” border=” border_style=’solid’ border_color=” radius=” min_col_height=” padding=” av-desktop-padding=” av-medium-padding=” av-small-padding=” av-mini-padding=” svg_div_top=” svg_div_top_color=’#333333′ svg_div_top_width=’100′ svg_div_top_height=’50’ svg_div_top_max_height=’none’ svg_div_top_flip=” svg_div_top_invert=” svg_div_top_front=” svg_div_top_opacity=” svg_div_top_preview=” svg_div_bottom=” svg_div_bottom_color=’#333333′ svg_div_bottom_width=’100′ svg_div_bottom_height=’50’ svg_div_bottom_max_height=’none’ svg_div_bottom_flip=” svg_div_bottom_invert=” svg_div_bottom_front=” svg_div_bottom_opacity=” svg_div_bottom_preview=” fold_type=” fold_height=” fold_more=’Read more’ fold_less=’Read less’ fold_text_style=” fold_btn_align=” column_boxshadow=” column_boxshadow_width=’10’ column_boxshadow_color=” background=’bg_color’ background_color=” background_gradient_direction=’vertical’ background_gradient_color1=’#000000′ background_gradient_color2=’#ffffff’ background_gradient_color3=” src=” background_position=’top left’ background_repeat=’no-repeat’ highlight=” highlight_size=” fold_overlay_color=” fold_text_color=” fold_btn_color=’theme-color’ fold_btn_bg_color=” fold_btn_font_color=” size-btn-text=” av-desktop-font-size-btn-text=” av-medium-font-size-btn-text=” av-small-font-size-btn-text=” av-mini-font-size-btn-text=” animation=” animation_duration=” animation_custom_bg_color=” animation_z_index_curtain=’100′ parallax_parallax=” parallax_parallax_speed=” av-desktop-parallax_parallax=” av-desktop-parallax_parallax_speed=” av-medium-parallax_parallax=” av-medium-parallax_parallax_speed=” av-small-parallax_parallax=” av-small-parallax_parallax_speed=” av-mini-parallax_parallax=” av-mini-parallax_parallax_speed=” fold_timer=” z_index_fold=” css_position=” css_position_location=” css_position_z_index=” av-desktop-css_position=” av-desktop-css_position_location=” av-desktop-css_position_z_index=” av-medium-css_position=” av-medium-css_position_location=” av-medium-css_position_z_index=” av-small-css_position=” av-small-css_position_location=” av-small-css_position_z_index=” av-mini-css_position=” av-mini-css_position_location=” av-mini-css_position_z_index=” link=” linktarget=” link_hover=” title_attr=” alt_attr=” mobile_display=” mobile_col_pos=’0′ id=” custom_class=” template_class=” aria_label=” av_uid=’av-34ilsfh’ sc_version=’1.0′]
[av_codeblock wrapper_element=” wrapper_element_attributes=” codeblock_type=” alb_description=” id=” custom_class=” template_class=” av_uid=’av-lth9x178′ sc_version=’1.0′]
[/av_codeblock]
[/av_one_third][av_two_third min_height=” vertical_alignment=’av-align-top’ space=” row_boxshadow=” row_boxshadow_width=’10’ row_boxshadow_color=” custom_margin=” margin=’0px’ av-desktop-margin=” av-medium-margin=” av-small-margin=” av-mini-margin=” mobile_breaking=” mobile_column_order=” border=” border_style=’solid’ border_color=” radius=” min_col_height=” padding=” av-desktop-padding=” av-medium-padding=” av-small-padding=” av-mini-padding=” svg_div_top=” svg_div_top_color=’#333333′ svg_div_top_width=’100′ svg_div_top_height=’50’ svg_div_top_max_height=’none’ svg_div_top_flip=” svg_div_top_invert=” svg_div_top_front=” svg_div_top_opacity=” svg_div_top_preview=” svg_div_bottom=” svg_div_bottom_color=’#333333′ svg_div_bottom_width=’100′ svg_div_bottom_height=’50’ svg_div_bottom_max_height=’none’ svg_div_bottom_flip=” svg_div_bottom_invert=” svg_div_bottom_front=” svg_div_bottom_opacity=” svg_div_bottom_preview=” fold_type=” fold_height=” fold_more=’Read more’ fold_less=’Read less’ fold_text_style=” fold_btn_align=” column_boxshadow=” column_boxshadow_width=’10’ column_boxshadow_color=” background=’bg_color’ background_color=” background_gradient_direction=’vertical’ background_gradient_color1=’#000000′ background_gradient_color2=’#ffffff’ background_gradient_color3=” src=” background_position=’top left’ background_repeat=’no-repeat’ highlight=” highlight_size=” fold_overlay_color=” fold_text_color=” fold_btn_color=’theme-color’ fold_btn_bg_color=” fold_btn_font_color=” size-btn-text=” av-desktop-font-size-btn-text=” av-medium-font-size-btn-text=” av-small-font-size-btn-text=” av-mini-font-size-btn-text=” animation=” animation_duration=” animation_custom_bg_color=” animation_z_index_curtain=’100′ parallax_parallax=” parallax_parallax_speed=” av-desktop-parallax_parallax=” av-desktop-parallax_parallax_speed=” av-medium-parallax_parallax=” av-medium-parallax_parallax_speed=” av-small-parallax_parallax=” av-small-parallax_parallax_speed=” av-mini-parallax_parallax=” av-mini-parallax_parallax_speed=” fold_timer=” z_index_fold=” css_position=” css_position_location=” css_position_z_index=” av-desktop-css_position=” av-desktop-css_position_location=” av-desktop-css_position_z_index=” av-medium-css_position=” av-medium-css_position_location=” av-medium-css_position_z_index=” av-small-css_position=” av-small-css_position_location=” av-small-css_position_z_index=” av-mini-css_position=” av-mini-css_position_location=” av-mini-css_position_z_index=” link=” linktarget=” link_hover=” title_attr=” alt_attr=” mobile_display=” mobile_col_pos=’0′ id=” custom_class=” template_class=” aria_label=” av_uid=’av-23mqpxp’ sc_version=’1.0′]
[av_codeblock wrapper_element=” wrapper_element_attributes=” codeblock_type=” alb_description=” id=” custom_class=” template_class=” av_uid=’av-1jpwtl9′ sc_version=’1.0′]
[/av_codeblock]
[av_hr class=’default’ icon_select=’yes’ icon=’ue808′ position=’center’ shadow=’no-shadow’ height=’50’ custom_border=’av-border-thin’ custom_width=’50px’ custom_margin_top=’30px’ custom_margin_bottom=’30px’ custom_border_color=” custom_icon_color=” av-desktop-hide=” av-medium-hide=” av-small-hide=” av-mini-hide=” id=” custom_class=” template_class=” av_uid=’av-4cblot’ sc_version=’1.0′]
[av_heading heading=’CSV File UTF-8 Encoding Issues fixed’ tag=’h2′ style=’blockquote modern-quote’ subheading_active=” show_icon=” icon=’ue800′ font=’entypo-fontello’ size=” av-desktop-font-size-title=” av-medium-font-size-title=” av-small-font-size-title=” av-mini-font-size-title=” subheading_size=” av-desktop-font-size=” av-medium-font-size=” av-small-font-size=” av-mini-font-size=” icon_size=” av-desktop-font-size-1=” av-medium-font-size-1=” av-small-font-size-1=” av-mini-font-size-1=” color=” custom_font=” subheading_color=” seperator_color=” icon_color=” margin=” margin_sync=’true’ av-desktop-margin=” av-desktop-margin_sync=’true’ av-medium-margin=” av-medium-margin_sync=’true’ av-small-margin=” av-small-margin_sync=’true’ av-mini-margin=” av-mini-margin_sync=’true’ headline_padding=” headline_padding_sync=’true’ av-desktop-headline_padding=” av-desktop-headline_padding_sync=’true’ av-medium-headline_padding=” av-medium-headline_padding_sync=’true’ av-small-headline_padding=” av-small-headline_padding_sync=’true’ av-mini-headline_padding=” av-mini-headline_padding_sync=’true’ padding=’10’ av-desktop-padding=” av-medium-padding=” av-small-padding=” av-mini-padding=” icon_padding=’10’ av-desktop-icon_padding=” av-medium-icon_padding=” av-small-icon_padding=” av-mini-icon_padding=” link=” link_target=” title_attr=” id=” custom_class=” template_class=” av_uid=’av-lslhnmyk’ sc_version=’1.0′ admin_preview_bg=”]
Get answers to frequently asked questions about our WooCommerce extention
[/av_heading]
[av_textblock fold_type=” fold_height=” fold_more=’Read more’ fold_less=’Read less’ fold_text_style=” fold_btn_align=” textblock_styling_align=” textblock_styling=” textblock_styling_gap=” textblock_styling_mobile=” size=” av-desktop-font-size=” av-medium-font-size=” av-small-font-size=” av-mini-font-size=” font_color=” color=” fold_overlay_color=” fold_text_color=” fold_btn_color=’theme-color’ fold_btn_bg_color=” fold_btn_font_color=” size-btn-text=” av-desktop-font-size-btn-text=” av-medium-font-size-btn-text=” av-small-font-size-btn-text=” av-mini-font-size-btn-text=” fold_timer=” z_index_fold=” id=” custom_class=” template_class=” av_uid=’av-lslhn3wx’ sc_version=’1.0′ admin_preview_bg=”]
When working with CSV files for product feeds, ensuring the correct UTF-8 encoding is essential for compatibility with various merchants’ requirements. Here’s a streamlined guide to addressing UTF-8 encoding issues using Microsoft Excel 2007:
Preparing to Import:
- Start Excel: Open Microsoft Excel 2007.
- Data Menu: Navigate to the ‘Data’ tab.
- Import Option: Select ‘From Text’ to begin importing your CSV file.
Importing the File:
- Locate File: Find and select your CSV file, then click ‘Import’. The Text Import Wizard will open.
- File Type: Choose between ‘Delimited’ or ‘Fixed Width’ based on your file’s structure.
- Encoding Setting: Set the File Origin to “65001: Unicode (UTF-8)” to ensure proper character representation.
- Delimiter Selection: In the next step, select the delimiter your file uses, such as commas or tabs. The preview window will adjust to show how your data will be organized.
- Data Formatting: In the final step, assign the appropriate data format to each column. You can also choose to skip certain columns if necessary.
- Finalize: Click ‘Finish’ to complete the import process and incorporate your data into Excel.
By following these steps, your CSV file will be correctly encoded in UTF-8 and ready for use, ensuring broad compatibility and accurate representation of all characters within your product feed. If issues persist or you're using a different version of Excel, consider using a UTF-8 compatible text editor to open and edit your CSV files.
[/av_textblock]
[av_promobox button='yes' label='Open a support ticket' icon_select='yes' icon='ue80b' font='entypo-fontello' label_display='' color='theme-color' custom_bg='#444444' custom_font='#ffffff' size='large' box_color='' box_custom_font='#ffffff' box_custom_bg='#444444' box_custom_border='#333333' gradient_color_direction='vertical' gradient_color_1='#000000' gradient_color_2='#ffffff' gradient_color_3='' border_promo='' border_promo_width='' border_promo_width_sync='true' border_promo_color='' border_radius_promo='' border_radius_promo_sync='true' box_shadow_promo='' box_shadow_promo_style='0px,0px,0px,0px' box_shadow_promo_color='' link='manually,https://marketingrobotai.com/support/' link_target='' title_attr='Open a support ticket' hover_opacity='' sonar_promo_effect='' sonar_promo_color='' sonar_promo_duration='1' sonar_promo_scale='' sonar_promo_opac='0.5' id='' custom_class='' template_class='' av_uid='av-lfky8d' sc_version='1.0' admin_preview_bg='']
Did you find this article helpful? If you have followed the steps but still need assistance or have additional questions, we’re here to help. Please don’t hesitate to open a support ticket.
[/av_promobox]
[/av_two_third][/av_section]