Cuando exportamos un fichero desde Excel a csv (comma separated value), y nuestro ordenador está en español, el delimitador por defecto es el punto y coma. En ocasiones tendremos que cambiar esto, o porque lo exija el programa destino, o porque nuestros campos incluyan puntos y coma. Hoy os enseñamos a hacerlo.
Cómo cambiamos el delimitador.
Este campo viene dado por Windows, y no por Excel. Excel lo coge de la configuración regional, de un campo que se llama Separador de Lista . Dicho campo está en:
Región e Idioma > Opciones adicionales de fecha, hora y configuración regional > Región >Cambiar formatos de fecha, hora o número > Configuración adicional.
En este vídeo os enseñamos a cambiarlo, con ejemplos para que veáis el proceso.
Os recomendamos los siguientes productos relacionados con la informática:
GoToners 603XL Cartucho de Tinta Compatible con 603XL 603 XL para XP-2100 XP-2105 XP-2150 XP-3100 XP-3150 XP-4100 WF-2810 WF-2820 WF-2830 WF-2835 WF-2850 (3 Negro, 3 Amarillo, 3 Magenta, 3 Cian)
19,99 € (as of 20 noviembre, 2024 04:06 GMT +01:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
Xiaomi Redmi Pad SE 4Go/128Go Wi-FI Gris (Graphite Gray)
133,47 € (as of 20 noviembre, 2024 04:06 GMT +01:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
Blackview Tab 60 WiFi Tablet 10 Pulgadas, PC Tablet Android 14, 12GB RAM + 128GB ROM/2TB TF, WiFi 6 Widevine L1, PC Mode 5100 mAh Batería Tablet Gaming Dual Cámara 8MP+5MP/WPS Suite/HD IPS
197,99 € (as of 21 noviembre, 2024 04:06 GMT +01:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
Impresora Multifunción HP DeskJet 4220e -3 meses de impresión Instant Ink con HP+ (Fotocopia, Escaneo, Impresión Dúplex, Wifi)
59,90 € (as of 20 noviembre, 2024 04:06 GMT +01:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
Lenovo Tablet Tab M11, Pantalla táctil de 11 Pulgadas, MediaTek G88, 4 GB de RAM, 128 GB eMMC 5.1, Android 13, Gris, Incluye Pen
159,00 € (as of 20 noviembre, 2024 04:06 GMT +01:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
ODEA Tablet 10 Pulgadas Android 14, A10 Tablet 12GB RAM + 128GB ROM(TF 1TB), Unisoc T606 Octa Core, 6000mAh/5G WiFi/BT5.0/1280 * 800 HD+/Widevine L1/Doble Cámara/Type-C/3.5mm Jack/Face ID
99,99 € (as of 20 noviembre, 2024 04:06 GMT +01:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
Philips Usb 2.0 Palillo De 32 Gb, Nieve Edición, Blanco, Gris
4,99 € (as of 20 noviembre, 2024 08:43 GMT +01:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
SHUBEIEUMI USB Bluetooth 5.4 Adaptador Bluetooth para PC, PC Dongle Bluetooth Adapter USB, para PC Windows 7/8.1/10/11, para Computadora Portátil Impresora Auricular Ratón
8,79 € (as of 21 noviembre, 2024 04:06 GMT +01:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
Lenovo Tab M11 - Tablet de 11" 1920 x 1200 px (MediaTek Helio G88, 8GB RAM, 128GB Ampliables hasta 1 TB, 4 Altavoces, WiFi, Bluetooth, Android 13) - Color Gris Luna - Incluye Tab Pen
191,99 € (as of 20 noviembre, 2024 04:06 GMT +01:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
Me ha resuelto el problema que tenía con la importación por medio de csv desde fmpro 9 a Memento. Muchas gracias. Hace falta además cambiar también la opción Formato, que aparece al principio de la configuración regional y de idioma, de español a inglés.